PACKAGE: APPS.ONT_OEXOECCL_XMLP_PKG

Source

1 PACKAGE ONT_OEXOECCL_XMLP_PKG AS
2 /* $Header: OEXOECCLS.pls 120.2 2008/05/05 10:14:35 dwkrishn noship $ */
3   P_CONC_REQUEST_ID NUMBER;
4   P_SOB_ID NUMBER;
5   P_ORDER_NUMBER VARCHAR2(32767);
6   P_CUSTOMER_NAME VARCHAR2(360);
7   P_DATE_HOLD_APPLIED_LOW DATE;
8   P_DATE_HOLD_APPLIED_HIGH DATE;
9   P_CURRENCY_CODE VARCHAR2(60);
10   P_CUSTOMER_NUMBER VARCHAR2(30);
11   LP_ORDER_NUMBER VARCHAR2(500);
12   LP_DATE_HOLD_APPLIED VARCHAR2(500);
13   LP_CURRENCY_CODE VARCHAR2(500);
14   LP_CUSTOMER_NUMBER VARCHAR2(500);
15   LP_CUSTOMER_NAME VARCHAR2(500);
16   P_ORDER_TYPE VARCHAR2(30);
17   LP_ORDER_TYPE VARCHAR2(500);
18   P_VAT_PROFILE VARCHAR2(30);
19   P_LINE_TYPE VARCHAR2(30);
20   LP_LINE_TYPE VARCHAR2(40);
21   P_ITEM_DESCRIPTION VARCHAR2(40);
22   P_ORG_ID VARCHAR2(32767);
23   LP_ORG_ID VARCHAR2(32767);
24   P_ITEM_STRUCTURE_NUM NUMBER;
25   P_ITEM_FLEX_CODE VARCHAR2(32767);
26   L_ORDER_TYPE VARCHAR2(30);
27   L_LINE_TYPE VARCHAR2(30);
28   INVENTORY_ITEM_ID NUMBER;
29   ORDERED_ITEM VARCHAR2(20);
30   ORDERED_ITEM_ID NUMBER;
31   RP_REPORT_NAME VARCHAR2(240);
32   RP_SUB_TITLE VARCHAR2(240);
33   RP_COMPANY_NAME VARCHAR2(100);
34   RP_FUNCTIONAL_CURRENCY VARCHAR2(20);
35   RP_DATA_FOUND VARCHAR2(300);
36   RP_DATE_HOLD_APPLIED_RANGE VARCHAR2(100);
37   RP_SHIP VARCHAR2(100);
38   RP_ORDER VARCHAR2(100);
39   RP_VAT_PROFILE VARCHAR2(100);
40   RP_PRINT_DESCRIPTION VARCHAR2(80);
41   RP_ITEM_FLEX_ALL_SEG VARCHAR2(500) := 'SI.SEGMENT1';
42   RP_DUMMY_ITEM VARCHAR2(500);
43   FUNCTION BeforeReport RETURN BOOLEAN;
44   FUNCTION AFTERREPORT RETURN BOOLEAN;
45   FUNCTION AFTERPFORM RETURN BOOLEAN;
46   FUNCTION C_DATA_NOT_FOUNDFORMULA(CUSTOMER_NAME IN VARCHAR2) RETURN NUMBER;
47   FUNCTION C_ADDRESSFORMULA(ADDRESS1 IN VARCHAR2
48                            ,CITY IN VARCHAR2
49                            ,STATE IN VARCHAR2) RETURN VARCHAR2;
50   FUNCTION P_ITEM_FLEX_CODEVALIDTRIGGER RETURN BOOLEAN;
51   FUNCTION INVENTORY_ITEM_ID_P RETURN NUMBER;
52   FUNCTION ORDERED_ITEM_P RETURN VARCHAR2;
53   FUNCTION ORDERED_ITEM_ID_P RETURN NUMBER;
54   FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
55   FUNCTION RP_SUB_TITLE_P RETURN VARCHAR2;
56   FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
57   FUNCTION RP_FUNCTIONAL_CURRENCY_P RETURN VARCHAR2;
58   FUNCTION RP_DATA_FOUND_P RETURN VARCHAR2;
59   FUNCTION RP_DATE_HOLD_APPLIED_RANGE_P RETURN VARCHAR2;
60   FUNCTION RP_SHIP_P RETURN VARCHAR2;
61   FUNCTION RP_ORDER_P RETURN VARCHAR2;
62   FUNCTION RP_VAT_PROFILE_P RETURN VARCHAR2;
63   FUNCTION RP_PRINT_DESCRIPTION_P RETURN VARCHAR2;
64   FUNCTION RP_ITEM_FLEX_ALL_SEG_P RETURN VARCHAR2;
65   FUNCTION RP_DUMMY_ITEM_P RETURN VARCHAR2;
66   function Item_DspFormula(item_identifier_type in VARCHAR2,ordered_item_id in number,ordered_item in varchar2,ORGANIZATION_ID in number,INVENTORY_ITEM_ID1 in number) return VARCHAR2;
67 END ONT_OEXOECCL_XMLP_PKG
68 ;
69 
70