DBA Data[Home] [Help]

APPS.JAI_MTL_TRXS_PKG dependencies on FND_GLOBAL

Line 627: P_LAST_UPDATED_BY => fnd_global.user_id,

623: P_CUSTOMER_SITE_ID => null,
624: P_CREATION_DATE => main_rec.creation_date,
625: P_CREATED_BY => main_rec.created_by,
626: P_LAST_UPDATE_DATE => sysdate,
627: P_LAST_UPDATED_BY => fnd_global.user_id,
628: P_LAST_UPDATE_LOGIN => main_rec.last_update_login,
629: P_CALLED_FROM => 'XFER',
630: P_CESS_AMOUNT => ln_cess_amount ,
631: P_SH_CESS_AMOUNT =>ln_other_sh_cess

Line 1287: fnd_global.user_id,

1283: p_je_category_name,
1284: sysdate,
1285: p_currency_code,
1286: sysdate,
1287: fnd_global.user_id,
1288: 'A',
1289: null,
1290: p_params(i).amount,
1291: sysdate,

Line 1348: fnd_global.user_id,

1344: p_je_category_name,
1345: sysdate,
1346: p_currency_code,
1347: sysdate,
1348: fnd_global.user_id,
1349: null,
1350: p_params(i).amount,
1351: sysdate,
1352: p_params(i).debit_account, -- Derived Value from JAI_CMN_INVENTORY_ORGS / mtl_interorg_parameters

Line 1364: fnd_global.user_id,

1360: p_transaction_temp_id,
1361: 'transaction_temp_id',
1362: to_char(p_params(i).organization_id),
1363: sysdate,
1364: fnd_global.user_id,
1365: sysdate,
1366: fnd_global.login_id,
1367: p_transaction_temp_id
1368: );

Line 1366: fnd_global.login_id,

1362: to_char(p_params(i).organization_id),
1363: sysdate,
1364: fnd_global.user_id,
1365: sysdate,
1366: fnd_global.login_id,
1367: p_transaction_temp_id
1368: );
1369:
1370:

Line 1406: fnd_global.user_id,

1402: p_je_category_name,
1403: sysdate,
1404: p_currency_code,
1405: sysdate,
1406: fnd_global.user_id,
1407: 'A',
1408: p_params(i).amount,
1409: null,
1410: sysdate,

Line 1466: fnd_global.user_id,

1462: p_je_category_name,
1463: sysdate,
1464: p_currency_code,
1465: sysdate,
1466: fnd_global.user_id,
1467: p_params(i).amount,
1468: null,
1469: sysdate,
1470: p_params(i).credit_account,

Line 1482: fnd_global.user_id,

1478: p_transaction_temp_id,
1479: 'transaction_temp_id',
1480: to_char(p_params(i).organization_id),
1481: sysdate,
1482: fnd_global.user_id,
1483: sysdate,
1484: fnd_global.login_id,
1485: p_transaction_temp_id
1486: );

Line 1484: fnd_global.login_id,

1480: to_char(p_params(i).organization_id),
1481: sysdate,
1482: fnd_global.user_id,
1483: sysdate,
1484: fnd_global.login_id,
1485: p_transaction_temp_id
1486: );
1487:
1488: END IF;

Line 3189: fnd_global.user_id ,

3185: p_transaction_source_type_id , -- Inventory
3186: p_transaction_id ,
3187: to_char(p_transaction_id) ,
3188: sysdate ,
3189: fnd_global.user_id ,
3190: sysdate ,
3191: fnd_global.user_id ,
3192: p_cost_group_id ,
3193: p_receiving_account_id ,

Line 3191: fnd_global.user_id ,

3187: to_char(p_transaction_id) ,
3188: sysdate ,
3189: fnd_global.user_id ,
3190: sysdate ,
3191: fnd_global.user_id ,
3192: p_cost_group_id ,
3193: p_receiving_account_id ,
3194: p_absorption_account_id ,
3195: p_receiving_account_id ,

Line 3268: fnd_global.user_id ,

3264: p_transaction_source_type_id , -- Inventory
3265: p_transaction_id ,
3266: to_char(p_transaction_id) ,
3267: sysdate ,
3268: fnd_global.user_id ,
3269: sysdate ,
3270: fnd_global.user_id ,
3271: p_cost_group_id ,
3272: p_receiving_account_id ,

Line 3270: fnd_global.user_id ,

3266: to_char(p_transaction_id) ,
3267: sysdate ,
3268: fnd_global.user_id ,
3269: sysdate ,
3270: fnd_global.user_id ,
3271: p_cost_group_id ,
3272: p_receiving_account_id ,
3273: p_absorption_account_id ,
3274: p_receiving_account_id ,

Line 3296: fnd_global.user_id ,

3292: )
3293: VALUES (
3294: ln_txn_interface_id ,
3295: sysdate ,
3296: fnd_global.user_id ,
3297: sysdate ,
3298: fnd_global.user_id ,
3299: p_organization_id ,
3300: ln_material_cost_element_id ,

Line 3298: fnd_global.user_id ,

3294: ln_txn_interface_id ,
3295: sysdate ,
3296: fnd_global.user_id ,
3297: sysdate ,
3298: fnd_global.user_id ,
3299: p_organization_id ,
3300: ln_material_cost_element_id ,
3301: ln_level_type ,
3302: p_value_change

Line 3319: fnd_global.user_id ,

3315: )
3316: VALUES (
3317: ln_txn_interface_id ,
3318: sysdate ,
3319: fnd_global.user_id ,
3320: sysdate ,
3321: fnd_global.user_id ,
3322: p_organization_id ,
3323: ln_material_cost_element_id ,

Line 3321: fnd_global.user_id ,

3317: ln_txn_interface_id ,
3318: sysdate ,
3319: fnd_global.user_id ,
3320: sysdate ,
3321: fnd_global.user_id ,
3322: p_organization_id ,
3323: ln_material_cost_element_id ,
3324: ln_level_type ,
3325: p_value_change

Line 3346: fnd_global.user_id ,

3342: )
3343: (SELECT
3344: ln_txn_interface_id ,
3345: sysdate ,
3346: fnd_global.user_id ,
3347: sysdate ,
3348: fnd_global.user_id ,
3349: p_organization_id ,
3350: clcd.cost_element_id ,

Line 3348: fnd_global.user_id ,

3344: ln_txn_interface_id ,
3345: sysdate ,
3346: fnd_global.user_id ,
3347: sysdate ,
3348: fnd_global.user_id ,
3349: p_organization_id ,
3350: clcd.cost_element_id ,
3351: clcd.level_type ,
3352: 0

Line 3387: fnd_global.user_id ,

3383: )
3384: (SELECT
3385: ln_txn_interface_id ,
3386: sysdate ,
3387: fnd_global.user_id ,
3388: sysdate ,
3389: fnd_global.user_id ,
3390: p_organization_id ,
3391: clcd.cost_element_id ,

Line 3389: fnd_global.user_id ,

3385: ln_txn_interface_id ,
3386: sysdate ,
3387: fnd_global.user_id ,
3388: sysdate ,
3389: fnd_global.user_id ,
3390: p_organization_id ,
3391: clcd.cost_element_id ,
3392: clcd.level_type ,
3393: 0

Line 3513: fnd_global.user_id,

3509: lv_category_name,
3510: trunc(sysdate),
3511: lv_currency_code,
3512: sysdate,
3513: fnd_global.user_id,
3514: 'A',
3515: p_cost_amount,
3516: NULL,
3517: sysdate,

Line 3572: fnd_global.user_id,

3568: lv_category_name,
3569: sysdate,
3570: lv_currency_code,
3571: sysdate,
3572: fnd_global.user_id,
3573: p_cost_amount,
3574: NULL,
3575: sysdate,
3576: ln_receiving_accnt_id,

Line 3588: fnd_global.user_id,

3584: p_transaction_id,
3585: lv_reference_26,
3586: to_char(p_organization_id),
3587: sysdate,
3588: fnd_global.user_id,
3589: sysdate,
3590: fnd_global.login_id,
3591: p_transaction_id
3592: );

Line 3590: fnd_global.login_id,

3586: to_char(p_organization_id),
3587: sysdate,
3588: fnd_global.user_id,
3589: sysdate,
3590: fnd_global.login_id,
3591: p_transaction_id
3592: );
3593:
3594:

Line 3634: fnd_global.user_id,

3630: lv_category_name,
3631: trunc(sysdate),
3632: lv_currency_code,
3633: sysdate,
3634: fnd_global.user_id,
3635: 'A',
3636: NULL,
3637: p_cost_amount,
3638: sysdate,

Line 3693: fnd_global.user_id,

3689: lv_category_name,
3690: sysdate,
3691: lv_currency_code,
3692: sysdate,
3693: fnd_global.user_id,
3694: NULL,
3695: p_cost_amount,
3696: sysdate,
3697: p_reference_account,

Line 3709: fnd_global.user_id,

3705: p_transaction_id,
3706: lv_reference_26,
3707: to_char(p_organization_id),
3708: sysdate,
3709: fnd_global.user_id,
3710: sysdate,
3711: fnd_global.login_id,
3712: p_transaction_id
3713: );

Line 3711: fnd_global.login_id,

3707: to_char(p_organization_id),
3708: sysdate,
3709: fnd_global.user_id,
3710: sysdate,
3711: fnd_global.login_id,
3712: p_transaction_id
3713: );
3714:
3715:

Line 3790: ln_created_by NUMBER := fnd_global.user_id;

3786: ln_tot_cenvat_amt NUMBER;
3787: ln_set_of_books_id NUMBER;
3788:
3789: lv_reference_10 VARCHAR2(240);
3790: ln_created_by NUMBER := fnd_global.user_id;
3791:
3792:
3793: BEGIN
3794:

Line 3974: fnd_global.user_id,/*6497301*/

3970: NULL,
3971: NULL,
3972: NULL,
3973: sysdate, /*6497301*/
3974: fnd_global.user_id,/*6497301*/
3975: fnd_global.login_id/*6497301*/
3976: );
3977: --cr excise receivable accnt
3978: INSERT INTO GL_INTERFACE

Line 3975: fnd_global.login_id/*6497301*/

3971: NULL,
3972: NULL,
3973: sysdate, /*6497301*/
3974: fnd_global.user_id,/*6497301*/
3975: fnd_global.login_id/*6497301*/
3976: );
3977: --cr excise receivable accnt
3978: INSERT INTO GL_INTERFACE
3979: (

Line 4089: fnd_global.user_id,/*6497301*/

4085: NULL,
4086: NULL,
4087: NULL,
4088: sysdate, /*6497301*/
4089: fnd_global.user_id,/*6497301*/
4090: fnd_global.login_id/*6497301*/
4091: );
4092: --dr modvat cg acount
4093: INSERT INTO GL_INTERFACE

Line 4090: fnd_global.login_id/*6497301*/

4086: NULL,
4087: NULL,
4088: sysdate, /*6497301*/
4089: fnd_global.user_id,/*6497301*/
4090: fnd_global.login_id/*6497301*/
4091: );
4092: --dr modvat cg acount
4093: INSERT INTO GL_INTERFACE
4094: (

Line 4267: fnd_global.user_id,/*6497301*/

4263: NULL,
4264: NULL,
4265: NULL,
4266: sysdate, /*6497301*/
4267: fnd_global.user_id,/*6497301*/
4268: fnd_global.login_id/*6497301*/
4269: );
4270: --cr excise cess recvable accnt --10607819
4271: INSERT INTO GL_INTERFACE

Line 4268: fnd_global.login_id/*6497301*/

4264: NULL,
4265: NULL,
4266: sysdate, /*6497301*/
4267: fnd_global.user_id,/*6497301*/
4268: fnd_global.login_id/*6497301*/
4269: );
4270: --cr excise cess recvable accnt --10607819
4271: INSERT INTO GL_INTERFACE
4272: (

Line 4382: fnd_global.user_id,/*6497301*/

4378: NULL,
4379: NULL,
4380: NULL,
4381: sysdate, /*6497301*/
4382: fnd_global.user_id,/*6497301*/
4383: fnd_global.login_id/*6497301*/
4384: );
4385: --dr edu cess cg account 10607819
4386: INSERT INTO GL_INTERFACE

Line 4383: fnd_global.login_id/*6497301*/

4379: NULL,
4380: NULL,
4381: sysdate, /*6497301*/
4382: fnd_global.user_id,/*6497301*/
4383: fnd_global.login_id/*6497301*/
4384: );
4385: --dr edu cess cg account 10607819
4386: INSERT INTO GL_INTERFACE
4387: (

Line 4498: fnd_global.user_id,/*6497301*/

4494: NULL,
4495: NULL,
4496: NULL,
4497: sysdate, /*6497301*/
4498: fnd_global.user_id,/*6497301*/
4499: fnd_global.login_id/*6497301*/
4500: );
4501: --cr excise rcvble accnt 10607819
4502: INSERT INTO GL_INTERFACE

Line 4499: fnd_global.login_id/*6497301*/

4495: NULL,
4496: NULL,
4497: sysdate, /*6497301*/
4498: fnd_global.user_id,/*6497301*/
4499: fnd_global.login_id/*6497301*/
4500: );
4501: --cr excise rcvble accnt 10607819
4502: INSERT INTO GL_INTERFACE
4503: (

Line 4613: fnd_global.user_id,/*6497301*/

4609: NULL,
4610: NULL,
4611: NULL,
4612: sysdate, /*6497301*/
4613: fnd_global.user_id,/*6497301*/
4614: fnd_global.login_id/*6497301*/
4615: );
4616: --dr cg accnt 10607819
4617: INSERT INTO GL_INTERFACE

Line 4614: fnd_global.login_id/*6497301*/

4610: NULL,
4611: NULL,
4612: sysdate, /*6497301*/
4613: fnd_global.user_id,/*6497301*/
4614: fnd_global.login_id/*6497301*/
4615: );
4616: --dr cg accnt 10607819
4617: INSERT INTO GL_INTERFACE
4618: (

Line 5065: fnd_global.user_id,

5061: NULL,
5062: tax_rec.tax_type,
5063: tax_rec.tax_id,
5064: NULL,
5065: fnd_global.user_id,
5066: SYSDATE,
5067: fnd_global.user_id,
5068: SYSDATE,
5069: fnd_global.login_id);

Line 5067: fnd_global.user_id,

5063: tax_rec.tax_id,
5064: NULL,
5065: fnd_global.user_id,
5066: SYSDATE,
5067: fnd_global.user_id,
5068: SYSDATE,
5069: fnd_global.login_id);
5070: if ln_instpaid_cnt>nvl(ln_cnt,0) then
5071: update jai_rcv_rgm_claims

Line 5069: fnd_global.login_id);

5065: fnd_global.user_id,
5066: SYSDATE,
5067: fnd_global.user_id,
5068: SYSDATE,
5069: fnd_global.login_id);
5070: if ln_instpaid_cnt>nvl(ln_cnt,0) then
5071: update jai_rcv_rgm_claims
5072: set claimed_amount=0,
5073: claimed_date=sysdate,

Line 5423: ln_user_id := fnd_global.user_id;

5419: --added by peng.zheng for bug 10043656, ends
5420:
5421: BEGIN
5422:
5423: ln_user_id := fnd_global.user_id;
5424:
5425: open c_jai_mtl_trxs;
5426: fetch c_jai_mtl_trxs into r_jai_mtl_trxs;
5427: close c_jai_mtl_trxs;

Line 5625: fnd_global.login_id

5621: sysdate,
5622: ln_user_id,
5623: sysdate,
5624: ln_user_id,
5625: fnd_global.login_id
5626: );
5627:
5628: --added round for bug#8882785
5629: ln_assessable_value := round(nvl(ln_assessable_value,0)* p_line_quantity,2); /* value returned is excise assessable value of the line */

Line 5648: p_last_update_login => fnd_global.login_id ,

5644: p_creation_date => sysdate ,
5645: p_created_by => ln_user_id,
5646: p_last_update_date => sysdate ,
5647: p_last_updated_by => ln_user_id,
5648: p_last_update_login => fnd_global.login_id ,
5649: p_operation_flag => NULL,
5650: p_vat_assessable_value => ln_vat_assessable_value
5651: --, pn_gst_assessable_value => ln_gst_assessable_value -- Added by Jia for GST Bug#10043656 on 2010/09/10 /*Commented by mmurtuza for removing GST Changes*/
5652: ) ;