APPS.PO_POXDLPDT_XMLP_PKG dependencies on PO_LOOKUP_CODES

Line 107: L_DISPLAYED_FIELD PO_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

103: END BLIND_RECEIVING_CHECK;
104:
105: FUNCTION BOILER_PLATE_DOC_TYPE(RRP_TRANSACTION_TYPE IN VARCHAR2) RETURN CHARACTER IS
106: L_TRANSACTION_TYPE VARCHAR2(20);
107: L_DISPLAYED_FIELD PO_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
108: BEGIN
109: L_TRANSACTION_TYPE := RRP_TRANSACTION_TYPE;
110: IF (L_TRANSACTION_TYPE = 'IN TRANSIT') THEN
111: BEGIN

Line 116: PO_LOOKUP_CODES

112: SELECT
113: DISPLAYED_FIELD
114: INTO L_DISPLAYED_FIELD
115: FROM
116: PO_LOOKUP_CODES
117: WHERE LOOKUP_TYPE = 'POXDLPDT TRANSLATE'
118: AND LOOKUP_CODE = 'TYPE';
119: RETURN (L_DISPLAYED_FIELD);
120: END;

Line 127: PO_LOOKUP_CODES

123: SELECT
124: DISPLAYED_FIELD
125: INTO L_DISPLAYED_FIELD
126: FROM
127: PO_LOOKUP_CODES
128: WHERE LOOKUP_TYPE = 'POXDLPDT TRANSLATE'
129: AND LOOKUP_CODE = 'DOCUMENT TYPE';
130: RETURN (L_DISPLAYED_FIELD);
131: END;

Line 138: L_DISPLAYED_FIELD PO_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

134: END BOILER_PLATE_DOC_TYPE;
135:
136: FUNCTION BOILER_PLATE_DOC_NUM(RRP_TRANSACTION_TYPE IN VARCHAR2) RETURN CHARACTER IS
137: L_TRANSACTION_TYPE VARCHAR2(20);
138: L_DISPLAYED_FIELD PO_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
139: BEGIN
140: L_TRANSACTION_TYPE := RRP_TRANSACTION_TYPE;
141: IF (L_TRANSACTION_TYPE = 'IN TRANSIT') THEN
142: BEGIN

Line 147: PO_LOOKUP_CODES

143: SELECT
144: DISPLAYED_FIELD
145: INTO L_DISPLAYED_FIELD
146: FROM
147: PO_LOOKUP_CODES
148: WHERE LOOKUP_TYPE = 'POXDLPDT TRANSLATE'
149: AND LOOKUP_CODE = 'SHIPMENT NUMBER';
150: RETURN (L_DISPLAYED_FIELD);
151: END;

Line 158: PO_LOOKUP_CODES

154: SELECT
155: DISPLAYED_FIELD
156: INTO L_DISPLAYED_FIELD
157: FROM
158: PO_LOOKUP_CODES
159: WHERE LOOKUP_TYPE = 'POXDLPDT TRANSLATE'
160: AND LOOKUP_CODE = 'DOCUMENT NUMBER';
161: RETURN (L_DISPLAYED_FIELD);
162: END;

Line 169: L_DISPLAYED_FIELD PO_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

165: END BOILER_PLATE_DOC_NUM;
166:
167: FUNCTION BOILER_PLATE_BUYER(RRP_TRANSACTION_TYPE IN VARCHAR2) RETURN CHARACTER IS
168: L_TRANSACTION_TYPE VARCHAR2(20);
169: L_DISPLAYED_FIELD PO_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
170: BEGIN
171: L_TRANSACTION_TYPE := RRP_TRANSACTION_TYPE;
172: IF (L_TRANSACTION_TYPE = 'PO') THEN
173: BEGIN

Line 178: PO_LOOKUP_CODES

174: SELECT
175: DISPLAYED_FIELD
176: INTO L_DISPLAYED_FIELD
177: FROM
178: PO_LOOKUP_CODES
179: WHERE LOOKUP_TYPE = 'POXDLPDT TRANSLATE'
180: AND LOOKUP_CODE = 'BUYER';
181: RETURN (L_DISPLAYED_FIELD);
182: END;

Line 189: PO_LOOKUP_CODES

185: SELECT
186: DISPLAYED_FIELD
187: INTO L_DISPLAYED_FIELD
188: FROM
189: PO_LOOKUP_CODES
190: WHERE LOOKUP_TYPE = 'POXDLPDT TRANSLATE'
191: AND LOOKUP_CODE = 'PREPARER';
192: RETURN (L_DISPLAYED_FIELD);
193: END;