DBA Data[Home] [Help]

APPS.GMS_LD_PKG dependencies on FND_PROFILE

Line 436: x_last_updated_by => to_number(fnd_profile.value('USER_ID')),

432:
433: gms_encumbrance_groups_pkg.insert_row (x_rowid => l_rowid,
434: x_encumbrance_group => l_encumbrance_grp,
435: x_last_update_date => sysdate,
436: x_last_updated_by => to_number(fnd_profile.value('USER_ID')),
437: x_creation_date => sysdate,
438: x_created_by => to_number(fnd_profile.value('USER_ID')),
439: x_encumbrance_group_status => 'RELEASED',
440: x_encumbrance_ending_date => TrxRec.expenditure_ending_date,

Line 438: x_created_by => to_number(fnd_profile.value('USER_ID')),

434: x_encumbrance_group => l_encumbrance_grp,
435: x_last_update_date => sysdate,
436: x_last_updated_by => to_number(fnd_profile.value('USER_ID')),
437: x_creation_date => sysdate,
438: x_created_by => to_number(fnd_profile.value('USER_ID')),
439: x_encumbrance_group_status => 'RELEASED',
440: x_encumbrance_ending_date => TrxRec.expenditure_ending_date,
441: x_system_linkage_function => TrxRec.system_linkage,
442: x_control_count => NULL,

Line 445: x_last_update_login => to_number(fnd_profile.value('LOGIN_ID')),

441: x_system_linkage_function => TrxRec.system_linkage,
442: x_control_count => NULL,
443: x_control_total_amount => NULL,
444: x_description => NULL,
445: x_last_update_login => to_number(fnd_profile.value('LOGIN_ID')),
446: x_transaction_source => P_TRANSACTION_SOURCE ,
447: x_org_id => l_org_id,
448: x_request_id => l_req_id /*bug 5689213*/
449: ); -- bug : 2376730

Line 479: x_last_updated_by => to_number(fnd_profile.value('USER_ID')),

475:
476: gms_encumbrance_groups_pkg.insert_row (x_rowid => l_rowid,
477: x_encumbrance_group => l_encumbrance_grp,
478: x_last_update_date => sysdate,
479: x_last_updated_by => to_number(fnd_profile.value('USER_ID')),
480: x_creation_date => sysdate,
481: x_created_by => to_number(fnd_profile.value('USER_ID')),
482: x_encumbrance_group_status => 'RELEASED',
483: x_encumbrance_ending_date => TrxRec.expenditure_ending_date,

Line 481: x_created_by => to_number(fnd_profile.value('USER_ID')),

477: x_encumbrance_group => l_encumbrance_grp,
478: x_last_update_date => sysdate,
479: x_last_updated_by => to_number(fnd_profile.value('USER_ID')),
480: x_creation_date => sysdate,
481: x_created_by => to_number(fnd_profile.value('USER_ID')),
482: x_encumbrance_group_status => 'RELEASED',
483: x_encumbrance_ending_date => TrxRec.expenditure_ending_date,
484: x_system_linkage_function => TrxRec.system_linkage,
485: x_control_count => NULL,

Line 488: x_last_update_login => to_number(fnd_profile.value('LOGIN_ID')),

484: x_system_linkage_function => TrxRec.system_linkage,
485: x_control_count => NULL,
486: x_control_total_amount => NULL,
487: x_description => NULL,
488: x_last_update_login => to_number(fnd_profile.value('LOGIN_ID')),
489: x_transaction_source => P_TRANSACTION_SOURCE ,
490: x_org_id => l_org_id,
491: x_request_id => l_req_id /*bug 5689213*/
492: ); -- bug : 2376730

Line 1234: x_last_updated_by => to_number(fnd_profile.value('USER_ID')),

1230:
1231: gms_encumbrances_pkg.insert_row (x_rowid => l_rowid,
1232: x_encumbrance_id => l_enc_id,
1233: x_last_update_date => sysdate,
1234: x_last_updated_by => to_number(fnd_profile.value('USER_ID')),
1235: x_creation_date => sysdate,
1236: x_created_by => to_number(fnd_profile.value('USER_ID')),
1237: x_encumbrance_status_code => 'APPROVED',
1238: x_encumbrance_ending_date => TrxRec.expenditure_ending_date,

Line 1236: x_created_by => to_number(fnd_profile.value('USER_ID')),

1232: x_encumbrance_id => l_enc_id,
1233: x_last_update_date => sysdate,
1234: x_last_updated_by => to_number(fnd_profile.value('USER_ID')),
1235: x_creation_date => sysdate,
1236: x_created_by => to_number(fnd_profile.value('USER_ID')),
1237: x_encumbrance_status_code => 'APPROVED',
1238: x_encumbrance_ending_date => TrxRec.expenditure_ending_date,
1239: x_encumbrance_class_code => TrxRec.system_linkage, /* changed to TrxRec.system_linkage from 'ST' for bug 5035700 --'ST',*/
1240: x_incurred_by_person_id => l_person_id,

Line 1247: x_last_update_login => to_number(fnd_profile.value('LOGIN_ID')),

1243: x_control_total_amount => NULL,
1244: x_entered_by_person_id => NULL,
1245: x_description => NULL,
1246: x_initial_submission_date => sysdate,
1247: x_last_update_login => to_number(fnd_profile.value('LOGIN_ID')),
1248: x_attribute_category => NULL,
1249: x_attribute1 => NULL,
1250: x_attribute2 => NULL,
1251: x_attribute3 => NULL,

Line 1336: x_last_updated_by => to_number(fnd_profile.value('USER_ID')),

1332: /* Modified the following insert call by passing attributes instead of NULL for bug 3646187*/
1333: gms_encumbrance_items_pkg.insert_row (x_rowid => l_rowid,
1334: x_encumbrance_item_id => l_enc_item_id,
1335: x_last_update_date => sysdate,
1336: x_last_updated_by => to_number(fnd_profile.value('USER_ID')),
1337: x_creation_date => sysdate,
1338: x_created_by => to_number(fnd_profile.value('USER_ID')),
1339: x_encumbrance_id => l_enc_id,
1340: x_task_id => l_task_id,

Line 1338: x_created_by => to_number(fnd_profile.value('USER_ID')),

1334: x_encumbrance_item_id => l_enc_item_id,
1335: x_last_update_date => sysdate,
1336: x_last_updated_by => to_number(fnd_profile.value('USER_ID')),
1337: x_creation_date => sysdate,
1338: x_created_by => to_number(fnd_profile.value('USER_ID')),
1339: x_encumbrance_id => l_enc_id,
1340: x_task_id => l_task_id,
1341: x_encumbrance_item_date => TrxRec.expenditure_item_date,
1342: x_encumbrance_type => TrxRec.expenditure_type,

Line 1349: x_last_update_login => to_number(fnd_profile.value('LOGIN_ID')),

1345: x_override_to_organization_id => l_override_organization_id,
1346: x_adjusted_encumbrance_item_id => l_orig_enc_item_id, -- Bug 3465939
1347: x_net_zero_adjustment_flag => l_net_zero_adj_flag, -- Bug 3465939
1348: x_transferred_from_enc_item_id => NULL,
1349: x_last_update_login => to_number(fnd_profile.value('LOGIN_ID')),
1350: x_request_id => NULL,
1351: x_attribute_category => TrxRec.attribute_category,
1352: x_attribute1 => TrxRec.attribute1,
1353: x_attribute2 => TrxRec.attribute2,