42:
43: -- private functions
44:
45: PROCEDURE get_fsp_values(
46: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
47: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
48: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
49: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
50: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
43: -- private functions
44:
45: PROCEDURE get_fsp_values(
46: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
47: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
48: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
49: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
50: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
51: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
44:
45: PROCEDURE get_fsp_values(
46: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
47: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
48: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
49: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
50: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
51: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
52: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
45: PROCEDURE get_fsp_values(
46: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
47: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
48: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
49: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
50: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
51: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
52: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
53: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
46: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
47: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
48: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
49: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
50: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
51: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
52: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
53: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
54: );
47: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
48: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
49: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
50: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
51: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
52: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
53: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
54: );
55:
53: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
54: );
55:
56: PROCEDURE get_vendor_values(
57: x_vendor_id IN po_headers.vendor_id%TYPE,
58: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
59: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
60: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
61: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
54: );
55:
56: PROCEDURE get_vendor_values(
57: x_vendor_id IN po_headers.vendor_id%TYPE,
58: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
59: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
60: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
61: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
62: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
55:
56: PROCEDURE get_vendor_values(
57: x_vendor_id IN po_headers.vendor_id%TYPE,
58: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
59: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
60: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
61: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
62: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
63: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
56: PROCEDURE get_vendor_values(
57: x_vendor_id IN po_headers.vendor_id%TYPE,
58: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
59: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
60: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
61: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
62: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
63: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
64: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
57: x_vendor_id IN po_headers.vendor_id%TYPE,
58: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
59: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
60: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
61: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
62: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
63: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
64: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
65: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
58: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
59: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
60: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
61: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
62: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
63: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
64: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
65: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
66: );
59: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
60: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
61: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
62: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
63: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
64: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
65: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
66: );
67:
65: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
66: );
67:
68: PROCEDURE get_vendor_site_values(
69: x_vendor_id IN po_headers.vendor_id%TYPE,
70: x_vendor_site_id IN po_headers.vendor_site_id%TYPE,
71: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
72: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
73: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
66: );
67:
68: PROCEDURE get_vendor_site_values(
69: x_vendor_id IN po_headers.vendor_id%TYPE,
70: x_vendor_site_id IN po_headers.vendor_site_id%TYPE,
71: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
72: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
73: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
74: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
67:
68: PROCEDURE get_vendor_site_values(
69: x_vendor_id IN po_headers.vendor_id%TYPE,
70: x_vendor_site_id IN po_headers.vendor_site_id%TYPE,
71: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
72: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
73: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
74: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
75: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
68: PROCEDURE get_vendor_site_values(
69: x_vendor_id IN po_headers.vendor_id%TYPE,
70: x_vendor_site_id IN po_headers.vendor_site_id%TYPE,
71: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
72: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
73: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
74: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
75: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
76: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
69: x_vendor_id IN po_headers.vendor_id%TYPE,
70: x_vendor_site_id IN po_headers.vendor_site_id%TYPE,
71: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
72: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
73: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
74: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
75: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
76: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
77: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
70: x_vendor_site_id IN po_headers.vendor_site_id%TYPE,
71: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
72: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
73: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
74: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
75: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
76: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
77: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
78: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
71: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
72: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
73: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
74: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
75: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
76: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
77: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
78: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
79: );
72: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
73: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
74: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
75: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
76: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
77: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
78: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
79: );
80:
78: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
79: );
80:
81: PROCEDURE validate_buyer_id(
82: x_buyer_id IN OUT NOCOPY po_headers.agent_id%TYPE,
83: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
84: x_sequence IN OUT NOCOPY po_online_report_text.line_num%TYPE
85: );
86:
87:
88: PROCEDURE validate_vendor(
89: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
90: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
91: x_vendor_id IN OUT NOCOPY po_headers.vendor_id%TYPE,
92: x_vendor_site_id IN OUT NOCOPY po_headers.vendor_site_id%TYPE,
93: x_vendor_contact_id IN OUT NOCOPY po_headers.vendor_contact_id%TYPE,
94: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
95: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
88: PROCEDURE validate_vendor(
89: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
90: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
91: x_vendor_id IN OUT NOCOPY po_headers.vendor_id%TYPE,
92: x_vendor_site_id IN OUT NOCOPY po_headers.vendor_site_id%TYPE,
93: x_vendor_contact_id IN OUT NOCOPY po_headers.vendor_contact_id%TYPE,
94: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
95: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
96: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
89: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
90: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
91: x_vendor_id IN OUT NOCOPY po_headers.vendor_id%TYPE,
92: x_vendor_site_id IN OUT NOCOPY po_headers.vendor_site_id%TYPE,
93: x_vendor_contact_id IN OUT NOCOPY po_headers.vendor_contact_id%TYPE,
94: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
95: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
96: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
97: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
90: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
91: x_vendor_id IN OUT NOCOPY po_headers.vendor_id%TYPE,
92: x_vendor_site_id IN OUT NOCOPY po_headers.vendor_site_id%TYPE,
93: x_vendor_contact_id IN OUT NOCOPY po_headers.vendor_contact_id%TYPE,
94: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
95: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
96: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
97: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
98: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
91: x_vendor_id IN OUT NOCOPY po_headers.vendor_id%TYPE,
92: x_vendor_site_id IN OUT NOCOPY po_headers.vendor_site_id%TYPE,
93: x_vendor_contact_id IN OUT NOCOPY po_headers.vendor_contact_id%TYPE,
94: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
95: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
96: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
97: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
98: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
99: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
92: x_vendor_site_id IN OUT NOCOPY po_headers.vendor_site_id%TYPE,
93: x_vendor_contact_id IN OUT NOCOPY po_headers.vendor_contact_id%TYPE,
94: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
95: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
96: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
97: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
98: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
99: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
100: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
93: x_vendor_contact_id IN OUT NOCOPY po_headers.vendor_contact_id%TYPE,
94: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
95: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
96: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
97: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
98: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
99: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
100: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
101: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
94: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
95: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
96: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
97: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
98: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
99: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
100: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
101: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
102: );
95: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
96: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
97: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
98: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
99: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
100: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
101: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
102: );
103:
102: );
103:
104: PROCEDURE validate_location_terms(
105: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
106: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
107: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
108: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
109: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
110: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
103:
104: PROCEDURE validate_location_terms(
105: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
106: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
107: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
108: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
109: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
110: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
111: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
104: PROCEDURE validate_location_terms(
105: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
106: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
107: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
108: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
109: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
110: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
111: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
112: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
105: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
106: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
107: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
108: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
109: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
110: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
111: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
112: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
113: );
106: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
107: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
108: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
109: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
110: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
111: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
112: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
113: );
114:
231: --
232: --Procedure that validate that the referenced global agreement is not cancelled or
233: --finally closed
234: PROCEDURE validate_global_ref(
235: p_from_header_id IN po_headers_all.po_header_id%TYPE,
236: p_from_line_id IN po_lines_all.po_line_id%TYPE,
237: p_online_report_id IN po_online_report_text.online_report_id%TYPE,
238: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
239: p_line_num IN po_online_report_text.line_num%TYPE
321:
322: -- end private function declarations
323:
324: PROCEDURE get_fsp_values(
325: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
326: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
327: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
328: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
329: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
322: -- end private function declarations
323:
324: PROCEDURE get_fsp_values(
325: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
326: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
327: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
328: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
329: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
330: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
323:
324: PROCEDURE get_fsp_values(
325: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
326: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
327: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
328: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
329: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
330: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
331: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
324: PROCEDURE get_fsp_values(
325: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
326: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
327: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
328: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
329: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
330: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
331: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
332: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
325: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
326: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
327: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
328: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
329: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
330: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
331: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
332: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
333: ) IS
326: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
327: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
328: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
329: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
330: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
331: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
332: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
333: ) IS
334:
379: END get_fsp_values;
380:
381:
382: PROCEDURE get_vendor_values(
383: x_vendor_id IN po_headers.vendor_id%TYPE,
384: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
385: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
386: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
387: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
380:
381:
382: PROCEDURE get_vendor_values(
383: x_vendor_id IN po_headers.vendor_id%TYPE,
384: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
385: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
386: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
387: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
388: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
381:
382: PROCEDURE get_vendor_values(
383: x_vendor_id IN po_headers.vendor_id%TYPE,
384: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
385: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
386: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
387: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
388: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
389: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
382: PROCEDURE get_vendor_values(
383: x_vendor_id IN po_headers.vendor_id%TYPE,
384: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
385: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
386: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
387: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
388: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
389: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
390: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
383: x_vendor_id IN po_headers.vendor_id%TYPE,
384: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
385: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
386: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
387: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
388: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
389: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
390: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
391: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
384: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
385: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
386: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
387: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
388: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
389: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
390: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
391: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
392: ) IS
385: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
386: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
387: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
388: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
389: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
390: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
391: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
392: ) IS
393:
441: END get_vendor_values;
442:
443:
444: PROCEDURE get_vendor_site_values(
445: x_vendor_id IN po_headers.vendor_id%TYPE,
446: x_vendor_site_id IN po_headers.vendor_site_id%TYPE,
447: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
448: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
449: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
442:
443:
444: PROCEDURE get_vendor_site_values(
445: x_vendor_id IN po_headers.vendor_id%TYPE,
446: x_vendor_site_id IN po_headers.vendor_site_id%TYPE,
447: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
448: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
449: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
450: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
443:
444: PROCEDURE get_vendor_site_values(
445: x_vendor_id IN po_headers.vendor_id%TYPE,
446: x_vendor_site_id IN po_headers.vendor_site_id%TYPE,
447: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
448: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
449: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
450: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
451: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
444: PROCEDURE get_vendor_site_values(
445: x_vendor_id IN po_headers.vendor_id%TYPE,
446: x_vendor_site_id IN po_headers.vendor_site_id%TYPE,
447: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
448: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
449: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
450: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
451: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
452: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
445: x_vendor_id IN po_headers.vendor_id%TYPE,
446: x_vendor_site_id IN po_headers.vendor_site_id%TYPE,
447: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
448: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
449: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
450: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
451: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
452: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
453: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
446: x_vendor_site_id IN po_headers.vendor_site_id%TYPE,
447: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
448: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
449: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
450: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
451: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
452: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
453: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
454: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
447: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
448: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
449: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
450: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
451: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
452: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
453: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
454: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
455: ) IS
448: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
449: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
450: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
451: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
452: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
453: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
454: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
455: ) IS
456:
505: END get_vendor_site_values;
506:
507:
508: PROCEDURE validate_buyer_id(
509: x_buyer_id IN OUT NOCOPY po_headers.agent_id%TYPE,
510: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
511: x_sequence IN OUT NOCOPY po_online_report_text.line_num%TYPE
512: ) IS
513: x_valid_flag VARCHAR2(2) := NULL;
557:
558: PROCEDURE validate_vendor(
559: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
560: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
561: x_vendor_id IN OUT NOCOPY po_headers.vendor_id%TYPE,
562: x_vendor_site_id IN OUT NOCOPY po_headers.vendor_site_id%TYPE,
563: x_vendor_contact_id IN OUT NOCOPY po_headers.vendor_contact_id%TYPE,
564: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
565: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
558: PROCEDURE validate_vendor(
559: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
560: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
561: x_vendor_id IN OUT NOCOPY po_headers.vendor_id%TYPE,
562: x_vendor_site_id IN OUT NOCOPY po_headers.vendor_site_id%TYPE,
563: x_vendor_contact_id IN OUT NOCOPY po_headers.vendor_contact_id%TYPE,
564: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
565: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
566: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
559: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
560: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
561: x_vendor_id IN OUT NOCOPY po_headers.vendor_id%TYPE,
562: x_vendor_site_id IN OUT NOCOPY po_headers.vendor_site_id%TYPE,
563: x_vendor_contact_id IN OUT NOCOPY po_headers.vendor_contact_id%TYPE,
564: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
565: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
566: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
567: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
560: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
561: x_vendor_id IN OUT NOCOPY po_headers.vendor_id%TYPE,
562: x_vendor_site_id IN OUT NOCOPY po_headers.vendor_site_id%TYPE,
563: x_vendor_contact_id IN OUT NOCOPY po_headers.vendor_contact_id%TYPE,
564: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
565: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
566: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
567: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
568: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
561: x_vendor_id IN OUT NOCOPY po_headers.vendor_id%TYPE,
562: x_vendor_site_id IN OUT NOCOPY po_headers.vendor_site_id%TYPE,
563: x_vendor_contact_id IN OUT NOCOPY po_headers.vendor_contact_id%TYPE,
564: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
565: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
566: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
567: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
568: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
569: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
562: x_vendor_site_id IN OUT NOCOPY po_headers.vendor_site_id%TYPE,
563: x_vendor_contact_id IN OUT NOCOPY po_headers.vendor_contact_id%TYPE,
564: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
565: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
566: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
567: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
568: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
569: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
570: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
563: x_vendor_contact_id IN OUT NOCOPY po_headers.vendor_contact_id%TYPE,
564: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
565: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
566: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
567: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
568: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
569: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
570: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
571: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
564: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
565: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
566: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
567: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
568: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
569: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
570: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
571: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
572: ) IS
565: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
566: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
567: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
568: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
569: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
570: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
571: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
572: ) IS
573:
717: END validate_vendor;
718:
719: PROCEDURE validate_location_terms(
720: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
721: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
722: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
723: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
724: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
725: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
718:
719: PROCEDURE validate_location_terms(
720: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
721: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
722: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
723: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
724: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
725: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
726: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
719: PROCEDURE validate_location_terms(
720: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
721: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
722: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
723: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
724: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
725: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
726: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
727: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
720: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
721: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
722: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
723: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
724: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
725: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
726: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
727: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
728: ) IS
721: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
722: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
723: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
724: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
725: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
726: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
727: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
728: ) IS
729:
2027: ) IS
2028: x_valid_flag VARCHAR2(2);
2029: x_progress VARCHAR2(4) := NULL;
2030:
2031: l_contract_doc_num PO_HEADERS_ALL.segment1%TYPE; --
2033: BEGIN
2034:
2035: IF (p_contract_id IS NULL) THEN --
2049: -- SQL Why: This is part of the copy doc submission check
2050:
2051: SELECT 'Y'
2052: INTO x_valid_flag
2053: FROM po_headers_all POH
2054: WHERE POH.po_header_id = p_contract_id
2055: AND POH.type_lookup_code = 'CONTRACT'
2056: AND POH.authorization_status = 'APPROVED'
2057: AND NVL(POH.closed_code, 'OPEN') = 'OPEN'
2063: EXCEPTION
2064: WHEN NO_DATA_FOUND THEN
2065: --
2066: -- When the error is displayed, we should should contract number
2067: l_contract_doc_num := PO_HEADERS_SV4.get_doc_num
2068: ( p_po_header_id => p_contract_id
2069: );
2070:
2071: fnd_message.set_name('PO', 'PO_PO_INVALID_CONTRACT');
2087: --
2088: --Private procedure that validate that the referenced global agreement is not cancelled or
2089: --finally closed
2090: PROCEDURE validate_global_ref(
2091: p_from_header_id IN po_headers_all.po_header_id%TYPE,
2092: p_from_line_id IN po_lines_all.po_line_id%TYPE,
2093: p_online_report_id IN po_online_report_text.online_report_id%TYPE,
2094: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2095: p_line_num IN po_online_report_text.line_num%TYPE
2106: l_progress := '001';
2107:
2108: SELECT 'Y'
2109: INTO l_valid_flag
2110: FROM po_headers_all
2111: WHERE po_header_id = p_from_header_id
2112: AND nvl(closed_code,'OPEN') <> 'FINALLY CLOSED'
2113: AND nvl(cancel_flag,'N') <> 'Y';
2114:
2267:
2268: -- SERVICES FPJ End
2269:
2270: PROCEDURE submission_check_copydoc(
2271: x_po_header_id IN po_headers.po_header_id%TYPE,
2272: x_online_report_id IN NUMBER,
2273: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
2274: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE) IS
2275:
2272: x_online_report_id IN NUMBER,
2273: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
2274: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE) IS
2275:
2276: x_po_header_record po_headers%ROWTYPE;
2277: x_po_line_record po_lines%ROWTYPE;
2278: x_po_shipment_record po_line_locations%ROWTYPE;
2279: x_po_distribution_record po_distributions%ROWTYPE;
2280:
2320: -- - ship-to-locatioin, bill-to-location
2321:
2322: SELECT *
2323: INTO x_po_header_record
2324: FROM po_headers
2325: WHERE po_header_id = x_po_header_id;
2326:
2327: /* Bug#6151431 ankusriv - FP for Bug#5871448 cvardia
2328: ** Desc : The below condition needs to be changed. We need to call Copy