APPS.IGI_CIS2007_IGIPMTHR_PKG dependencies on IGI_CIS_MTH_RET_HDR_T

Line 68: FROM igi_cis_mth_ret_hdr_t audit_hdr_t,

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

Line 947: SELECT IGI_CIS_MTH_RET_HDR_T_S.nextval

943: end if;
944: --
945: -- get the next header id
946: --
947: SELECT IGI_CIS_MTH_RET_HDR_T_S.nextval
948: INTO l_header_id
949: FROM dual;
950: log(C_STATE_LEVEL, l_procedure_name, 'l_header_id='||l_header_id);
951: --

Line 967: log(C_STATE_LEVEL, l_procedure_name, 'insert into igi_cis_mth_ret_hdr_t');

963: log(C_STATE_LEVEL, l_procedure_name, 'cis_sender_id='||C_rep_entity_rec.cis_sender_id);
964: log(C_STATE_LEVEL, l_procedure_name, 'cis_sender_id='||C_rep_entity_rec.cis_sender_id);
965: -- for debugging
966:
967: log(C_STATE_LEVEL, l_procedure_name, 'insert into igi_cis_mth_ret_hdr_t');
968: insert into igi_cis_mth_ret_hdr_t(
969: HEADER_ID,
970: ORG_ID,
971: CIS_SENDER_ID,

Line 968: insert into igi_cis_mth_ret_hdr_t(

964: log(C_STATE_LEVEL, l_procedure_name, 'cis_sender_id='||C_rep_entity_rec.cis_sender_id);
965: -- for debugging
966:
967: log(C_STATE_LEVEL, l_procedure_name, 'insert into igi_cis_mth_ret_hdr_t');
968: insert into igi_cis_mth_ret_hdr_t(
969: HEADER_ID,
970: ORG_ID,
971: CIS_SENDER_ID,
972: TAX_OFFICE_NUMBER,

Line 1342: update IGI_CIS_MTH_RET_HDR_T

1338: end if;
1339:
1340: l_prelim_hdr_id := l_header_id;
1341: --update the status to C and update who columns
1342: update IGI_CIS_MTH_RET_HDR_T
1343: set --REQUEST_STATUS_CODE = 'C',
1344: PROGRAM_ID = FND_GLOBAL.CONC_PROGRAM_ID(),
1345: PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID(),
1346: PROGRAM_LOGIN_ID = FND_GLOBAL.CONC_LOGIN_ID()

Line 1492: from igi_cis_mth_ret_hdr_t

1488: FND_GLOBAL.USER_ID(),--LAST_UPDATED_BY
1489: FND_GLOBAL.LOGIN_ID(),--LAST_UPDATE_LOGIN
1490: sysdate, --CREATION_DATE
1491: FND_GLOBAL.USER_ID() --CREATED_BY
1492: from igi_cis_mth_ret_hdr_t
1493: where HEADER_ID = p_header_id ;
1494:
1495: insert into igi_cis_mth_ret_lines_h
1496: (HEADER_ID,

Line 1589: delete from igi_cis_mth_ret_hdr_t where header_id = p_header_id;

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;
1591: delete from igi_cis_mth_ret_pay_t where header_id = p_header_id;
1592: End MOVE_TO_HISTORY;
1593:

Line 1652: delete from igi_cis_mth_ret_hdr_t where header_id = p_header_id;

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