DBA Data[Home] [Help]

APPS.ENGECOBO dependencies on FND_PROFILE

Line 559: , user_id => FND_PROFILE.value('USER_ID')

555: , from_sequence_id => p_from_sequence_id
556: , from_org_id => p_from_org_id
557: , to_org_id => p_to_org_id
558: , display_option => 1
559: , user_id => FND_PROFILE.value('USER_ID')
560: , to_item_id => p_to_item_id
561: , direction => 3
562: , to_alternate => p_to_alternate
563: , rev_date => sysdate

Line 595: where assignment_set_id = FND_PROFILE.VALUE( 'MRP_DEFAULT_ASSIGNMENT_SET' )

591: -- Scoped out
592: /*BEGIN
593: select 1 into l_item_sourced from dual
594: where exists (select 1 from mrp_sources_v
595: where assignment_set_id = FND_PROFILE.VALUE( 'MRP_DEFAULT_ASSIGNMENT_SET' )
596: and organization_id = g_global_org_id
597: and inventory_item_id = p_revised_item_id
598: and source_organization_id = p_local_org_id
599: and source_type = 2);

Line 3133: Eng_Globals.G_WHO_REC.user_id := FND_PROFILE.value('USER_ID');

3129: IF l_check_invalid_objects = 1 THEN
3130: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
3131:
3132: Eng_Globals.G_WHO_REC.org_id := l_org_id;
3133: Eng_Globals.G_WHO_REC.user_id := FND_PROFILE.value('USER_ID');
3134: Eng_Globals.G_WHO_REC.login_id := FND_PROFILE.value('LOGIN_ID');
3135: Eng_Globals.G_WHO_REC.prog_appid := FND_PROFILE.value('RESP_APPL_ID');
3136: Eng_Globals.G_WHO_REC.prog_id := NULL;
3137: Eng_Globals.G_WHO_REC.req_id := NULL;

Line 3134: Eng_Globals.G_WHO_REC.login_id := FND_PROFILE.value('LOGIN_ID');

3130: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
3131:
3132: Eng_Globals.G_WHO_REC.org_id := l_org_id;
3133: Eng_Globals.G_WHO_REC.user_id := FND_PROFILE.value('USER_ID');
3134: Eng_Globals.G_WHO_REC.login_id := FND_PROFILE.value('LOGIN_ID');
3135: Eng_Globals.G_WHO_REC.prog_appid := FND_PROFILE.value('RESP_APPL_ID');
3136: Eng_Globals.G_WHO_REC.prog_id := NULL;
3137: Eng_Globals.G_WHO_REC.req_id := NULL;
3138:

Line 3135: Eng_Globals.G_WHO_REC.prog_appid := FND_PROFILE.value('RESP_APPL_ID');

3131:
3132: Eng_Globals.G_WHO_REC.org_id := l_org_id;
3133: Eng_Globals.G_WHO_REC.user_id := FND_PROFILE.value('USER_ID');
3134: Eng_Globals.G_WHO_REC.login_id := FND_PROFILE.value('LOGIN_ID');
3135: Eng_Globals.G_WHO_REC.prog_appid := FND_PROFILE.value('RESP_APPL_ID');
3136: Eng_Globals.G_WHO_REC.prog_id := NULL;
3137: Eng_Globals.G_WHO_REC.req_id := NULL;
3138:
3139: fnd_global.apps_initialize

Line 3141: resp_id => FND_PROFILE.value('RESP_ID'),

3137: Eng_Globals.G_WHO_REC.req_id := NULL;
3138:
3139: fnd_global.apps_initialize
3140: (user_id => Eng_Globals.G_WHO_REC.user_id,
3141: resp_id => FND_PROFILE.value('RESP_ID'),
3142: resp_appl_id => Eng_Globals.G_WHO_REC.prog_appid
3143: );
3144:
3145: /* Initializing the Error Handler */

Line 4017: last_updated_by = FND_PROFILE.VALUE('USER_ID'),

4013: UPDATE eng_revised_items
4014: SET status_code = l_status_code,
4015: status_type = l_new_status_type,
4016: last_update_date = sysdate,
4017: last_updated_by = FND_PROFILE.VALUE('USER_ID'),
4018: last_update_login = FND_PROFILE.VALUE('LOGIN_ID')
4019: WHERE change_id = p_local_change_id;
4020: END IF;
4021: CLOSE c_get_init_status;

Line 4018: last_update_login = FND_PROFILE.VALUE('LOGIN_ID')

4014: SET status_code = l_status_code,
4015: status_type = l_new_status_type,
4016: last_update_date = sysdate,
4017: last_updated_by = FND_PROFILE.VALUE('USER_ID'),
4018: last_update_login = FND_PROFILE.VALUE('LOGIN_ID')
4019: WHERE change_id = p_local_change_id;
4020: END IF;
4021: CLOSE c_get_init_status;
4022: EXCEPTION

Line 5007: IF (FND_PROFILE.VALUE('ENG:ECO_REVISED_ITEM_REVISION') = '1') AND

5003: ELSE
5004: l_new_item_revision := NULL;
5005: END IF;
5006:
5007: IF (FND_PROFILE.VALUE('ENG:ECO_REVISED_ITEM_REVISION') = '1') AND
5008: (l_new_item_revision IS NULL OR l_new_item_revision = FND_API.G_MISS_CHAR) AND
5009: ri.new_item_revision IS NOT NULL
5010: THEN
5011: l_token_tbl.delete;

Line 5759: AND acc.responsibility_id = TO_NUMBER(fnd_profile.value('RESP_ID'))));

5755: AND (NOT EXISTS(SELECT 1 FROM ORG_ACCESS acc
5756: WHERE acc.organization_id = eclo.local_organization_id )
5757: OR EXISTS(SELECT 1 FROM ORG_ACCESS acc
5758: WHERE acc.organization_id = eclo.local_organization_id
5759: AND acc.responsibility_id = TO_NUMBER(fnd_profile.value('RESP_ID'))));
5760: l_org_Idx NUMBER;
5761: l_orgs_Cnt NUMBER;
5762:
5763: BEGIN