APPS.XTR_IG_TRANSFERS_PKG dependencies on XTR_DEAL_DATE_AMOUNTS

Line 97: from xtr_deal_date_amounts

93: p_action_code IN VARCHAR2) return number is
94: -----------------------------------------------------------------------------------------
95: cursor ins_bal is
96: Select sum(cashflow_amount) balance
97: from xtr_deal_date_amounts
98: where cparty_code = p_party_code
99: and company_code = p_company_code
100: and currency = p_currency
101: and deal_type = 'IG'

Line 2099: l_settle_auth xtr_deal_date_amounts.SETTLEMENT_AUTHORISED_BY%TYPE;

2095: -----------------------------------------------------------------------------------------------------
2096:
2097: l_settle VARCHAR2(1);
2098: l_settle_no NUMBER;
2099: l_settle_auth xtr_deal_date_amounts.SETTLEMENT_AUTHORISED_BY%TYPE;
2100: l_settle_date DATE;
2101: l_trans_mts VARCHAR2(1);
2102: l_audit_indic VARCHAR2(1);
2103: l_dummy_num NUMBER;

Line 2122: insert into xtr_DEAL_DATE_AMOUNTS_v

2118: l_trans_mts,
2119: l_audit_indic);
2120: --*****************************************************************************************************************
2121:
2122: insert into xtr_DEAL_DATE_AMOUNTS_v
2123: (DEAL_TYPE,AMOUNT_TYPE,DATE_TYPE,DEAL_NUMBER,TRANSACTION_NUMBER,
2124: TRANSACTION_DATE,CURRENCY,AMOUNT,HCE_AMOUNT,AMOUNT_DATE,
2125: CASHFLOW_AMOUNT,COMPANY_CODE,ACCOUNT_NO,ACTION_CODE,CPARTY_ACCOUNT_NO,
2126: STATUS_CODE,CPARTY_CODE,

Line 2204: insert into xtr_DEAL_DATE_AMOUNTS_v

2200: /* This will not be executed for Open API since interest is zero. */
2201: /*-----------------------------------------------------------------*/
2202: if nvl(G_Ig_Main_Rec.INTEREST_SETTLED,0) <> 0 then
2203:
2204: insert into xtr_DEAL_DATE_AMOUNTS_v
2205: (DEAL_TYPE,AMOUNT_TYPE,DATE_TYPE,DEAL_NUMBER,TRANSACTION_NUMBER,
2206: TRANSACTION_DATE,CURRENCY,AMOUNT,HCE_AMOUNT,AMOUNT_DATE,
2207: CASHFLOW_AMOUNT,COMPANY_CODE,ACCOUNT_NO,ACTION_CODE,CPARTY_ACCOUNT_NO,
2208: STATUS_CODE,CPARTY_CODE,SETTLE,DEAL_SUBTYPE,PRODUCT_TYPE,

Line 2237: l_settle_auth xtr_deal_date_amounts.SETTLEMENT_AUTHORISED_BY%TYPE;

2233: -- 3800146 set values for settlement ***************************************************************************
2234: --*****************************************************************************************************************
2235: l_settle VARCHAR2(1);
2236: l_settle_no NUMBER;
2237: l_settle_auth xtr_deal_date_amounts.SETTLEMENT_AUTHORISED_BY%TYPE;
2238: l_settle_date DATE;
2239: l_trans_mts VARCHAR2(1);
2240: l_audit_indic VARCHAR2(1);
2241: l_dummy_num NUMBER;

Line 2260: insert into xtr_DEAL_DATE_AMOUNTS_v

2256: l_trans_mts,
2257: l_audit_indic);
2258: -----------------------------------------------------------------
2259:
2260: insert into xtr_DEAL_DATE_AMOUNTS_v
2261: (DEAL_TYPE,AMOUNT_TYPE,DATE_TYPE,DEAL_NUMBER,TRANSACTION_NUMBER,
2262: TRANSACTION_DATE,CURRENCY,AMOUNT,HCE_AMOUNT,AMOUNT_DATE,
2263: CASHFLOW_AMOUNT,COMPANY_CODE,ACCOUNT_NO,ACTION_CODE,CPARTY_ACCOUNT_NO,
2264: STATUS_CODE,CPARTY_CODE,

Line 2620: update xtr_deal_date_amounts_v

2616: */
2617:
2618: if p_update = 'Y' then
2619:
2620: update xtr_deal_date_amounts_v
2621: set AMOUNT = abs(nvl(l_bal_out,0)),
2622: HCE_AMOUNT = abs(nvl(l_bal_out_hce,0)),
2623: AMOUNT_DATE = nvl(l_date,G_Ig_curr_date),
2624: --LIMIT_CODE = nvl(l_limit_code,'NILL'),

Line 2641: insert into xtr_DEAL_DATE_AMOUNTS_v (DEAL_TYPE, AMOUNT_TYPE,

2637: and CURRENCY = p_currency
2638: and COMPANY_CODE = p_company_code;
2639:
2640: if SQL%NOTFOUND and l_count <> 0 then
2641: insert into xtr_DEAL_DATE_AMOUNTS_v (DEAL_TYPE, AMOUNT_TYPE,
2642: DATE_TYPE, DEAL_NUMBER,
2643: TRANSACTION_NUMBER, TRANSACTION_DATE,
2644: AMOUNT_DATE, COMPANY_CODE,
2645: STATUS_CODE, CPARTY_CODE, LIMIT_PARTY,