1 PACKAGE PO_LINE_LOCATIONS_SV6 AS
2 /* $Header: POXPIISS.pls 120.0.12000000.1 2007/01/16 23:03:59 appldev ship $ */
3
4 /*==================================================================
5 PROCEDURE NAME: insert_po_line_locations()
6
7 DESCRIPTION: This API is used to insert a new row in
8 po_line_locations
9
10 PARAMETERS:
11
12 DESIGN
13 REFERENCES: 832valapl.doc
14
15 ALGORITHM:
16
17 NOTES:
18
19 OPEN ISSUES:
20
21 CLOSE ISSUES:
22
23 CHANGE
24 HISTORY: Created 22-FEB-1996 DXYU
25
26
27 =======================================================================*/
28 PROCEDURE insert_po_line_locations(
29 x_line_location_id IN NUMBER,
30 x_last_update_date IN DATE,
31 x_last_updated_by IN NUMBER,
32 x_po_header_id IN NUMBER,
33 x_po_line_id IN NUMBER,
34 x_last_update_login IN NUMBER,
35 x_creation_date IN DATE,
36 x_created_by IN NUMBER,
37 x_quantity IN NUMBER,
38 x_quantity_received IN NUMBER,
39 x_quantity_accepted IN NUMBER,
40 x_quantity_rejected IN NUMBER,
41 x_quantity_billed IN NUMBER,
42 x_quantity_cancelled IN NUMBER,
43 x_unit_meas_lookup_code IN VARCHAR2,
44 x_po_release_id IN NUMBER,
45 x_ship_to_location_id IN NUMBER,
46 x_ship_via_lookup_code IN VARCHAR2,
47 x_need_by_date IN DATE,
48 x_promised_date IN DATE,
49 x_last_accept_date IN DATE,
50 x_price_override IN NUMBER,
51 x_encumbered_flag IN VARCHAR2,
52 x_encumbered_date IN DATE,
53 x_fob_lookup_code IN VARCHAR2,
54 x_freight_terms_lookup_code IN VARCHAR2,
55 x_taxable_flag IN VARCHAR2,
56 x_tax_code_id IN NUMBER,
57 x_from_header_id IN NUMBER,
58 x_from_line_id IN NUMBER,
59 x_from_line_location_id IN NUMBER,
60 x_start_date IN DATE,
61 x_end_date IN DATE,
62 x_lead_time IN NUMBER,
63 x_lead_time_unit IN VARCHAR2,
64 x_price_discount IN NUMBER,
65 x_terms_id IN NUMBER,
66 x_approved_flag IN VARCHAR2,
67 x_closed_flag IN VARCHAR2,
68 x_cancel_flag IN VARCHAR2,
69 x_cancelled_by IN NUMBER,
70 x_cancel_date IN DATE,
71 x_cancel_reason IN VARCHAR2,
72 x_firm_status_lookup_code IN VARCHAR2,
73 x_attribute_category IN VARCHAR2,
74 x_attribute1 IN VARCHAR2,
75 x_attribute2 IN VARCHAR2,
76 x_attribute3 IN VARCHAR2,
77 x_attribute4 IN VARCHAR2,
78 x_attribute5 IN VARCHAR2,
79 x_attribute6 IN VARCHAR2,
80 x_attribute7 IN VARCHAR2,
81 x_attribute8 IN VARCHAR2,
82 x_attribute9 IN VARCHAR2,
83 x_attribute10 IN VARCHAR2,
84 x_attribute11 IN VARCHAR2,
85 x_attribute12 IN VARCHAR2,
86 x_attribute13 IN VARCHAR2,
87 x_attribute14 IN VARCHAR2,
88 x_attribute15 IN VARCHAR2,
89 x_inspection_required_flag IN VARCHAR2,
90 x_receipt_required_flag IN VARCHAR2,
91 x_qty_rcv_tolerance IN NUMBER,
92 x_qty_rcv_exception_code IN VARCHAR2,
93 x_enforce_ship_to_loc_code IN VARCHAR2,
94 x_allow_sub_receipts_flag IN VARCHAR2,
95 x_days_early_receipt_allowed IN VARCHAR2,
96 x_days_late_receipt_allowed IN VARCHAR2,
97 x_receipt_days_exception_code IN VARCHAR2,
98 x_invoice_close_tolerance IN NUMBER,
99 x_receive_close_tolerance IN NUMBER,
100 x_ship_to_organization_id IN NUMBER,
101 x_shipment_num IN NUMBER,
102 x_source_shipment_id IN NUMBER,
103 x_shipment_type IN VARCHAR2,
104 x_closed_code IN VARCHAR2,
105 x_request_id IN NUMBER,
106 x_program_application_id IN NUMBER,
107 x_program_id IN NUMBER,
108 x_program_update_date IN DATE,
109 x_ussgl_transaction_code IN VARCHAR2,
110 x_government_context IN VARCHAR2,
111 x_receiving_routing_id IN NUMBER,
112 x_accrue_on_receipt_flag IN VARCHAR2,
113 x_closed_reason IN VARCHAR2,
114 x_closed_date IN DATE,
115 x_closed_by IN NUMBER,
116 x_org_id IN NUMBER,
117 p_transaction_flow_header_id IN NUMBER, --< Shared Proc FPJ >
118 --<SERVICES FPJ START>
119 p_amount IN NUMBER,
120 p_order_type_lookup_code IN VARCHAR2,
121 p_purchase_basis IN VARCHAR2,
122 --<SERVICES FPJ END>
123 x_match_option IN VARCHAR2 DEFAULT NULL,
124 X_note_to_receiver IN VARCHAR2 default null --togeorge 09/28/2000
125
126 );
127
128
129 END PO_LINE_LOCATIONS_SV6;