DBA Data[Home] [Help]

APPS.PO_VENDORS_SV dependencies on PO_LOOKUP_CODES

Line 154: X_fob_lookup_code po_lookup_codes.lookup_code%TYPE;

150: X_ship_to_location_id number;
151: X_bill_to_location_id number;
152: X_ship_via_lookup_code varchar2(25);
153: -- Bug: 1710995 Define the codes according to the definition in the table.
154: X_fob_lookup_code po_lookup_codes.lookup_code%TYPE;
155: X_freight_terms_lookup_code po_lookup_codes.lookup_code%TYPE;
156: X_terms_id number;
157: X_invoice_currency_code varchar2(15);
158: X_num_1099 varchar2(30);

Line 155: X_freight_terms_lookup_code po_lookup_codes.lookup_code%TYPE;

151: X_bill_to_location_id number;
152: X_ship_via_lookup_code varchar2(25);
153: -- Bug: 1710995 Define the codes according to the definition in the table.
154: X_fob_lookup_code po_lookup_codes.lookup_code%TYPE;
155: X_freight_terms_lookup_code po_lookup_codes.lookup_code%TYPE;
156: X_terms_id number;
157: X_invoice_currency_code varchar2(15);
158: X_num_1099 varchar2(30);
159: /*

Line 180: X_vs_fob_lookup_code po_lookup_codes.lookup_code%TYPE;

176: X_vs_bill_to_location_id number;
177: X_vs_ship_via_lookup_code varchar2(25);
178: X_vs_pay_on_code varchar2(25);
179: -- Bug: 1710995 Define the codes according to the definition in the table.
180: X_vs_fob_lookup_code po_lookup_codes.lookup_code%TYPE;
181: X_vs_freight_terms_lookup_code po_lookup_codes.lookup_code%TYPE;
182: X_vs_terms_id number;
183: X_vs_invoice_currency_code varchar2(15);
184: x_vs_shipping_control po_lookup_codes.lookup_code%TYPE; --

Line 181: X_vs_freight_terms_lookup_code po_lookup_codes.lookup_code%TYPE;

177: X_vs_ship_via_lookup_code varchar2(25);
178: X_vs_pay_on_code varchar2(25);
179: -- Bug: 1710995 Define the codes according to the definition in the table.
180: X_vs_fob_lookup_code po_lookup_codes.lookup_code%TYPE;
181: X_vs_freight_terms_lookup_code po_lookup_codes.lookup_code%TYPE;
182: X_vs_terms_id number;
183: X_vs_invoice_currency_code varchar2(15);
184: x_vs_shipping_control po_lookup_codes.lookup_code%TYPE; --
185:

Line 184: x_vs_shipping_control po_lookup_codes.lookup_code%TYPE; --

180: X_vs_fob_lookup_code po_lookup_codes.lookup_code%TYPE;
181: X_vs_freight_terms_lookup_code po_lookup_codes.lookup_code%TYPE;
182: X_vs_terms_id number;
183: X_vs_invoice_currency_code varchar2(15);
184: x_vs_shipping_control po_lookup_codes.lookup_code%TYPE; --
185:
186:
187: X_progress varchar2(3) := '';
188:

Line 388: x_lookup_type PO_LOOKUP_CODES.LOOKUP_TYPE%type; --bug3808435

384: procedure val_fob( X_temp_fob_lookup_code IN varchar2,
385: X_res_fob IN OUT NOCOPY varchar2) is
386:
387: X_progress varchar2(3) := '';
388: x_lookup_type PO_LOOKUP_CODES.LOOKUP_TYPE%type; --bug3808435
389: begin
390: X_progress := '010';
391: --Bug3808435
392: --Replaced the hardcoded literal 'FOB' in the sql with a

Line 399: from po_lookup_codes

395: /* Check if the given FOB lookupcode is active */
396:
397: select lookup_code
398: into X_res_fob
399: from po_lookup_codes
400: where lookup_type = x_lookup_type
401: and sysdate < nvl(inactive_date, sysdate + 1)
402: and lookup_code = X_temp_fob_lookup_code;
403:

Line 425: x_lookup_type PO_LOOKUP_CODES.LOOKUP_TYPE%type; --bug3808435

421: procedure val_freight_terms ( X_temp_freight_terms IN varchar2,
422: X_res_freight_terms IN OUT NOCOPY varchar2) is
423:
424: X_progress varchar2(3) := '';
425: x_lookup_type PO_LOOKUP_CODES.LOOKUP_TYPE%type; --bug3808435
426:
427: begin
428: X_progress := '010';
429: --Bug3808435

Line 437: FROM po_lookup_codes

433: /* Check if the given Freight Terms Code is active */
434:
435: SELECT lookup_code
436: INTO X_res_freight_terms
437: FROM po_lookup_codes
438: WHERE lookup_type = x_lookup_type
439: AND sysdate < nvl(inactive_date, sysdate + 1)
440: AND lookup_code = X_temp_freight_terms ;
441: exception

Line 506: x_lookup_type PO_LOOKUP_CODES.LOOKUP_TYPE%type; --bug3808435

502: )
503: IS
504:
505: X_progress varchar2(3) := '';
506: x_lookup_type PO_LOOKUP_CODES.LOOKUP_TYPE%type; --bug3808435
507: BEGIN
508:
509: X_progress := '010';
510: --Bug3808435

Line 518: FROM po_lookup_codes

514: /* Check if the given shipping control is active */
515:
516: SELECT lookup_code
517: INTO x_res_shipping_control
518: FROM po_lookup_codes
519: WHERE lookup_type = x_lookup_type
520: AND TRUNC(SYSDATE) < NVL( TRUNC(inactive_date), SYSDATE + 1 )
521: AND lookup_code = p_temp_shipping_control;
522:

Line 623: from po_lookup_codes

619: -- Get the displayed value for a given FOB lookup Code
620:
621: select displayed_field
622: into X_fob_dsp
623: from po_lookup_codes
624: where lookup_type = 'FOB'
625: and sysdate < nvl(inactive_date, sysdate + 1)
626: and lookup_code = X_res_fob;
627: exception

Line 652: from po_lookup_codes

648: --Get the displayed value for a given Freight Terms Lookup Type
649:
650: select displayed_field
651: into X_freight_terms_dsp
652: from po_lookup_codes
653: where lookup_type = 'FREIGHT TERMS'
654: and sysdate < nvl(inactive_date, sysdate + 1)
655: and lookup_code = X_res_freight_terms ;
656: