APPS.IGI_CIS2007_IGIPMTHR_PKG dependencies on IGI_CIS_MTH_RET_PAY_GT

Line 146: delete from IGI_CIS_MTH_RET_PAY_GT;

142: l_awt_amnt := 0;
143: l_temp_pay_amount := 0;
144: l_start_date := to_date(p_in_start_date, 'DD-MM-YYYY');
145: l_end_date := to_date(p_in_end_date,'DD-MM-YYYY');
146: delete from IGI_CIS_MTH_RET_PAY_GT;
147: /* if p_in_vendor_from is null then
148: select min(vendor_name) , max(vendor_name)
149: into vendorFrom, vendorTo
150: From po_vendors;

Line 174: log(C_STATE_LEVEL, l_procedure_name, 'Insertint into IGI_CIS_MTH_RET_PAY_GT');

170: l_mat_cost,
171: l_awt_amnt,
172: l_cis_tax);
173:
174: log(C_STATE_LEVEL, l_procedure_name, 'Insertint into IGI_CIS_MTH_RET_PAY_GT');
175: log(C_STATE_LEVEL, l_procedure_name, 'VENDOR_ID='||all_payment_list(i).parent_id);
176: log(C_STATE_LEVEL, l_procedure_name, 'CHILD_VENDOR_ID='||all_payment_list(i).child_id);
177: log(C_STATE_LEVEL, l_procedure_name, 'INVOICE_ID='||all_payment_list(i).invoice_id);
178: log(C_STATE_LEVEL, l_procedure_name, 'INVOICE_PAYMENT_ID='||all_payment_list(i).payment_id);

Line 185: insert into IGI_CIS_MTH_RET_PAY_GT(

181: log(C_STATE_LEVEL, l_procedure_name, 'MATERIAL_COST='||l_mat_cost);
182: log(C_STATE_LEVEL, l_procedure_name, 'TOTAL_DEDUCTIONS='||l_awt_amnt);
183: log(C_STATE_LEVEL, l_procedure_name, 'DISCOUNT_AMOUNT='||all_payment_list(i).discount_amount);
184: log(C_STATE_LEVEL, l_procedure_name, 'CIS_TAX='||l_cis_tax);
185: insert into IGI_CIS_MTH_RET_PAY_GT(
186: VENDOR_ID,
187: CHILD_VENDOR_ID,
188: INVOICE_ID,
189: INVOICE_PAYMENT_ID,

Line 210: /*insert into IGI_CIS_MTH_RET_PAY_GT

206: all_payment_list(i).discount_amount,
207: l_cis_tax);
208: ret_count := ret_count +1;
209: end loop;
210: /*insert into IGI_CIS_MTH_RET_PAY_GT
211: values
212: (c1_rec_info.vendor_id,
213: c1_rec_info.vendor_id,
214: null,

Line 659: total_deductions, discount_amount from igi_cis_mth_ret_pay_gt;*/

655: -- get all the payments info
656: /*cursor C_pay_info is
657: select vendor_id, child_vendor_id, invoice_id,
658: invoice_payment_id, amount, labour_cost, material_cost,
659: total_deductions, discount_amount from igi_cis_mth_ret_pay_gt;*/
660: -- get the reporting entity information
661: Cursor C_rep_entity is
662: Select UNIQUE_TAX_REFERENCE_NUM,ACCOUNTS_OFFICE_REFERENCE,
663: TAX_OFFICE_NUMBER,PAYE_REFERENCE,fnd_profile.value('ORG_ID') ORG_ID,

Line 703: from AP_SUPPLIERS pov, IGI_CIS_MTH_RET_PAY_GT pay

699: sum(nvl(pay.MATERIAL_COST, 0)) MATERIAL_COST,
700: sum(nvl(pay.LABOUR_COST, 0)) LABOUR_COST,
701: sum(nvl(pay.DISCOUNT_AMOUNT, 0)) DISCOUNT_AMOUNT,
702: sum(nvl(pay.CIS_TAX,0)) CIS_TAX
703: from AP_SUPPLIERS pov, IGI_CIS_MTH_RET_PAY_GT pay
704: where pov.vendor_id = pay.vendor_id
705: group by pov.vendor_id,
706: -- Commented for bug 5671997 and add decode to get partnership name in case BT= partnership
707: -- pov.vendor_name,

Line 1238: from igi_cis_mth_ret_pay_gt;

1234: FND_GLOBAL.USER_ID(),
1235: FND_GLOBAL.LOGIN_ID(),
1236: sysdate,
1237: FND_GLOBAL.USER_ID()
1238: from igi_cis_mth_ret_pay_gt;
1239: -- for debugging
1240: FND_FILE.PUT_LINE(FND_FILE.LOG,'igi_cis_mth_ret_pay_t populate with '||SQL%ROWCOUNT);
1241: commit;
1242: --