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_VAL_REC_T

Line 487: FUNCTION PL_TO_SQL2(aPlsqlItem OE_ORDER_PUB.HEADER_VAL_REC_TYPE)

483:
484: RETURN aPlsqlItem;
485: END SQL_TO_PL1;
486:
487: FUNCTION PL_TO_SQL2(aPlsqlItem OE_ORDER_PUB.HEADER_VAL_REC_TYPE)
488: RETURN OE_ORDER_PUB_HEADER_VAL_REC_T IS
489: aSqlItem OE_ORDER_PUB_HEADER_VAL_REC_T;
490: BEGIN
491: aSqlItem := OE_ORDER_PUB_HEADER_VAL_REC_T(NULL, NULL, NULL, NULL, NULL, NULL

Line 488: RETURN OE_ORDER_PUB_HEADER_VAL_REC_T IS

484: RETURN aPlsqlItem;
485: END SQL_TO_PL1;
486:
487: FUNCTION PL_TO_SQL2(aPlsqlItem OE_ORDER_PUB.HEADER_VAL_REC_TYPE)
488: RETURN OE_ORDER_PUB_HEADER_VAL_REC_T IS
489: aSqlItem OE_ORDER_PUB_HEADER_VAL_REC_T;
490: BEGIN
491: aSqlItem := OE_ORDER_PUB_HEADER_VAL_REC_T(NULL, NULL, NULL, NULL, NULL, NULL
492: , NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL

Line 489: aSqlItem OE_ORDER_PUB_HEADER_VAL_REC_T;

485: END SQL_TO_PL1;
486:
487: FUNCTION PL_TO_SQL2(aPlsqlItem OE_ORDER_PUB.HEADER_VAL_REC_TYPE)
488: RETURN OE_ORDER_PUB_HEADER_VAL_REC_T IS
489: aSqlItem OE_ORDER_PUB_HEADER_VAL_REC_T;
490: BEGIN
491: aSqlItem := OE_ORDER_PUB_HEADER_VAL_REC_T(NULL, NULL, NULL, NULL, NULL, NULL
492: , NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
493: , NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL

Line 491: aSqlItem := OE_ORDER_PUB_HEADER_VAL_REC_T(NULL, NULL, NULL, NULL, NULL, NULL

487: FUNCTION PL_TO_SQL2(aPlsqlItem OE_ORDER_PUB.HEADER_VAL_REC_TYPE)
488: RETURN OE_ORDER_PUB_HEADER_VAL_REC_T IS
489: aSqlItem OE_ORDER_PUB_HEADER_VAL_REC_T;
490: BEGIN
491: aSqlItem := OE_ORDER_PUB_HEADER_VAL_REC_T(NULL, NULL, NULL, NULL, NULL, NULL
492: , NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
493: , NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
494: , NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
495: , NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL

Line 654: FUNCTION SQL_TO_PL2(aSqlItem OE_ORDER_PUB_HEADER_VAL_REC_T)

650: aSqlItem.AUTHORING_PARTY := aPlsqlItem.AUTHORING_PARTY;
651: RETURN aSqlItem;
652: END PL_TO_SQL2;
653:
654: FUNCTION SQL_TO_PL2(aSqlItem OE_ORDER_PUB_HEADER_VAL_REC_T)
655: RETURN OE_ORDER_PUB.HEADER_VAL_REC_TYPE IS
656: aPlsqlItem OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
657: BEGIN
658: aPlsqlItem.ACCOUNTING_RULE := aSqlItem.ACCOUNTING_RULE;

Line 655: RETURN OE_ORDER_PUB.HEADER_VAL_REC_TYPE IS

651: RETURN aSqlItem;
652: END PL_TO_SQL2;
653:
654: FUNCTION SQL_TO_PL2(aSqlItem OE_ORDER_PUB_HEADER_VAL_REC_T)
655: RETURN OE_ORDER_PUB.HEADER_VAL_REC_TYPE IS
656: aPlsqlItem OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
657: BEGIN
658: aPlsqlItem.ACCOUNTING_RULE := aSqlItem.ACCOUNTING_RULE;
659: aPlsqlItem.AGREEMENT := aSqlItem.AGREEMENT;

Line 656: aPlsqlItem OE_ORDER_PUB.HEADER_VAL_REC_TYPE;

652: END PL_TO_SQL2;
653:
654: FUNCTION SQL_TO_PL2(aSqlItem OE_ORDER_PUB_HEADER_VAL_REC_T)
655: RETURN OE_ORDER_PUB.HEADER_VAL_REC_TYPE IS
656: aPlsqlItem OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
657: BEGIN
658: aPlsqlItem.ACCOUNTING_RULE := aSqlItem.ACCOUNTING_RULE;
659: aPlsqlItem.AGREEMENT := aSqlItem.AGREEMENT;
660: aPlsqlItem.CONVERSION_TYPE := aSqlItem.CONVERSION_TYPE;

Line 4786: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,

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,
4790: P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,

Line 4787: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,

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,
4790: P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
4791: P_OLD_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,

Line 4834: X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_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 ,
4838: X_HEADER_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ATT_T ,

Line 4863: P_HEADER_VAL_REC_ APPS.OE_ORDER_PUB.HEADER_VAL_REC_TYPE;

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;
4867: P_HEADER_ADJ_VAL_TBL_ APPS.OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE;

Line 4864: P_OLD_HEADER_VAL_REC_ APPS.OE_ORDER_PUB.HEADER_VAL_REC_TYPE;

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;
4867: P_HEADER_ADJ_VAL_TBL_ APPS.OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE;
4868: P_OLD_HEADER_ADJ_VAL_TBL_ APPS.OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE;

Line 4911: X_HEADER_VAL_REC_ APPS.OE_ORDER_PUB.HEADER_VAL_REC_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;
4915: X_HEADER_ADJ_ATT_TBL_ APPS.OE_ORDER_PUB.HEADER_ADJ_ATT_TBL_TYPE;

Line 5252: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,

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,
5256: P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,

Line 5253: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,

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,
5256: P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
5257: P_OLD_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,

Line 5300: X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_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 ,
5304: X_HEADER_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ATT_T ,