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.

APPS.OE_INBOUND_INT dependencies on OE_ORDER_PUB_REQUEST_TBL_TYPE

Line 4933: FUNCTION PL_TO_SQL25(aPlsqlItem OE_ORDER_PUB.REQUEST_TBL_TYPE)

4929: aPlsqlItem.DATE_PARAM8 := aSqlItem.DATE_PARAM8;
4930: aPlsqlItem.PROCESSED := aSqlItem.PROCESSED;
4931: RETURN aPlsqlItem;
4932: END SQL_TO_PL48;
4933: FUNCTION PL_TO_SQL25(aPlsqlItem OE_ORDER_PUB.REQUEST_TBL_TYPE)
4934: RETURN OE_ORDER_PUB_REQUEST_TBL_TYPE IS
4935: aSqlItem OE_ORDER_PUB_REQUEST_TBL_TYPE;
4936: BEGIN
4937: aSqlItem := OE_ORDER_PUB_REQUEST_TBL_TYPE();

Line 4934: RETURN OE_ORDER_PUB_REQUEST_TBL_TYPE IS

4930: aPlsqlItem.PROCESSED := aSqlItem.PROCESSED;
4931: RETURN aPlsqlItem;
4932: END SQL_TO_PL48;
4933: FUNCTION PL_TO_SQL25(aPlsqlItem OE_ORDER_PUB.REQUEST_TBL_TYPE)
4934: RETURN OE_ORDER_PUB_REQUEST_TBL_TYPE IS
4935: aSqlItem OE_ORDER_PUB_REQUEST_TBL_TYPE;
4936: BEGIN
4937: aSqlItem := OE_ORDER_PUB_REQUEST_TBL_TYPE();
4938: IF aPlsqlItem.COUNT > 0 THEN

Line 4935: aSqlItem OE_ORDER_PUB_REQUEST_TBL_TYPE;

4931: RETURN aPlsqlItem;
4932: END SQL_TO_PL48;
4933: FUNCTION PL_TO_SQL25(aPlsqlItem OE_ORDER_PUB.REQUEST_TBL_TYPE)
4934: RETURN OE_ORDER_PUB_REQUEST_TBL_TYPE IS
4935: aSqlItem OE_ORDER_PUB_REQUEST_TBL_TYPE;
4936: BEGIN
4937: aSqlItem := OE_ORDER_PUB_REQUEST_TBL_TYPE();
4938: IF aPlsqlItem.COUNT > 0 THEN
4939: aSqlItem.EXTEND(aPlsqlItem.COUNT);

Line 4937: aSqlItem := OE_ORDER_PUB_REQUEST_TBL_TYPE();

4933: FUNCTION PL_TO_SQL25(aPlsqlItem OE_ORDER_PUB.REQUEST_TBL_TYPE)
4934: RETURN OE_ORDER_PUB_REQUEST_TBL_TYPE IS
4935: aSqlItem OE_ORDER_PUB_REQUEST_TBL_TYPE;
4936: BEGIN
4937: aSqlItem := OE_ORDER_PUB_REQUEST_TBL_TYPE();
4938: IF aPlsqlItem.COUNT > 0 THEN
4939: aSqlItem.EXTEND(aPlsqlItem.COUNT);
4940: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
4941: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL48(aPlsqlItem(I));

Line 4951: FUNCTION SQL_TO_PL25(aSqlItem OE_ORDER_PUB_REQUEST_TBL_TYPE)

4947: end if;
4948: RETURN aSqlItem;
4949: END PL_TO_SQL25;
4950:
4951: FUNCTION SQL_TO_PL25(aSqlItem OE_ORDER_PUB_REQUEST_TBL_TYPE)
4952: RETURN OE_ORDER_PUB.REQUEST_TBL_TYPE IS
4953: aPlsqlItem OE_ORDER_PUB.REQUEST_TBL_TYPE;
4954: BEGIN
4955: BEGIN

Line 4952: RETURN OE_ORDER_PUB.REQUEST_TBL_TYPE IS

4948: RETURN aSqlItem;
4949: END PL_TO_SQL25;
4950:
4951: FUNCTION SQL_TO_PL25(aSqlItem OE_ORDER_PUB_REQUEST_TBL_TYPE)
4952: RETURN OE_ORDER_PUB.REQUEST_TBL_TYPE IS
4953: aPlsqlItem OE_ORDER_PUB.REQUEST_TBL_TYPE;
4954: BEGIN
4955: BEGIN
4956: FOR I IN 1..aSqlItem.COUNT LOOP

Line 4953: aPlsqlItem OE_ORDER_PUB.REQUEST_TBL_TYPE;

4949: END PL_TO_SQL25;
4950:
4951: FUNCTION SQL_TO_PL25(aSqlItem OE_ORDER_PUB_REQUEST_TBL_TYPE)
4952: RETURN OE_ORDER_PUB.REQUEST_TBL_TYPE IS
4953: aPlsqlItem OE_ORDER_PUB.REQUEST_TBL_TYPE;
4954: BEGIN
4955: BEGIN
4956: FOR I IN 1..aSqlItem.COUNT LOOP
4957: aPlsqlItem(I) := SQL_TO_PL48(aSqlItem(I));

Line 5037: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,

5033: P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
5034: P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
5035: P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
5036: P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
5037: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
5038: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HDR_REC25,
5039: X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T,
5040: X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T,
5041: X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_VAL_T,

Line 5062: X_ACTION_REQUEST_TBL OUT NOCOPY OE_ORDER_PUB_REQUEST_TBL_TYPE,

5058: X_LINE_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_TBL,
5059: X_LINE_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_VAL,
5060: X_LOT_SERIAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_TBL_T,
5061: X_LOT_SERIAL_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_VAL_T ,
5062: X_ACTION_REQUEST_TBL OUT NOCOPY OE_ORDER_PUB_REQUEST_TBL_TYPE,
5063: P_RTRIM_DATA VARCHAR2
5064: )
5065: IS
5066: l_header_rec_old OE_ORDER_PUB_HEADER_REC_TYPE;

Line 5072: l_action_request_tbl OE_ORDER_PUB_REQUEST_TBL_TYPE;

5068:
5069: l_in_line_tab OE_ORDER_PUB_LINE_TBL_TYPE;
5070: l_in_line_val_tab OE_ORDER_PUB_LINE_VAL_TBL_TYP;
5071:
5072: l_action_request_tbl OE_ORDER_PUB_REQUEST_TBL_TYPE;
5073:
5074: TYPE config_process_rec_type IS RECORD (
5075: line_id oe_order_lines_all.line_id%TYPE,
5076: config_header_id oe_order_lines_all.config_header_id%TYPE,

Line 5823: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,

5819: P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
5820: P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
5821: P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
5822: P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
5823: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
5824: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE ,
5825: X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T ,
5826: X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T ,
5827: X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_VAL_T ,

Line 5848: X_ACTION_REQUEST_TBL OUT NOCOPY OE_ORDER_PUB_REQUEST_TBL_TYPE ,

5844: X_LINE_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_TBL ,
5845: X_LINE_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_VAL ,
5846: X_LOT_SERIAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_TBL_T ,
5847: X_LOT_SERIAL_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_VAL_T ,
5848: X_ACTION_REQUEST_TBL OUT NOCOPY OE_ORDER_PUB_REQUEST_TBL_TYPE ,
5849: P_RTRIM_DATA VARCHAR2
5850: )
5851: IS
5852: P_HEADER_REC_ OE_ORDER_PUB.HEADER_REC_TYPE;

Line 5900: P_ACTION_REQUEST_TBL_ OE_ORDER_PUB.REQUEST_TBL_TYPE;

5896: P_LOT_SERIAL_TBL_ OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE;
5897: P_OLD_LOT_SERIAL_TBL_ OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE;
5898: P_LOT_SERIAL_VAL_TBL_ OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE;
5899: P_OLD_LOT_SERIAL_VAL_TBL_ OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE;
5900: P_ACTION_REQUEST_TBL_ OE_ORDER_PUB.REQUEST_TBL_TYPE;
5901: X_HEADER_REC_ OE_ORDER_PUB.HEADER_REC_TYPE;
5902: X_HEADER_VAL_REC_ OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
5903: X_HEADER_ADJ_TBL_ OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;
5904: X_HEADER_ADJ_VAL_TBL_ OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE;

Line 5925: X_ACTION_REQUEST_TBL_ OE_ORDER_PUB.REQUEST_TBL_TYPE;

5921: X_LINE_PAYMENT_TBL_ OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE;
5922: X_LINE_PAYMENT_VAL_TBL_ OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE;
5923: X_LOT_SERIAL_TBL_ OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE;
5924: X_LOT_SERIAL_VAL_TBL_ OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE;
5925: X_ACTION_REQUEST_TBL_ OE_ORDER_PUB.REQUEST_TBL_TYPE;
5926: l_temp_var VARCHAR2(2000) := NULL;
5927: l_return_status VARCHAR2(256);
5928:
5929: L_MSG_COUNT NUMBER ;

Line 6443: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,

6439: P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
6440: P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
6441: P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
6442: P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
6443: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
6444: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE ,
6445: X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T ,
6446: X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T ,
6447: X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_VAL_T ,

Line 6468: X_ACTION_REQUEST_TBL OUT NOCOPY OE_ORDER_PUB_REQUEST_TBL_TYPE ,

6464: X_LINE_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_TBL ,
6465: X_LINE_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_VAL ,
6466: X_LOT_SERIAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_TBL_T ,
6467: X_LOT_SERIAL_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_VAL_T ,
6468: X_ACTION_REQUEST_TBL OUT NOCOPY OE_ORDER_PUB_REQUEST_TBL_TYPE ,
6469: P_RTRIM_DATA VARCHAR2
6470: )
6471: IS
6472: