APPS.JAI_CMN_ST_FORMS_PKG dependencies on FND_GLOBAL

Line 451: v_uid := fnd_global.USER_ID;

447: Fnd_File.put_line(Fnd_File.LOG, '**** ========================================== ****');
448: Fnd_File.put_line(Fnd_File.LOG, '**** Start procedure - jai_cmn_st_forms_pkg.generate_ap_forms ****');
449: end if;
450:
451: v_uid := fnd_global.USER_ID;
452:
453: v_error_flag := 'N';
454:
455: v_processed_inv_cnt := 0;

Line 1056: OPEN c_program_id(FND_GLOBAL.CONC_REQUEST_ID);

1052:
1053: if P_Enable_Trace = 'Y' or P_Enable_Trace = 'y' then
1054: execute immediate 'ALTER SESSION SET EVENTS ''10046 trace name context forever, level 4''' ;
1055:
1056: OPEN c_program_id(FND_GLOBAL.CONC_REQUEST_ID);
1057: FETCH c_program_id INTO v_program_id, v_enable_trace;
1058: CLOSE c_program_id;
1059:
1060: fnd_file.put_line(FND_FILE.LOG, 'v_program_id -> '||v_program_id

Line 1062: ||', request_id -> '||FND_GLOBAL.CONC_REQUEST_ID);

1058: CLOSE c_program_id;
1059:
1060: fnd_file.put_line(FND_FILE.LOG, 'v_program_id -> '||v_program_id
1061: ||', v_enable_trace -> '||v_enable_trace
1062: ||', request_id -> '||FND_GLOBAL.CONC_REQUEST_ID);
1063:
1064: if v_enable_trace = 'Y' THEN
1065: OPEN get_audsid;
1066: FETCH get_audsid INTO sid, serial, spid;

Line 1455: fnd_global.user_id ,

1451: st_forms_rec.customer_id ,
1452: st_forms_rec.customer_site_id ,
1453: tax_rec.stform_type ,
1454: sysdate ,
1455: fnd_global.user_id ,
1456: sysdate ,
1457: fnd_global.user_id ,
1458: fnd_global.login_id ,
1459: st_forms_rec.org_id ,

Line 1457: fnd_global.user_id ,

1453: tax_rec.stform_type ,
1454: sysdate ,
1455: fnd_global.user_id ,
1456: sysdate ,
1457: fnd_global.user_id ,
1458: fnd_global.login_id ,
1459: st_forms_rec.org_id ,
1460: 'C'
1461: ) RETURNING st_hdr_id INTO v_st_hdr_id;

Line 1458: fnd_global.login_id ,

1454: sysdate ,
1455: fnd_global.user_id ,
1456: sysdate ,
1457: fnd_global.user_id ,
1458: fnd_global.login_id ,
1459: st_forms_rec.org_id ,
1460: 'C'
1461: ) RETURNING st_hdr_id INTO v_st_hdr_id;
1462: fnd_file.put_line(FND_FILE.LOG,' inserting into JAI_CMN_STFORM_HDRS_ALL table with header id '|| v_st_hdr_id);

Line 1540: fnd_global.user_id ,

1536: v_orgn_id ,
1537: v_locn_id ,
1538: 'ISO' ,
1539: sysdate ,
1540: fnd_global.user_id ,
1541: sysdate ,
1542: fnd_global.user_id ,
1543: fnd_global.login_id
1544:

Line 1542: fnd_global.user_id ,

1538: 'ISO' ,
1539: sysdate ,
1540: fnd_global.user_id ,
1541: sysdate ,
1542: fnd_global.user_id ,
1543: fnd_global.login_id
1544:
1545: ) RETURNING st_dtl_id INTO v_st_line_id;
1546: fnd_file.put_line(FND_FILE.LOG,' inserting into JAI_CMN_ST_FORM_DTLS table with detail id :' ||v_st_line_id );

Line 1543: fnd_global.login_id

1539: sysdate ,
1540: fnd_global.user_id ,
1541: sysdate ,
1542: fnd_global.user_id ,
1543: fnd_global.login_id
1544:
1545: ) RETURNING st_dtl_id INTO v_st_line_id;
1546: fnd_file.put_line(FND_FILE.LOG,' inserting into JAI_CMN_ST_FORM_DTLS table with detail id :' ||v_st_line_id );
1547: v_base_tax_amt :=NULL;

Line 1944: fnd_global.user_id ,

1940: st_forms_rec.customer_id ,
1941: st_forms_rec.customer_site_id ,
1942: tax_rec.stform_type ,
1943: sysdate ,
1944: fnd_global.user_id ,
1945: sysdate ,
1946: fnd_global.user_id ,
1947: fnd_global.login_id ,
1948: st_forms_rec.org_id ,

Line 1946: fnd_global.user_id ,

1942: tax_rec.stform_type ,
1943: sysdate ,
1944: fnd_global.user_id ,
1945: sysdate ,
1946: fnd_global.user_id ,
1947: fnd_global.login_id ,
1948: st_forms_rec.org_id ,
1949: 'C'
1950: ) RETURNING st_hdr_id INTO v_st_hdr_id;

Line 1947: fnd_global.login_id ,

1943: sysdate ,
1944: fnd_global.user_id ,
1945: sysdate ,
1946: fnd_global.user_id ,
1947: fnd_global.login_id ,
1948: st_forms_rec.org_id ,
1949: 'C'
1950: ) RETURNING st_hdr_id INTO v_st_hdr_id;
1951:

Line 2051: fnd_global.user_id ,

2047: st_forms_rec.trx_number ,
2048: v_orgn_id ,
2049: v_locn_id ,
2050: sysdate ,
2051: fnd_global.user_id ,
2052: sysdate ,
2053: fnd_global.user_id ,
2054: fnd_global.login_id
2055:

Line 2053: fnd_global.user_id ,

2049: v_locn_id ,
2050: sysdate ,
2051: fnd_global.user_id ,
2052: sysdate ,
2053: fnd_global.user_id ,
2054: fnd_global.login_id
2055:
2056: ) RETURNING st_dtl_id INTO v_st_line_id;
2057:

Line 2054: fnd_global.login_id

2050: sysdate ,
2051: fnd_global.user_id ,
2052: sysdate ,
2053: fnd_global.user_id ,
2054: fnd_global.login_id
2055:
2056: ) RETURNING st_dtl_id INTO v_st_line_id;
2057:
2058: v_base_tax_amt :=NULL;