[Home] [Help]
30: AND audit_hdr.period_name = p_in_period
31: UNION all
32: SELECT audit_lines_t.vendor_id
33: FROM igi_cis_mth_ret_hdr_t audit_hdr_t,
34: igi_cis_mth_ret_lines_t audit_lines_t
35: WHERE audit_hdr_t.header_id = audit_lines_t.header_id
36: AND audit_hdr_t.request_status_code = 'R'
37: AND audit_hdr_t.period_name = p_in_period)
38: AND upper(pov.vendor_name)
781: -- populate the lines table
782: --
783: if p_nil_return_flag = 'Y' then
784: For C_nil_ret_rec in C_nil_ret_lines_info loop
785: insert into igi_cis_mth_ret_lines_t(
786: HEADER_ID,
787: ORG_ID,
788: VENDOR_ID,
789: VENDOR_NAME,
837: );
838: End loop;
839: Elsif p_nil_return_flag = 'N' then
840: For C_n_nil_ret_rec in C_non_nil_ret_lines_info loop
841: insert into igi_cis_mth_ret_lines_t(
842: HEADER_ID,
843: ORG_ID,
844: VENDOR_ID,
845: VENDOR_NAME,
1231: FND_GLOBAL.USER_ID(),--LAST_UPDATED_BY
1232: FND_GLOBAL.LOGIN_ID(),--LAST_UPDATE_LOGIN
1233: sysdate, --CREATION_DATE
1234: FND_GLOBAL.USER_ID() --CREATED_BY
1235: from igi_cis_mth_ret_lines_t
1236: where HEADER_ID = p_header_id ;
1237:
1238: insert into igi_cis_mth_ret_pay_h
1239: (HEADER_ID,
1271: from igi_cis_mth_ret_pay_t
1272: where HEADER_ID = p_header_id;
1273: -- delete the records from interface tables
1274: delete from igi_cis_mth_ret_hdr_t where header_id = p_header_id;
1275: delete from igi_cis_mth_ret_lines_t where header_id = p_header_id;
1276: delete from igi_cis_mth_ret_pay_t where header_id = p_header_id;
1277: End MOVE_TO_HISTORY;
1278:
1279: PROCEDURE RUN_MTH_RET_REPORT(p_period_name IN varchar2,
1333: END IF;
1334: IF l_dev_phase = 'COMPLETE' THEN
1335: -- delete records
1336: delete from igi_cis_mth_ret_hdr_t where header_id = p_header_id;
1337: delete from igi_cis_mth_ret_lines_t where header_id = p_header_id;
1338: delete from igi_cis_mth_ret_pay_t where header_id = p_header_id;
1339: commit;
1340: END IF;
1341: End POST_REPORT_DELETE;*/