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_HEADER_REC_TYPE

Line 206: FUNCTION PL_TO_SQL1(aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE)

202: -- End of bug 9131751
203: -------------------------
204:
205: -------------------------
206: FUNCTION PL_TO_SQL1(aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE)
207: RETURN OE_ORDER_PUB_HEADER_REC_TYPE IS
208: aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE;
209: BEGIN
210: aSqlItem := OE_ORDER_PUB_HEADER_REC_TYPE(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 207: RETURN OE_ORDER_PUB_HEADER_REC_TYPE IS

203: -------------------------
204:
205: -------------------------
206: FUNCTION PL_TO_SQL1(aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE)
207: RETURN OE_ORDER_PUB_HEADER_REC_TYPE IS
208: aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE;
209: BEGIN
210: aSqlItem := OE_ORDER_PUB_HEADER_REC_TYPE(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
211: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 208: aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE;

204:
205: -------------------------
206: FUNCTION PL_TO_SQL1(aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE)
207: RETURN OE_ORDER_PUB_HEADER_REC_TYPE IS
208: aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE;
209: BEGIN
210: aSqlItem := OE_ORDER_PUB_HEADER_REC_TYPE(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
211: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
212: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 210: aSqlItem := OE_ORDER_PUB_HEADER_REC_TYPE(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

206: FUNCTION PL_TO_SQL1(aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE)
207: RETURN OE_ORDER_PUB_HEADER_REC_TYPE IS
208: aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE;
209: BEGIN
210: aSqlItem := OE_ORDER_PUB_HEADER_REC_TYPE(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
211: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
212: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
213: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
214: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 445: FUNCTION SQL_TO_PL1(aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE)

441: aSqlItem.ORDER_FIRMED_DATE := aPlsqlItem.ORDER_FIRMED_DATE;
442: RETURN aSqlItem;
443: END PL_TO_SQL1;
444:
445: FUNCTION SQL_TO_PL1(aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE)
446: RETURN OE_ORDER_PUB.HEADER_REC_TYPE IS
447: aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE;
448: BEGIN
449: aPlsqlItem.ACCOUNTING_RULE_ID := aSqlItem.ACCOUNTING_RULE_ID;

Line 446: RETURN OE_ORDER_PUB.HEADER_REC_TYPE IS

442: RETURN aSqlItem;
443: END PL_TO_SQL1;
444:
445: FUNCTION SQL_TO_PL1(aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE)
446: RETURN OE_ORDER_PUB.HEADER_REC_TYPE IS
447: aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE;
448: BEGIN
449: aPlsqlItem.ACCOUNTING_RULE_ID := aSqlItem.ACCOUNTING_RULE_ID;
450: aPlsqlItem.AGREEMENT_ID := aSqlItem.AGREEMENT_ID;

Line 447: aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE;

443: END PL_TO_SQL1;
444:
445: FUNCTION SQL_TO_PL1(aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE)
446: RETURN OE_ORDER_PUB.HEADER_REC_TYPE IS
447: aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE;
448: BEGIN
449: aPlsqlItem.ACCOUNTING_RULE_ID := aSqlItem.ACCOUNTING_RULE_ID;
450: aPlsqlItem.AGREEMENT_ID := aSqlItem.AGREEMENT_ID;
451: aPlsqlItem.ATTRIBUTE1 := aSqlItem.ATTRIBUTE1;

Line 4989: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,

4985: P_RETURN_VALUES VARCHAR2,
4986: P_ACTION_COMMIT VARCHAR2,
4987: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
4988: X_MESSAGES OUT NOCOPY OE_MESSAGE_OBJ_T,
4989: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
4990: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
4991: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
4992: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
4993: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,

Line 4990: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,

4986: P_ACTION_COMMIT VARCHAR2,
4987: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
4988: X_MESSAGES OUT NOCOPY OE_MESSAGE_OBJ_T,
4989: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
4990: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
4991: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
4992: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
4993: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
4994: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,

Line 5066: l_header_rec_old OE_ORDER_PUB_HEADER_REC_TYPE;

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;
5067: l_line_tab_old OE_ORDER_PUB_LINE_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;

Line 5697: l_hdr_rec oe_order_pub.header_rec_type;

5693: -- synched to AIA.
5694: DECLARE
5695: l_sso_seq NUMBER;
5696: l_stat VARCHAR2(30);
5697: l_hdr_rec oe_order_pub.header_rec_type;
5698: BEGIN
5699: oe_debug_pub.ADD(' Price Changed on line ' || repr_line_tbl(1).line_id);
5700:
5701: SELECT OE_XML_MESSAGE_SEQ_S.NEXTVAL INTO l_sso_seq FROM dual;

Line 5775: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,

5771: P_RETURN_VALUES VARCHAR2,
5772: P_ACTION_COMMIT VARCHAR2,
5773: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
5774: X_MESSAGES OUT NOCOPY OE_MESSAGE_OBJ_T,
5775: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
5776: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
5777: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
5778: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
5779: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,

Line 5776: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,

5772: P_ACTION_COMMIT VARCHAR2,
5773: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
5774: X_MESSAGES OUT NOCOPY OE_MESSAGE_OBJ_T,
5775: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
5776: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
5777: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
5778: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
5779: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
5780: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,

Line 5824: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE ,

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 ,
5828: X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT ,

Line 5852: P_HEADER_REC_ OE_ORDER_PUB.HEADER_REC_TYPE;

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;
5853: P_OLD_HEADER_REC_ OE_ORDER_PUB.HEADER_REC_TYPE;
5854: P_HEADER_VAL_REC_ OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
5855: P_OLD_HEADER_VAL_REC_ OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
5856: P_HEADER_ADJ_TBL_ OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;

Line 5853: P_OLD_HEADER_REC_ OE_ORDER_PUB.HEADER_REC_TYPE;

5849: P_RTRIM_DATA VARCHAR2
5850: )
5851: IS
5852: P_HEADER_REC_ OE_ORDER_PUB.HEADER_REC_TYPE;
5853: P_OLD_HEADER_REC_ OE_ORDER_PUB.HEADER_REC_TYPE;
5854: P_HEADER_VAL_REC_ OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
5855: P_OLD_HEADER_VAL_REC_ OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
5856: P_HEADER_ADJ_TBL_ OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;
5857: P_OLD_HEADER_ADJ_TBL_ OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;

Line 5901: X_HEADER_REC_ OE_ORDER_PUB.HEADER_REC_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;
5905: X_HEADER_PRICE_ATT_TBL_ OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE;

Line 6395: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,

6391: P_ACTION_COMMIT VARCHAR2,
6392: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
6393: X_MSG_COUNT OUT NOCOPY NUMBER ,
6394: X_MSG_DATA OUT NOCOPY VARCHAR2 ,
6395: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
6396: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
6397: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
6398: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
6399: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,

Line 6396: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,

6392: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
6393: X_MSG_COUNT OUT NOCOPY NUMBER ,
6394: X_MSG_DATA OUT NOCOPY VARCHAR2 ,
6395: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
6396: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
6397: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
6398: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
6399: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
6400: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,

Line 6444: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE ,

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 ,
6448: X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT ,

Line 6591: PROCEDURE Convert_hdr_null_to_miss (p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type)

6587: WHEN OTHERS THEN
6588: RAISE;
6589: END;
6590:
6591: PROCEDURE Convert_hdr_null_to_miss (p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type)
6592: IS
6593: BEGIN
6594: oe_genesis_util.Convert_hdr_null_to_miss (p_x_header_rec);
6595: EXCEPTION