1 PACKAGE PO_NEGOTIATIONS_SV2 AS
2 /* $Header: POXNEG3S.pls 120.2 2005/10/13 13:46:46 spangulu noship $ */
3
4
5 TYPE who_rec_type IS RECORD -- <SERVICES FPJ>
6 ( created_by PO_LINES_ALL.created_by%TYPE
7 , creation_date PO_LINES_ALL.creation_date%TYPE
8 , last_update_login PO_LINES_ALL.last_update_login%TYPE
9 , last_updated_by PO_LINES_ALL.last_updated_by%TYPE
10 , last_update_date PO_LINES_ALL.last_update_date%TYPE
11 );
12
13 /*******************************************************************
14 PROCEDURE NAME: default_po_dist_interface()
15
16 DESCRIPTION: This API defaults the distribution in
17 po_distributions_interface table(for the interface lines
18 which are not backed by a req). This uses account
19 generator to build the accounts.
20 Referenced by: This is called from po_interface_s.setup_interface_tables.
21 from the file POXBWP1B.pls
22
23 CHANGE History: Created 12-Feb-2002 Toju George
24 *******************************************************************/
25
26 PROCEDURE default_po_dist_interface(
27 x_interface_header_id IN NUMBER,
28 x_interface_line_id IN NUMBER,
29 x_item_id IN NUMBER,
30 x_category_id IN NUMBER,
31 x_ship_to_organization_id IN NUMBER,
32 x_ship_to_location_id IN NUMBER,
33 x_deliver_to_person_id IN NUMBER,
34 x_def_sob_id IN NUMBER,
35 x_chart_of_accounts_id IN NUMBER,
36 x_line_type_id IN NUMBER,
37 x_quantity IN number,
38 x_amount IN NUMBER, -- <SERVICES FPJ>
39 x_rate IN NUMBER,
40 x_rate_date IN DATE,
41 x_vendor_id IN NUMBER,
42 x_vendor_site_id IN NUMBER,
43 x_agent_id IN NUMBER,
44 x_po_encumbrance_flag IN VARCHAR2,
45 x_ussgl_transaction_code IN VARCHAR2,
46 x_type_lookup_code IN VARCHAR2,
47 x_expenditure_organization_id IN NUMBER,
48 x_project_id IN NUMBER,
49 x_task_id IN NUMBER,
50 x_bom_resource_id IN NUMBER,
51 x_wip_entity_id IN NUMBER,
52 x_wip_line_id IN NUMBER,
53 x_wip_repetitive_schedule_id IN NUMBER,
54 x_gl_encumbered_date IN DATE,
55 x_gl_encumbered_period IN VARCHAR2,
56 x_destination_subinventory IN VARCHAR2,
57 x_expenditure_type IN VARCHAR2,
58 x_expenditure_item_date IN DATE,
59 x_wip_operation_seq_num IN NUMBER,
60 x_wip_resource_seq_num IN NUMBER,
61 x_project_accounting_context IN VARCHAR2,
62 p_purchasing_ou_id IN NUMBER, --< Shared Proc FPJ >
63 p_unit_price IN NUMBER --<BUG 3407630>
64 );
65
66
67 /*******************************************************************
68 PROCEDURE NAME: handle_sourcing_attachments
69
70 DESCRIPTION : This is the main API which handles all the copying of
71 attachments from req as well as sourcing to po lines and
72 also the creation of new attachments dynamically from
73 different notes in Oracle sourcing.
74 Referenced by : This is called from po_interface_s.create_line.
75 from the file POXBWP1B.pls
76 parameters :
77 x_column1 this parameter decides whether to copy
78 attachments from only sourcing entities
79 or also from requisition.
80 x_attch_suppress_flag this parameter decides whether to
81 suppress attachments from negotiation
82 due to grouping of two req lines to a
83 single po line.
84 CHANGE History: Created 12-Feb-2002 Toju George
85 *******************************************************************/
86 PROCEDURE handle_sourcing_attachments(
87 x_auction_header_id IN NUMBER,
88 x_auction_line_number IN NUMBER,
89 x_bid_number IN NUMBER,
90 x_bid_line_number IN NUMBER,
91 x_requisition_header_id IN NUMBER,
92 x_requisition_line_id IN NUMBER,
93 x_po_line_id IN NUMBER,
94 x_column1 IN VARCHAR2,
95 x_attch_suppress_flag IN VARCHAR2,
96 X_created_by IN NUMBER DEFAULT NULL,
97 X_last_update_login IN NUMBER DEFAULT NULL);
98
99
100
101 /*******************************************************************
102 PROCEDURE NAME: copy_attachments
103
104 DESCRIPTION : This API copies attachments from one entity to another
105 Referenced by : This is called from handle_sourcing_attachments.
106 parameters :
107 x_column1 this parameter decides whether to copy
108 attachments from only sourcing entities
109 or also from requisition.
110 CHANGE History: Created 12-Feb-2002 Toju George
111 *******************************************************************/
112 PROCEDURE copy_attachments(X_from_entity_name IN VARCHAR2,
113 X_from_pk1_value IN VARCHAR2,
114 X_from_pk2_value IN VARCHAR2 DEFAULT NULL,
115 X_from_pk3_value IN VARCHAR2 DEFAULT NULL,
116 X_from_pk4_value IN VARCHAR2 DEFAULT NULL,
117 X_from_pk5_value IN VARCHAR2 DEFAULT NULL,
118 X_to_entity_name IN VARCHAR2,
119 X_to_pk1_value IN VARCHAR2,
120 X_to_pk2_value IN VARCHAR2 DEFAULT NULL,
121 X_to_pk3_value IN VARCHAR2 DEFAULT NULL,
122 X_to_pk4_value IN VARCHAR2 DEFAULT NULL,
123 X_to_pk5_value IN VARCHAR2 DEFAULT NULL,
124 X_created_by IN NUMBER DEFAULT NULL,
125 X_last_update_login IN NUMBER DEFAULT NULL,
126 X_program_application_id IN NUMBER DEFAULT NULL,
127 X_program_id IN NUMBER DEFAULT NULL,
128 X_request_id IN NUMBER DEFAULT NULL,
129 X_column1 IN VARCHAR2 DEFAULT NULL);
130
131 /*******************************************************************
132 PROCEDURE NAME: add_attch_dynamic
133
134 DESCRIPTION : This API dynamically creates attachments from different
135 notes from the sourcing
136 Referenced by : This is called from handle_sourcing_attachments.
137 parameters :
138 CHANGE History: Created 12-Feb-2002 Toju George
139 *******************************************************************/
140 PROCEDURE add_attch_dynamic(
141 X_from_entity_name IN VARCHAR2
142 , x_auction_header_id IN NUMBER
143 , x_auction_line_number IN NUMBER
144 , x_bid_number IN NUMBER
145 , x_bid_line_number IN NUMBER
146 , X_to_entity_name IN VARCHAR2
147 , X_to_pk1_value IN VARCHAR2
148 , X_created_by IN NUMBER DEFAULT NULL
149 , X_last_update_login IN NUMBER DEFAULT NULL
150 , X_program_application_id IN NUMBER DEFAULT NULL
151 , X_program_id IN NUMBER DEFAULT NULL
152 , X_request_id IN NUMBER DEFAULT NULL
153 , p_auction_payment_id IN NUMBER DEFAULT NULL -- <Complex Work R12>
154 );
155
156 -- <SERVICES FPJ>
157 PROCEDURE convert_text_to_attachment ( p_long_text IN LONG
158 , p_description IN VARCHAR2
159 , p_category_id IN NUMBER
160 , p_to_entity_name IN VARCHAR2
161 , p_to_pk1_value IN VARCHAR2
162 , p_who_rec IN who_rec_type
163 );
164
165
166 -- <Complex Work R12 Start>
167 PROCEDURE copy_sourcing_payitem_atts(
168 p_line_location_id IN NUMBER
169 , p_created_by IN NUMBER
170 , p_last_update_login IN NUMBER
171 , p_auction_header_id IN NUMBER
172 , p_auction_line_number IN NUMBER
173 , p_bid_number IN NUMBER
174 , p_bid_line_number IN NUMBER
175 );
176 -- <Complex Work R12 End>
177
178
179 END PO_NEGOTIATIONS_SV2;