DBA Data[Home] [Help]

APPS.IGI_CIS2007_IGIPMTHR_PKG dependencies on FND_GLOBAL

Line 750: FND_GLOBAL.CONC_REQUEST_ID(), -- REQUEST_ID

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

Line 752: FND_GLOBAL.PROG_APPL_ID(), -- PROGRAM_APPLICATION_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,

Line 753: FND_GLOBAL.CONC_PROGRAM_ID(), -- PROGRAM_ID

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,

Line 754: FND_GLOBAL.CONC_LOGIN_ID(), -- PROGRAM_LOGIN_ID

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,

Line 765: FND_GLOBAL.USER_ID(),

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: );

Line 766: FND_GLOBAL.LOGIN_ID(),

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;

Line 768: FND_GLOBAL.USER_ID()

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

Line 833: FND_GLOBAL.USER_ID(),

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: );

Line 834: FND_GLOBAL.LOGIN_ID(),

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;

Line 836: FND_GLOBAL.USER_ID()

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

Line 889: FND_GLOBAL.USER_ID(),

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: );

Line 890: FND_GLOBAL.LOGIN_ID(),

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;

Line 892: FND_GLOBAL.USER_ID()

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

Line 933: FND_GLOBAL.USER_ID(),

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;

Line 934: FND_GLOBAL.LOGIN_ID(),

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

Line 936: FND_GLOBAL.USER_ID()

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;

Line 1040: PROGRAM_ID = FND_GLOBAL.CONC_PROGRAM_ID(),

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

Line 1041: PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_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
1045: -- mov the records and then commit

Line 1042: PROGRAM_LOGIN_ID = FND_GLOBAL.CONC_LOGIN_ID()

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:

Line 1177: FND_GLOBAL.USER_ID(),--LAST_UPDATED_BY

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

Line 1178: FND_GLOBAL.LOGIN_ID(),--LAST_UPDATE_LOGIN

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 ;

Line 1180: FND_GLOBAL.USER_ID() --CREATED_BY

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

Line 1231: FND_GLOBAL.USER_ID(),--LAST_UPDATED_BY

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

Line 1232: FND_GLOBAL.LOGIN_ID(),--LAST_UPDATE_LOGIN

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 ;

Line 1234: FND_GLOBAL.USER_ID() --CREATED_BY

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

Line 1263: FND_GLOBAL.USER_ID(),--LAST_UPDATED_BY

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,

Line 1264: FND_GLOBAL.LOGIN_ID(),--LAST_UPDATE_LOGIN

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,

Line 1266: FND_GLOBAL.USER_ID(), --CREATED_BY

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