DBA Data[Home] [Help]

APPS.JAI_MTL_TRXS_PKG dependencies on FND_GLOBAL

Line 504: P_LAST_UPDATED_BY => fnd_global.user_id,

500: P_CUSTOMER_SITE_ID => null,
501: P_CREATION_DATE => main_rec.creation_date,
502: P_CREATED_BY => main_rec.created_by,
503: P_LAST_UPDATE_DATE => sysdate,
504: P_LAST_UPDATED_BY => fnd_global.user_id,
505: P_LAST_UPDATE_LOGIN => main_rec.last_update_login,
506: P_CALLED_FROM => 'XFER',
507: P_CESS_AMOUNT => ln_cess_amount ,
508: P_SH_CESS_AMOUNT =>ln_other_sh_cess

Line 1159: fnd_global.user_id,

1155: p_je_category_name,
1156: sysdate,
1157: p_currency_code,
1158: sysdate,
1159: fnd_global.user_id,
1160: 'A',
1161: null,
1162: p_params(i).amount,
1163: sysdate,

Line 1220: fnd_global.user_id,

1216: p_je_category_name,
1217: sysdate,
1218: p_currency_code,
1219: sysdate,
1220: fnd_global.user_id,
1221: null,
1222: p_params(i).amount,
1223: sysdate,
1224: p_params(i).debit_account, -- Derived Value from JAI_CMN_INVENTORY_ORGS / mtl_interorg_parameters

Line 1236: fnd_global.user_id,

1232: p_transaction_temp_id,
1233: 'transaction_temp_id',
1234: to_char(p_params(i).organization_id),
1235: sysdate,
1236: fnd_global.user_id,
1237: sysdate,
1238: fnd_global.login_id,
1239: p_transaction_temp_id
1240: );

Line 1238: fnd_global.login_id,

1234: to_char(p_params(i).organization_id),
1235: sysdate,
1236: fnd_global.user_id,
1237: sysdate,
1238: fnd_global.login_id,
1239: p_transaction_temp_id
1240: );
1241:
1242:

Line 1278: fnd_global.user_id,

1274: p_je_category_name,
1275: sysdate,
1276: p_currency_code,
1277: sysdate,
1278: fnd_global.user_id,
1279: 'A',
1280: p_params(i).amount,
1281: null,
1282: sysdate,

Line 1338: fnd_global.user_id,

1334: p_je_category_name,
1335: sysdate,
1336: p_currency_code,
1337: sysdate,
1338: fnd_global.user_id,
1339: p_params(i).amount,
1340: null,
1341: sysdate,
1342: p_params(i).credit_account,

Line 1354: fnd_global.user_id,

1350: p_transaction_temp_id,
1351: 'transaction_temp_id',
1352: to_char(p_params(i).organization_id),
1353: sysdate,
1354: fnd_global.user_id,
1355: sysdate,
1356: fnd_global.login_id,
1357: p_transaction_temp_id
1358: );

Line 1356: fnd_global.login_id,

1352: to_char(p_params(i).organization_id),
1353: sysdate,
1354: fnd_global.user_id,
1355: sysdate,
1356: fnd_global.login_id,
1357: p_transaction_temp_id
1358: );
1359:
1360: END IF;

Line 3025: fnd_global.user_id ,

3021: p_transaction_source_type_id , -- Inventory
3022: p_transaction_id ,
3023: to_char(p_transaction_id) ,
3024: sysdate ,
3025: fnd_global.user_id ,
3026: sysdate ,
3027: fnd_global.user_id ,
3028: p_cost_group_id ,
3029: p_receiving_account_id ,

Line 3027: fnd_global.user_id ,

3023: to_char(p_transaction_id) ,
3024: sysdate ,
3025: fnd_global.user_id ,
3026: sysdate ,
3027: fnd_global.user_id ,
3028: p_cost_group_id ,
3029: p_receiving_account_id ,
3030: p_absorption_account_id ,
3031: p_receiving_account_id ,

Line 3104: fnd_global.user_id ,

3100: p_transaction_source_type_id , -- Inventory
3101: p_transaction_id ,
3102: to_char(p_transaction_id) ,
3103: sysdate ,
3104: fnd_global.user_id ,
3105: sysdate ,
3106: fnd_global.user_id ,
3107: p_cost_group_id ,
3108: p_receiving_account_id ,

Line 3106: fnd_global.user_id ,

3102: to_char(p_transaction_id) ,
3103: sysdate ,
3104: fnd_global.user_id ,
3105: sysdate ,
3106: fnd_global.user_id ,
3107: p_cost_group_id ,
3108: p_receiving_account_id ,
3109: p_absorption_account_id ,
3110: p_receiving_account_id ,

Line 3132: fnd_global.user_id ,

3128: )
3129: VALUES (
3130: ln_txn_interface_id ,
3131: sysdate ,
3132: fnd_global.user_id ,
3133: sysdate ,
3134: fnd_global.user_id ,
3135: p_organization_id ,
3136: ln_material_cost_element_id ,

Line 3134: fnd_global.user_id ,

3130: ln_txn_interface_id ,
3131: sysdate ,
3132: fnd_global.user_id ,
3133: sysdate ,
3134: fnd_global.user_id ,
3135: p_organization_id ,
3136: ln_material_cost_element_id ,
3137: ln_level_type ,
3138: p_value_change

Line 3155: fnd_global.user_id ,

3151: )
3152: VALUES (
3153: ln_txn_interface_id ,
3154: sysdate ,
3155: fnd_global.user_id ,
3156: sysdate ,
3157: fnd_global.user_id ,
3158: p_organization_id ,
3159: ln_material_cost_element_id ,

Line 3157: fnd_global.user_id ,

3153: ln_txn_interface_id ,
3154: sysdate ,
3155: fnd_global.user_id ,
3156: sysdate ,
3157: fnd_global.user_id ,
3158: p_organization_id ,
3159: ln_material_cost_element_id ,
3160: ln_level_type ,
3161: p_value_change

Line 3182: fnd_global.user_id ,

3178: )
3179: (SELECT
3180: ln_txn_interface_id ,
3181: sysdate ,
3182: fnd_global.user_id ,
3183: sysdate ,
3184: fnd_global.user_id ,
3185: p_organization_id ,
3186: clcd.cost_element_id ,

Line 3184: fnd_global.user_id ,

3180: ln_txn_interface_id ,
3181: sysdate ,
3182: fnd_global.user_id ,
3183: sysdate ,
3184: fnd_global.user_id ,
3185: p_organization_id ,
3186: clcd.cost_element_id ,
3187: clcd.level_type ,
3188: 0

Line 3223: fnd_global.user_id ,

3219: )
3220: (SELECT
3221: ln_txn_interface_id ,
3222: sysdate ,
3223: fnd_global.user_id ,
3224: sysdate ,
3225: fnd_global.user_id ,
3226: p_organization_id ,
3227: clcd.cost_element_id ,

Line 3225: fnd_global.user_id ,

3221: ln_txn_interface_id ,
3222: sysdate ,
3223: fnd_global.user_id ,
3224: sysdate ,
3225: fnd_global.user_id ,
3226: p_organization_id ,
3227: clcd.cost_element_id ,
3228: clcd.level_type ,
3229: 0

Line 3349: fnd_global.user_id,

3345: lv_category_name,
3346: trunc(sysdate),
3347: lv_currency_code,
3348: sysdate,
3349: fnd_global.user_id,
3350: 'A',
3351: p_cost_amount,
3352: NULL,
3353: sysdate,

Line 3408: fnd_global.user_id,

3404: lv_category_name,
3405: sysdate,
3406: lv_currency_code,
3407: sysdate,
3408: fnd_global.user_id,
3409: p_cost_amount,
3410: NULL,
3411: sysdate,
3412: ln_receiving_accnt_id,

Line 3424: fnd_global.user_id,

3420: p_transaction_id,
3421: lv_reference_26,
3422: to_char(p_organization_id),
3423: sysdate,
3424: fnd_global.user_id,
3425: sysdate,
3426: fnd_global.login_id,
3427: p_transaction_id
3428: );

Line 3426: fnd_global.login_id,

3422: to_char(p_organization_id),
3423: sysdate,
3424: fnd_global.user_id,
3425: sysdate,
3426: fnd_global.login_id,
3427: p_transaction_id
3428: );
3429:
3430:

Line 3470: fnd_global.user_id,

3466: lv_category_name,
3467: trunc(sysdate),
3468: lv_currency_code,
3469: sysdate,
3470: fnd_global.user_id,
3471: 'A',
3472: NULL,
3473: p_cost_amount,
3474: sysdate,

Line 3529: fnd_global.user_id,

3525: lv_category_name,
3526: sysdate,
3527: lv_currency_code,
3528: sysdate,
3529: fnd_global.user_id,
3530: NULL,
3531: p_cost_amount,
3532: sysdate,
3533: p_reference_account,

Line 3545: fnd_global.user_id,

3541: p_transaction_id,
3542: lv_reference_26,
3543: to_char(p_organization_id),
3544: sysdate,
3545: fnd_global.user_id,
3546: sysdate,
3547: fnd_global.login_id,
3548: p_transaction_id
3549: );

Line 3547: fnd_global.login_id,

3543: to_char(p_organization_id),
3544: sysdate,
3545: fnd_global.user_id,
3546: sysdate,
3547: fnd_global.login_id,
3548: p_transaction_id
3549: );
3550:
3551:

Line 3623: ln_created_by NUMBER := fnd_global.user_id;

3619: ln_tot_cenvat_amt NUMBER;
3620: ln_set_of_books_id NUMBER;
3621:
3622: lv_reference_10 VARCHAR2(240);
3623: ln_created_by NUMBER := fnd_global.user_id;
3624:
3625:
3626: BEGIN
3627:

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

3794: NULL,
3795: NULL,
3796: NULL,
3797: sysdate, /*6497301*/
3798: fnd_global.user_id,/*6497301*/
3799: fnd_global.login_id/*6497301*/
3800: );
3801:
3802: INSERT INTO GL_INTERFACE

Line 3799: fnd_global.login_id/*6497301*/

3795: NULL,
3796: NULL,
3797: sysdate, /*6497301*/
3798: fnd_global.user_id,/*6497301*/
3799: fnd_global.login_id/*6497301*/
3800: );
3801:
3802: INSERT INTO GL_INTERFACE
3803: (

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

3908: NULL,
3909: NULL,
3910: NULL,
3911: sysdate, /*6497301*/
3912: fnd_global.user_id,/*6497301*/
3913: fnd_global.login_id/*6497301*/
3914: );
3915:
3916: INSERT INTO GL_INTERFACE

Line 3913: fnd_global.login_id/*6497301*/

3909: NULL,
3910: NULL,
3911: sysdate, /*6497301*/
3912: fnd_global.user_id,/*6497301*/
3913: fnd_global.login_id/*6497301*/
3914: );
3915:
3916: INSERT INTO GL_INTERFACE
3917: (

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

4055: NULL,
4056: NULL,
4057: NULL,
4058: sysdate, /*6497301*/
4059: fnd_global.user_id,/*6497301*/
4060: fnd_global.login_id/*6497301*/
4061: );
4062:
4063: INSERT INTO GL_INTERFACE

Line 4060: fnd_global.login_id/*6497301*/

4056: NULL,
4057: NULL,
4058: sysdate, /*6497301*/
4059: fnd_global.user_id,/*6497301*/
4060: fnd_global.login_id/*6497301*/
4061: );
4062:
4063: INSERT INTO GL_INTERFACE
4064: (

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

4170: NULL,
4171: NULL,
4172: NULL,
4173: sysdate, /*6497301*/
4174: fnd_global.user_id,/*6497301*/
4175: fnd_global.login_id/*6497301*/
4176: );
4177:
4178: INSERT INTO GL_INTERFACE

Line 4175: fnd_global.login_id/*6497301*/

4171: NULL,
4172: NULL,
4173: sysdate, /*6497301*/
4174: fnd_global.user_id,/*6497301*/
4175: fnd_global.login_id/*6497301*/
4176: );
4177:
4178: INSERT INTO GL_INTERFACE
4179: (

Line 4622: fnd_global.user_id,

4618: NULL,
4619: tax_rec.tax_type,
4620: tax_rec.tax_id,
4621: NULL,
4622: fnd_global.user_id,
4623: SYSDATE,
4624: fnd_global.user_id,
4625: SYSDATE,
4626: fnd_global.login_id);

Line 4624: fnd_global.user_id,

4620: tax_rec.tax_id,
4621: NULL,
4622: fnd_global.user_id,
4623: SYSDATE,
4624: fnd_global.user_id,
4625: SYSDATE,
4626: fnd_global.login_id);
4627: if ln_instpaid_cnt>nvl(ln_cnt,0) then
4628: update jai_rcv_rgm_claims

Line 4626: fnd_global.login_id);

4622: fnd_global.user_id,
4623: SYSDATE,
4624: fnd_global.user_id,
4625: SYSDATE,
4626: fnd_global.login_id);
4627: if ln_instpaid_cnt>nvl(ln_cnt,0) then
4628: update jai_rcv_rgm_claims
4629: set claimed_amount=0,
4630: claimed_date=sysdate,

Line 4963: ln_user_id := fnd_global.user_id;

4959: ln_vat_assessable_value number(15);
4960:
4961: BEGIN
4962:
4963: ln_user_id := fnd_global.user_id;
4964:
4965: open c_jai_mtl_trxs;
4966: fetch c_jai_mtl_trxs into r_jai_mtl_trxs;
4967: close c_jai_mtl_trxs;

Line 5111: fnd_global.login_id

5107: sysdate,
5108: ln_user_id,
5109: sysdate,
5110: ln_user_id,
5111: fnd_global.login_id
5112: );
5113:
5114: ln_assessable_value := nvl(ln_assessable_value,0)* p_line_quantity; /* value returned is excise assessable value of the line */
5115:

Line 5133: p_last_update_login => fnd_global.login_id ,

5129: p_creation_date => sysdate ,
5130: p_created_by => ln_user_id,
5131: p_last_update_date => sysdate ,
5132: p_last_updated_by => ln_user_id,
5133: p_last_update_login => fnd_global.login_id ,
5134: p_operation_flag => NULL,
5135: p_vat_assessable_value => ln_vat_assessable_value
5136: ) ;
5137: