APPS.XTR_STOCK_PKG dependencies on XTR_CONFIRMATION_DETAILS

Line 103: -- Insert into xtr_confirmation details

99: D.PORTFOLIO_CODE, D.DEALER_CODE, D.CLIENT_CODE, D.DEAL_SUBTYPE, D.CPARTY_CODE,
100: 'N', D.PRODUCT_TYPE, nvl(D.LIMIT_CODE, 'NILL'),
101: nvl(D.ACCEPTOR_CODE,D.CPARTY_CODE));
102:
103: -- Insert into xtr_confirmation details
104: XTR_MISC_P.DEAL_ACTIONS
105: (D.deal_type, D.deal_no, 1, 'NEW_STOCK_BUY_CONTRACT',
106: D.cparty_code, D.client_code, l_sysdate,
107: D.company_code, D.status_code, null,

Line 178: -- Insert into xtr_confirmation details

174: End loop;
175:
176: end if;
177:
178: -- Insert into xtr_confirmation details
179: XTR_MISC_P.DEAL_ACTIONS
180: (D.deal_type, D.deal_no, 1, 'NEW_STOCK_SELL_CONTRACT',
181: D.cparty_code, D.client_code, l_sysdate,
182: D.company_code, D.status_code, null,

Line 312: -- Delete entris from XTR_CONFIRMATION_DETAILS table

308: end if;
309:
310:
311: -----------------------------------------------------
312: -- Delete entris from XTR_CONFIRMATION_DETAILS table
313: -----------------------------------------------------
314: delete xtr_confirmation_details
315: where deal_type = 'STOCK'
316: and deal_no = p_deal_no;

Line 314: delete xtr_confirmation_details

310:
311: -----------------------------------------------------
312: -- Delete entris from XTR_CONFIRMATION_DETAILS table
313: -----------------------------------------------------
314: delete xtr_confirmation_details
315: where deal_type = 'STOCK'
316: and deal_no = p_deal_no;
317:
318: ----------------------------------------------------------------------------

Line 576: from xtr_confirmation_details

572: and b.tax_settled_reference is not null;
573:
574: cursor CHK_CONFIRMATION is
575: select 3
576: from xtr_confirmation_details
577: where deal_type = 'STOCK'
578: and transaction_no = p_div_id
579: and (confirmation_validated_by is not null
580: or confirmation_validated_on is not null);

Line 1238: delete xtr_confirmation_details

1234:
1235: -------------------------------
1236: -- Any confirmation details
1237: -------------------------------
1238: delete xtr_confirmation_details
1239: where deal_type = 'STOCK'
1240: and transaction_no = p_div_id;
1241:
1242: return TRUE;