746: l_org_id,
747: C_rep_entity_rec.cis_sender_id,
748: C_rep_entity_rec.tax_office_number,
749: C_rep_entity_rec.PAYE_REFERENCE,
750: FND_GLOBAL.CONC_REQUEST_ID(), -- REQUEST_ID
751: 'P', -- REQUEST_STATUS_CODE
752: FND_GLOBAL.PROG_APPL_ID(), -- PROGRAM_APPLICATION_ID
753: FND_GLOBAL.CONC_PROGRAM_ID(), -- PROGRAM_ID
754: FND_GLOBAL.CONC_LOGIN_ID(), -- PROGRAM_LOGIN_ID
748: C_rep_entity_rec.tax_office_number,
749: C_rep_entity_rec.PAYE_REFERENCE,
750: FND_GLOBAL.CONC_REQUEST_ID(), -- REQUEST_ID
751: 'P', -- REQUEST_STATUS_CODE
752: FND_GLOBAL.PROG_APPL_ID(), -- PROGRAM_APPLICATION_ID
753: FND_GLOBAL.CONC_PROGRAM_ID(), -- PROGRAM_ID
754: FND_GLOBAL.CONC_LOGIN_ID(), -- PROGRAM_LOGIN_ID
755: C_rep_entity_rec.UNIQUE_TAX_REFERENCE_NUM,
756: C_rep_entity_rec.ACCOUNTS_OFFICE_REFERENCE,
749: C_rep_entity_rec.PAYE_REFERENCE,
750: FND_GLOBAL.CONC_REQUEST_ID(), -- REQUEST_ID
751: 'P', -- REQUEST_STATUS_CODE
752: FND_GLOBAL.PROG_APPL_ID(), -- PROGRAM_APPLICATION_ID
753: FND_GLOBAL.CONC_PROGRAM_ID(), -- PROGRAM_ID
754: FND_GLOBAL.CONC_LOGIN_ID(), -- PROGRAM_LOGIN_ID
755: C_rep_entity_rec.UNIQUE_TAX_REFERENCE_NUM,
756: C_rep_entity_rec.ACCOUNTS_OFFICE_REFERENCE,
757: p_period_name,
750: FND_GLOBAL.CONC_REQUEST_ID(), -- REQUEST_ID
751: 'P', -- REQUEST_STATUS_CODE
752: FND_GLOBAL.PROG_APPL_ID(), -- PROGRAM_APPLICATION_ID
753: FND_GLOBAL.CONC_PROGRAM_ID(), -- PROGRAM_ID
754: FND_GLOBAL.CONC_LOGIN_ID(), -- PROGRAM_LOGIN_ID
755: C_rep_entity_rec.UNIQUE_TAX_REFERENCE_NUM,
756: C_rep_entity_rec.ACCOUNTS_OFFICE_REFERENCE,
757: p_period_name,
758: l_period_end_date,
761: p_subcont_verify_flag,
762: p_info_crct_flag,
763: nvl(p_inact_indicat_flag,'N'),
764: sysdate,
765: FND_GLOBAL.USER_ID(),
766: FND_GLOBAL.LOGIN_ID(),
767: sysdate,
768: FND_GLOBAL.USER_ID()
769: );
762: p_info_crct_flag,
763: nvl(p_inact_indicat_flag,'N'),
764: sysdate,
765: FND_GLOBAL.USER_ID(),
766: FND_GLOBAL.LOGIN_ID(),
767: sysdate,
768: FND_GLOBAL.USER_ID()
769: );
770: l_rep_ent_exist := 1;
764: sysdate,
765: FND_GLOBAL.USER_ID(),
766: FND_GLOBAL.LOGIN_ID(),
767: sysdate,
768: FND_GLOBAL.USER_ID()
769: );
770: l_rep_ent_exist := 1;
771: end loop;
772: -- for debugging
829: C_nil_ret_rec.MATERIAL_COST,
830: C_nil_ret_rec.TOTAL_DEDUCTIONS,
831: C_nil_ret_rec.DISCOUNT_AMOUNT,
832: sysdate,
833: FND_GLOBAL.USER_ID(),
834: FND_GLOBAL.LOGIN_ID(),
835: sysdate,
836: FND_GLOBAL.USER_ID()
837: );
830: C_nil_ret_rec.TOTAL_DEDUCTIONS,
831: C_nil_ret_rec.DISCOUNT_AMOUNT,
832: sysdate,
833: FND_GLOBAL.USER_ID(),
834: FND_GLOBAL.LOGIN_ID(),
835: sysdate,
836: FND_GLOBAL.USER_ID()
837: );
838: End loop;
832: sysdate,
833: FND_GLOBAL.USER_ID(),
834: FND_GLOBAL.LOGIN_ID(),
835: sysdate,
836: FND_GLOBAL.USER_ID()
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
885: C_n_nil_ret_rec.MATERIAL_COST,
886: C_n_nil_ret_rec.TOTAL_DEDUCTIONS,
887: C_n_nil_ret_rec.DISCOUNT_AMOUNT,
888: sysdate,
889: FND_GLOBAL.USER_ID(),
890: FND_GLOBAL.LOGIN_ID(),
891: sysdate,
892: FND_GLOBAL.USER_ID()
893: );
886: C_n_nil_ret_rec.TOTAL_DEDUCTIONS,
887: C_n_nil_ret_rec.DISCOUNT_AMOUNT,
888: sysdate,
889: FND_GLOBAL.USER_ID(),
890: FND_GLOBAL.LOGIN_ID(),
891: sysdate,
892: FND_GLOBAL.USER_ID()
893: );
894: End loop;
888: sysdate,
889: FND_GLOBAL.USER_ID(),
890: FND_GLOBAL.LOGIN_ID(),
891: sysdate,
892: FND_GLOBAL.USER_ID()
893: );
894: End loop;
895: End if;
896: -- for debugging
929: MATERIAL_COST,
930: TOTAL_DEDUCTIONS,
931: DISCOUNT_AMOUNT,
932: sysdate,
933: FND_GLOBAL.USER_ID(),
934: FND_GLOBAL.LOGIN_ID(),
935: sysdate,
936: FND_GLOBAL.USER_ID()
937: from igi_cis_mth_ret_pay_gt;
930: TOTAL_DEDUCTIONS,
931: DISCOUNT_AMOUNT,
932: sysdate,
933: FND_GLOBAL.USER_ID(),
934: FND_GLOBAL.LOGIN_ID(),
935: sysdate,
936: FND_GLOBAL.USER_ID()
937: from igi_cis_mth_ret_pay_gt;
938: -- for debugging
932: sysdate,
933: FND_GLOBAL.USER_ID(),
934: FND_GLOBAL.LOGIN_ID(),
935: sysdate,
936: FND_GLOBAL.USER_ID()
937: from igi_cis_mth_ret_pay_gt;
938: -- for debugging
939: FND_FILE.PUT_LINE(FND_FILE.LOG,'Payments table is populated');
940: commit;
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()
1043: where HEADER_ID = l_prelim_hdr_id;
1044: --call the procedure to mov recods
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()
1043: where HEADER_ID = l_prelim_hdr_id;
1044: --call the procedure to mov recods
1045: -- mov the records and then commit
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()
1043: where HEADER_ID = l_prelim_hdr_id;
1044: --call the procedure to mov recods
1045: -- mov the records and then commit
1046:
1173: SUBCONT_VERIFY_FLAG,
1174: INFORMATION_CORRECT_FLAG,
1175: INACTIVITY_INDICATOR,
1176: sysdate, --LAST_UPDATE_DATE
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
1174: INFORMATION_CORRECT_FLAG,
1175: INACTIVITY_INDICATOR,
1176: sysdate, --LAST_UPDATE_DATE
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 ;
1176: sysdate, --LAST_UPDATE_DATE
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
1227: MATERIAL_COST,
1228: TOTAL_DEDUCTIONS,
1229: DISCOUNT_AMOUNT,
1230: sysdate, --LAST_UPDATE_DATE
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
1228: TOTAL_DEDUCTIONS,
1229: DISCOUNT_AMOUNT,
1230: sysdate, --LAST_UPDATE_DATE
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 ;
1230: sysdate, --LAST_UPDATE_DATE
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
1259: INVOICE_ID,
1260: INVOICE_PAYMENT_ID,
1261: AMOUNT,
1262: sysdate, --LAST_UPDATE_DATE
1263: FND_GLOBAL.USER_ID(),--LAST_UPDATED_BY
1264: FND_GLOBAL.LOGIN_ID(),--LAST_UPDATE_LOGIN
1265: sysdate, --CREATION_DATE
1266: FND_GLOBAL.USER_ID(), --CREATED_BY
1267: LABOUR_COST,
1260: INVOICE_PAYMENT_ID,
1261: AMOUNT,
1262: sysdate, --LAST_UPDATE_DATE
1263: FND_GLOBAL.USER_ID(),--LAST_UPDATED_BY
1264: FND_GLOBAL.LOGIN_ID(),--LAST_UPDATE_LOGIN
1265: sysdate, --CREATION_DATE
1266: FND_GLOBAL.USER_ID(), --CREATED_BY
1267: LABOUR_COST,
1268: MATERIAL_COST,
1262: sysdate, --LAST_UPDATE_DATE
1263: FND_GLOBAL.USER_ID(),--LAST_UPDATED_BY
1264: FND_GLOBAL.LOGIN_ID(),--LAST_UPDATE_LOGIN
1265: sysdate, --CREATION_DATE
1266: FND_GLOBAL.USER_ID(), --CREATED_BY
1267: LABOUR_COST,
1268: MATERIAL_COST,
1269: TOTAL_DEDUCTIONS,
1270: DISCOUNT_AMOUNT