DBA Data[Home] [Help]

APPS.WMS_WMSSCHS1_XMLP_PKG dependencies on MFG_LOOKUPS

Line 64: L_VALUE_YES MFG_LOOKUPS.MEANING%TYPE;

60: RETURN (TRUE);
61: END BEFOREREPORT;
62:
63: FUNCTION AFTERPFORM RETURN BOOLEAN IS
64: L_VALUE_YES MFG_LOOKUPS.MEANING%TYPE;
65: L_VALUE_NO MFG_LOOKUPS.MEANING%TYPE;
66: L_MASTER_ORG_ID NUMBER;
67: BEGIN
68:

Line 65: L_VALUE_NO MFG_LOOKUPS.MEANING%TYPE;

61: END BEFOREREPORT;
62:
63: FUNCTION AFTERPFORM RETURN BOOLEAN IS
64: L_VALUE_YES MFG_LOOKUPS.MEANING%TYPE;
65: L_VALUE_NO MFG_LOOKUPS.MEANING%TYPE;
66: L_MASTER_ORG_ID NUMBER;
67: BEGIN
68:
69: P_PROJECT_1:=P_PROJECT;

Line 161: MFG_LOOKUPS

157: SELECT
158: MEANING
159: INTO L_VALUE_NO
160: FROM
161: MFG_LOOKUPS
162: WHERE LOOKUP_TYPE = 'SYS_YES_NO'
163: AND LOOKUP_CODE = 2;
164: SELECT
165: MEANING

Line 168: MFG_LOOKUPS

164: SELECT
165: MEANING
166: INTO L_VALUE_YES
167: FROM
168: MFG_LOOKUPS
169: WHERE LOOKUP_TYPE = 'SYS_YES_NO'
170: AND LOOKUP_CODE = 1;
171: IF P_PRINT_CUS_PROD_DET = 1 THEN
172: P_PRINT_CUS_DETAILS := L_VALUE_YES;