APPS.PKG_GMP_BUCKET_DATA dependencies on FND_PROFILE

Line 276: X_whse_code := FND_PROFILE.VALUE('SY$ALL');

272: AND item_id = V_item_id;
273: END IF;
274:
275: IF (INSTR(V_whse_list,',') <> 0) THEN
276: X_whse_code := FND_PROFILE.VALUE('SY$ALL');
277: ELSE
278: X_whse_code := REPLACE(V_whse_list, '''', '');
279: END IF;
280:

Line 703: /* ' and ((TO_NUMBER(FND_PROFILE.VALUE(''GMP_EXCLUDE_INTERNAL_OMSO'')) = 1 ' ||

699: ' and mtl.demand_id = dtl.line_id '||
700: ' and dtl.header_id = hdr.header_id '||
701: ' and dtl.ship_from_org_id = org.organization_id '||
702: ' and org.process_enabled_flag = '|| '''Y''' ||
703: /* ' and ((TO_NUMBER(FND_PROFILE.VALUE(''GMP_EXCLUDE_INTERNAL_OMSO'')) = 1 ' ||
704: ' and nvl(dtl.source_document_type_id, 0) <> 10 ' ||
705: ' ) ' ||
706: ' or TO_NUMBER(FND_PROFILE.VALUE(''GMP_EXCLUDE_INTERNAL_OMSO'')) = 0 ' ||
707: ' ) ' ||

Line 706: ' or TO_NUMBER(FND_PROFILE.VALUE(''GMP_EXCLUDE_INTERNAL_OMSO'')) = 0 ' ||

702: ' and org.process_enabled_flag = '|| '''Y''' ||
703: /* ' and ((TO_NUMBER(FND_PROFILE.VALUE(''GMP_EXCLUDE_INTERNAL_OMSO'')) = 1 ' ||
704: ' and nvl(dtl.source_document_type_id, 0) <> 10 ' ||
705: ' ) ' ||
706: ' or TO_NUMBER(FND_PROFILE.VALUE(''GMP_EXCLUDE_INTERNAL_OMSO'')) = 0 ' ||
707: ' ) ' ||
708: */
709: ' and NOT EXISTS '||
710: ' (SELECT 1 '||

Line 1173: -- X_whse_code := FND_PROFILE.VALUE('SY$ALL');

1169: WHERE matl_rep_id = V_matl_rep_id
1170: AND item_id = V_item_id;
1171: END IF;
1172: IF (INSTR(V_org_list,',') <> 0) THEN
1173: -- X_whse_code := FND_PROFILE.VALUE('SY$ALL');
1174: X_organization_id := NULL;
1175: ELSE /* For reports the V_org_list will be single org */
1176: X_organization_id := TO_NUMBER(V_org_list);
1177: -- X_whse_code := REPLACE(V_org_list, '''', '');