APPS.BOM_DELETE_ENTITY dependencies on FND_PROFILE

Line 107: oav.RESPONSIBILITY_ID = FND_PROFILE.Value('RESP_ID')

103: CURSOR orgname is
104: SELECT oav.ORGANIZATION_NAME
105: FROM ORG_ACCESS_VIEW oav
106: WHERE
107: oav.RESPONSIBILITY_ID = FND_PROFILE.Value('RESP_ID')
108: AND oav.RESP_APPLICATION_ID = FND_PROFILE.Value('RESP_APPL_ID')
109: AND oav.ORGANIZATION_ID = org_id;
110: BEGIN
111: FOR c_orgname IN orgname LOOP

Line 108: AND oav.RESP_APPLICATION_ID = FND_PROFILE.Value('RESP_APPL_ID')

104: SELECT oav.ORGANIZATION_NAME
105: FROM ORG_ACCESS_VIEW oav
106: WHERE
107: oav.RESPONSIBILITY_ID = FND_PROFILE.Value('RESP_ID')
108: AND oav.RESP_APPLICATION_ID = FND_PROFILE.Value('RESP_APPL_ID')
109: AND oav.ORGANIZATION_ID = org_id;
110: BEGIN
111: FOR c_orgname IN orgname LOOP
112: RETURN c_orgname.organization_name;

Line 133: to_number(FND_PROFILE.value('RESP_ID')) and

129: and
130: exists ( select 'x'
131: from org_access_view
132: where responsibility_id =
133: to_number(FND_PROFILE.value('RESP_ID')) and
134: resp_application_id =
135: to_number(FND_PROFILE.value('RESP_APPL_ID'))
136: );
137: l_org_id mtl_parameters.organization_id%type;

Line 135: to_number(FND_PROFILE.value('RESP_APPL_ID'))

131: from org_access_view
132: where responsibility_id =
133: to_number(FND_PROFILE.value('RESP_ID')) and
134: resp_application_id =
135: to_number(FND_PROFILE.value('RESP_APPL_ID'))
136: );
137: l_org_id mtl_parameters.organization_id%type;
138: l_index NUMBER := 0;
139: BEGIN