DBA Data[Home] [Help]

APPS.JAI_OPEN_API_PKG dependencies on FND_GLOBAL

Line 402: ln_user_id := fnd_global.user_id ;

398: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;
399: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;
400: BEGIN
401:
402: ln_user_id := fnd_global.user_id ;
403: ln_login_id := fnd_global.login_id ;
404:
405: INSERT INTO JAI_INTERFACE_ERR_LINES
406: (

Line 403: ln_login_id := fnd_global.login_id ;

399: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;
400: BEGIN
401:
402: ln_user_id := fnd_global.user_id ;
403: ln_login_id := fnd_global.login_id ;
404:
405: INSERT INTO JAI_INTERFACE_ERR_LINES
406: (
407: INTERFACE_ERROR_ID,

Line 7964: IF ln_max_req_id = fnd_global.conc_request_id THEN

7960: FETCH get_max_request_id_cur
7961: INTO ln_max_req_id;
7962: CLOSE get_max_request_id_cur;
7963:
7964: IF ln_max_req_id = fnd_global.conc_request_id THEN
7965: COMMIT;
7966: ELSE
7967: ROLLBACK;
7968:

Line 10412: ln_user_id NUMBER := fnd_global.user_id;

10408: --
10409: --===========================================================================
10410: PROCEDURE populate_jai_interface_taxes( pn_interface_line_id NUMBER)
10411: IS
10412: ln_user_id NUMBER := fnd_global.user_id;
10413: ln_login_id NUMBER := fnd_global.login_id;
10414: ld_sys_date DATE := SYSDATE;
10415:
10416: lv_insert_jai_ap_tax_sql VARCHAR2(32000);

Line 10413: ln_login_id NUMBER := fnd_global.login_id;

10409: --===========================================================================
10410: PROCEDURE populate_jai_interface_taxes( pn_interface_line_id NUMBER)
10411: IS
10412: ln_user_id NUMBER := fnd_global.user_id;
10413: ln_login_id NUMBER := fnd_global.login_id;
10414: ld_sys_date DATE := SYSDATE;
10415:
10416: lv_insert_jai_ap_tax_sql VARCHAR2(32000);
10417: lv_insert_jai_ar_tax_sql VARCHAR2(32000);

Line 11077: , p_created_by => FND_GLOBAL.user_id

11073: , p_vendor_id => ln_vendor_id
11074: , p_currency => 'INR'
11075: , p_currency_conv_factor => 1
11076: , p_creation_date => SYSDATE
11077: , p_created_by => FND_GLOBAL.user_id
11078: , p_last_update_date => SYSDATE
11079: , p_last_updated_by => FND_GLOBAL.user_id
11080: , p_last_update_login => FND_GLOBAL.login_id
11081: , p_operation_flag => NULL

Line 11079: , p_last_updated_by => FND_GLOBAL.user_id

11075: , p_currency_conv_factor => 1
11076: , p_creation_date => SYSDATE
11077: , p_created_by => FND_GLOBAL.user_id
11078: , p_last_update_date => SYSDATE
11079: , p_last_updated_by => FND_GLOBAL.user_id
11080: , p_last_update_login => FND_GLOBAL.login_id
11081: , p_operation_flag => NULL
11082: , p_vat_assessable_value => ln_line_amount--ln_vat_assessable_value
11083: , p_source_trx_type => jai_constants.G_AP_STANDALONE_INVOICE

Line 11080: , p_last_update_login => FND_GLOBAL.login_id

11076: , p_creation_date => SYSDATE
11077: , p_created_by => FND_GLOBAL.user_id
11078: , p_last_update_date => SYSDATE
11079: , p_last_updated_by => FND_GLOBAL.user_id
11080: , p_last_update_login => FND_GLOBAL.login_id
11081: , p_operation_flag => NULL
11082: , p_vat_assessable_value => ln_line_amount--ln_vat_assessable_value
11083: , p_source_trx_type => jai_constants.G_AP_STANDALONE_INVOICE
11084: );

Line 11144: p_created_by => FND_GLOBAL.user_id,

11140: p_vendor_id => NULL,
11141: p_currency => NULL,
11142: p_currency_conv_factor => 1,
11143: p_creation_date => sysdate,
11144: p_created_by => FND_GLOBAL.user_id,
11145: p_last_update_date => sysdate,
11146: p_last_updated_by => FND_GLOBAL.user_id,
11147: p_last_update_login => FND_GLOBAL.login_id,
11148: p_operation_flag => NULL,

Line 11146: p_last_updated_by => FND_GLOBAL.user_id,

11142: p_currency_conv_factor => 1,
11143: p_creation_date => sysdate,
11144: p_created_by => FND_GLOBAL.user_id,
11145: p_last_update_date => sysdate,
11146: p_last_updated_by => FND_GLOBAL.user_id,
11147: p_last_update_login => FND_GLOBAL.login_id,
11148: p_operation_flag => NULL,
11149: p_vat_assessable_value => ln_vat_assessable_value,
11150: p_source_trx_type => 'AR_TRANSACTION'

Line 11147: p_last_update_login => FND_GLOBAL.login_id,

11143: p_creation_date => sysdate,
11144: p_created_by => FND_GLOBAL.user_id,
11145: p_last_update_date => sysdate,
11146: p_last_updated_by => FND_GLOBAL.user_id,
11147: p_last_update_login => FND_GLOBAL.login_id,
11148: p_operation_flag => NULL,
11149: p_vat_assessable_value => ln_vat_assessable_value,
11150: p_source_trx_type => 'AR_TRANSACTION'
11151: );

Line 11614: GN_REQUEST_ID := fnd_global.conc_request_id;

11610: ln_phase NUMBER;
11611:
11612: BEGIN
11613: --Get request id for concurrent.
11614: GN_REQUEST_ID := fnd_global.conc_request_id;
11615:
11616: --Get import module for process
11617: GV_IMPORT_MODULE := pv_import_module;
11618: