APPS.IGI_CIS2007_IGIPMTHR_PKG dependencies on IGI_CIS_MTH_RET_LINES_T

Line 69: igi_cis_mth_ret_lines_t audit_lines_t

65: AND audit_hdr.period_name = p_in_period
66: UNION all
67: SELECT audit_lines_t.vendor_id
68: FROM igi_cis_mth_ret_hdr_t audit_hdr_t,
69: igi_cis_mth_ret_lines_t audit_lines_t
70: WHERE audit_hdr_t.header_id = audit_lines_t.header_id
71: AND audit_hdr_t.request_status_code = 'R'
72: AND audit_hdr_t.period_name = p_in_period)
73: AND upper(pov.vendor_name)

Line 1057: log(C_STATE_LEVEL, l_procedure_name, 'insert into igi_cis_mth_ret_lines_t');

1053: log(C_STATE_LEVEL, l_procedure_name, 'TOTAL_DEDUCTIONS='||C_nil_ret_rec.TOTAL_DEDUCTIONS);
1054: log(C_STATE_LEVEL, l_procedure_name, 'DISCOUNT_AMOUNT='||C_nil_ret_rec.DISCOUNT_AMOUNT);
1055: log(C_STATE_LEVEL, l_procedure_name, 'CIS_TAX='||C_nil_ret_rec.CIS_TAX);
1056: log(C_STATE_LEVEL, l_procedure_name, '================');
1057: log(C_STATE_LEVEL, l_procedure_name, 'insert into igi_cis_mth_ret_lines_t');
1058: insert into igi_cis_mth_ret_lines_t(
1059: HEADER_ID,
1060: ORG_ID,
1061: VENDOR_ID,

Line 1058: insert into igi_cis_mth_ret_lines_t(

1054: log(C_STATE_LEVEL, l_procedure_name, 'DISCOUNT_AMOUNT='||C_nil_ret_rec.DISCOUNT_AMOUNT);
1055: log(C_STATE_LEVEL, l_procedure_name, 'CIS_TAX='||C_nil_ret_rec.CIS_TAX);
1056: log(C_STATE_LEVEL, l_procedure_name, '================');
1057: log(C_STATE_LEVEL, l_procedure_name, 'insert into igi_cis_mth_ret_lines_t');
1058: insert into igi_cis_mth_ret_lines_t(
1059: HEADER_ID,
1060: ORG_ID,
1061: VENDOR_ID,
1062: VENDOR_NAME,

Line 1138: log(C_STATE_LEVEL, l_procedure_name, 'insert into igi_cis_mth_ret_lines_t');

1134: log(C_STATE_LEVEL, l_procedure_name, 'TOTAL_DEDUCTIONS='||C_n_nil_ret_rec.TOTAL_DEDUCTIONS);
1135: log(C_STATE_LEVEL, l_procedure_name, 'DISCOUNT_AMOUNT='||C_n_nil_ret_rec.DISCOUNT_AMOUNT);
1136: log(C_STATE_LEVEL, l_procedure_name, 'CIS_TAX='||C_n_nil_ret_rec.CIS_TAX);
1137: log(C_STATE_LEVEL, l_procedure_name, '================');
1138: log(C_STATE_LEVEL, l_procedure_name, 'insert into igi_cis_mth_ret_lines_t');
1139: insert into igi_cis_mth_ret_lines_t(
1140: HEADER_ID,
1141: ORG_ID,
1142: VENDOR_ID,

Line 1139: insert into igi_cis_mth_ret_lines_t(

1135: log(C_STATE_LEVEL, l_procedure_name, 'DISCOUNT_AMOUNT='||C_n_nil_ret_rec.DISCOUNT_AMOUNT);
1136: log(C_STATE_LEVEL, l_procedure_name, 'CIS_TAX='||C_n_nil_ret_rec.CIS_TAX);
1137: log(C_STATE_LEVEL, l_procedure_name, '================');
1138: log(C_STATE_LEVEL, l_procedure_name, 'insert into igi_cis_mth_ret_lines_t');
1139: insert into igi_cis_mth_ret_lines_t(
1140: HEADER_ID,
1141: ORG_ID,
1142: VENDOR_ID,
1143: VENDOR_NAME,

Line 1548: from igi_cis_mth_ret_lines_t

1544: FND_GLOBAL.USER_ID(),--LAST_UPDATED_BY
1545: FND_GLOBAL.LOGIN_ID(),--LAST_UPDATE_LOGIN
1546: sysdate, --CREATION_DATE
1547: FND_GLOBAL.USER_ID() --CREATED_BY
1548: from igi_cis_mth_ret_lines_t
1549: where HEADER_ID = p_header_id ;
1550:
1551: insert into igi_cis_mth_ret_pay_h
1552: (HEADER_ID,

Line 1590: delete from igi_cis_mth_ret_lines_t where header_id = p_header_id;

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;
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,

Line 1653: delete from igi_cis_mth_ret_lines_t where header_id = p_header_id;

1649: END IF;
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;*/