eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.INV_INVTOPKL_XMLP_PKG

Source


1 PACKAGE INV_INVTOPKL_XMLP_PKG AS
2 /* $Header: INVTOPKLS.pls 120.2 2008/01/08 06:27:05 dwkrishn noship $ */
3   P_ORG_ID NUMBER;
4   P_DATE_REQD_HI DATE;
5   P_DATE_REQD_LO DATE;
6   CP_DATE_REQD_LO varchar2(20);
7   CP_DATE_REQD_HI varchar2(20);
8   P_ITEM_FLEXSQL VARCHAR2(1000):= '(msi.segment1  || ''\n'' || msi.segment2  || ''\n'' || msi.segment3  || ''\n'' ||
9   msi.segment4  || ''\n'' || msi.segment5  || ''\n'' || msi.segment6  || ''\n'' || msi.segment7  || ''\n'' ||
10   msi.segment8  || ''\n'' || msi.segment9  || ''\n'' || msi.segment10 || ''\n'' || msi.segment11 || ''\n'' ||
11   msi.segment12 || ''\n'' || msi.segment13 || ''\n'' )';
12   P_ITEM_FLEXNUM NUMBER;
13   P_DEST_SUBINV VARCHAR2(10);
14   P_TRACE_FLAG NUMBER;
15   P_CBO_FLAG NUMBER;
16   P_TO_ACCOUNT_FLEXSQL VARCHAR2(1000):= 'gcc.segment1|| ''\n'' || gcc.segment2|| ''\n'' || gcc.segment3|| ''\n'' ||
17   gcc.segment4|| ''\n'' || gcc.segment5|| ''\n'' || gcc.segment6|| ''\n'' || gcc.segment7|| ''\n'' || gcc.segment8|| ''\n'' ||
18   gcc.segment9|| ''\n'' || gcc.segment10|| ''\n'' || gcc.segment11|| ''\n'' || gcc.segment12|| ''\n'' ||
19   gcc.segment13|| ''\n'' || gcc.segment14|| ''\n'' || gcc.segment15|| ''\n'' || gcc.segment16|| ''\n'' ||
20   gcc.segment17|| ''\n'' || gcc.segment18|| ''\n'' || gcc.segment19|| ''\n'' || gcc.segment20|| ''\n'' ||
21   gcc.segment21|| ''\n'' || gcc.segment22|| ''\n'' || gcc.segment23|| ''\n'' || gcc.segment24|| ''\n'' ||
22   gcc.segment25|| ''\n'' || gcc.segment26|| ''\n'' || gcc.segment27|| ''\n'' || gcc.segment28|| ''\n'' ||
23   gcc.segment29|| ''\n'' || gcc.segment30';
24   P_SOURCE_SUBINV VARCHAR2(10);
25   P_DEST_LOCATOR_ID NUMBER;
26   P_SOURCE_LOCATOR_ID NUMBER;
27   P_REQUESTED_BY NUMBER;
28   P_SET_OF_BOOKS_ID NUMBER;
29   P_WHERE_MMT VARCHAR2(2000) := '1=1';
30   P_REQUESTED_BY_NAME VARCHAR2(50);
31   P_PRINT_OPTION VARCHAR2(32767);
32   P_WHERE_MMTT VARCHAR2(2000) := '1=1';
33   P_WHERE_MTRL VARCHAR2(2000) := '1=1';
34   P_MOVE_ORDER_TYPE NUMBER;
35   P_ALLOCATE_MOVE_ORDER VARCHAR2(32767);
36   P_WMS_INSTALL VARCHAR2(1) := 'N';
37   P_PLAN_TASKS VARCHAR2(22);
38   P_PICK_SLIP_GROUP_RULE_ID NUMBER;
39   P_PICK_SLIP_GROUP_RULE_NAME VARCHAR2(30);
40   P_ORG_NAME VARCHAR2(240);
41   P_SOURCE_LOCATOR VARCHAR2(2000);
42   P_DEST_LOCATOR VARCHAR2(2000);
43   P_MOVE_ORDER_TYPE_MEANING VARCHAR2(80);
44   P_PRINT_OPTION_MEANING VARCHAR2(80);
45   P_CONST_UNALLOCATED VARCHAR2(30);
46   P_MOVE_ORDER_LOW VARCHAR2(30);
47   P_MOVE_ORDER_HIGH VARCHAR2(30);
48   P_CONC_REQUEST_ID NUMBER;
49   P_SORT_BY NUMBER;
50   P_FROM_MMT VARCHAR2(1000);
51   P_FROM_MMTT VARCHAR2(1000);
52   P_FROM_MTRL VARCHAR2(1000);
53   P_SALES_ORDER_LOW VARCHAR2(22);
54   P_SALES_ORDER_HIGH VARCHAR2(22);
55   P_CUSTOMER_ID NUMBER;
56   P_FREIGHT_CODE VARCHAR2(30);
57   P_PICK_SLIP_NUMBER_LOW NUMBER;
58   P_PICK_SLIP_NUMBER_HIGH NUMBER;
59   P_CUSTOMER_NAME VARCHAR2(50);
60   P_ALLOCATE_MOVE_ORDER_MEANING VARCHAR2(32767);
61   P_PLAN_TASKS_MEANING VARCHAR2(32767);
62   P_SER_PARENT_S_FROM VARCHAR2(600):= 'SELECT LAG(MSN.SERIAL_NUMBER, 1) OVER(ORDER BY LENGTH(MSN.SERIAL_NUMBER), MSN.SERIAL_NUMBER) PREV_SERIAL, MSN.SERIAL_NUMBER SERIAL_NUMBER,
63   LEAD(MSN.SERIAL_NUMBER, 1) OVER(ORDER BY LENGTH(MSN.SERIAL_NUMBER), MSN.SERIAL_NUMBER) NEXT_SERIAL
67   P_SER_CHILD_S_FROM VARCHAR2(1000):= 'SELECT LAG(SERIAL_NUMBER, 1) OVER(ORDER BY LENGTH(SERIAL_NUMBER), SERIAL_NUMBER) PREV_SERIAL, SERIAL_NUMBER, LEAD(SERIAL_NUMBER, 1) OVER(ORDER BY LENGTH(SERIAL_NUMBER), SERIAL_NUMBER) NEXT_SERIAL
64   FROM MTL_SERIAL_NUMBERS_TEMP MSNT, MTL_SERIAL_NUMBERS MSN
65   WHERE MSNT.TRANSACTION_TEMP_ID = :PARENT_TXN_TEMP_ID AND MSN.SERIAL_NUMBER BETWEEN MSNT.FM_SERIAL_NUMBER
66   AND MSNT.TO_SERIAL_NUMBER AND MSN.INVENTORY_ITEM_ID = :PARENT_ITEM_ID AND LENGTH(MSN.SERIAL_NUMBER) = LENGTH(MSNT.FM_SERIAL_NUMBER)';
68   FROM MTL_UNIT_TRANSACTIONS WHERE TRANSACTION_ID = :TRANSACTION_ID
69   UNION ALL SELECT LAG(MSN.SERIAL_NUMBER, 1) OVER(ORDER BY LENGTH(MSN.SERIAL_NUMBER), MSN.SERIAL_NUMBER)
70   PREV_SERIAL, MSN.SERIAL_NUMBER SERIAL_NUMBER, LEAD(SERIAL_NUMBER, 1) OVER(ORDER BY LENGTH(SERIAL_NUMBER), SERIAL_NUMBER) NEXT_SERIAL FROM MTL_SERIAL_NUMBERS_TEMP MSNT, MTL_SERIAL_NUMBERS MSN
71   WHERE MSNT.TRANSACTION_TEMP_ID = :TRANSACTION_ID AND MSN.SERIAL_NUMBER BETWEEN MSNT.FM_SERIAL_NUMBER
72   AND MSNT.TO_SERIAL_NUMBER AND MSN.INVENTORY_ITEM_ID = :INVENTORY_ITEM_ID AND LENGTH(MSN.SERIAL_NUMBER) = LENGTH(MSNT.FM_SERIAL_NUMBER)';
73   P_SER_PARENT_LS_FROM VARCHAR2(600):= 'SELECT LAG(MSN.SERIAL_NUMBER, 1) OVER(ORDER BY LENGTH(MSN.SERIAL_NUMBER), MSN.SERIAL_NUMBER) PREV_SERIAL, MSN.SERIAL_NUMBER SERIAL_NUMBER,
74   LEAD(MSN.SERIAL_NUMBER, 1) OVER(ORDER BY LENGTH(MSN.SERIAL_NUMBER), MSN.SERIAL_NUMBER) NEXT_SERIAL FROM MTL_SERIAL_NUMBERS_TEMP MSNT, MTL_SERIAL_NUMBERS MSN WHERE MSNT.TRANSACTION_TEMP_ID = :L_PARENT_SER_TXN_TEMP_ID
75   AND MSN.SERIAL_NUMBER BETWEEN MSNT.FM_SERIAL_NUMBER AND MSNT.TO_SERIAL_NUMBER
76   AND MSN.INVENTORY_ITEM_ID = :PARENT_ITEM_ID AND LENGTH(MSN.SERIAL_NUMBER) = LENGTH(MSNT.FM_SERIAL_NUMBER)';
77   P_SER_CHILD_LS_FROM VARCHAR2(1000):= 'SELECT LAG(SERIAL_NUMBER, 1) OVER(ORDER BY LENGTH(SERIAL_NUMBER), SERIAL_NUMBER) PREV_SERIAL, SERIAL_NUMBER, LEAD(SERIAL_NUMBER, 1) OVER(ORDER BY LENGTH(SERIAL_NUMBER), SERIAL_NUMBER) NEXT_SERIAL
78   FROM MTL_UNIT_TRANSACTIONS WHERE TRANSACTION_ID = :LS_SER_TXN_ID UNION ALL SELECT LAG(MSN.SERIAL_NUMBER, 1) OVER(ORDER BY LENGTH(MSN.SERIAL_NUMBER), MSN.SERIAL_NUMBER) PREV_SERIAL,
79   MSN.SERIAL_NUMBER SERIAL_NUMBER, LEAD(SERIAL_NUMBER, 1) OVER(ORDER BY LENGTH(SERIAL_NUMBER), SERIAL_NUMBER) NEXT_SERIAL FROM MTL_SERIAL_NUMBERS_TEMP MSNT, MTL_SERIAL_NUMBERS MSN
80   WHERE MSNT.TRANSACTION_TEMP_ID = :LS_SER_TXN_ID AND MSN.SERIAL_NUMBER BETWEEN MSNT.FM_SERIAL_NUMBER AND MSNT.TO_SERIAL_NUMBER AND MSN.INVENTORY_ITEM_ID = :INVENTORY_ITEM_ID AND LENGTH(MSN.SERIAL_NUMBER) = LENGTH(MSNT.FM_SERIAL_NUMBER)';
81   CP_SO_ORDER_NUMBER NUMBER;
82   CP_SO_LINE_NUMBER NUMBER;
83   CP_SO_DELIVERY_NAME NUMBER;
84   CP_WIP_JOB VARCHAR2(500);
85   CP_WIP_DEPARTMENT VARCHAR2(20);
86   CP_WIP_LINE VARCHAR2(20);
87   CP_WIP_ENTITY_TYPE NUMBER;
88   CP_WIP_START_DATE VARCHAR2(20);
89   CP_WIP_OPERATION VARCHAR2(20);
90   CP_CHART_OF_ACCOUNTS_NUM NUMBER;
91   FUNCTION BEFOREREPORT RETURN BOOLEAN;
92   FUNCTION AFTERREPORT RETURN BOOLEAN;
93   FUNCTION AFTERPFORM RETURN BOOLEAN;
94   PROCEDURE GET_CHART_OF_ACCOUNTS_ID;
95   FUNCTION P_REQUESTED_BYVALIDTRIGGER RETURN BOOLEAN;
96   FUNCTION P_ORG_IDVALIDTRIGGER RETURN BOOLEAN;
97   FUNCTION CF_PROJECT_NUMBERFORMULA(PROJECT_ID IN NUMBER) RETURN CHAR;
98   FUNCTION CF_TASK_NUMBERFORMULA(TASK_ID IN NUMBER
99                                 ,PROJECT_ID IN NUMBER) RETURN CHAR;
100   FUNCTION P_MOVE_ORDER_TYPEVALIDTRIGGER RETURN BOOLEAN;
101   FUNCTION P_PICK_SLIP_GROUP_RULE_IDVALID RETURN BOOLEAN;
102   FUNCTION P_PRINT_OPTIONVALIDTRIGGER RETURN BOOLEAN;
103   FUNCTION CF_WIP_INFOFORMULA(LINE_ID_P IN NUMBER
104                              ,MOVE_ORDER_TYPE IN NUMBER
105                              ,TRANSACTION_SOURCE_TYPE_ID IN NUMBER) RETURN NUMBER;
106   FUNCTION CF_SO_INFOFORMULA(LINE_ID IN NUMBER
107                             ,MOVE_ORDER_TYPE IN NUMBER) RETURN NUMBER;
108   PROCEDURE INV_CALL_ALLOCATIONS_ENGINE;
109   FUNCTION P_CUSTOMER_IDVALIDTRIGGER RETURN BOOLEAN;
110   FUNCTION CF_TASK_STATUSFORMULA(TASK_STATUS IN NUMBER) RETURN CHAR;
111   FUNCTION CF_TASK_IDFORMULA(TASK_STATUS IN NUMBER
112                             ,PARENT_LINE_ID IN NUMBER
113                             ,TRANSACTION_ID IN NUMBER) RETURN NUMBER;
114   FUNCTION P_ALLOCATE_MOVE_ORDERVALIDTRIG RETURN BOOLEAN;
115   FUNCTION P_PLAN_TASKSVALIDTRIGGER RETURN BOOLEAN;
116   FUNCTION P_FREIGHT_CODEVALIDTRIGGER RETURN BOOLEAN;
117   FUNCTION CF_SEC_QTYFORMULA(INVENTORY_ITEM_ID_1 IN NUMBER
118                             ,SEC_TRANSACTION_QTY IN NUMBER) RETURN NUMBER;
119   FUNCTION CF_SEC_UOMFORMULA(INVENTORY_ITEM_ID_1 IN NUMBER
120                             ,SEC_UOM IN VARCHAR2) RETURN CHAR;
121   FUNCTION CF_PARENT_SEC_UOMFORMULA(PARENT_ITEM_ID IN NUMBER
122                                    ,PARENT_SEC_TXN_UOM IN VARCHAR2) RETURN CHAR;
123   FUNCTION CF_PARENT_SEC_QTYFORMULA(PARENT_ITEM_ID IN NUMBER
124                                    ,PARENT_SEC_TXN_QTY IN NUMBER) RETURN NUMBER;
125   FUNCTION CP_SO_ORDER_NUMBER_P RETURN NUMBER;
126   FUNCTION CP_SO_LINE_NUMBER_P RETURN NUMBER;
127   FUNCTION CP_SO_DELIVERY_NAME_P RETURN NUMBER;
128   FUNCTION CP_WIP_JOB_P RETURN VARCHAR2;
129   FUNCTION CP_WIP_DEPARTMENT_P RETURN VARCHAR2;
130   FUNCTION CP_WIP_LINE_P RETURN VARCHAR2;
131   FUNCTION CP_WIP_ENTITY_TYPE_P RETURN NUMBER;
132   FUNCTION CP_WIP_START_DATE_P RETURN VARCHAR2;
133   FUNCTION CP_WIP_OPERATION_P RETURN VARCHAR2;
134   FUNCTION CP_CHART_OF_ACCOUNTS_NUM_P RETURN NUMBER;
135 END INV_INVTOPKL_XMLP_PKG;
136 
137 
138