DBA Data[Home] [Help]

APPS.PO_COPYDOC_SUB dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 89: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,

85: );
86:
87:
88: PROCEDURE validate_vendor(
89: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
90: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
91: x_vendor_id IN OUT NOCOPY po_headers.vendor_id%TYPE,
92: x_vendor_site_id IN OUT NOCOPY po_headers.vendor_site_id%TYPE,
93: x_vendor_contact_id IN OUT NOCOPY po_headers.vendor_contact_id%TYPE,

Line 90: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,

86:
87:
88: PROCEDURE validate_vendor(
89: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
90: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
91: x_vendor_id IN OUT NOCOPY po_headers.vendor_id%TYPE,
92: x_vendor_site_id IN OUT NOCOPY po_headers.vendor_site_id%TYPE,
93: x_vendor_contact_id IN OUT NOCOPY po_headers.vendor_contact_id%TYPE,
94: x_ship_to_location_id IN OUT NOCOPY po_headers.ship_to_location_id%TYPE,

Line 105: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,

101: x_sequence IN OUT NOCOPY po_online_report_text.sequence%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,

Line 121: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,

117: x_item_description IN OUT NOCOPY po_lines.item_description%TYPE,
118: x_item_revision IN OUT NOCOPY po_lines.item_revision%TYPE,
119: x_category_id IN OUT NOCOPY po_lines.category_id%TYPE,
120: x_line_type_id IN po_lines.line_type_id%TYPE,
121: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
122: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
123: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
124: x_line_num IN po_online_report_text.line_num%TYPE,
125: x_return_code OUT NOCOPY NUMBER

Line 156: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,

152: PROCEDURE validate_account_id(
153: x_account_id IN OUT NOCOPY NUMBER,
154: x_account_type IN VARCHAR2,
155: x_gl_date IN DATE,
156: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
157: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
158: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
159: x_line_num IN po_online_report_text.line_num%TYPE,
160: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

Line 167: x_ship_org_id IN financials_system_parameters.inventory_organization_id%TYPE,

163:
164: PROCEDURE validate_destination_type_code(
165: x_destination_type_code IN OUT NOCOPY po_distributions.destination_type_code%TYPE,
166: x_item_id IN po_lines.item_id%TYPE,
167: x_ship_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
168: x_accrue_on_receipt_flag IN varchar2,
169: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
170: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
171: x_line_num IN po_online_report_text.line_num%TYPE,

Line 353: FROM FINANCIALS_SYSTEM_PARAMETERS fsp;

349: x_ship_via_lookup_code,
350: x_fob_lookup_code,
351: x_freight_terms_lu_code,
352: x_terms_id
353: FROM FINANCIALS_SYSTEM_PARAMETERS fsp;
354:
355: EXCEPTION
356: WHEN NO_DATA_FOUND THEN
357: x_ship_to_location_id := NULL;

Line 559: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,

555:
556: END validate_buyer_id;
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,

Line 560: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,

556: END validate_buyer_id;
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,

Line 720: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,

716:
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,

Line 873: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,

869: x_item_description IN OUT NOCOPY po_lines.item_description%TYPE,
870: x_item_revision IN OUT NOCOPY po_lines.item_revision%TYPE,
871: x_category_id IN OUT NOCOPY po_lines.category_id%TYPE,
872: x_line_type_id IN po_lines.line_type_id%TYPE,
873: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
874: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
875: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
876: x_line_num IN po_online_report_text.line_num%TYPE,
877: x_return_code OUT NOCOPY NUMBER

Line 1196: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,

1192: PROCEDURE validate_account_id(
1193: x_account_id IN OUT NOCOPY NUMBER,
1194: x_account_type IN VARCHAR2,
1195: x_gl_date IN DATE,
1196: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
1197: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1198: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1199: x_line_num IN po_online_report_text.line_num%TYPE,
1200: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

Line 1526: x_ship_org_id IN financials_system_parameters.inventory_organization_id%TYPE,

1522:
1523: PROCEDURE validate_destination_type_code(
1524: x_destination_type_code IN OUT NOCOPY po_distributions.destination_type_code%TYPE,
1525: x_item_id IN po_lines.item_id%TYPE,
1526: x_ship_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
1527: x_accrue_on_receipt_flag IN varchar2,
1528: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1529: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1530: x_line_num IN po_online_report_text.line_num%TYPE,

Line 2273: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,

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:
2276: x_po_header_record po_headers%ROWTYPE;
2277: x_po_line_record po_lines%ROWTYPE;

Line 2274: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE) IS

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