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_RELATIONSHIPS

Line 79: from xtr_hedge_relationships r

75: and h.hedge_attribute_id = p_hedge_no;
76:
77: cursor ref_amt is
78: select abs(sum(r.reference_amount)) ref_amt
79: from xtr_hedge_relationships r
80: where r.hedge_attribute_id = p_hedge_no
81: and instrument_item_flag = 'I';
82:
83: cursor reclass is

Line 108: from xtr_hedge_relationships

104:
105: cursor deal_count is
106: select count(primary_code) deal_count,
107: abs(sum(nvl(reference_amount,0))) deal_total
108: from xtr_hedge_relationships
109: where hedge_attribute_id = p_hedge_no
110: and instrument_item_flag = 'U';
111:
112: cursor get_deals is

Line 115: from xtr_hedge_relationships

111:
112: cursor get_deals is
113: select primary_code deal_no,
114: abs(nvl(reference_amount,0)) alloc_ref_amt
115: from xtr_hedge_relationships
116: where hedge_attribute_id = p_hedge_no
117: and instrument_item_flag = 'U';
118:
119: cursor get_cumu(p_hedge_no in number, p_batch_id in number) is

Line 216: LOG_MSG('event', 'updating xtr_hedge_relationships...');

212: set reclass_gain_loss_amt = nvl(l_rec_gl_amt,0),
213: retro_batch_id = p_batch_id
214: where reclass_details_id = p_reclass_id;
215:
216: LOG_MSG('event', 'updating xtr_hedge_relationships...');
217:
218: update xtr_hedge_relationships
219: set cur_pct_allocation = round(pct_allocation * (l_rem_hedge_amt - l_rec_hdg_amt)/l_orig_hedge_amt,2),
220: cur_reference_amt = round(reference_amount * (l_rem_hedge_amt - l_rec_hdg_amt)/l_orig_hedge_amt, l_round)

Line 218: update xtr_hedge_relationships

214: where reclass_details_id = p_reclass_id;
215:
216: LOG_MSG('event', 'updating xtr_hedge_relationships...');
217:
218: update xtr_hedge_relationships
219: set cur_pct_allocation = round(pct_allocation * (l_rem_hedge_amt - l_rec_hdg_amt)/l_orig_hedge_amt,2),
220: cur_reference_amt = round(reference_amount * (l_rem_hedge_amt - l_rec_hdg_amt)/l_orig_hedge_amt, l_round)
221: where hedge_attribute_id = p_hedge_no;
222:

Line 727: from xtr_hedge_relationships

723: --------------------------------------------------------*/
724:
725: cursor ref_amt is
726: select nvl(reference_amount,0) alloc_ref_amt
727: from xtr_hedge_relationships
728: where hedge_attribute_id = p_hedge_no
729: and primary_code = p_deal_no
730: and instrument_item_flag = 'U';
731:

Line 735: from xtr_hedge_relationships

731:
732:
733: cursor ref_tot is
734: select sum(nvl(reference_amount,0)) deal_total
735: from xtr_hedge_relationships
736: where hedge_attribute_id = p_hedge_no
737: and instrument_item_flag = 'U';
738:
739: Begin

Line 948: from xtr_revaluation_details r, xtr_eligible_hedges_v ha, xtr_hedge_relationships hr

944: ,0 unrealised_pl
945: ,0 realised_pl
946: ,0 curr_gain_loss_amount
947: ,NULL realized_flag
948: from xtr_revaluation_details r, xtr_eligible_hedges_v ha, xtr_hedge_relationships hr
949: where batch_id is not null
950: and r.company_code = p_company
951: and r.deal_no = hr.primary_code
952: and r.deal_type = 'FX'

Line 1065: from xtr_hedge_relationships

1061: cursor get_deals(p_hedge_no in number) is
1062: select primary_code deal_no,
1063: cur_pct_allocation deal_pct,
1064: abs(nvl(reference_amount,0)) alloc_ref_amt
1065: from xtr_hedge_relationships
1066: where hedge_attribute_id = p_hedge_no
1067: and instrument_item_flag = 'U';
1068:
1069: /*-------------------------------------------------------

Line 1136: from xtr_hedge_relationships

1132: --------------------------------------------------------*/
1133: cursor deal_count(p_hedge_no in number) is
1134: select count(primary_code) deal_count,
1135: abs(sum(nvl(reference_amount,0))) deal_total
1136: from xtr_hedge_relationships
1137: where hedge_attribute_id = p_hedge_no
1138: and instrument_item_flag = 'U';
1139:
1140: cursor cur_rnd(p_ccy in varchar2) is

Line 1643: FROM XTR_HEDGE_RELATIONSHIPS

1639:
1640: cursor cur_rel(HEDGE_NO IN NUMBER) is
1641: SELECT PRIMARY_CODE TRX_INV_ID, SECONDARY_CODE PAY_SCHEDULE_ID, HEDGE_ATTRIBUTE_ID,
1642: PCT_ALLOCATION, REFERENCE_AMOUNT HEDGE_AMOUNT
1643: FROM XTR_HEDGE_RELATIONSHIPS
1644: WHERE HEDGE_ATTRIBUTE_ID = HEDGE_NO
1645: AND INSTRUMENT_ITEM_FLAG = 'I';
1646:
1647: cursor trx(p_trx_id in number) is

Line 1752: select count(*) from xtr_hedge_relationships

1748:
1749: l_count NUMBER := 0;
1750:
1751: Cursor cur_dtls(p_hedge_no in number) is
1752: select count(*) from xtr_hedge_relationships
1753: where hedge_attribute_id = p_hedge_no
1754: and instrument_item_flag = 'I';
1755:
1756: l_iu_flag VARCHAR2(1) := 'I';

Line 1802: PCT_ALLOCATION, REFERENCE_AMOUNT FROM XTR_HEDGE_RELATIONSHIPS WHERE

1798: CLOSE hcur;
1799: Elsif (l_status in ('FULFILLED','FAILED') or (l_status = 'CURRENT' and l_count <> 0)) then
1800: l_data_source := 'XTR';
1801: l_query := 'SELECT PRIMARY_CODE TRX_INV_ID, SECONDARY_CODE PAY_SCHEDULE_ID, HEDGE_ATTRIBUTE_ID, AMOUNT,
1802: PCT_ALLOCATION, REFERENCE_AMOUNT FROM XTR_HEDGE_RELATIONSHIPS WHERE
1803: INSTRUMENT_ITEM_FLAG = :iu_flag AND HEDGE_ATTRIBUTE_ID = :HEDGE_NO';
1804:
1805: OPEN hcur FOR l_query using l_iu_flag, p_hedge_no;
1806: LOOP

Line 1958: TYPE X_HEDGE_RELATIONSHIP_ID is table of xtr_hedge_relationships.HEDGE_RELATIONSHIP_ID%type Index By BINARY_INTEGER;

1954: TYPE HCurTyp IS REF CURSOR;
1955:
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;

Line 1959: TYPE X_HEDGE_ATTRIBUTE_ID is table of xtr_hedge_relationships.HEDGE_ATTRIBUTE_ID%type Index By BINARY_INTEGER;

1955:
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;

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 1961: TYPE X_PRIMARY_CODE is table of xtr_hedge_relationships.PRIMARY_CODE%type Index By BINARY_INTEGER;

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;
1965: TYPE X_REFERENCE_AMOUNT is table of xtr_hedge_relationships.REFERENCE_AMOUNT%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 1963: TYPE X_INSTRUMENT_ITEM_FLAG is table of xtr_hedge_relationships.INSTRUMENT_ITEM_FLAG%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;
1967: TYPE X_CREATED_BY is table of xtr_hedge_relationships.CREATED_BY%type Index By BINARY_INTEGER;

Line 1964: TYPE X_PCT_ALLOCATION is table of xtr_hedge_relationships.PCT_ALLOCATION%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;
1967: TYPE X_CREATED_BY is table of xtr_hedge_relationships.CREATED_BY%type Index By BINARY_INTEGER;
1968: TYPE X_CREATION_DATE is table of xtr_hedge_relationships.CREATION_DATE%type Index By BINARY_INTEGER;

Line 1965: TYPE X_REFERENCE_AMOUNT is table of xtr_hedge_relationships.REFERENCE_AMOUNT%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;
1967: TYPE X_CREATED_BY is table of xtr_hedge_relationships.CREATED_BY%type Index By BINARY_INTEGER;
1968: TYPE X_CREATION_DATE is table of xtr_hedge_relationships.CREATION_DATE%type Index By BINARY_INTEGER;
1969: TYPE X_LAST_UPDATED_BY is table of xtr_hedge_relationships.LAST_UPDATED_BY%type Index By BINARY_INTEGER;

Line 1966: TYPE X_AMOUNT is table of xtr_hedge_relationships.AMOUNT%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;
1967: TYPE X_CREATED_BY is table of xtr_hedge_relationships.CREATED_BY%type Index By BINARY_INTEGER;
1968: TYPE X_CREATION_DATE is table of xtr_hedge_relationships.CREATION_DATE%type Index By BINARY_INTEGER;
1969: TYPE X_LAST_UPDATED_BY is table of xtr_hedge_relationships.LAST_UPDATED_BY%type Index By BINARY_INTEGER;
1970: TYPE X_LAST_UPDATE_DATE is table of xtr_hedge_relationships.LAST_UPDATE_DATE%type Index By BINARY_INTEGER;

Line 1967: TYPE X_CREATED_BY is table of xtr_hedge_relationships.CREATED_BY%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;
1967: TYPE X_CREATED_BY is table of xtr_hedge_relationships.CREATED_BY%type Index By BINARY_INTEGER;
1968: TYPE X_CREATION_DATE is table of xtr_hedge_relationships.CREATION_DATE%type Index By BINARY_INTEGER;
1969: TYPE X_LAST_UPDATED_BY is table of xtr_hedge_relationships.LAST_UPDATED_BY%type Index By BINARY_INTEGER;
1970: TYPE X_LAST_UPDATE_DATE is table of xtr_hedge_relationships.LAST_UPDATE_DATE%type Index By BINARY_INTEGER;
1971: TYPE X_LAST_UPDATE_LOGIN is table of xtr_hedge_relationships.LAST_UPDATE_LOGIN%type Index By BINARY_INTEGER;

Line 1968: TYPE X_CREATION_DATE is table of xtr_hedge_relationships.CREATION_DATE%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;
1967: TYPE X_CREATED_BY is table of xtr_hedge_relationships.CREATED_BY%type Index By BINARY_INTEGER;
1968: TYPE X_CREATION_DATE is table of xtr_hedge_relationships.CREATION_DATE%type Index By BINARY_INTEGER;
1969: TYPE X_LAST_UPDATED_BY is table of xtr_hedge_relationships.LAST_UPDATED_BY%type Index By BINARY_INTEGER;
1970: TYPE X_LAST_UPDATE_DATE is table of xtr_hedge_relationships.LAST_UPDATE_DATE%type Index By BINARY_INTEGER;
1971: TYPE X_LAST_UPDATE_LOGIN is table of xtr_hedge_relationships.LAST_UPDATE_LOGIN%type Index By BINARY_INTEGER;
1972:

Line 1969: TYPE X_LAST_UPDATED_BY is table of xtr_hedge_relationships.LAST_UPDATED_BY%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;
1967: TYPE X_CREATED_BY is table of xtr_hedge_relationships.CREATED_BY%type Index By BINARY_INTEGER;
1968: TYPE X_CREATION_DATE is table of xtr_hedge_relationships.CREATION_DATE%type Index By BINARY_INTEGER;
1969: TYPE X_LAST_UPDATED_BY is table of xtr_hedge_relationships.LAST_UPDATED_BY%type Index By BINARY_INTEGER;
1970: TYPE X_LAST_UPDATE_DATE is table of xtr_hedge_relationships.LAST_UPDATE_DATE%type Index By BINARY_INTEGER;
1971: TYPE X_LAST_UPDATE_LOGIN is table of xtr_hedge_relationships.LAST_UPDATE_LOGIN%type Index By BINARY_INTEGER;
1972:
1973: HEDGE_RELATIONSHIP_ID X_HEDGE_RELATIONSHIP_ID;

Line 1970: TYPE X_LAST_UPDATE_DATE is table of xtr_hedge_relationships.LAST_UPDATE_DATE%type Index By BINARY_INTEGER;

1966: TYPE X_AMOUNT is table of xtr_hedge_relationships.AMOUNT%type Index By BINARY_INTEGER;
1967: TYPE X_CREATED_BY is table of xtr_hedge_relationships.CREATED_BY%type Index By BINARY_INTEGER;
1968: TYPE X_CREATION_DATE is table of xtr_hedge_relationships.CREATION_DATE%type Index By BINARY_INTEGER;
1969: TYPE X_LAST_UPDATED_BY is table of xtr_hedge_relationships.LAST_UPDATED_BY%type Index By BINARY_INTEGER;
1970: TYPE X_LAST_UPDATE_DATE is table of xtr_hedge_relationships.LAST_UPDATE_DATE%type Index By BINARY_INTEGER;
1971: TYPE X_LAST_UPDATE_LOGIN is table of xtr_hedge_relationships.LAST_UPDATE_LOGIN%type Index By BINARY_INTEGER;
1972:
1973: HEDGE_RELATIONSHIP_ID X_HEDGE_RELATIONSHIP_ID;
1974: HEDGE_ATTRIBUTE_ID X_HEDGE_ATTRIBUTE_ID;

Line 1971: TYPE X_LAST_UPDATE_LOGIN is table of xtr_hedge_relationships.LAST_UPDATE_LOGIN%type Index By BINARY_INTEGER;

1967: TYPE X_CREATED_BY is table of xtr_hedge_relationships.CREATED_BY%type Index By BINARY_INTEGER;
1968: TYPE X_CREATION_DATE is table of xtr_hedge_relationships.CREATION_DATE%type Index By BINARY_INTEGER;
1969: TYPE X_LAST_UPDATED_BY is table of xtr_hedge_relationships.LAST_UPDATED_BY%type Index By BINARY_INTEGER;
1970: TYPE X_LAST_UPDATE_DATE is table of xtr_hedge_relationships.LAST_UPDATE_DATE%type Index By BINARY_INTEGER;
1971: TYPE X_LAST_UPDATE_LOGIN is table of xtr_hedge_relationships.LAST_UPDATE_LOGIN%type Index By BINARY_INTEGER;
1972:
1973: HEDGE_RELATIONSHIP_ID X_HEDGE_RELATIONSHIP_ID;
1974: HEDGE_ATTRIBUTE_ID X_HEDGE_ATTRIBUTE_ID;
1975: SOURCE_TYPE_ID X_SOURCE_TYPE_ID;

Line 1990: xtr_hedge_relationships hr, xtr_hedge_attributes ha

1986: LAST_UPDATE_LOGIN X_LAST_UPDATE_LOGIN;
1987:
1988: cursor pct(p_prim_code in VARCHAR2, p_sec_code in VARCHAR2) is
1989: select nvl(sum(pct_allocation),0) from
1990: xtr_hedge_relationships hr, xtr_hedge_attributes ha
1991: where hr.hedge_attribute_id = ha.hedge_attribute_id
1992: and ((ha.hedge_status in ('DESIGNATE','CURRENT','FULFILLED'))
1993: OR (hedge_status in ('FAILED','DEDESIGNATED') and ha.start_date <= ha.discontinue_date)
1994: )

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;

Line 2058: insert into xtr_hedge_relationships

2054: LAST_UPDATE_LOGIN(k) := fnd_global.login_id;
2055: END LOOP;
2056:
2057: FORALL J in PRIMARY_CODE.FIRST..PRIMARY_CODE.LAST
2058: insert into xtr_hedge_relationships
2059: (HEDGE_RELATIONSHIP_ID,HEDGE_ATTRIBUTE_ID,SOURCE_TYPE_ID,PRIMARY_CODE,
2060: SECONDARY_CODE,INSTRUMENT_ITEM_FLAG,PCT_ALLOCATION,REFERENCE_AMOUNT,AMOUNT,
2061: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
2062: values (HEDGE_RELATIONSHIP_ID(j),HEDGE_ATTRIBUTE_ID(j),SOURCE_TYPE_ID(j),PRIMARY_CODE(j),