eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_HE_IMPORT_DATA dependencies on FND_GLOBAL

Line 176: l_created_by CONSTANT NUMBER := FND_GLOBAL.USER_ID;

172: call to new function to check for logically deleted records.
173: ***************************************************************** */
174:
175: l_interface_api_id NUMBER ;
176: l_created_by CONSTANT NUMBER := FND_GLOBAL.USER_ID;
177: l_last_updated_by CONSTANT NUMBER := FND_GLOBAL.LOGIN_ID;
178: l_api_start_dt igs_ad_api_int.start_dt%TYPE;
179: l_insert_record BOOLEAN;
180:

Line 177: l_last_updated_by CONSTANT NUMBER := FND_GLOBAL.LOGIN_ID;

173: ***************************************************************** */
174:
175: l_interface_api_id NUMBER ;
176: l_created_by CONSTANT NUMBER := FND_GLOBAL.USER_ID;
177: l_last_updated_by CONSTANT NUMBER := FND_GLOBAL.LOGIN_ID;
178: l_api_start_dt igs_ad_api_int.start_dt%TYPE;
179: l_insert_record BOOLEAN;
180:
181: -- sjlaport HEFD350 Process 4

Line 499: l_created_by CONSTANT NUMBER := FND_GLOBAL.USER_ID;

495: ***************************************************************** */
496:
497: l_status VARCHAR2(2);
498: l_record_status VARCHAR2(1);
499: l_created_by CONSTANT NUMBER := FND_GLOBAL.USER_ID;
500: l_last_updated_by CONSTANT NUMBER := FND_GLOBAL.LOGIN_ID;
501: l_request_id CONSTANT NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
502: l_program_application_id CONSTANT NUMBER := FND_GLOBAL.PROG_APPL_ID;
503: l_program_id CONSTANT NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

Line 500: l_last_updated_by CONSTANT NUMBER := FND_GLOBAL.LOGIN_ID;

496:
497: l_status VARCHAR2(2);
498: l_record_status VARCHAR2(1);
499: l_created_by CONSTANT NUMBER := FND_GLOBAL.USER_ID;
500: l_last_updated_by CONSTANT NUMBER := FND_GLOBAL.LOGIN_ID;
501: l_request_id CONSTANT NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
502: l_program_application_id CONSTANT NUMBER := FND_GLOBAL.PROG_APPL_ID;
503: l_program_id CONSTANT NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
504: l_interface_id NUMBER ;

Line 501: l_request_id CONSTANT NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

497: l_status VARCHAR2(2);
498: l_record_status VARCHAR2(1);
499: l_created_by CONSTANT NUMBER := FND_GLOBAL.USER_ID;
500: l_last_updated_by CONSTANT NUMBER := FND_GLOBAL.LOGIN_ID;
501: l_request_id CONSTANT NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
502: l_program_application_id CONSTANT NUMBER := FND_GLOBAL.PROG_APPL_ID;
503: l_program_id CONSTANT NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
504: l_interface_id NUMBER ;
505: l_interface_stat_id NUMBER ;

Line 502: l_program_application_id CONSTANT NUMBER := FND_GLOBAL.PROG_APPL_ID;

498: l_record_status VARCHAR2(1);
499: l_created_by CONSTANT NUMBER := FND_GLOBAL.USER_ID;
500: l_last_updated_by CONSTANT NUMBER := FND_GLOBAL.LOGIN_ID;
501: l_request_id CONSTANT NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
502: l_program_application_id CONSTANT NUMBER := FND_GLOBAL.PROG_APPL_ID;
503: l_program_id CONSTANT NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
504: l_interface_id NUMBER ;
505: l_interface_stat_id NUMBER ;
506: l_interface_api_id NUMBER ;

Line 503: l_program_id CONSTANT NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

499: l_created_by CONSTANT NUMBER := FND_GLOBAL.USER_ID;
500: l_last_updated_by CONSTANT NUMBER := FND_GLOBAL.LOGIN_ID;
501: l_request_id CONSTANT NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
502: l_program_application_id CONSTANT NUMBER := FND_GLOBAL.PROG_APPL_ID;
503: l_program_id CONSTANT NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
504: l_interface_id NUMBER ;
505: l_interface_stat_id NUMBER ;
506: l_interface_api_id NUMBER ;
507: l_interface_disablty_id NUMBER ;

Line 1535: fnd_global.user_id,

1531: program_update_date,
1532: program_id)
1533: VALUES ( l_imp_batch_id,
1534: fnd_message.get_string('IGS','IGS_HE_IMP_HESA_DET_BATCH_ID'),
1535: fnd_global.user_id,
1536: SYSDATE,
1537: fnd_global.user_id,
1538: SYSDATE,
1539: fnd_global.login_id,

Line 1537: fnd_global.user_id,

1533: VALUES ( l_imp_batch_id,
1534: fnd_message.get_string('IGS','IGS_HE_IMP_HESA_DET_BATCH_ID'),
1535: fnd_global.user_id,
1536: SYSDATE,
1537: fnd_global.user_id,
1538: SYSDATE,
1539: fnd_global.login_id,
1540: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
1541: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),

Line 1539: fnd_global.login_id,

1535: fnd_global.user_id,
1536: SYSDATE,
1537: fnd_global.user_id,
1538: SYSDATE,
1539: fnd_global.login_id,
1540: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
1541: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
1542: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE),
1543: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id)

Line 1540: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),

1536: SYSDATE,
1537: fnd_global.user_id,
1538: SYSDATE,
1539: fnd_global.login_id,
1540: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
1541: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
1542: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE),
1543: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id)
1544: );

Line 1541: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),

1537: fnd_global.user_id,
1538: SYSDATE,
1539: fnd_global.login_id,
1540: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
1541: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
1542: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE),
1543: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id)
1544: );
1545: END IF ;

Line 1542: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE),

1538: SYSDATE,
1539: fnd_global.login_id,
1540: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
1541: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
1542: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE),
1543: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id)
1544: );
1545: END IF ;
1546:

Line 1543: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id)

1539: fnd_global.login_id,
1540: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
1541: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
1542: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE),
1543: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id)
1544: );
1545: END IF ;
1546:
1547: -- Process all the import interface reocrds for the passed Batch ID

Line 2370: fnd_global.user_id,

2366: 'N',
2367: c_interface_rec.prev_inst_left_date,
2368: '2',
2369: 'N',
2370: fnd_global.user_id,
2371: SYSDATE,
2372: fnd_global.user_id,
2373: SYSDATE,
2374: fnd_global.login_id,

Line 2372: fnd_global.user_id,

2368: '2',
2369: 'N',
2370: fnd_global.user_id,
2371: SYSDATE,
2372: fnd_global.user_id,
2373: SYSDATE,
2374: fnd_global.login_id,
2375: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
2376: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),

Line 2374: fnd_global.login_id,

2370: fnd_global.user_id,
2371: SYSDATE,
2372: fnd_global.user_id,
2373: SYSDATE,
2374: fnd_global.login_id,
2375: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
2376: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
2377: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id),
2378: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE) )

Line 2375: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),

2371: SYSDATE,
2372: fnd_global.user_id,
2373: SYSDATE,
2374: fnd_global.login_id,
2375: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
2376: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
2377: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id),
2378: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE) )
2379: RETURNING interface_acadhis_id INTO l_interface_acadhis_id;

Line 2376: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),

2372: fnd_global.user_id,
2373: SYSDATE,
2374: fnd_global.login_id,
2375: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
2376: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
2377: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id),
2378: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE) )
2379: RETURNING interface_acadhis_id INTO l_interface_acadhis_id;
2380:

Line 2377: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id),

2373: SYSDATE,
2374: fnd_global.login_id,
2375: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
2376: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
2377: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id),
2378: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE) )
2379: RETURNING interface_acadhis_id INTO l_interface_acadhis_id;
2380:
2381: EXCEPTION

Line 2378: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE) )

2374: fnd_global.login_id,
2375: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_request_id),
2376: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.prog_appl_id),
2377: DECODE(fnd_global.conc_request_id,-1,NULL,fnd_global.conc_program_id),
2378: DECODE(fnd_global.conc_request_id,-1,NULL,SYSDATE) )
2379: RETURNING interface_acadhis_id INTO l_interface_acadhis_id;
2380:
2381: EXCEPTION
2382: WHEN OTHERS THEN