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
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;
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;
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
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;
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;
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
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;
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;