eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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_clm_flag IN po_doc_style_headers.clm_flag%TYPE, -- CLM

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_clm_flag IN po_doc_style_headers.clm_flag%TYPE, -- CLM
112: x_online_report_id IN po_online_report_text.online_report_id%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_clm_flag IN po_doc_style_headers.clm_flag%TYPE, -- CLM
112: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
113: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE

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_clm_flag IN po_doc_style_headers.clm_flag%TYPE, -- CLM
112: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
113: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
114: );

Line 237: p_from_header_id IN po_headers_all.po_header_id%TYPE,

233: --
234: --Procedure that validate that the referenced global agreement is not cancelled or
235: --finally closed
236: PROCEDURE validate_global_ref(
237: p_from_header_id IN po_headers_all.po_header_id%TYPE,
238: p_from_line_id IN po_lines_all.po_line_id%TYPE,
239: p_online_report_id IN po_online_report_text.online_report_id%TYPE,
240: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
241: p_line_num IN po_online_report_text.line_num%TYPE

Line 360: x_po_header_record IN po_headers%ROWTYPE,

356: );
357:
358: --
359: PROCEDURE clm_named_cols_check(
360: x_po_header_record IN po_headers%ROWTYPE,
361: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
362: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
363: );
364:

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

364:
365: -- end private function declarations
366:
367: PROCEDURE get_fsp_values(
368: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
369: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
370: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
371: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
372: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,

Line 369: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,

365: -- end private function declarations
366:
367: PROCEDURE get_fsp_values(
368: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
369: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
370: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
371: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
372: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
373: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,

Line 370: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,

366:
367: PROCEDURE get_fsp_values(
368: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
369: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
370: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
371: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
372: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
373: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
374: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

Line 371: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,

367: PROCEDURE get_fsp_values(
368: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
369: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
370: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
371: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
372: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
373: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
374: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
375: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE

Line 372: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,

368: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
369: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
370: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
371: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
372: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
373: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
374: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
375: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
376: ) IS

Line 373: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,

369: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
370: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
371: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
372: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
373: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
374: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
375: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
376: ) IS
377:

Line 426: x_vendor_id IN po_headers.vendor_id%TYPE,

422: END get_fsp_values;
423:
424:
425: PROCEDURE get_vendor_values(
426: x_vendor_id IN po_headers.vendor_id%TYPE,
427: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
428: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
429: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
430: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,

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

423:
424:
425: PROCEDURE get_vendor_values(
426: x_vendor_id IN po_headers.vendor_id%TYPE,
427: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
428: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
429: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
430: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
431: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,

Line 428: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,

424:
425: PROCEDURE get_vendor_values(
426: x_vendor_id IN po_headers.vendor_id%TYPE,
427: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
428: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
429: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
430: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
431: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
432: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,

Line 429: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,

425: PROCEDURE get_vendor_values(
426: x_vendor_id IN po_headers.vendor_id%TYPE,
427: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
428: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
429: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
430: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
431: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
432: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
433: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

Line 430: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,

426: x_vendor_id IN po_headers.vendor_id%TYPE,
427: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
428: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
429: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
430: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
431: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
432: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
433: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
434: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE

Line 431: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,

427: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
428: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
429: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
430: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
431: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
432: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
433: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
434: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
435: ) IS

Line 432: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,

428: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
429: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
430: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
431: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
432: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
433: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
434: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
435: ) IS
436:

Line 488: x_vendor_id IN po_headers.vendor_id%TYPE,

484: END get_vendor_values;
485:
486:
487: PROCEDURE get_vendor_site_values(
488: x_vendor_id IN po_headers.vendor_id%TYPE,
489: x_vendor_site_id IN po_headers.vendor_site_id%TYPE,
490: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
491: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
492: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,

Line 489: x_vendor_site_id IN po_headers.vendor_site_id%TYPE,

485:
486:
487: PROCEDURE get_vendor_site_values(
488: x_vendor_id IN po_headers.vendor_id%TYPE,
489: x_vendor_site_id IN po_headers.vendor_site_id%TYPE,
490: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
491: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
492: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
493: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,

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

486:
487: PROCEDURE get_vendor_site_values(
488: x_vendor_id IN po_headers.vendor_id%TYPE,
489: x_vendor_site_id IN po_headers.vendor_site_id%TYPE,
490: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
491: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
492: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
493: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
494: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,

Line 491: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,

487: PROCEDURE get_vendor_site_values(
488: x_vendor_id IN po_headers.vendor_id%TYPE,
489: x_vendor_site_id IN po_headers.vendor_site_id%TYPE,
490: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
491: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
492: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
493: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
494: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
495: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,

Line 492: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,

488: x_vendor_id IN po_headers.vendor_id%TYPE,
489: x_vendor_site_id IN po_headers.vendor_site_id%TYPE,
490: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
491: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
492: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
493: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
494: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
495: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
496: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

Line 493: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,

489: x_vendor_site_id IN po_headers.vendor_site_id%TYPE,
490: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
491: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
492: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
493: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
494: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
495: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
496: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
497: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE

Line 494: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,

490: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
491: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
492: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
493: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
494: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
495: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
496: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
497: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
498: ) IS

Line 495: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,

491: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
492: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
493: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
494: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
495: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
496: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
497: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
498: ) IS
499:

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

548: END get_vendor_site_values;
549:
550:
551: PROCEDURE validate_buyer_id(
552: x_buyer_id IN OUT NOCOPY po_headers.agent_id%TYPE,
553: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
554: x_sequence IN OUT NOCOPY po_online_report_text.line_num%TYPE
555: ) IS
556: x_valid_flag VARCHAR2(2) := NULL;

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

600:
601: PROCEDURE validate_vendor(
602: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
603: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
604: x_vendor_id IN OUT NOCOPY po_headers.vendor_id%TYPE,
605: x_vendor_site_id IN OUT NOCOPY po_headers.vendor_site_id%TYPE,
606: x_vendor_contact_id IN OUT NOCOPY po_headers.vendor_contact_id%TYPE,
607: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
608: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,

Line 605: x_vendor_site_id IN OUT NOCOPY po_headers.vendor_site_id%TYPE,

601: PROCEDURE validate_vendor(
602: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
603: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
604: x_vendor_id IN OUT NOCOPY po_headers.vendor_id%TYPE,
605: x_vendor_site_id IN OUT NOCOPY po_headers.vendor_site_id%TYPE,
606: x_vendor_contact_id IN OUT NOCOPY po_headers.vendor_contact_id%TYPE,
607: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
608: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
609: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,

Line 606: x_vendor_contact_id IN OUT NOCOPY po_headers.vendor_contact_id%TYPE,

602: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
603: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
604: x_vendor_id IN OUT NOCOPY po_headers.vendor_id%TYPE,
605: x_vendor_site_id IN OUT NOCOPY po_headers.vendor_site_id%TYPE,
606: x_vendor_contact_id IN OUT NOCOPY po_headers.vendor_contact_id%TYPE,
607: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
608: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
609: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
610: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,

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

603: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
604: x_vendor_id IN OUT NOCOPY po_headers.vendor_id%TYPE,
605: x_vendor_site_id IN OUT NOCOPY po_headers.vendor_site_id%TYPE,
606: x_vendor_contact_id IN OUT NOCOPY po_headers.vendor_contact_id%TYPE,
607: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
608: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
609: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
610: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
611: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,

Line 608: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,

604: x_vendor_id IN OUT NOCOPY po_headers.vendor_id%TYPE,
605: x_vendor_site_id IN OUT NOCOPY po_headers.vendor_site_id%TYPE,
606: x_vendor_contact_id IN OUT NOCOPY po_headers.vendor_contact_id%TYPE,
607: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
608: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
609: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
610: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
611: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
612: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,

Line 609: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,

605: x_vendor_site_id IN OUT NOCOPY po_headers.vendor_site_id%TYPE,
606: x_vendor_contact_id IN OUT NOCOPY po_headers.vendor_contact_id%TYPE,
607: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
608: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
609: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
610: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
611: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
612: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
613: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

Line 610: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,

606: x_vendor_contact_id IN OUT NOCOPY po_headers.vendor_contact_id%TYPE,
607: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
608: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
609: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
610: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
611: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
612: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
613: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
614: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE

Line 611: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,

607: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
608: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
609: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
610: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
611: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
612: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
613: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
614: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
615: ) IS

Line 612: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,

608: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
609: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
610: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
611: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
612: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
613: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
614: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
615: ) IS
616:

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

760: END validate_vendor;
761:
762: PROCEDURE validate_location_terms(
763: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
764: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
765: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
766: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
767: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
768: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,

Line 765: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,

761:
762: PROCEDURE validate_location_terms(
763: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
764: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
765: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
766: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
767: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
768: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
769: x_clm_flag IN po_doc_style_headers.clm_flag%TYPE, -- CLM

Line 766: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,

762: PROCEDURE validate_location_terms(
763: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
764: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
765: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
766: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
767: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
768: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
769: x_clm_flag IN po_doc_style_headers.clm_flag%TYPE, -- CLM
770: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

Line 767: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,

763: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
764: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
765: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
766: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
767: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
768: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
769: x_clm_flag IN po_doc_style_headers.clm_flag%TYPE, -- CLM
770: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
771: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE

Line 768: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,

764: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,
765: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
766: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
767: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
768: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
769: x_clm_flag IN po_doc_style_headers.clm_flag%TYPE, -- CLM
770: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
771: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
772: ) IS

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

2172: ) IS
2173: x_valid_flag VARCHAR2(2);
2174: x_progress VARCHAR2(4) := NULL;
2175:
2176: l_contract_doc_num PO_HEADERS_ALL.segment1%TYPE; --
2177:
2178: BEGIN
2179:
2180: IF (p_contract_id IS NULL) THEN --

Line 2198: FROM po_headers_all POH

2194: -- SQL Why: This is part of the copy doc submission check
2195:
2196: SELECT 'Y'
2197: INTO x_valid_flag
2198: FROM po_headers_all POH
2199: WHERE POH.po_header_id = p_contract_id
2200: AND POH.type_lookup_code = 'CONTRACT'
2201: AND POH.authorization_status = 'APPROVED'
2202: AND NVL(POH.closed_code, 'OPEN') = 'OPEN'

Line 2213: l_contract_doc_num := PO_HEADERS_SV4.get_doc_num

2209: EXCEPTION
2210: WHEN NO_DATA_FOUND THEN
2211: --
2212: -- When the error is displayed, we should should contract number
2213: l_contract_doc_num := PO_HEADERS_SV4.get_doc_num
2214: ( p_po_header_id => p_contract_id
2215: );
2216:
2217: fnd_message.set_name('PO', 'PO_PO_INVALID_CONTRACT');

Line 2237: p_from_header_id IN po_headers_all.po_header_id%TYPE,

2233: --
2234: --Private procedure that validate that the referenced global agreement is not cancelled or
2235: --finally closed
2236: PROCEDURE validate_global_ref(
2237: p_from_header_id IN po_headers_all.po_header_id%TYPE,
2238: p_from_line_id IN po_lines_all.po_line_id%TYPE,
2239: p_online_report_id IN po_online_report_text.online_report_id%TYPE,
2240: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2241: p_line_num IN po_online_report_text.line_num%TYPE

Line 2256: FROM po_headers_all

2252: l_progress := '001';
2253:
2254: SELECT 'Y'
2255: INTO l_valid_flag
2256: FROM po_headers_all
2257: WHERE po_header_id = p_from_header_id
2258: AND nvl(closed_code,'OPEN') <> 'FINALLY CLOSED'
2259: AND nvl(cancel_flag,'N') <> 'Y';
2260:

Line 2417: x_po_header_id IN po_headers.po_header_id%TYPE,

2413:
2414: -- SERVICES FPJ End
2415:
2416: PROCEDURE submission_check_copydoc(
2417: x_po_header_id IN po_headers.po_header_id%TYPE,
2418: x_online_report_id IN NUMBER,
2419: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
2420: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE) IS
2421:

Line 2422: x_po_header_record po_headers%ROWTYPE;

2418: x_online_report_id IN NUMBER,
2419: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
2420: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE) IS
2421:
2422: x_po_header_record po_headers%ROWTYPE;
2423: x_po_line_record po_lines%ROWTYPE;
2424: x_po_shipment_record po_line_locations%ROWTYPE;
2425: x_po_distribution_record po_distributions%ROWTYPE;
2426:

Line 2471: FROM po_headers

2467: -- - ship-to-locatioin, bill-to-location
2468:
2469: SELECT *
2470: INTO x_po_header_record
2471: FROM po_headers
2472: WHERE po_header_id = x_po_header_id;
2473:
2474: /* Bug#6151431 ankusriv - FP for Bug#5871448 cvardia
2475: ** Desc : The below condition needs to be changed. We need to call Copy

Line 3514: FROM po_headers_all POH

3510: to check if source is a valid Quotation.The Status that defines an active Quotation is
3511: status_lookup_code.Hence added that check as well*/
3512: SELECT 'Y'
3513: INTO l_valid_flag
3514: FROM po_headers_all POH
3515: WHERE POH.po_header_id = p_blanket_id
3516: AND ( (POH.type_lookup_code = 'QUOTATION' AND Nvl(poh.STATUS_LOOKUP_CODE,'I') = 'A') --
3517: OR ( POH.type_lookup_code = 'BLANKET' AND Nvl(POH.authorization_status,'INCOMPLETE') = 'APPROVED' ) ) --
3518: AND NVL(POH.closed_code, 'OPEN') = 'OPEN'

Line 3541: x_po_header_record IN po_headers%ROWTYPE,

3537: END validate_blanket_ref;
3538:
3539: -- CLM Checks: Validations for CLM named columns
3540: PROCEDURE clm_named_cols_check(
3541: x_po_header_record IN po_headers%ROWTYPE,
3542: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
3543: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
3544: )
3545: IS

Line 3557: FROM po_headers_all poh

3553: -- It should not be closed-out, i.e. frozen_flag = Y
3554: BEGIN
3555: SELECT poh.frozen_flag
3556: INTO l_frozen_flag
3557: FROM po_headers_all poh
3558: WHERE poh.po_header_id = x_po_header_record.clm_source_document_id;
3559: EXCEPTION
3560: WHEN NO_DATA_FOUND THEN -- when there is no source document
3561: l_frozen_flag := 'N';