DBA Data[Home] [Help]

APPS.JAI_CMN_ST_FORMS_PKG dependencies on FND_GLOBAL

Line 561: v_uid := fnd_global.USER_ID;

557: Fnd_File.put_line(Fnd_File.LOG, '**** ========================================== ****');
558: Fnd_File.put_line(Fnd_File.LOG, '**** Start procedure - jai_cmn_st_forms_pkg.generate_ap_forms ****');
559: end if;
560:
561: v_uid := fnd_global.USER_ID;
562:
563: v_error_flag := 'N';
564:
565: v_processed_inv_cnt := 0;

Line 1196: OPEN c_program_id(FND_GLOBAL.CONC_REQUEST_ID);

1192:
1193: if P_Enable_Trace = 'Y' or P_Enable_Trace = 'y' then
1194: execute immediate 'ALTER SESSION SET EVENTS ''10046 trace name context forever, level 4''' ;
1195:
1196: OPEN c_program_id(FND_GLOBAL.CONC_REQUEST_ID);
1197: FETCH c_program_id INTO v_program_id, v_enable_trace;
1198: CLOSE c_program_id;
1199:
1200: fnd_file.put_line(FND_FILE.LOG, 'v_program_id -> '||v_program_id

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

1198: CLOSE c_program_id;
1199:
1200: fnd_file.put_line(FND_FILE.LOG, 'v_program_id -> '||v_program_id
1201: ||', v_enable_trace -> '||v_enable_trace
1202: ||', request_id -> '||FND_GLOBAL.CONC_REQUEST_ID);
1203:
1204: if v_enable_trace = 'Y' THEN
1205: OPEN get_audsid;
1206: FETCH get_audsid INTO sid, serial, spid;

Line 1600: fnd_global.user_id ,

1596: st_forms_rec.customer_id ,
1597: st_forms_rec.customer_site_id ,
1598: tax_rec.stform_type ,
1599: sysdate ,
1600: fnd_global.user_id ,
1601: sysdate ,
1602: fnd_global.user_id ,
1603: fnd_global.login_id ,
1604: st_forms_rec.org_id ,

Line 1602: fnd_global.user_id ,

1598: tax_rec.stform_type ,
1599: sysdate ,
1600: fnd_global.user_id ,
1601: sysdate ,
1602: fnd_global.user_id ,
1603: fnd_global.login_id ,
1604: st_forms_rec.org_id ,
1605: 'C'
1606: ) RETURNING st_hdr_id INTO v_st_hdr_id;

Line 1603: fnd_global.login_id ,

1599: sysdate ,
1600: fnd_global.user_id ,
1601: sysdate ,
1602: fnd_global.user_id ,
1603: fnd_global.login_id ,
1604: st_forms_rec.org_id ,
1605: 'C'
1606: ) RETURNING st_hdr_id INTO v_st_hdr_id;
1607: fnd_file.put_line(FND_FILE.LOG,' inserting into JAI_CMN_STFORM_HDRS_ALL table with header id '|| v_st_hdr_id);

Line 1685: fnd_global.user_id ,

1681: v_orgn_id ,
1682: v_locn_id ,
1683: 'ISO' ,
1684: sysdate ,
1685: fnd_global.user_id ,
1686: sysdate ,
1687: fnd_global.user_id ,
1688: fnd_global.login_id
1689:

Line 1687: fnd_global.user_id ,

1683: 'ISO' ,
1684: sysdate ,
1685: fnd_global.user_id ,
1686: sysdate ,
1687: fnd_global.user_id ,
1688: fnd_global.login_id
1689:
1690: ) RETURNING st_dtl_id INTO v_st_line_id;
1691: fnd_file.put_line(FND_FILE.LOG,' inserting into JAI_CMN_ST_FORM_DTLS table with detail id :' ||v_st_line_id );

Line 1688: fnd_global.login_id

1684: sysdate ,
1685: fnd_global.user_id ,
1686: sysdate ,
1687: fnd_global.user_id ,
1688: fnd_global.login_id
1689:
1690: ) RETURNING st_dtl_id INTO v_st_line_id;
1691: fnd_file.put_line(FND_FILE.LOG,' inserting into JAI_CMN_ST_FORM_DTLS table with detail id :' ||v_st_line_id );
1692: v_base_tax_amt :=NULL;

Line 2091: fnd_global.user_id ,

2087: st_forms_rec.customer_id ,
2088: st_forms_rec.customer_site_id ,
2089: tax_rec.stform_type ,
2090: sysdate ,
2091: fnd_global.user_id ,
2092: sysdate ,
2093: fnd_global.user_id ,
2094: fnd_global.login_id ,
2095: st_forms_rec.org_id ,

Line 2093: fnd_global.user_id ,

2089: tax_rec.stform_type ,
2090: sysdate ,
2091: fnd_global.user_id ,
2092: sysdate ,
2093: fnd_global.user_id ,
2094: fnd_global.login_id ,
2095: st_forms_rec.org_id ,
2096: 'C'
2097: ) RETURNING st_hdr_id INTO v_st_hdr_id;

Line 2094: fnd_global.login_id ,

2090: sysdate ,
2091: fnd_global.user_id ,
2092: sysdate ,
2093: fnd_global.user_id ,
2094: fnd_global.login_id ,
2095: st_forms_rec.org_id ,
2096: 'C'
2097: ) RETURNING st_hdr_id INTO v_st_hdr_id;
2098:

Line 2198: fnd_global.user_id ,

2194: st_forms_rec.trx_number ,
2195: v_orgn_id ,
2196: v_locn_id ,
2197: sysdate ,
2198: fnd_global.user_id ,
2199: sysdate ,
2200: fnd_global.user_id ,
2201: fnd_global.login_id
2202:

Line 2200: fnd_global.user_id ,

2196: v_locn_id ,
2197: sysdate ,
2198: fnd_global.user_id ,
2199: sysdate ,
2200: fnd_global.user_id ,
2201: fnd_global.login_id
2202:
2203: ) RETURNING st_dtl_id INTO v_st_line_id;
2204:

Line 2201: fnd_global.login_id

2197: sysdate ,
2198: fnd_global.user_id ,
2199: sysdate ,
2200: fnd_global.user_id ,
2201: fnd_global.login_id
2202:
2203: ) RETURNING st_dtl_id INTO v_st_line_id;
2204:
2205: v_base_tax_amt :=NULL;