DBA Data[Home] [Help]

APPS.PO_COPYDOC_SUB dependencies on PO_HEADERS

Line 46: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,

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,

Line 47: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%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,

Line 48: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%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,

Line 49: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%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

Line 50: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%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: );

Line 51: x_terms_id IN OUT NOCOPY po_headers.terms_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: );
55:

Line 57: x_vendor_id IN po_headers.vendor_id%TYPE,

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,

Line 58: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%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,

Line 59: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%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,

Line 60: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%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,

Line 61: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%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

Line 62: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%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: );

Line 63: x_terms_id IN OUT NOCOPY po_headers.terms_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: );
67:

Line 69: x_vendor_id IN po_headers.vendor_id%TYPE,

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,

Line 70: x_vendor_site_id IN po_headers.vendor_site_id%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,

Line 71: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%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,

Line 72: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%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,

Line 73: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%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,

Line 74: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%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

Line 75: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%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: );

Line 76: x_terms_id IN OUT NOCOPY po_headers.terms_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: );
80:

Line 82: x_buyer_id IN OUT NOCOPY po_headers.agent_id%TYPE,

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:

Line 91: x_vendor_id IN OUT NOCOPY po_headers.vendor_id%TYPE,

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,

Line 92: x_vendor_site_id IN OUT NOCOPY po_headers.vendor_site_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,

Line 93: x_vendor_contact_id IN OUT NOCOPY po_headers.vendor_contact_id%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,

Line 94: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_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,
98: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,

Line 95: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_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,
99: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,

Line 96: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%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,

Line 97: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%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

Line 98: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%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: );

Line 99: x_terms_id IN OUT NOCOPY po_headers.terms_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: );
103:

Line 106: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,

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,

Line 107: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_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,

Line 108: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%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

Line 109: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%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: );

Line 110: x_terms_id IN OUT NOCOPY po_headers.terms_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: );
114:

Line 235: p_from_header_id IN po_headers_all.po_header_id%TYPE,

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

Line 325: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%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,

Line 326: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%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,

Line 327: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%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,

Line 328: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%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

Line 329: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%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

Line 330: x_terms_id IN OUT NOCOPY po_headers.terms_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
334:

Line 383: x_vendor_id IN po_headers.vendor_id%TYPE,

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,

Line 384: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%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,

Line 385: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%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,

Line 386: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%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,

Line 387: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%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

Line 388: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%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

Line 389: x_terms_id IN OUT NOCOPY po_headers.terms_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
393:

Line 445: x_vendor_id IN po_headers.vendor_id%TYPE,

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,

Line 446: x_vendor_site_id IN po_headers.vendor_site_id%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,

Line 447: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%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,

Line 448: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%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,

Line 449: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%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,

Line 450: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%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

Line 451: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%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

Line 452: x_terms_id IN OUT NOCOPY po_headers.terms_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
456:

Line 509: x_buyer_id IN OUT NOCOPY po_headers.agent_id%TYPE,

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;

Line 561: x_vendor_id IN OUT NOCOPY po_headers.vendor_id%TYPE,

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,

Line 562: x_vendor_site_id IN OUT NOCOPY po_headers.vendor_site_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,

Line 563: x_vendor_contact_id IN OUT NOCOPY po_headers.vendor_contact_id%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,

Line 564: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_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,
568: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,

Line 565: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_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,
569: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,

Line 566: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%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,

Line 567: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%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

Line 568: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%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

Line 569: x_terms_id IN OUT NOCOPY po_headers.terms_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
573:

Line 721: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,

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,

Line 722: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_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,

Line 723: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%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

Line 724: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%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

Line 725: x_terms_id IN OUT NOCOPY po_headers.terms_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
729:

Line 2031: l_contract_doc_num PO_HEADERS_ALL.segment1%TYPE; --

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; --
2032:
2033: BEGIN
2034:
2035: IF (p_contract_id IS NULL) THEN --

Line 2053: FROM po_headers_all POH

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'

Line 2067: l_contract_doc_num := PO_HEADERS_SV4.get_doc_num

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

Line 2091: p_from_header_id IN po_headers_all.po_header_id%TYPE,

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

Line 2110: FROM po_headers_all

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:

Line 2271: x_po_header_id IN po_headers.po_header_id%TYPE,

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:

Line 2276: x_po_header_record po_headers%ROWTYPE;

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:

Line 2324: FROM po_headers

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