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 3225: Eng_Globals.G_WHO_REC.user_id := FND_PROFILE.value('USER_ID');

3221: IF l_check_invalid_objects = 1 THEN
3222: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
3223:
3224: Eng_Globals.G_WHO_REC.org_id := l_org_id;
3225: Eng_Globals.G_WHO_REC.user_id := FND_PROFILE.value('USER_ID');
3226: Eng_Globals.G_WHO_REC.login_id := FND_PROFILE.value('LOGIN_ID');
3227: Eng_Globals.G_WHO_REC.prog_appid := FND_PROFILE.value('RESP_APPL_ID');
3228: Eng_Globals.G_WHO_REC.prog_id := NULL;
3229: Eng_Globals.G_WHO_REC.req_id := NULL;

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

3222: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
3223:
3224: Eng_Globals.G_WHO_REC.org_id := l_org_id;
3225: Eng_Globals.G_WHO_REC.user_id := FND_PROFILE.value('USER_ID');
3226: Eng_Globals.G_WHO_REC.login_id := FND_PROFILE.value('LOGIN_ID');
3227: Eng_Globals.G_WHO_REC.prog_appid := FND_PROFILE.value('RESP_APPL_ID');
3228: Eng_Globals.G_WHO_REC.prog_id := NULL;
3229: Eng_Globals.G_WHO_REC.req_id := NULL;
3230:

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

3223:
3224: Eng_Globals.G_WHO_REC.org_id := l_org_id;
3225: Eng_Globals.G_WHO_REC.user_id := FND_PROFILE.value('USER_ID');
3226: Eng_Globals.G_WHO_REC.login_id := FND_PROFILE.value('LOGIN_ID');
3227: Eng_Globals.G_WHO_REC.prog_appid := FND_PROFILE.value('RESP_APPL_ID');
3228: Eng_Globals.G_WHO_REC.prog_id := NULL;
3229: Eng_Globals.G_WHO_REC.req_id := NULL;
3230:
3231: fnd_global.apps_initialize

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

3229: Eng_Globals.G_WHO_REC.req_id := NULL;
3230:
3231: fnd_global.apps_initialize
3232: (user_id => Eng_Globals.G_WHO_REC.user_id,
3233: resp_id => FND_PROFILE.value('RESP_ID'),
3234: resp_appl_id => Eng_Globals.G_WHO_REC.prog_appid
3235: );
3236:
3237: /* Initializing the Error Handler */

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

4138: UPDATE eng_revised_items
4139: SET status_code = l_status_code,
4140: status_type = l_new_status_type,
4141: last_update_date = sysdate,
4142: last_updated_by = FND_PROFILE.VALUE('USER_ID'),
4143: last_update_login = FND_PROFILE.VALUE('LOGIN_ID')
4144: WHERE change_id = p_local_change_id;
4145: END IF;
4146: CLOSE c_get_init_status;

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

4139: SET status_code = l_status_code,
4140: status_type = l_new_status_type,
4141: last_update_date = sysdate,
4142: last_updated_by = FND_PROFILE.VALUE('USER_ID'),
4143: last_update_login = FND_PROFILE.VALUE('LOGIN_ID')
4144: WHERE change_id = p_local_change_id;
4145: END IF;
4146: CLOSE c_get_init_status;
4147: EXCEPTION

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

5130: ELSE
5131: l_new_item_revision := NULL;
5132: END IF;
5133:
5134: IF (FND_PROFILE.VALUE('ENG:ECO_REVISED_ITEM_REVISION') = '1') AND
5135: (l_new_item_revision IS NULL OR l_new_item_revision = FND_API.G_MISS_CHAR) AND
5136: ri.new_item_revision IS NOT NULL
5137: THEN
5138: l_token_tbl.delete;

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

6228: AND (NOT EXISTS(SELECT 1 FROM ORG_ACCESS acc
6229: WHERE acc.organization_id = eclo.local_organization_id )
6230: OR EXISTS(SELECT 1 FROM ORG_ACCESS acc
6231: WHERE acc.organization_id = eclo.local_organization_id
6232: AND acc.responsibility_id = TO_NUMBER(fnd_profile.value('RESP_ID'))));
6233: l_org_Idx NUMBER;
6234: l_orgs_Cnt NUMBER;
6235:
6236: BEGIN