DBA Data[Home] [Help]

APPS.XTR_JOURNAL_PROCESS_P dependencies on XTR_UNVAL_DEALS_GT

Line 1211: Insert into xtr_unval_deals_gt

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

Line 1235: Insert into xtr_unval_deals_gt

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

Line 1256: from xtr_unval_deals_gt;

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

Line 1303: Delete from xtr_unval_deals_gt;

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