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.XTR_HEDGE_PROCESS_P dependencies on XTR_HEDGE_ITEMS_TEMP

Line 1590: TYPE X_HEDGE_ATTRIBUTE_ID is table of XTR_HEDGE_ITEMS_TEMP.HEDGE_ATTRIBUTE_ID%type Index By BINARY_INTEGER;

1586:
1587: TYPE HCurTyp IS REF CURSOR;
1588: hcur HCurTyp;
1589:
1590: TYPE X_HEDGE_ATTRIBUTE_ID is table of XTR_HEDGE_ITEMS_TEMP.HEDGE_ATTRIBUTE_ID%type Index By BINARY_INTEGER;
1591: TYPE X_TRX_INV_ID is table of XTR_HEDGE_ITEMS_TEMP.TRX_INV_ID%type Index By BINARY_INTEGER;
1592: TYPE X_PAY_SCHEDULE_ID is table of XTR_HEDGE_ITEMS_TEMP.PAY_SCHEDULE_ID%type Index By BINARY_INTEGER;
1593: TYPE X_SOURCE_NAME is table of XTR_HEDGE_ITEMS_TEMP.SOURCE_NAME%type Index By BINARY_INTEGER;
1594: TYPE X_TRX_TYPE_NAME is table of XTR_HEDGE_ITEMS_TEMP.TRX_TYPE_NAME%type Index By BINARY_INTEGER;

Line 1591: TYPE X_TRX_INV_ID is table of XTR_HEDGE_ITEMS_TEMP.TRX_INV_ID%type Index By BINARY_INTEGER;

1587: TYPE HCurTyp IS REF CURSOR;
1588: hcur HCurTyp;
1589:
1590: TYPE X_HEDGE_ATTRIBUTE_ID is table of XTR_HEDGE_ITEMS_TEMP.HEDGE_ATTRIBUTE_ID%type Index By BINARY_INTEGER;
1591: TYPE X_TRX_INV_ID is table of XTR_HEDGE_ITEMS_TEMP.TRX_INV_ID%type Index By BINARY_INTEGER;
1592: TYPE X_PAY_SCHEDULE_ID is table of XTR_HEDGE_ITEMS_TEMP.PAY_SCHEDULE_ID%type Index By BINARY_INTEGER;
1593: TYPE X_SOURCE_NAME is table of XTR_HEDGE_ITEMS_TEMP.SOURCE_NAME%type Index By BINARY_INTEGER;
1594: TYPE X_TRX_TYPE_NAME is table of XTR_HEDGE_ITEMS_TEMP.TRX_TYPE_NAME%type Index By BINARY_INTEGER;
1595: TYPE X_ORG_NAME is table of XTR_HEDGE_ITEMS_TEMP.ORG_NAME%type Index By BINARY_INTEGER;

Line 1592: TYPE X_PAY_SCHEDULE_ID is table of XTR_HEDGE_ITEMS_TEMP.PAY_SCHEDULE_ID%type Index By BINARY_INTEGER;

1588: hcur HCurTyp;
1589:
1590: TYPE X_HEDGE_ATTRIBUTE_ID is table of XTR_HEDGE_ITEMS_TEMP.HEDGE_ATTRIBUTE_ID%type Index By BINARY_INTEGER;
1591: TYPE X_TRX_INV_ID is table of XTR_HEDGE_ITEMS_TEMP.TRX_INV_ID%type Index By BINARY_INTEGER;
1592: TYPE X_PAY_SCHEDULE_ID is table of XTR_HEDGE_ITEMS_TEMP.PAY_SCHEDULE_ID%type Index By BINARY_INTEGER;
1593: TYPE X_SOURCE_NAME is table of XTR_HEDGE_ITEMS_TEMP.SOURCE_NAME%type Index By BINARY_INTEGER;
1594: TYPE X_TRX_TYPE_NAME is table of XTR_HEDGE_ITEMS_TEMP.TRX_TYPE_NAME%type Index By BINARY_INTEGER;
1595: TYPE X_ORG_NAME is table of XTR_HEDGE_ITEMS_TEMP.ORG_NAME%type Index By BINARY_INTEGER;
1596: TYPE X_VEND_CUST_NAME is table of XTR_HEDGE_ITEMS_TEMP.VEND_CUST_NAME%type Index By BINARY_INTEGER;

Line 1593: TYPE X_SOURCE_NAME is table of XTR_HEDGE_ITEMS_TEMP.SOURCE_NAME%type Index By BINARY_INTEGER;

1589:
1590: TYPE X_HEDGE_ATTRIBUTE_ID is table of XTR_HEDGE_ITEMS_TEMP.HEDGE_ATTRIBUTE_ID%type Index By BINARY_INTEGER;
1591: TYPE X_TRX_INV_ID is table of XTR_HEDGE_ITEMS_TEMP.TRX_INV_ID%type Index By BINARY_INTEGER;
1592: TYPE X_PAY_SCHEDULE_ID is table of XTR_HEDGE_ITEMS_TEMP.PAY_SCHEDULE_ID%type Index By BINARY_INTEGER;
1593: TYPE X_SOURCE_NAME is table of XTR_HEDGE_ITEMS_TEMP.SOURCE_NAME%type Index By BINARY_INTEGER;
1594: TYPE X_TRX_TYPE_NAME is table of XTR_HEDGE_ITEMS_TEMP.TRX_TYPE_NAME%type Index By BINARY_INTEGER;
1595: TYPE X_ORG_NAME is table of XTR_HEDGE_ITEMS_TEMP.ORG_NAME%type Index By BINARY_INTEGER;
1596: TYPE X_VEND_CUST_NAME is table of XTR_HEDGE_ITEMS_TEMP.VEND_CUST_NAME%type Index By BINARY_INTEGER;
1597: TYPE X_TRX_DATE is table of XTR_HEDGE_ITEMS_TEMP.TRX_DATE%type Index By BINARY_INTEGER;

Line 1594: TYPE X_TRX_TYPE_NAME is table of XTR_HEDGE_ITEMS_TEMP.TRX_TYPE_NAME%type Index By BINARY_INTEGER;

1590: TYPE X_HEDGE_ATTRIBUTE_ID is table of XTR_HEDGE_ITEMS_TEMP.HEDGE_ATTRIBUTE_ID%type Index By BINARY_INTEGER;
1591: TYPE X_TRX_INV_ID is table of XTR_HEDGE_ITEMS_TEMP.TRX_INV_ID%type Index By BINARY_INTEGER;
1592: TYPE X_PAY_SCHEDULE_ID is table of XTR_HEDGE_ITEMS_TEMP.PAY_SCHEDULE_ID%type Index By BINARY_INTEGER;
1593: TYPE X_SOURCE_NAME is table of XTR_HEDGE_ITEMS_TEMP.SOURCE_NAME%type Index By BINARY_INTEGER;
1594: TYPE X_TRX_TYPE_NAME is table of XTR_HEDGE_ITEMS_TEMP.TRX_TYPE_NAME%type Index By BINARY_INTEGER;
1595: TYPE X_ORG_NAME is table of XTR_HEDGE_ITEMS_TEMP.ORG_NAME%type Index By BINARY_INTEGER;
1596: TYPE X_VEND_CUST_NAME is table of XTR_HEDGE_ITEMS_TEMP.VEND_CUST_NAME%type Index By BINARY_INTEGER;
1597: TYPE X_TRX_DATE is table of XTR_HEDGE_ITEMS_TEMP.TRX_DATE%type Index By BINARY_INTEGER;
1598: TYPE X_TRX_NUMBER is table of XTR_HEDGE_ITEMS_TEMP.TRX_NUMBER%type Index By BINARY_INTEGER;

Line 1595: TYPE X_ORG_NAME is table of XTR_HEDGE_ITEMS_TEMP.ORG_NAME%type Index By BINARY_INTEGER;

1591: TYPE X_TRX_INV_ID is table of XTR_HEDGE_ITEMS_TEMP.TRX_INV_ID%type Index By BINARY_INTEGER;
1592: TYPE X_PAY_SCHEDULE_ID is table of XTR_HEDGE_ITEMS_TEMP.PAY_SCHEDULE_ID%type Index By BINARY_INTEGER;
1593: TYPE X_SOURCE_NAME is table of XTR_HEDGE_ITEMS_TEMP.SOURCE_NAME%type Index By BINARY_INTEGER;
1594: TYPE X_TRX_TYPE_NAME is table of XTR_HEDGE_ITEMS_TEMP.TRX_TYPE_NAME%type Index By BINARY_INTEGER;
1595: TYPE X_ORG_NAME is table of XTR_HEDGE_ITEMS_TEMP.ORG_NAME%type Index By BINARY_INTEGER;
1596: TYPE X_VEND_CUST_NAME is table of XTR_HEDGE_ITEMS_TEMP.VEND_CUST_NAME%type Index By BINARY_INTEGER;
1597: TYPE X_TRX_DATE is table of XTR_HEDGE_ITEMS_TEMP.TRX_DATE%type Index By BINARY_INTEGER;
1598: TYPE X_TRX_NUMBER is table of XTR_HEDGE_ITEMS_TEMP.TRX_NUMBER%type Index By BINARY_INTEGER;
1599: TYPE X_CURRENCY_CODE is table of XTR_HEDGE_ITEMS_TEMP.CURRENCY_CODE%type Index By BINARY_INTEGER;

Line 1596: TYPE X_VEND_CUST_NAME is table of XTR_HEDGE_ITEMS_TEMP.VEND_CUST_NAME%type Index By BINARY_INTEGER;

1592: TYPE X_PAY_SCHEDULE_ID is table of XTR_HEDGE_ITEMS_TEMP.PAY_SCHEDULE_ID%type Index By BINARY_INTEGER;
1593: TYPE X_SOURCE_NAME is table of XTR_HEDGE_ITEMS_TEMP.SOURCE_NAME%type Index By BINARY_INTEGER;
1594: TYPE X_TRX_TYPE_NAME is table of XTR_HEDGE_ITEMS_TEMP.TRX_TYPE_NAME%type Index By BINARY_INTEGER;
1595: TYPE X_ORG_NAME is table of XTR_HEDGE_ITEMS_TEMP.ORG_NAME%type Index By BINARY_INTEGER;
1596: TYPE X_VEND_CUST_NAME is table of XTR_HEDGE_ITEMS_TEMP.VEND_CUST_NAME%type Index By BINARY_INTEGER;
1597: TYPE X_TRX_DATE is table of XTR_HEDGE_ITEMS_TEMP.TRX_DATE%type Index By BINARY_INTEGER;
1598: TYPE X_TRX_NUMBER is table of XTR_HEDGE_ITEMS_TEMP.TRX_NUMBER%type Index By BINARY_INTEGER;
1599: TYPE X_CURRENCY_CODE is table of XTR_HEDGE_ITEMS_TEMP.CURRENCY_CODE%type Index By BINARY_INTEGER;
1600: TYPE X_AMOUNT is table of XTR_HEDGE_ITEMS_TEMP.AMOUNT%type Index By BINARY_INTEGER;

Line 1597: TYPE X_TRX_DATE is table of XTR_HEDGE_ITEMS_TEMP.TRX_DATE%type Index By BINARY_INTEGER;

1593: TYPE X_SOURCE_NAME is table of XTR_HEDGE_ITEMS_TEMP.SOURCE_NAME%type Index By BINARY_INTEGER;
1594: TYPE X_TRX_TYPE_NAME is table of XTR_HEDGE_ITEMS_TEMP.TRX_TYPE_NAME%type Index By BINARY_INTEGER;
1595: TYPE X_ORG_NAME is table of XTR_HEDGE_ITEMS_TEMP.ORG_NAME%type Index By BINARY_INTEGER;
1596: TYPE X_VEND_CUST_NAME is table of XTR_HEDGE_ITEMS_TEMP.VEND_CUST_NAME%type Index By BINARY_INTEGER;
1597: TYPE X_TRX_DATE is table of XTR_HEDGE_ITEMS_TEMP.TRX_DATE%type Index By BINARY_INTEGER;
1598: TYPE X_TRX_NUMBER is table of XTR_HEDGE_ITEMS_TEMP.TRX_NUMBER%type Index By BINARY_INTEGER;
1599: TYPE X_CURRENCY_CODE is table of XTR_HEDGE_ITEMS_TEMP.CURRENCY_CODE%type Index By BINARY_INTEGER;
1600: TYPE X_AMOUNT is table of XTR_HEDGE_ITEMS_TEMP.AMOUNT%type Index By BINARY_INTEGER;
1601: TYPE X_DUE_DATE is table of XTR_HEDGE_ITEMS_TEMP.DUE_DATE%type Index By BINARY_INTEGER;

Line 1598: TYPE X_TRX_NUMBER is table of XTR_HEDGE_ITEMS_TEMP.TRX_NUMBER%type Index By BINARY_INTEGER;

1594: TYPE X_TRX_TYPE_NAME is table of XTR_HEDGE_ITEMS_TEMP.TRX_TYPE_NAME%type Index By BINARY_INTEGER;
1595: TYPE X_ORG_NAME is table of XTR_HEDGE_ITEMS_TEMP.ORG_NAME%type Index By BINARY_INTEGER;
1596: TYPE X_VEND_CUST_NAME is table of XTR_HEDGE_ITEMS_TEMP.VEND_CUST_NAME%type Index By BINARY_INTEGER;
1597: TYPE X_TRX_DATE is table of XTR_HEDGE_ITEMS_TEMP.TRX_DATE%type Index By BINARY_INTEGER;
1598: TYPE X_TRX_NUMBER is table of XTR_HEDGE_ITEMS_TEMP.TRX_NUMBER%type Index By BINARY_INTEGER;
1599: TYPE X_CURRENCY_CODE is table of XTR_HEDGE_ITEMS_TEMP.CURRENCY_CODE%type Index By BINARY_INTEGER;
1600: TYPE X_AMOUNT is table of XTR_HEDGE_ITEMS_TEMP.AMOUNT%type Index By BINARY_INTEGER;
1601: TYPE X_DUE_DATE is table of XTR_HEDGE_ITEMS_TEMP.DUE_DATE%type Index By BINARY_INTEGER;
1602: TYPE X_PCT_ALLOCATION is table of XTR_HEDGE_ITEMS_TEMP.PCT_ALLOCATION%type Index By BINARY_INTEGER;

Line 1599: TYPE X_CURRENCY_CODE is table of XTR_HEDGE_ITEMS_TEMP.CURRENCY_CODE%type Index By BINARY_INTEGER;

1595: TYPE X_ORG_NAME is table of XTR_HEDGE_ITEMS_TEMP.ORG_NAME%type Index By BINARY_INTEGER;
1596: TYPE X_VEND_CUST_NAME is table of XTR_HEDGE_ITEMS_TEMP.VEND_CUST_NAME%type Index By BINARY_INTEGER;
1597: TYPE X_TRX_DATE is table of XTR_HEDGE_ITEMS_TEMP.TRX_DATE%type Index By BINARY_INTEGER;
1598: TYPE X_TRX_NUMBER is table of XTR_HEDGE_ITEMS_TEMP.TRX_NUMBER%type Index By BINARY_INTEGER;
1599: TYPE X_CURRENCY_CODE is table of XTR_HEDGE_ITEMS_TEMP.CURRENCY_CODE%type Index By BINARY_INTEGER;
1600: TYPE X_AMOUNT is table of XTR_HEDGE_ITEMS_TEMP.AMOUNT%type Index By BINARY_INTEGER;
1601: TYPE X_DUE_DATE is table of XTR_HEDGE_ITEMS_TEMP.DUE_DATE%type Index By BINARY_INTEGER;
1602: TYPE X_PCT_ALLOCATION is table of XTR_HEDGE_ITEMS_TEMP.PCT_ALLOCATION%type Index By BINARY_INTEGER;
1603: TYPE X_REFERENCE_AMOUNT is table of XTR_HEDGE_ITEMS_TEMP.REFERENCE_AMOUNT%type Index By BINARY_INTEGER;

Line 1600: TYPE X_AMOUNT is table of XTR_HEDGE_ITEMS_TEMP.AMOUNT%type Index By BINARY_INTEGER;

1596: TYPE X_VEND_CUST_NAME is table of XTR_HEDGE_ITEMS_TEMP.VEND_CUST_NAME%type Index By BINARY_INTEGER;
1597: TYPE X_TRX_DATE is table of XTR_HEDGE_ITEMS_TEMP.TRX_DATE%type Index By BINARY_INTEGER;
1598: TYPE X_TRX_NUMBER is table of XTR_HEDGE_ITEMS_TEMP.TRX_NUMBER%type Index By BINARY_INTEGER;
1599: TYPE X_CURRENCY_CODE is table of XTR_HEDGE_ITEMS_TEMP.CURRENCY_CODE%type Index By BINARY_INTEGER;
1600: TYPE X_AMOUNT is table of XTR_HEDGE_ITEMS_TEMP.AMOUNT%type Index By BINARY_INTEGER;
1601: TYPE X_DUE_DATE is table of XTR_HEDGE_ITEMS_TEMP.DUE_DATE%type Index By BINARY_INTEGER;
1602: TYPE X_PCT_ALLOCATION is table of XTR_HEDGE_ITEMS_TEMP.PCT_ALLOCATION%type Index By BINARY_INTEGER;
1603: TYPE X_REFERENCE_AMOUNT is table of XTR_HEDGE_ITEMS_TEMP.REFERENCE_AMOUNT%type Index By BINARY_INTEGER;
1604: TYPE X_REQUEST_ID is table of XTR_HEDGE_ITEMS_TEMP.REQUEST_ID%type Index By BINARY_INTEGER;

Line 1601: TYPE X_DUE_DATE is table of XTR_HEDGE_ITEMS_TEMP.DUE_DATE%type Index By BINARY_INTEGER;

1597: TYPE X_TRX_DATE is table of XTR_HEDGE_ITEMS_TEMP.TRX_DATE%type Index By BINARY_INTEGER;
1598: TYPE X_TRX_NUMBER is table of XTR_HEDGE_ITEMS_TEMP.TRX_NUMBER%type Index By BINARY_INTEGER;
1599: TYPE X_CURRENCY_CODE is table of XTR_HEDGE_ITEMS_TEMP.CURRENCY_CODE%type Index By BINARY_INTEGER;
1600: TYPE X_AMOUNT is table of XTR_HEDGE_ITEMS_TEMP.AMOUNT%type Index By BINARY_INTEGER;
1601: TYPE X_DUE_DATE is table of XTR_HEDGE_ITEMS_TEMP.DUE_DATE%type Index By BINARY_INTEGER;
1602: TYPE X_PCT_ALLOCATION is table of XTR_HEDGE_ITEMS_TEMP.PCT_ALLOCATION%type Index By BINARY_INTEGER;
1603: TYPE X_REFERENCE_AMOUNT is table of XTR_HEDGE_ITEMS_TEMP.REFERENCE_AMOUNT%type Index By BINARY_INTEGER;
1604: TYPE X_REQUEST_ID is table of XTR_HEDGE_ITEMS_TEMP.REQUEST_ID%type Index By BINARY_INTEGER;
1605: TYPE X_CREATED_BY is table of XTR_HEDGE_ITEMS_TEMP.CREATED_BY%type Index By BINARY_INTEGER;

Line 1602: TYPE X_PCT_ALLOCATION is table of XTR_HEDGE_ITEMS_TEMP.PCT_ALLOCATION%type Index By BINARY_INTEGER;

1598: TYPE X_TRX_NUMBER is table of XTR_HEDGE_ITEMS_TEMP.TRX_NUMBER%type Index By BINARY_INTEGER;
1599: TYPE X_CURRENCY_CODE is table of XTR_HEDGE_ITEMS_TEMP.CURRENCY_CODE%type Index By BINARY_INTEGER;
1600: TYPE X_AMOUNT is table of XTR_HEDGE_ITEMS_TEMP.AMOUNT%type Index By BINARY_INTEGER;
1601: TYPE X_DUE_DATE is table of XTR_HEDGE_ITEMS_TEMP.DUE_DATE%type Index By BINARY_INTEGER;
1602: TYPE X_PCT_ALLOCATION is table of XTR_HEDGE_ITEMS_TEMP.PCT_ALLOCATION%type Index By BINARY_INTEGER;
1603: TYPE X_REFERENCE_AMOUNT is table of XTR_HEDGE_ITEMS_TEMP.REFERENCE_AMOUNT%type Index By BINARY_INTEGER;
1604: TYPE X_REQUEST_ID is table of XTR_HEDGE_ITEMS_TEMP.REQUEST_ID%type Index By BINARY_INTEGER;
1605: TYPE X_CREATED_BY is table of XTR_HEDGE_ITEMS_TEMP.CREATED_BY%type Index By BINARY_INTEGER;
1606: TYPE X_CREATION_DATE is table of XTR_HEDGE_ITEMS_TEMP.CREATION_DATE%type Index By BINARY_INTEGER;

Line 1603: TYPE X_REFERENCE_AMOUNT is table of XTR_HEDGE_ITEMS_TEMP.REFERENCE_AMOUNT%type Index By BINARY_INTEGER;

1599: TYPE X_CURRENCY_CODE is table of XTR_HEDGE_ITEMS_TEMP.CURRENCY_CODE%type Index By BINARY_INTEGER;
1600: TYPE X_AMOUNT is table of XTR_HEDGE_ITEMS_TEMP.AMOUNT%type Index By BINARY_INTEGER;
1601: TYPE X_DUE_DATE is table of XTR_HEDGE_ITEMS_TEMP.DUE_DATE%type Index By BINARY_INTEGER;
1602: TYPE X_PCT_ALLOCATION is table of XTR_HEDGE_ITEMS_TEMP.PCT_ALLOCATION%type Index By BINARY_INTEGER;
1603: TYPE X_REFERENCE_AMOUNT is table of XTR_HEDGE_ITEMS_TEMP.REFERENCE_AMOUNT%type Index By BINARY_INTEGER;
1604: TYPE X_REQUEST_ID is table of XTR_HEDGE_ITEMS_TEMP.REQUEST_ID%type Index By BINARY_INTEGER;
1605: TYPE X_CREATED_BY is table of XTR_HEDGE_ITEMS_TEMP.CREATED_BY%type Index By BINARY_INTEGER;
1606: TYPE X_CREATION_DATE is table of XTR_HEDGE_ITEMS_TEMP.CREATION_DATE%type Index By BINARY_INTEGER;
1607: TYPE X_LAST_UPDATED_BY is table of XTR_HEDGE_ITEMS_TEMP.LAST_UPDATED_BY%type Index By BINARY_INTEGER;

Line 1604: TYPE X_REQUEST_ID is table of XTR_HEDGE_ITEMS_TEMP.REQUEST_ID%type Index By BINARY_INTEGER;

1600: TYPE X_AMOUNT is table of XTR_HEDGE_ITEMS_TEMP.AMOUNT%type Index By BINARY_INTEGER;
1601: TYPE X_DUE_DATE is table of XTR_HEDGE_ITEMS_TEMP.DUE_DATE%type Index By BINARY_INTEGER;
1602: TYPE X_PCT_ALLOCATION is table of XTR_HEDGE_ITEMS_TEMP.PCT_ALLOCATION%type Index By BINARY_INTEGER;
1603: TYPE X_REFERENCE_AMOUNT is table of XTR_HEDGE_ITEMS_TEMP.REFERENCE_AMOUNT%type Index By BINARY_INTEGER;
1604: TYPE X_REQUEST_ID is table of XTR_HEDGE_ITEMS_TEMP.REQUEST_ID%type Index By BINARY_INTEGER;
1605: TYPE X_CREATED_BY is table of XTR_HEDGE_ITEMS_TEMP.CREATED_BY%type Index By BINARY_INTEGER;
1606: TYPE X_CREATION_DATE is table of XTR_HEDGE_ITEMS_TEMP.CREATION_DATE%type Index By BINARY_INTEGER;
1607: TYPE X_LAST_UPDATED_BY is table of XTR_HEDGE_ITEMS_TEMP.LAST_UPDATED_BY%type Index By BINARY_INTEGER;
1608: TYPE X_LAST_UPDATE_DATE is table of XTR_HEDGE_ITEMS_TEMP.LAST_UPDATE_DATE%type Index By BINARY_INTEGER;

Line 1605: TYPE X_CREATED_BY is table of XTR_HEDGE_ITEMS_TEMP.CREATED_BY%type Index By BINARY_INTEGER;

1601: TYPE X_DUE_DATE is table of XTR_HEDGE_ITEMS_TEMP.DUE_DATE%type Index By BINARY_INTEGER;
1602: TYPE X_PCT_ALLOCATION is table of XTR_HEDGE_ITEMS_TEMP.PCT_ALLOCATION%type Index By BINARY_INTEGER;
1603: TYPE X_REFERENCE_AMOUNT is table of XTR_HEDGE_ITEMS_TEMP.REFERENCE_AMOUNT%type Index By BINARY_INTEGER;
1604: TYPE X_REQUEST_ID is table of XTR_HEDGE_ITEMS_TEMP.REQUEST_ID%type Index By BINARY_INTEGER;
1605: TYPE X_CREATED_BY is table of XTR_HEDGE_ITEMS_TEMP.CREATED_BY%type Index By BINARY_INTEGER;
1606: TYPE X_CREATION_DATE is table of XTR_HEDGE_ITEMS_TEMP.CREATION_DATE%type Index By BINARY_INTEGER;
1607: TYPE X_LAST_UPDATED_BY is table of XTR_HEDGE_ITEMS_TEMP.LAST_UPDATED_BY%type Index By BINARY_INTEGER;
1608: TYPE X_LAST_UPDATE_DATE is table of XTR_HEDGE_ITEMS_TEMP.LAST_UPDATE_DATE%type Index By BINARY_INTEGER;
1609: TYPE X_LAST_UPDATE_LOGIN is table of XTR_HEDGE_ITEMS_TEMP.LAST_UPDATE_LOGIN %type Index By BINARY_INTEGER;

Line 1606: TYPE X_CREATION_DATE is table of XTR_HEDGE_ITEMS_TEMP.CREATION_DATE%type Index By BINARY_INTEGER;

1602: TYPE X_PCT_ALLOCATION is table of XTR_HEDGE_ITEMS_TEMP.PCT_ALLOCATION%type Index By BINARY_INTEGER;
1603: TYPE X_REFERENCE_AMOUNT is table of XTR_HEDGE_ITEMS_TEMP.REFERENCE_AMOUNT%type Index By BINARY_INTEGER;
1604: TYPE X_REQUEST_ID is table of XTR_HEDGE_ITEMS_TEMP.REQUEST_ID%type Index By BINARY_INTEGER;
1605: TYPE X_CREATED_BY is table of XTR_HEDGE_ITEMS_TEMP.CREATED_BY%type Index By BINARY_INTEGER;
1606: TYPE X_CREATION_DATE is table of XTR_HEDGE_ITEMS_TEMP.CREATION_DATE%type Index By BINARY_INTEGER;
1607: TYPE X_LAST_UPDATED_BY is table of XTR_HEDGE_ITEMS_TEMP.LAST_UPDATED_BY%type Index By BINARY_INTEGER;
1608: TYPE X_LAST_UPDATE_DATE is table of XTR_HEDGE_ITEMS_TEMP.LAST_UPDATE_DATE%type Index By BINARY_INTEGER;
1609: TYPE X_LAST_UPDATE_LOGIN is table of XTR_HEDGE_ITEMS_TEMP.LAST_UPDATE_LOGIN %type Index By BINARY_INTEGER;
1610:

Line 1607: TYPE X_LAST_UPDATED_BY is table of XTR_HEDGE_ITEMS_TEMP.LAST_UPDATED_BY%type Index By BINARY_INTEGER;

1603: TYPE X_REFERENCE_AMOUNT is table of XTR_HEDGE_ITEMS_TEMP.REFERENCE_AMOUNT%type Index By BINARY_INTEGER;
1604: TYPE X_REQUEST_ID is table of XTR_HEDGE_ITEMS_TEMP.REQUEST_ID%type Index By BINARY_INTEGER;
1605: TYPE X_CREATED_BY is table of XTR_HEDGE_ITEMS_TEMP.CREATED_BY%type Index By BINARY_INTEGER;
1606: TYPE X_CREATION_DATE is table of XTR_HEDGE_ITEMS_TEMP.CREATION_DATE%type Index By BINARY_INTEGER;
1607: TYPE X_LAST_UPDATED_BY is table of XTR_HEDGE_ITEMS_TEMP.LAST_UPDATED_BY%type Index By BINARY_INTEGER;
1608: TYPE X_LAST_UPDATE_DATE is table of XTR_HEDGE_ITEMS_TEMP.LAST_UPDATE_DATE%type Index By BINARY_INTEGER;
1609: TYPE X_LAST_UPDATE_LOGIN is table of XTR_HEDGE_ITEMS_TEMP.LAST_UPDATE_LOGIN %type Index By BINARY_INTEGER;
1610:
1611: HEDGE_ATTRIBUTE_ID X_HEDGE_ATTRIBUTE_ID;

Line 1608: TYPE X_LAST_UPDATE_DATE is table of XTR_HEDGE_ITEMS_TEMP.LAST_UPDATE_DATE%type Index By BINARY_INTEGER;

1604: TYPE X_REQUEST_ID is table of XTR_HEDGE_ITEMS_TEMP.REQUEST_ID%type Index By BINARY_INTEGER;
1605: TYPE X_CREATED_BY is table of XTR_HEDGE_ITEMS_TEMP.CREATED_BY%type Index By BINARY_INTEGER;
1606: TYPE X_CREATION_DATE is table of XTR_HEDGE_ITEMS_TEMP.CREATION_DATE%type Index By BINARY_INTEGER;
1607: TYPE X_LAST_UPDATED_BY is table of XTR_HEDGE_ITEMS_TEMP.LAST_UPDATED_BY%type Index By BINARY_INTEGER;
1608: TYPE X_LAST_UPDATE_DATE is table of XTR_HEDGE_ITEMS_TEMP.LAST_UPDATE_DATE%type Index By BINARY_INTEGER;
1609: TYPE X_LAST_UPDATE_LOGIN is table of XTR_HEDGE_ITEMS_TEMP.LAST_UPDATE_LOGIN %type Index By BINARY_INTEGER;
1610:
1611: HEDGE_ATTRIBUTE_ID X_HEDGE_ATTRIBUTE_ID;
1612: TRX_INV_ID X_TRX_INV_ID;

Line 1609: TYPE X_LAST_UPDATE_LOGIN is table of XTR_HEDGE_ITEMS_TEMP.LAST_UPDATE_LOGIN %type Index By BINARY_INTEGER;

1605: TYPE X_CREATED_BY is table of XTR_HEDGE_ITEMS_TEMP.CREATED_BY%type Index By BINARY_INTEGER;
1606: TYPE X_CREATION_DATE is table of XTR_HEDGE_ITEMS_TEMP.CREATION_DATE%type Index By BINARY_INTEGER;
1607: TYPE X_LAST_UPDATED_BY is table of XTR_HEDGE_ITEMS_TEMP.LAST_UPDATED_BY%type Index By BINARY_INTEGER;
1608: TYPE X_LAST_UPDATE_DATE is table of XTR_HEDGE_ITEMS_TEMP.LAST_UPDATE_DATE%type Index By BINARY_INTEGER;
1609: TYPE X_LAST_UPDATE_LOGIN is table of XTR_HEDGE_ITEMS_TEMP.LAST_UPDATE_LOGIN %type Index By BINARY_INTEGER;
1610:
1611: HEDGE_ATTRIBUTE_ID X_HEDGE_ATTRIBUTE_ID;
1612: TRX_INV_ID X_TRX_INV_ID;
1613: PAY_SCHEDULE_ID X_PAY_SCHEDULE_ID;

Line 1929: insert into XTR_HEDGE_ITEMS_TEMP(HEDGE_ATTRIBUTE_ID,

1925: End If;
1926:
1927: IF (l_data_source = 'EXT' AND idx > 1) OR (l_data_source = 'XTR' AND cnt > 1) then
1928: FORALL J in TRX_INV_ID.FIRST..TRX_INV_ID.LAST
1929: insert into XTR_HEDGE_ITEMS_TEMP(HEDGE_ATTRIBUTE_ID,
1930: TRX_INV_ID,PAY_SCHEDULE_ID,SOURCE_NAME,
1931: TRX_TYPE_NAME, ORG_NAME,VEND_CUST_NAME,TRX_DATE,
1932: TRX_NUMBER,CURRENCY_CODE, AMOUNT,PCT_ALLOCATION, REFERENCE_AMOUNT,
1933: DUE_DATE,REQUEST_ID,CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,