eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGI_CIS2007_IGIPMTHR_PKG dependencies on IGI_CIS_MTH_RET_PAY_T

Line 232: p_inv_pay_id in number, --igi_cis_mth_ret_pay_t.invoice_payment_id%Type,

228: log(C_STATE_LEVEL, l_procedure_name, 'END EXCEPTION');
229: END Populate_Vendors;
230:
231: PROCEDURE GET_PAYMENT_CIS_DETAILS(
232: p_inv_pay_id in number, --igi_cis_mth_ret_pay_t.invoice_payment_id%Type,
233: p_inv_id in number,
234: p_tax_mth_start_date in date,
235: p_tax_mth_end_date in date,
236: p_pay_amount in out nocopy number, --igi_cis_mth_ret_pay_t.payment_amount%Type,

Line 236: p_pay_amount in out nocopy number, --igi_cis_mth_ret_pay_t.payment_amount%Type,

232: p_inv_pay_id in number, --igi_cis_mth_ret_pay_t.invoice_payment_id%Type,
233: p_inv_id in number,
234: p_tax_mth_start_date in date,
235: p_tax_mth_end_date in date,
236: p_pay_amount in out nocopy number, --igi_cis_mth_ret_pay_t.payment_amount%Type,
237: p_discount_amount in number,
238: p_labour_cost out nocopy number, --igi_cis_mth_ret_pay_t.labour_cost%Type,
239: p_material_cost out nocopy number, --igi_cis_mth_ret_pay_t.material_cost%Type,
240: p_awt_amount out nocopy number,--igi_cis_mth_ret_pay_t.total_deductions%Type

Line 238: p_labour_cost out nocopy number, --igi_cis_mth_ret_pay_t.labour_cost%Type,

234: p_tax_mth_start_date in date,
235: p_tax_mth_end_date in date,
236: p_pay_amount in out nocopy number, --igi_cis_mth_ret_pay_t.payment_amount%Type,
237: p_discount_amount in number,
238: p_labour_cost out nocopy number, --igi_cis_mth_ret_pay_t.labour_cost%Type,
239: p_material_cost out nocopy number, --igi_cis_mth_ret_pay_t.material_cost%Type,
240: p_awt_amount out nocopy number,--igi_cis_mth_ret_pay_t.total_deductions%Type
241: p_cis_tax out nocopy number --igi_cis_mth_ret_pay_t.vat_amount%Type,
242: )

Line 239: p_material_cost out nocopy number, --igi_cis_mth_ret_pay_t.material_cost%Type,

235: p_tax_mth_end_date in date,
236: p_pay_amount in out nocopy number, --igi_cis_mth_ret_pay_t.payment_amount%Type,
237: p_discount_amount in number,
238: p_labour_cost out nocopy number, --igi_cis_mth_ret_pay_t.labour_cost%Type,
239: p_material_cost out nocopy number, --igi_cis_mth_ret_pay_t.material_cost%Type,
240: p_awt_amount out nocopy number,--igi_cis_mth_ret_pay_t.total_deductions%Type
241: p_cis_tax out nocopy number --igi_cis_mth_ret_pay_t.vat_amount%Type,
242: )
243: IS

Line 240: p_awt_amount out nocopy number,--igi_cis_mth_ret_pay_t.total_deductions%Type

236: p_pay_amount in out nocopy number, --igi_cis_mth_ret_pay_t.payment_amount%Type,
237: p_discount_amount in number,
238: p_labour_cost out nocopy number, --igi_cis_mth_ret_pay_t.labour_cost%Type,
239: p_material_cost out nocopy number, --igi_cis_mth_ret_pay_t.material_cost%Type,
240: p_awt_amount out nocopy number,--igi_cis_mth_ret_pay_t.total_deductions%Type
241: p_cis_tax out nocopy number --igi_cis_mth_ret_pay_t.vat_amount%Type,
242: )
243: IS
244: l_procedure_name VARCHAR2(100):='.GET_PAYMENT_CIS_DETAILS';

Line 241: p_cis_tax out nocopy number --igi_cis_mth_ret_pay_t.vat_amount%Type,

237: p_discount_amount in number,
238: p_labour_cost out nocopy number, --igi_cis_mth_ret_pay_t.labour_cost%Type,
239: p_material_cost out nocopy number, --igi_cis_mth_ret_pay_t.material_cost%Type,
240: p_awt_amount out nocopy number,--igi_cis_mth_ret_pay_t.total_deductions%Type
241: p_cis_tax out nocopy number --igi_cis_mth_ret_pay_t.vat_amount%Type,
242: )
243: IS
244: l_procedure_name VARCHAR2(100):='.GET_PAYMENT_CIS_DETAILS';
245: -- Fetch the invoice_amount

Line 364: l_inv_labour_amount number; --igi_cis_mth_ret_pay_t.labour_cost%Type;

360: where tax_name in (
361: select name from ap_tax_codes_all
362: where awt_vendor_id = fnd_profile.value('IGI_CIS2007_TAX_AUTHORITY')));
363: l_inv_amount number;
364: l_inv_labour_amount number; --igi_cis_mth_ret_pay_t.labour_cost%Type;
365: l_inv_material_amount number; --igi_cis_mth_ret_pay_t.material_cost%Type;
366: l_awt_amount number; --igi_cis_mth_ret_pay_t.total_deductions%Type;
367: l_material_amount number; --igi_cis_mth_ret_pay_t.material_cost%Type;
368: l_labour_amount number; --igi_cis_mth_ret_pay_t.labour_cost%Type;

Line 365: l_inv_material_amount number; --igi_cis_mth_ret_pay_t.material_cost%Type;

361: select name from ap_tax_codes_all
362: where awt_vendor_id = fnd_profile.value('IGI_CIS2007_TAX_AUTHORITY')));
363: l_inv_amount number;
364: l_inv_labour_amount number; --igi_cis_mth_ret_pay_t.labour_cost%Type;
365: l_inv_material_amount number; --igi_cis_mth_ret_pay_t.material_cost%Type;
366: l_awt_amount number; --igi_cis_mth_ret_pay_t.total_deductions%Type;
367: l_material_amount number; --igi_cis_mth_ret_pay_t.material_cost%Type;
368: l_labour_amount number; --igi_cis_mth_ret_pay_t.labour_cost%Type;
369: -- Start 5609552

Line 366: l_awt_amount number; --igi_cis_mth_ret_pay_t.total_deductions%Type;

362: where awt_vendor_id = fnd_profile.value('IGI_CIS2007_TAX_AUTHORITY')));
363: l_inv_amount number;
364: l_inv_labour_amount number; --igi_cis_mth_ret_pay_t.labour_cost%Type;
365: l_inv_material_amount number; --igi_cis_mth_ret_pay_t.material_cost%Type;
366: l_awt_amount number; --igi_cis_mth_ret_pay_t.total_deductions%Type;
367: l_material_amount number; --igi_cis_mth_ret_pay_t.material_cost%Type;
368: l_labour_amount number; --igi_cis_mth_ret_pay_t.labour_cost%Type;
369: -- Start 5609552
370: l_vat_amount number; ---bug fix for 5609552

Line 367: l_material_amount number; --igi_cis_mth_ret_pay_t.material_cost%Type;

363: l_inv_amount number;
364: l_inv_labour_amount number; --igi_cis_mth_ret_pay_t.labour_cost%Type;
365: l_inv_material_amount number; --igi_cis_mth_ret_pay_t.material_cost%Type;
366: l_awt_amount number; --igi_cis_mth_ret_pay_t.total_deductions%Type;
367: l_material_amount number; --igi_cis_mth_ret_pay_t.material_cost%Type;
368: l_labour_amount number; --igi_cis_mth_ret_pay_t.labour_cost%Type;
369: -- Start 5609552
370: l_vat_amount number; ---bug fix for 5609552
371: l_inv_vat_amount number; ---bug fix for 5609552

Line 368: l_labour_amount number; --igi_cis_mth_ret_pay_t.labour_cost%Type;

364: l_inv_labour_amount number; --igi_cis_mth_ret_pay_t.labour_cost%Type;
365: l_inv_material_amount number; --igi_cis_mth_ret_pay_t.material_cost%Type;
366: l_awt_amount number; --igi_cis_mth_ret_pay_t.total_deductions%Type;
367: l_material_amount number; --igi_cis_mth_ret_pay_t.material_cost%Type;
368: l_labour_amount number; --igi_cis_mth_ret_pay_t.labour_cost%Type;
369: -- Start 5609552
370: l_vat_amount number; ---bug fix for 5609552
371: l_inv_vat_amount number; ---bug fix for 5609552
372: -- End 5609552

Line 1199: log(C_STATE_LEVEL, l_procedure_name, 'insert into igi_cis_mth_ret_pay_t');

1195: End if;
1196: --
1197: -- populate the payments table
1198: --
1199: log(C_STATE_LEVEL, l_procedure_name, 'insert into igi_cis_mth_ret_pay_t');
1200: insert into igi_cis_mth_ret_pay_t
1201: (
1202: HEADER_ID,
1203: ORG_ID,

Line 1200: insert into igi_cis_mth_ret_pay_t

1196: --
1197: -- populate the payments table
1198: --
1199: log(C_STATE_LEVEL, l_procedure_name, 'insert into igi_cis_mth_ret_pay_t');
1200: insert into igi_cis_mth_ret_pay_t
1201: (
1202: HEADER_ID,
1203: ORG_ID,
1204: VENDOR_ID,

Line 1240: FND_FILE.PUT_LINE(FND_FILE.LOG,'igi_cis_mth_ret_pay_t populate with '||SQL%ROWCOUNT);

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: --
1243: -- submit the CP request to run the subcontractor deduction report
1244: --

Line 1586: from igi_cis_mth_ret_pay_t

1582: MATERIAL_COST,
1583: TOTAL_DEDUCTIONS,
1584: DISCOUNT_AMOUNT,
1585: CIS_TAX
1586: from igi_cis_mth_ret_pay_t
1587: where HEADER_ID = p_header_id;
1588: -- delete the records from interface tables
1589: delete from igi_cis_mth_ret_hdr_t where header_id = p_header_id;
1590: delete from igi_cis_mth_ret_lines_t where header_id = p_header_id;

Line 1591: delete from igi_cis_mth_ret_pay_t where header_id = p_header_id;

1587: where HEADER_ID = p_header_id;
1588: -- delete the records from interface tables
1589: delete from igi_cis_mth_ret_hdr_t where header_id = p_header_id;
1590: delete from igi_cis_mth_ret_lines_t where header_id = p_header_id;
1591: delete from igi_cis_mth_ret_pay_t where header_id = p_header_id;
1592: End MOVE_TO_HISTORY;
1593:
1594: PROCEDURE RUN_MTH_RET_REPORT(p_period_name IN varchar2,
1595: p_orig_dub IN varchar2,

Line 1654: delete from igi_cis_mth_ret_pay_t where header_id = p_header_id;

1650: IF l_dev_phase = 'COMPLETE' THEN
1651: -- delete records
1652: delete from igi_cis_mth_ret_hdr_t where header_id = p_header_id;
1653: delete from igi_cis_mth_ret_lines_t where header_id = p_header_id;
1654: delete from igi_cis_mth_ret_pay_t where header_id = p_header_id;
1655: commit;
1656: END IF;
1657: End POST_REPORT_DELETE;*/
1658: BEGIN