APPS.IGI_CIS2007_IGIPMTHR_PKG dependencies on IGI_CIS_MTH_RET_HDR_T

Line 33: FROM igi_cis_mth_ret_hdr_t audit_hdr_t,

29: AND audit_hdr.request_status_code = 'C'
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)

Line 705: SELECT IGI_CIS_MTH_RET_HDR_T_S.nextval

701: end if;
702: --
703: -- get the next header id
704: --
705: SELECT IGI_CIS_MTH_RET_HDR_T_S.nextval
706: INTO l_header_id
707: FROM dual;
708: -- for debugging
709: FND_FILE.PUT_LINE(FND_FILE.LOG,'Header Id: ' || l_header_id);

Line 718: insert into igi_cis_mth_ret_hdr_t(

714: l_org_id := C_rep_entity_rec.ORG_ID;
715: -- for debugging
716: FND_FILE.PUT_LINE(FND_FILE.LOG,'Org id: ' || l_org_id);
717:
718: insert into igi_cis_mth_ret_hdr_t(
719: HEADER_ID,
720: ORG_ID,
721: CIS_SENDER_ID,
722: TAX_OFFICE_NUMBER,

Line 1038: update IGI_CIS_MTH_RET_HDR_T

1034: end if;
1035:
1036: l_prelim_hdr_id := l_header_id;
1037: --update the status to C and update who columns
1038: update IGI_CIS_MTH_RET_HDR_T
1039: set --REQUEST_STATUS_CODE = 'C',
1040: PROGRAM_ID = FND_GLOBAL.CONC_PROGRAM_ID(),
1041: PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID(),
1042: PROGRAM_LOGIN_ID = FND_GLOBAL.CONC_LOGIN_ID()

Line 1181: from igi_cis_mth_ret_hdr_t

1177: FND_GLOBAL.USER_ID(),--LAST_UPDATED_BY
1178: FND_GLOBAL.LOGIN_ID(),--LAST_UPDATE_LOGIN
1179: sysdate, --CREATION_DATE
1180: FND_GLOBAL.USER_ID() --CREATED_BY
1181: from igi_cis_mth_ret_hdr_t
1182: where HEADER_ID = p_header_id ;
1183:
1184: insert into igi_cis_mth_ret_lines_h
1185: (HEADER_ID,

Line 1274: delete from igi_cis_mth_ret_hdr_t where header_id = p_header_id;

1270: DISCOUNT_AMOUNT
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:

Line 1336: delete from igi_cis_mth_ret_hdr_t where header_id = p_header_id;

1332: RAISE e_request_wait_error;
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;