DBA Data[Home] [Help]

APPS.IGI_CIS2007_IGIPMTHR_PKG dependencies on FND_GLOBAL

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

996: l_org_id,
997: C_rep_entity_rec.cis_sender_id,
998: C_rep_entity_rec.tax_office_number,
999: C_rep_entity_rec.PAYE_REFERENCE,
1000: FND_GLOBAL.CONC_REQUEST_ID(), -- REQUEST_ID
1001: 'P', -- REQUEST_STATUS_CODE
1002: FND_GLOBAL.PROG_APPL_ID(), -- PROGRAM_APPLICATION_ID
1003: FND_GLOBAL.CONC_PROGRAM_ID(), -- PROGRAM_ID
1004: FND_GLOBAL.CONC_LOGIN_ID(), -- PROGRAM_LOGIN_ID

Line 1002: FND_GLOBAL.PROG_APPL_ID(), -- PROGRAM_APPLICATION_ID

998: C_rep_entity_rec.tax_office_number,
999: C_rep_entity_rec.PAYE_REFERENCE,
1000: FND_GLOBAL.CONC_REQUEST_ID(), -- REQUEST_ID
1001: 'P', -- REQUEST_STATUS_CODE
1002: FND_GLOBAL.PROG_APPL_ID(), -- PROGRAM_APPLICATION_ID
1003: FND_GLOBAL.CONC_PROGRAM_ID(), -- PROGRAM_ID
1004: FND_GLOBAL.CONC_LOGIN_ID(), -- PROGRAM_LOGIN_ID
1005: C_rep_entity_rec.UNIQUE_TAX_REFERENCE_NUM,
1006: C_rep_entity_rec.ACCOUNTS_OFFICE_REFERENCE,

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

999: C_rep_entity_rec.PAYE_REFERENCE,
1000: FND_GLOBAL.CONC_REQUEST_ID(), -- REQUEST_ID
1001: 'P', -- REQUEST_STATUS_CODE
1002: FND_GLOBAL.PROG_APPL_ID(), -- PROGRAM_APPLICATION_ID
1003: FND_GLOBAL.CONC_PROGRAM_ID(), -- PROGRAM_ID
1004: FND_GLOBAL.CONC_LOGIN_ID(), -- PROGRAM_LOGIN_ID
1005: C_rep_entity_rec.UNIQUE_TAX_REFERENCE_NUM,
1006: C_rep_entity_rec.ACCOUNTS_OFFICE_REFERENCE,
1007: p_period_name,

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

1000: FND_GLOBAL.CONC_REQUEST_ID(), -- REQUEST_ID
1001: 'P', -- REQUEST_STATUS_CODE
1002: FND_GLOBAL.PROG_APPL_ID(), -- PROGRAM_APPLICATION_ID
1003: FND_GLOBAL.CONC_PROGRAM_ID(), -- PROGRAM_ID
1004: FND_GLOBAL.CONC_LOGIN_ID(), -- PROGRAM_LOGIN_ID
1005: C_rep_entity_rec.UNIQUE_TAX_REFERENCE_NUM,
1006: C_rep_entity_rec.ACCOUNTS_OFFICE_REFERENCE,
1007: p_period_name,
1008: l_period_end_date,

Line 1015: FND_GLOBAL.USER_ID(),

1011: p_subcont_verify_flag,
1012: p_info_crct_flag,
1013: nvl(p_inact_indicat_flag,'N'),
1014: sysdate,
1015: FND_GLOBAL.USER_ID(),
1016: FND_GLOBAL.LOGIN_ID(),
1017: sysdate,
1018: FND_GLOBAL.USER_ID()
1019: );

Line 1016: FND_GLOBAL.LOGIN_ID(),

1012: p_info_crct_flag,
1013: nvl(p_inact_indicat_flag,'N'),
1014: sysdate,
1015: FND_GLOBAL.USER_ID(),
1016: FND_GLOBAL.LOGIN_ID(),
1017: sysdate,
1018: FND_GLOBAL.USER_ID()
1019: );
1020: l_rep_ent_exist := 1;

Line 1018: FND_GLOBAL.USER_ID()

1014: sysdate,
1015: FND_GLOBAL.USER_ID(),
1016: FND_GLOBAL.LOGIN_ID(),
1017: sysdate,
1018: FND_GLOBAL.USER_ID()
1019: );
1020: l_rep_ent_exist := 1;
1021: end loop;
1022: -- for debugging

Line 1108: FND_GLOBAL.USER_ID(),

1104: C_nil_ret_rec.TOTAL_DEDUCTIONS,
1105: C_nil_ret_rec.DISCOUNT_AMOUNT,
1106: C_nil_ret_rec.CIS_TAX,
1107: sysdate,
1108: FND_GLOBAL.USER_ID(),
1109: FND_GLOBAL.LOGIN_ID(),
1110: sysdate,
1111: FND_GLOBAL.USER_ID()
1112: );

Line 1109: FND_GLOBAL.LOGIN_ID(),

1105: C_nil_ret_rec.DISCOUNT_AMOUNT,
1106: C_nil_ret_rec.CIS_TAX,
1107: sysdate,
1108: FND_GLOBAL.USER_ID(),
1109: FND_GLOBAL.LOGIN_ID(),
1110: sysdate,
1111: FND_GLOBAL.USER_ID()
1112: );
1113: End loop;

Line 1111: FND_GLOBAL.USER_ID()

1107: sysdate,
1108: FND_GLOBAL.USER_ID(),
1109: FND_GLOBAL.LOGIN_ID(),
1110: sysdate,
1111: FND_GLOBAL.USER_ID()
1112: );
1113: End loop;
1114: Elsif p_nil_return_flag = 'N' then
1115: log(C_STATE_LEVEL, l_procedure_name, 'p_nil_return_flag is not Y');

Line 1189: FND_GLOBAL.USER_ID(),

1185: C_n_nil_ret_rec.TOTAL_DEDUCTIONS,
1186: C_n_nil_ret_rec.DISCOUNT_AMOUNT,
1187: C_n_nil_ret_rec.CIS_TAX,
1188: sysdate,
1189: FND_GLOBAL.USER_ID(),
1190: FND_GLOBAL.LOGIN_ID(),
1191: sysdate,
1192: FND_GLOBAL.USER_ID()
1193: );

Line 1190: FND_GLOBAL.LOGIN_ID(),

1186: C_n_nil_ret_rec.DISCOUNT_AMOUNT,
1187: C_n_nil_ret_rec.CIS_TAX,
1188: sysdate,
1189: FND_GLOBAL.USER_ID(),
1190: FND_GLOBAL.LOGIN_ID(),
1191: sysdate,
1192: FND_GLOBAL.USER_ID()
1193: );
1194: End loop;

Line 1192: FND_GLOBAL.USER_ID()

1188: sysdate,
1189: FND_GLOBAL.USER_ID(),
1190: FND_GLOBAL.LOGIN_ID(),
1191: sysdate,
1192: FND_GLOBAL.USER_ID()
1193: );
1194: End loop;
1195: End if;
1196: --

Line 1234: FND_GLOBAL.USER_ID(),

1230: TOTAL_DEDUCTIONS,
1231: DISCOUNT_AMOUNT,
1232: CIS_TAX,--11699868
1233: sysdate,
1234: FND_GLOBAL.USER_ID(),
1235: FND_GLOBAL.LOGIN_ID(),
1236: sysdate,
1237: FND_GLOBAL.USER_ID()
1238: from igi_cis_mth_ret_pay_gt;

Line 1235: FND_GLOBAL.LOGIN_ID(),

1231: DISCOUNT_AMOUNT,
1232: CIS_TAX,--11699868
1233: sysdate,
1234: FND_GLOBAL.USER_ID(),
1235: FND_GLOBAL.LOGIN_ID(),
1236: sysdate,
1237: FND_GLOBAL.USER_ID()
1238: from igi_cis_mth_ret_pay_gt;
1239: -- for debugging

Line 1237: FND_GLOBAL.USER_ID()

1233: sysdate,
1234: FND_GLOBAL.USER_ID(),
1235: FND_GLOBAL.LOGIN_ID(),
1236: sysdate,
1237: FND_GLOBAL.USER_ID()
1238: from igi_cis_mth_ret_pay_gt;
1239: -- for debugging
1240: FND_FILE.PUT_LINE(FND_FILE.LOG,'igi_cis_mth_ret_pay_t populate with '||SQL%ROWCOUNT);
1241: commit;

Line 1344: PROGRAM_ID = FND_GLOBAL.CONC_PROGRAM_ID(),

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()
1347: where HEADER_ID = l_prelim_hdr_id;
1348: --call the procedure to mov recods

Line 1345: PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_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()
1347: where HEADER_ID = l_prelim_hdr_id;
1348: --call the procedure to mov recods
1349: -- mov the records and then commit

Line 1346: PROGRAM_LOGIN_ID = FND_GLOBAL.CONC_LOGIN_ID()

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()
1347: where HEADER_ID = l_prelim_hdr_id;
1348: --call the procedure to mov recods
1349: -- mov the records and then commit
1350:

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

1484: SUBCONT_VERIFY_FLAG,
1485: INFORMATION_CORRECT_FLAG,
1486: INACTIVITY_INDICATOR,
1487: sysdate, --LAST_UPDATE_DATE
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

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

1485: INFORMATION_CORRECT_FLAG,
1486: INACTIVITY_INDICATOR,
1487: sysdate, --LAST_UPDATE_DATE
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 ;

Line 1491: FND_GLOBAL.USER_ID() --CREATED_BY

1487: sysdate, --LAST_UPDATE_DATE
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

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

1540: TOTAL_DEDUCTIONS,
1541: DISCOUNT_AMOUNT,
1542: CIS_TAX,
1543: sysdate, --LAST_UPDATE_DATE
1544: FND_GLOBAL.USER_ID(),--LAST_UPDATED_BY
1545: FND_GLOBAL.LOGIN_ID(),--LAST_UPDATE_LOGIN
1546: sysdate, --CREATION_DATE
1547: FND_GLOBAL.USER_ID() --CREATED_BY
1548: from igi_cis_mth_ret_lines_t

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

1541: DISCOUNT_AMOUNT,
1542: CIS_TAX,
1543: sysdate, --LAST_UPDATE_DATE
1544: FND_GLOBAL.USER_ID(),--LAST_UPDATED_BY
1545: FND_GLOBAL.LOGIN_ID(),--LAST_UPDATE_LOGIN
1546: sysdate, --CREATION_DATE
1547: FND_GLOBAL.USER_ID() --CREATED_BY
1548: from igi_cis_mth_ret_lines_t
1549: where HEADER_ID = p_header_id ;

Line 1547: FND_GLOBAL.USER_ID() --CREATED_BY

1543: sysdate, --LAST_UPDATE_DATE
1544: FND_GLOBAL.USER_ID(),--LAST_UPDATED_BY
1545: FND_GLOBAL.LOGIN_ID(),--LAST_UPDATE_LOGIN
1546: sysdate, --CREATION_DATE
1547: FND_GLOBAL.USER_ID() --CREATED_BY
1548: from igi_cis_mth_ret_lines_t
1549: where HEADER_ID = p_header_id ;
1550:
1551: insert into igi_cis_mth_ret_pay_h

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

1573: INVOICE_ID,
1574: INVOICE_PAYMENT_ID,
1575: AMOUNT,
1576: sysdate, --LAST_UPDATE_DATE
1577: FND_GLOBAL.USER_ID(),--LAST_UPDATED_BY
1578: FND_GLOBAL.LOGIN_ID(),--LAST_UPDATE_LOGIN
1579: sysdate, --CREATION_DATE
1580: FND_GLOBAL.USER_ID(), --CREATED_BY
1581: LABOUR_COST,

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

1574: INVOICE_PAYMENT_ID,
1575: AMOUNT,
1576: sysdate, --LAST_UPDATE_DATE
1577: FND_GLOBAL.USER_ID(),--LAST_UPDATED_BY
1578: FND_GLOBAL.LOGIN_ID(),--LAST_UPDATE_LOGIN
1579: sysdate, --CREATION_DATE
1580: FND_GLOBAL.USER_ID(), --CREATED_BY
1581: LABOUR_COST,
1582: MATERIAL_COST,

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

1576: sysdate, --LAST_UPDATE_DATE
1577: FND_GLOBAL.USER_ID(),--LAST_UPDATED_BY
1578: FND_GLOBAL.LOGIN_ID(),--LAST_UPDATE_LOGIN
1579: sysdate, --CREATION_DATE
1580: FND_GLOBAL.USER_ID(), --CREATED_BY
1581: LABOUR_COST,
1582: MATERIAL_COST,
1583: TOTAL_DEDUCTIONS,
1584: DISCOUNT_AMOUNT,