APPS.GML_GMLUNALC_XMLP_PKG dependencies on FND_PROFILE

Line 6: P_DEFAULT_LOCATION := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');

2: /* $Header: GMLUNALCB.pls 120.0 2007/12/24 13:19:58 nchinnam noship $ */
3: FUNCTION AFTERPFORM RETURN BOOLEAN IS
4: SORT4 VARCHAR2(20);
5: BEGIN
6: P_DEFAULT_LOCATION := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');
7: PARAM_WHERE_CLAUSE := ' ';
8: IF (P_FROM_WHSE IS NOT NULL) THEN
9: PARAM_WHERE_CLAUSE := PARAM_WHERE_CLAUSE || ' and whse.whse_code >= :p_from_whse ';
10: END IF;

Line 123: OR LOCATION <> FND_PROFILE.VALUE('IC$DEFAULT_LOCT') );

119: AND DELETE_MARK = 0
120: AND DOC_TYPE = 'OMSO'
121: AND QC_GRADE = CF_1FORMULA.QC_GRADE
122: AND ( LOT_ID <> 0
123: OR LOCATION <> FND_PROFILE.VALUE('IC$DEFAULT_LOCT') );
124: CURSOR RESERVED_QUANTITY_FOR_ATP IS
125: SELECT
126: SUM(NVL(TRANS_QTY
127: ,0)),

Line 137: OR LOCATION <> FND_PROFILE.VALUE('IC$DEFAULT_LOCT') );

133: AND WHSE_CODE = CF_1FORMULA.WHSE_CODE
134: AND COMPLETED_IND = 0
135: AND DELETE_MARK = 0
136: AND ( LOT_ID <> 0
137: OR LOCATION <> FND_PROFILE.VALUE('IC$DEFAULT_LOCT') );
138: CURSOR QTY_ON_HAND IS
139: SELECT
140: SUM(NVL(S.ONHAND_ORDER_QTY
141: ,0)),

Line 308: WHERE ORGANIZATION_ID = FND_PROFILE.VALUE('ORG_ID');

304: NAME
305: INTO CP_ORGN_NAME
306: FROM
307: HR_OPERATING_UNITS
308: WHERE ORGANIZATION_ID = FND_PROFILE.VALUE('ORG_ID');
309: SELECT
310: USER_NAME
311: INTO CP_USER
312: FROM