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 5: FUNCTION PL_TO_SQL1(aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE)

1: PACKAGE BODY Oe_Inbound_Int AS
2: /* $Header: OEXOEINB.pls 120.3.12010000.2 2008/12/14 17:41:43 snimmaga ship $ */
3:
4: -------------------------
5: FUNCTION PL_TO_SQL1(aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE)
6: RETURN OE_ORDER_PUB_HEADER_REC_TYPE IS
7: aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE;
8: BEGIN
9: 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 6: RETURN OE_ORDER_PUB_HEADER_REC_TYPE IS

2: /* $Header: OEXOEINB.pls 120.3.12010000.2 2008/12/14 17:41:43 snimmaga ship $ */
3:
4: -------------------------
5: FUNCTION PL_TO_SQL1(aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE)
6: RETURN OE_ORDER_PUB_HEADER_REC_TYPE IS
7: aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE;
8: BEGIN
9: 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,
10: 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 7: aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE;

3:
4: -------------------------
5: FUNCTION PL_TO_SQL1(aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE)
6: RETURN OE_ORDER_PUB_HEADER_REC_TYPE IS
7: aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE;
8: BEGIN
9: 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,
10: 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,
11: 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 9: 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,

5: FUNCTION PL_TO_SQL1(aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE)
6: RETURN OE_ORDER_PUB_HEADER_REC_TYPE IS
7: aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE;
8: BEGIN
9: 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,
10: 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,
11: 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,
12: 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,
13: 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 245: FUNCTION SQL_TO_PL1(aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE)

241: aSqlItem.ORDER_FIRMED_DATE := aPlsqlItem.ORDER_FIRMED_DATE;
242: RETURN aSqlItem;
243: END PL_TO_SQL1;
244:
245: FUNCTION SQL_TO_PL1(aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE)
246: RETURN OE_ORDER_PUB.HEADER_REC_TYPE IS
247: aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE;
248: BEGIN
249: aPlsqlItem.ACCOUNTING_RULE_ID := aSqlItem.ACCOUNTING_RULE_ID;

Line 246: RETURN OE_ORDER_PUB.HEADER_REC_TYPE IS

242: RETURN aSqlItem;
243: END PL_TO_SQL1;
244:
245: FUNCTION SQL_TO_PL1(aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE)
246: RETURN OE_ORDER_PUB.HEADER_REC_TYPE IS
247: aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE;
248: BEGIN
249: aPlsqlItem.ACCOUNTING_RULE_ID := aSqlItem.ACCOUNTING_RULE_ID;
250: aPlsqlItem.AGREEMENT_ID := aSqlItem.AGREEMENT_ID;

Line 247: aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE;

243: END PL_TO_SQL1;
244:
245: FUNCTION SQL_TO_PL1(aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE)
246: RETURN OE_ORDER_PUB.HEADER_REC_TYPE IS
247: aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE;
248: BEGIN
249: aPlsqlItem.ACCOUNTING_RULE_ID := aSqlItem.ACCOUNTING_RULE_ID;
250: aPlsqlItem.AGREEMENT_ID := aSqlItem.AGREEMENT_ID;
251: aPlsqlItem.ATTRIBUTE1 := aSqlItem.ATTRIBUTE1;

Line 4784: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,

4780: P_RETURN_VALUES VARCHAR2,
4781: P_ACTION_COMMIT VARCHAR2,
4782: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
4783: X_MESSAGES OUT NOCOPY OE_MESSAGE_OBJ_T,
4784: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
4785: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
4786: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
4787: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
4788: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,

Line 4785: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,

4781: P_ACTION_COMMIT VARCHAR2,
4782: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
4783: X_MESSAGES OUT NOCOPY OE_MESSAGE_OBJ_T,
4784: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
4785: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
4786: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
4787: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
4788: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
4789: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,

Line 4833: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE ,

4829: P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
4830: P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
4831: P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
4832: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
4833: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE ,
4834: X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T ,
4835: X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T ,
4836: X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_VAL_T ,
4837: X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT ,

Line 4861: P_HEADER_REC_ APPS.OE_ORDER_PUB.HEADER_REC_TYPE;

4857: X_ACTION_REQUEST_TBL OUT NOCOPY OE_ORDER_PUB_REQUEST_TBL_TYPE ,
4858: P_RTRIM_DATA VARCHAR2
4859: )
4860: IS
4861: P_HEADER_REC_ APPS.OE_ORDER_PUB.HEADER_REC_TYPE;
4862: P_OLD_HEADER_REC_ APPS.OE_ORDER_PUB.HEADER_REC_TYPE;
4863: P_HEADER_VAL_REC_ APPS.OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
4864: P_OLD_HEADER_VAL_REC_ APPS.OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
4865: P_HEADER_ADJ_TBL_ APPS.OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;

Line 4862: P_OLD_HEADER_REC_ APPS.OE_ORDER_PUB.HEADER_REC_TYPE;

4858: P_RTRIM_DATA VARCHAR2
4859: )
4860: IS
4861: P_HEADER_REC_ APPS.OE_ORDER_PUB.HEADER_REC_TYPE;
4862: P_OLD_HEADER_REC_ APPS.OE_ORDER_PUB.HEADER_REC_TYPE;
4863: P_HEADER_VAL_REC_ APPS.OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
4864: P_OLD_HEADER_VAL_REC_ APPS.OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
4865: P_HEADER_ADJ_TBL_ APPS.OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;
4866: P_OLD_HEADER_ADJ_TBL_ APPS.OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;

Line 4910: X_HEADER_REC_ APPS.OE_ORDER_PUB.HEADER_REC_TYPE;

4906: P_OLD_LOT_SERIAL_TBL_ APPS.OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE;
4907: P_LOT_SERIAL_VAL_TBL_ APPS.OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE;
4908: P_OLD_LOT_SERIAL_VAL_TBL_ APPS.OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE;
4909: P_ACTION_REQUEST_TBL_ APPS.OE_ORDER_PUB.REQUEST_TBL_TYPE;
4910: X_HEADER_REC_ APPS.OE_ORDER_PUB.HEADER_REC_TYPE;
4911: X_HEADER_VAL_REC_ APPS.OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
4912: X_HEADER_ADJ_TBL_ APPS.OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;
4913: X_HEADER_ADJ_VAL_TBL_ APPS.OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE;
4914: X_HEADER_PRICE_ATT_TBL_ APPS.OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE;

Line 5250: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,

5246: P_ACTION_COMMIT VARCHAR2,
5247: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
5248: X_MSG_COUNT OUT NOCOPY NUMBER ,
5249: X_MSG_DATA OUT NOCOPY VARCHAR2 ,
5250: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
5251: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
5252: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
5253: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
5254: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,

Line 5251: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,

5247: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
5248: X_MSG_COUNT OUT NOCOPY NUMBER ,
5249: X_MSG_DATA OUT NOCOPY VARCHAR2 ,
5250: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
5251: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
5252: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
5253: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
5254: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
5255: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,

Line 5299: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE ,

5295: P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
5296: P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
5297: P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
5298: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
5299: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE ,
5300: X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T ,
5301: X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T ,
5302: X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_VAL_T ,
5303: X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT ,

Line 6738: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type)

6734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6735: END Convert_Line_null_to_miss;
6736:
6737: PROCEDURE Convert_hdr_null_to_miss
6738: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type)
6739: IS
6740: BEGIN
6741: oe_debug_pub.add('Entering CONVERT_HDR_NULL_TO_MISS', 1);
6742: