R11 – 4566 Prototype scripts and 4566 Dataload template scripts

by Thomas Lundqvist

Here are all 4566 supported API’s:

(pls. register before download)

These scripts is genrated by exporting the PLSQL package names from irep and using the api.sql and proto.sql scripts available for download from www.sql4oracle.com

Scripts for all supported API’s for Oracle Applications is generated. This will enable you to get started with development using of any of the supported API’s.

The 4566 API scripts, will enable you to develop xls4oracle dataload templates. All mapping info i generated (the oe_order_pub.process_order has 3600 mappings in 45 structures).

example of a prototype script:

-- *****************************************************************************
-- sql4oracle PROTO script
-- *****************************************************************************
-- copyright 2008 - www.thomaslundqvist.dk
-- *****************************************************************************
-- package       AP_PO_VENDORS_APIS_PKG
-- procedure     UPDATE_VENDOR
-- overload      0
-- extract date  20-apr-2011 19:52
-- *****************************************************************************

declare
P_VENDOR_ID                             NUMBER;
P_TAXPAYER_ID                           VARCHAR2(2000);
P_TAX_REGISTRATION_ID                   VARCHAR2(2000);
P_WOMEN_OWNED_FLAG                      VARCHAR2(2000);
P_SMALL_BUSINESS_FLAG                   VARCHAR2(2000);
P_MINORITY_GROUP_LOOKUP_CODE            VARCHAR2(2000);
X_STATUS                                VARCHAR2(2000);
X_EXCEPTION_MSG                         VARCHAR2(2000);
P_CALLING_SOURCE                        VARCHAR2(2000);
BEGIN
--
-- P_VENDOR_ID := 0;
-- P_TAXPAYER_ID := '';
-- P_TAX_REGISTRATION_ID := '';
-- P_WOMEN_OWNED_FLAG := '';
-- P_SMALL_BUSINESS_FLAG := '';
-- P_MINORITY_GROUP_LOOKUP_CODE := '';
-- P_CALLING_SOURCE := '';
--
AP_PO_VENDORS_APIS_PKG.UPDATE_VENDOR
(P_VENDOR_ID                              => P_VENDOR_ID
,P_TAXPAYER_ID                            => P_TAXPAYER_ID
,P_TAX_REGISTRATION_ID                    => P_TAX_REGISTRATION_ID
,P_WOMEN_OWNED_FLAG                       => P_WOMEN_OWNED_FLAG
,P_SMALL_BUSINESS_FLAG                    => P_SMALL_BUSINESS_FLAG
,P_MINORITY_GROUP_LOOKUP_CODE             => P_MINORITY_GROUP_LOOKUP_CODE
,X_STATUS                                 => X_STATUS
,X_EXCEPTION_MSG                          => X_EXCEPTION_MSG
,P_CALLING_SOURCE                         => P_CALLING_SOURCE
);
--
end;
/

 

Exampe of a API script:

-- *****************************************************************************
-- Oracle API Mapping script for the "Excel for Oracle Applications" tool
-- *****************************************************************************
-- copyright 2008 - www.thomaslundqvist.dk
-- *****************************************************************************
-- package       GMD_OPERATIONS_PUB
-- procedure     DELETE_OPERATION
-- overload      0
-- extract date  20-apr-2011 22:25
-- *****************************************************************************
-- copy to the dataload sheet:
-- *****************************************************************************
1
data
mapping
DECLARE
-- copyright 2009 - www.thomaslundqvist.dk
P_API_VERSION                           NUMBER;
P_INIT_MSG_LIST                         PL/SQL BOOLEAN;
P_COMMIT                                PL/SQL BOOLEAN;
P_OPRN_ID                               NUMBER;
P_OPRN_NO                               VARCHAR2(2000);
P_OPRN_VERS                             NUMBER;
X_MESSAGE_COUNT                         NUMBER;
X_MESSAGE_LIST                          VARCHAR2(2000);
X_RETURN_STATUS                         VARCHAR2(2000);
BEGIN
x_msg_data := '';
:x_status := '';
:x_msg_data1 := '';
:x_msg_data2 := '';
:x_msg_data3 := '';
--$MAPPING
GMD_OPERATIONS_PUB.DELETE_OPERATION
(P_API_VERSION                            => P_API_VERSION
,P_INIT_MSG_LIST                          => P_INIT_MSG_LIST
,P_COMMIT                                 => P_COMMIT
,P_OPRN_ID                                => P_OPRN_ID
,P_OPRN_NO                                => P_OPRN_NO
,P_OPRN_VERS                              => P_OPRN_VERS
,X_MESSAGE_COUNT                          => X_MESSAGE_COUNT
,X_MESSAGE_LIST                           => X_MESSAGE_LIST
,X_RETURN_STATUS                          => X_RETURN_STATUS
);
EXCEPTION WHEN OTHERS THEN
:x_status := 'E';
:x_msg_data1 := substr(SQLERRM,1,125);
END;
/
-- *****************************************************************************
-- copy to the mapping sheet:
-- *****************************************************************************
column datatype default mapping
P_API_VERSION N  P_API_VERSION
P_OPRN_ID N  P_OPRN_ID
P_OPRN_NO V  P_OPRN_NO
P_OPRN_VERS N  P_OPRN_VERS

2 Responses to R11 – 4566 Prototype scripts and 4566 Dataload template scripts

  1. Pingback: Complete list of supported API’s | xls4oracle

  2. Pingback: 4566… | xls4oracle

Leave a Reply