DBA Data[Home] [Help]

APPS.XTR_JOURNAL_PROCESS_P dependencies on XTR_UNVAL_DEALS_GT

Line 1210: Insert into xtr_unval_deals_gt

1206: l_user_deal_type := nvl(l_user_deal_type,l_deal_type);
1207: End If;
1208:
1209: Begin
1210: Insert into xtr_unval_deals_gt
1211: (deal_type,
1212: deal_number,
1213: trans_number)
1214: values (l_user_deal_type, l_deal_no, l_trans_no_1);

Line 1234: Insert into xtr_unval_deals_gt

1230: Close DEAL_VAL_BY;
1231: End If;
1232:
1233: Begin
1234: Insert into xtr_unval_deals_gt
1235: (deal_type,
1236: deal_number,
1237: trans_number)
1238: values (l_user_deal_type, l_deal_no, l_trans_no_1);

Line 1255: from xtr_unval_deals_gt;

1251: PROCEDURE PRT_UNVAL_DEALS is
1252:
1253: Cursor UNVAL_DEALS is
1254: Select *
1255: from xtr_unval_deals_gt;
1256:
1257: unval_deals_rec unval_deals%ROWTYPE;
1258: Begin
1259: Open UNVAL_DEALS;

Line 1302: Delete from xtr_unval_deals_gt;

1298: l_iac_valreq := nvl(l_iac_valreq,'N');
1299:
1300:
1301:
1302: Delete from xtr_unval_deals_gt;
1303:
1304: -- End 1336492 addition.
1305:
1306: ----------------------------------------------------------