DBA Data[Home] [Help]

APPS.XTR_HEDGE_PROCESS_P dependencies on XTR_HEDGE_RELATIONSHIPS_S

Line 1960: TYPE X_SOURCE_TYPE_ID is table of xtr_hedge_relationships.SOURCE_TYPE_ID%type Index By BINARY_INTEGER;

1956: hcur HCurTyp;
1957:
1958: TYPE X_HEDGE_RELATIONSHIP_ID is table of xtr_hedge_relationships.HEDGE_RELATIONSHIP_ID%type Index By BINARY_INTEGER;
1959: TYPE X_HEDGE_ATTRIBUTE_ID is table of xtr_hedge_relationships.HEDGE_ATTRIBUTE_ID%type Index By BINARY_INTEGER;
1960: TYPE X_SOURCE_TYPE_ID is table of xtr_hedge_relationships.SOURCE_TYPE_ID%type Index By BINARY_INTEGER;
1961: TYPE X_PRIMARY_CODE is table of xtr_hedge_relationships.PRIMARY_CODE%type Index By BINARY_INTEGER;
1962: TYPE X_SECONDARY_CODE is table of xtr_hedge_relationships.SECONDARY_CODE%type Index By BINARY_INTEGER;
1963: TYPE X_INSTRUMENT_ITEM_FLAG is table of xtr_hedge_relationships.INSTRUMENT_ITEM_FLAG%type Index By BINARY_INTEGER;
1964: TYPE X_PCT_ALLOCATION is table of xtr_hedge_relationships.PCT_ALLOCATION%type Index By BINARY_INTEGER;

Line 1962: TYPE X_SECONDARY_CODE is table of xtr_hedge_relationships.SECONDARY_CODE%type Index By BINARY_INTEGER;

1958: TYPE X_HEDGE_RELATIONSHIP_ID is table of xtr_hedge_relationships.HEDGE_RELATIONSHIP_ID%type Index By BINARY_INTEGER;
1959: TYPE X_HEDGE_ATTRIBUTE_ID is table of xtr_hedge_relationships.HEDGE_ATTRIBUTE_ID%type Index By BINARY_INTEGER;
1960: TYPE X_SOURCE_TYPE_ID is table of xtr_hedge_relationships.SOURCE_TYPE_ID%type Index By BINARY_INTEGER;
1961: TYPE X_PRIMARY_CODE is table of xtr_hedge_relationships.PRIMARY_CODE%type Index By BINARY_INTEGER;
1962: TYPE X_SECONDARY_CODE is table of xtr_hedge_relationships.SECONDARY_CODE%type Index By BINARY_INTEGER;
1963: TYPE X_INSTRUMENT_ITEM_FLAG is table of xtr_hedge_relationships.INSTRUMENT_ITEM_FLAG%type Index By BINARY_INTEGER;
1964: TYPE X_PCT_ALLOCATION is table of xtr_hedge_relationships.PCT_ALLOCATION%type Index By BINARY_INTEGER;
1965: TYPE X_REFERENCE_AMOUNT is table of xtr_hedge_relationships.REFERENCE_AMOUNT%type Index By BINARY_INTEGER;
1966: TYPE X_AMOUNT is table of xtr_hedge_relationships.AMOUNT%type Index By BINARY_INTEGER;

Line 2045: select xtr_hedge_relationships_s.nextval into HEDGE_RELATIONSHIP_ID(k) from dual;

2041: close pct;
2042:
2043: PCT_ALLOCATION(k) := 100-nvl(l_pct,0);
2044: REFERENCE_AMOUNT(k) := AMOUNT(k) * (PCT_ALLOCATION(k)/100);
2045: select xtr_hedge_relationships_s.nextval into HEDGE_RELATIONSHIP_ID(k) from dual;
2046:
2047: HEDGE_ATTRIBUTE_ID(k) := p_hedge_no;
2048: SOURCE_TYPE_ID(k) := l_source_id;
2049: INSTRUMENT_ITEM_FLAG(k) := l_iu_flag;