APPS.MSC_PHUB_FILE_PKG dependencies on FND_GLOBAL

Line 31: last_updated_by=fnd_global.user_id,

27: l_sql varchar2(200);
28: begin
29: msc_phub_util.log('msc_phub_file_pkg.export_table');
30: update msc_apcc_upload_detail set
31: last_updated_by=fnd_global.user_id,
32: last_update_date=sysdate,
33: last_update_login=fnd_global.login_id,
34: program_id=fnd_global.conc_program_id,
35: program_login_id=fnd_global.conc_login_id,

Line 33: last_update_login=fnd_global.login_id,

29: msc_phub_util.log('msc_phub_file_pkg.export_table');
30: update msc_apcc_upload_detail set
31: last_updated_by=fnd_global.user_id,
32: last_update_date=sysdate,
33: last_update_login=fnd_global.login_id,
34: program_id=fnd_global.conc_program_id,
35: program_login_id=fnd_global.conc_login_id,
36: program_application_id=fnd_global.prog_appl_id,
37: request_id=fnd_global.conc_request_id

Line 34: program_id=fnd_global.conc_program_id,

30: update msc_apcc_upload_detail set
31: last_updated_by=fnd_global.user_id,
32: last_update_date=sysdate,
33: last_update_login=fnd_global.login_id,
34: program_id=fnd_global.conc_program_id,
35: program_login_id=fnd_global.conc_login_id,
36: program_application_id=fnd_global.prog_appl_id,
37: request_id=fnd_global.conc_request_id
38: where transfer_id=p_transfer_id and fact_type=p_fact_type;

Line 35: program_login_id=fnd_global.conc_login_id,

31: last_updated_by=fnd_global.user_id,
32: last_update_date=sysdate,
33: last_update_login=fnd_global.login_id,
34: program_id=fnd_global.conc_program_id,
35: program_login_id=fnd_global.conc_login_id,
36: program_application_id=fnd_global.prog_appl_id,
37: request_id=fnd_global.conc_request_id
38: where transfer_id=p_transfer_id and fact_type=p_fact_type;
39: commit;

Line 36: program_application_id=fnd_global.prog_appl_id,

32: last_update_date=sysdate,
33: last_update_login=fnd_global.login_id,
34: program_id=fnd_global.conc_program_id,
35: program_login_id=fnd_global.conc_login_id,
36: program_application_id=fnd_global.prog_appl_id,
37: request_id=fnd_global.conc_request_id
38: where transfer_id=p_transfer_id and fact_type=p_fact_type;
39: commit;
40:

Line 37: request_id=fnd_global.conc_request_id

33: last_update_login=fnd_global.login_id,
34: program_id=fnd_global.conc_program_id,
35: program_login_id=fnd_global.conc_login_id,
36: program_application_id=fnd_global.prog_appl_id,
37: request_id=fnd_global.conc_request_id
38: where transfer_id=p_transfer_id and fact_type=p_fact_type;
39: commit;
40:
41: retcode := 0;

Line 134: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.login_id

130: -23453 organization_id,
131: date1 plan_start_date,
132: date2 plan_cutoff_date,
133: sysdate plan_completion_date,
134: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.login_id
135: from msc_hub_query
136: where query_id=p_query_id
137: and number1=1;
138:

Line 152: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.login_id

148: number2 fact_type,
149: char3 file_name,
150: blob1 file_data,
151: date1 overwrite_after_date,
152: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.login_id
153: from msc_hub_query
154: where query_id=p_query_id
155: and number1=2
156: and blob1 is not null;

Line 259: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.login_id);

255: l_organization_id,
256: p_plan_start_date,
257: p_plan_cutoff_date,
258: p_plan_completion_date,
259: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.login_id);
260:
261: msc_phub_util.log('msc_phub_file_pkg.prepare_transfer_tables'||
262: ',p_include_ods='||p_include_ods||
263: ',p_include_pds='||p_include_pds||

Line 272: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.login_id

268: transfer_id, fact_type, file_name,
269: created_by, creation_date, last_updated_by, last_update_date, last_update_login)
270: select
271: l_transfer_id, fact_type, upper('msc_st_'||entity_name||'_f')||'.csv',
272: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.login_id
273: from
274: (select rownum fact_type, entity_name, initial_verion from table(msc_phub_pkg.meta_info))
275: where decode(fact_type,4,p_include_ods,p_include_pds)=1
276: and initial_verion<=nvl(p_source_version, msc_phub_util.g_version);

Line 313: last_updated_by=fnd_global.user_id,

309: retcode := 0;
310: errbuf := null;
311:
312: update msc_apcc_upload set
313: last_updated_by=fnd_global.user_id,
314: last_update_date=sysdate,
315: last_update_login=fnd_global.login_id,
316: program_id=fnd_global.conc_program_id,
317: program_login_id=fnd_global.conc_login_id,

Line 315: last_update_login=fnd_global.login_id,

311:
312: update msc_apcc_upload set
313: last_updated_by=fnd_global.user_id,
314: last_update_date=sysdate,
315: last_update_login=fnd_global.login_id,
316: program_id=fnd_global.conc_program_id,
317: program_login_id=fnd_global.conc_login_id,
318: program_application_id=fnd_global.prog_appl_id,
319: request_id=fnd_global.conc_request_id

Line 316: program_id=fnd_global.conc_program_id,

312: update msc_apcc_upload set
313: last_updated_by=fnd_global.user_id,
314: last_update_date=sysdate,
315: last_update_login=fnd_global.login_id,
316: program_id=fnd_global.conc_program_id,
317: program_login_id=fnd_global.conc_login_id,
318: program_application_id=fnd_global.prog_appl_id,
319: request_id=fnd_global.conc_request_id
320: where transfer_id=p_transfer_id;

Line 317: program_login_id=fnd_global.conc_login_id,

313: last_updated_by=fnd_global.user_id,
314: last_update_date=sysdate,
315: last_update_login=fnd_global.login_id,
316: program_id=fnd_global.conc_program_id,
317: program_login_id=fnd_global.conc_login_id,
318: program_application_id=fnd_global.prog_appl_id,
319: request_id=fnd_global.conc_request_id
320: where transfer_id=p_transfer_id;
321: commit;

Line 318: program_application_id=fnd_global.prog_appl_id,

314: last_update_date=sysdate,
315: last_update_login=fnd_global.login_id,
316: program_id=fnd_global.conc_program_id,
317: program_login_id=fnd_global.conc_login_id,
318: program_application_id=fnd_global.prog_appl_id,
319: request_id=fnd_global.conc_request_id
320: where transfer_id=p_transfer_id;
321: commit;
322:

Line 319: request_id=fnd_global.conc_request_id

315: last_update_login=fnd_global.login_id,
316: program_id=fnd_global.conc_program_id,
317: program_login_id=fnd_global.conc_login_id,
318: program_application_id=fnd_global.prog_appl_id,
319: request_id=fnd_global.conc_request_id
320: where transfer_id=p_transfer_id;
321: commit;
322:
323: select source_plan_run_id

Line 373: last_updated_by=fnd_global.user_id,

369: retcode := 0;
370: errbuf := null;
371:
372: update msc_apcc_upload set
373: last_updated_by=fnd_global.user_id,
374: last_update_date=sysdate,
375: last_update_login=fnd_global.login_id,
376: program_id=fnd_global.conc_program_id,
377: program_login_id=fnd_global.conc_login_id,

Line 375: last_update_login=fnd_global.login_id,

371:
372: update msc_apcc_upload set
373: last_updated_by=fnd_global.user_id,
374: last_update_date=sysdate,
375: last_update_login=fnd_global.login_id,
376: program_id=fnd_global.conc_program_id,
377: program_login_id=fnd_global.conc_login_id,
378: program_application_id=fnd_global.prog_appl_id,
379: request_id=fnd_global.conc_request_id

Line 376: program_id=fnd_global.conc_program_id,

372: update msc_apcc_upload set
373: last_updated_by=fnd_global.user_id,
374: last_update_date=sysdate,
375: last_update_login=fnd_global.login_id,
376: program_id=fnd_global.conc_program_id,
377: program_login_id=fnd_global.conc_login_id,
378: program_application_id=fnd_global.prog_appl_id,
379: request_id=fnd_global.conc_request_id
380: where transfer_id=p_transfer_id;

Line 377: program_login_id=fnd_global.conc_login_id,

373: last_updated_by=fnd_global.user_id,
374: last_update_date=sysdate,
375: last_update_login=fnd_global.login_id,
376: program_id=fnd_global.conc_program_id,
377: program_login_id=fnd_global.conc_login_id,
378: program_application_id=fnd_global.prog_appl_id,
379: request_id=fnd_global.conc_request_id
380: where transfer_id=p_transfer_id;
381: commit;

Line 378: program_application_id=fnd_global.prog_appl_id,

374: last_update_date=sysdate,
375: last_update_login=fnd_global.login_id,
376: program_id=fnd_global.conc_program_id,
377: program_login_id=fnd_global.conc_login_id,
378: program_application_id=fnd_global.prog_appl_id,
379: request_id=fnd_global.conc_request_id
380: where transfer_id=p_transfer_id;
381: commit;
382:

Line 379: request_id=fnd_global.conc_request_id

375: last_update_login=fnd_global.login_id,
376: program_id=fnd_global.conc_program_id,
377: program_login_id=fnd_global.conc_login_id,
378: program_application_id=fnd_global.prog_appl_id,
379: request_id=fnd_global.conc_request_id
380: where transfer_id=p_transfer_id;
381: commit;
382:
383: prepare_context(errbuf, retcode, p_transfer_id, msc_phub_pkg.sys_no);

Line 684: last_updated_by=fnd_global.user_id,

680: l_sql varchar2(1000);
681: begin
682: msc_phub_util.log('msc_phub_file_pkg.import_table');
683: update msc_apcc_upload_detail set
684: last_updated_by=fnd_global.user_id,
685: last_update_date=sysdate,
686: last_update_login=fnd_global.login_id,
687: program_id=fnd_global.conc_program_id,
688: program_login_id=fnd_global.conc_login_id,

Line 686: last_update_login=fnd_global.login_id,

682: msc_phub_util.log('msc_phub_file_pkg.import_table');
683: update msc_apcc_upload_detail set
684: last_updated_by=fnd_global.user_id,
685: last_update_date=sysdate,
686: last_update_login=fnd_global.login_id,
687: program_id=fnd_global.conc_program_id,
688: program_login_id=fnd_global.conc_login_id,
689: program_application_id=fnd_global.prog_appl_id,
690: request_id=fnd_global.conc_request_id

Line 687: program_id=fnd_global.conc_program_id,

683: update msc_apcc_upload_detail set
684: last_updated_by=fnd_global.user_id,
685: last_update_date=sysdate,
686: last_update_login=fnd_global.login_id,
687: program_id=fnd_global.conc_program_id,
688: program_login_id=fnd_global.conc_login_id,
689: program_application_id=fnd_global.prog_appl_id,
690: request_id=fnd_global.conc_request_id
691: where transfer_id=p_transfer_id and fact_type=p_fact_type;

Line 688: program_login_id=fnd_global.conc_login_id,

684: last_updated_by=fnd_global.user_id,
685: last_update_date=sysdate,
686: last_update_login=fnd_global.login_id,
687: program_id=fnd_global.conc_program_id,
688: program_login_id=fnd_global.conc_login_id,
689: program_application_id=fnd_global.prog_appl_id,
690: request_id=fnd_global.conc_request_id
691: where transfer_id=p_transfer_id and fact_type=p_fact_type;
692: commit;

Line 689: program_application_id=fnd_global.prog_appl_id,

685: last_update_date=sysdate,
686: last_update_login=fnd_global.login_id,
687: program_id=fnd_global.conc_program_id,
688: program_login_id=fnd_global.conc_login_id,
689: program_application_id=fnd_global.prog_appl_id,
690: request_id=fnd_global.conc_request_id
691: where transfer_id=p_transfer_id and fact_type=p_fact_type;
692: commit;
693:

Line 690: request_id=fnd_global.conc_request_id

686: last_update_login=fnd_global.login_id,
687: program_id=fnd_global.conc_program_id,
688: program_login_id=fnd_global.conc_login_id,
689: program_application_id=fnd_global.prog_appl_id,
690: request_id=fnd_global.conc_request_id
691: where transfer_id=p_transfer_id and fact_type=p_fact_type;
692: commit;
693:
694: retcode := 0;

Line 848: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate

844: nvl(plan_cutoff_date, sysdate),
845: nvl(plan_completion_date, sysdate),
846: 0, 0, 0, 0, 0, plan_type,
847: 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2,
848: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate
849: from msc_apcc_upload
850: where transfer_id=p_transfer_id;
851: commit;
852: