1 PACKAGE po_interface_s AUTHID CURRENT_USER AS
2 /* $Header: POXBWP1S.pls 120.2.12020000.3 2013/03/12 11:57:28 ssindhe ship $*/
3
4
5 --Public Variables
6 --Used by create_documents procedure to set the return status
7 --when duplicate document number error is returned
8 G_RET_STS_DUP_DOC_NUM CONSTANT VARCHAR2(1) := 'D'; --<Shared Proc FPJ>
9
10 /****************************************************************************
11 --<SOURCING TO PO FPH>
12 Name: CREATE_DOCUMENTS_WRAPPER
13 DESC: This procedure is modified to add two new parameters.
14 ARGS: x_document_number OUT varchar2 returns the PO/Blanket number
15 when for sourcing, null for
16 existing autocreate.
17 x_errorcode OUT number 1 success
18 2 manual document number notunique
19 3 any other error.
20 --<CONTERMS FPJ START>
21 p_sourcing_k_doc_type IN VARCHAR2 - The document type that Sourcing
22 has seeded in Contracts.
23 Deafault null
24 p_conterms_exist_flag IN VARCHAR2 - Whether the sourcing document
25 has contract template attached.
26 Deafult - N
27 --<CONTERMS FPJ END>
28 --<DBI FPJ>
29 p_document_creation_method IN VARCHAR2 - Stores the method by which
30 the document has been created.
31 *****************************************************************************/
32 procedure create_documents(x_batch_id IN number,
33 x_document_id IN OUT NOCOPY number,
34 x_number_lines IN OUT NOCOPY number,
35 x_document_number IN OUT NOCOPY varchar2,
36 x_errorcode OUT NOCOPY number
37 ,p_sourcing_k_doc_type IN VARCHAR2 DEFAULT NULL--<CONTERMS FPJ>
38 ,p_conterms_exist_flag IN VARCHAR2 DEFAULT 'N' --<CONTERMS FPJ>
39 ,p_document_creation_method IN VARCHAR2 DEFAULT NULL --<DBI FPJ>
40 ,p_orig_org_id IN NUMBER DEFAULT NULL -- <R12 MOAC>
41 ,p_group_shipments IN VARCHAR2 DEFAULT NULL --<Bug 14608120, Autocreate GE ER>
42 );
43 /****************************************************************************/
44
45 /****************************************************************************
46 --<SOURCING TO PO FPH>
47 Name: CREATE_DOCUMENTS
48 DESC: This procedure is a wrapper with the original signature.
49 ARGS: x_batch_id IN number unique identifier for the all
50 the documents to be created.
51 It will be the same as
52 interface_header_id as we always
53 create 1 doc at a time.
54 x_document_id IN OUT number IN document id to ADD to N/A for
55 sourcing.
56 OUT returns the id of the document
57 created.
58 x_number_lines IN OUT number IN N/A
59 OUT returns the number of interface
60 records processed.
61 --<DBI FPJ>
62 p_document_creation_method IN VARCHAR2 - Stores the method by which
63 the document has been created.
64 *****************************************************************************/
65 procedure create_documents(x_batch_id IN number,
66 x_document_id IN OUT NOCOPY number,
67 x_number_lines IN OUT NOCOPY number,
68 p_document_creation_method IN VARCHAR2 DEFAULT NULL --<DBI FPJ>
69 ,p_orig_org_id IN NUMBER DEFAULT NULL -- <R12 MOAC>
70 ,p_group_shipments IN VARCHAR2 DEFAULT NULL --<Bug 14608120, Autocreate GE ER>
71 );
72 /****************************************************************************/
73
74
75
76 -- Bug 2082757 :
77 FUNCTION source_blanket_line(x_po_header_id IN NUMBER,
78 x_requisition_line_id IN NUMBER,
79 x_interface_line_num IN NUMBER,
80 -- Bug 2707576 whether to allow the BPA to have
81 -- a different UOM from the requisition
82 x_allow_different_uoms IN VARCHAR2 DEFAULT 'Y',
83 p_purchasing_ou_id IN NUMBER --<Shared Proc FPJ>
84 ) RETURN NUMBER;
85 PRAGMA RESTRICT_REFERENCES (source_blanket_line, WNDS, RNPS);
86
87 --<Shared Proc FPJ Start>
88 PROCEDURE create_documents (
89 p_api_version IN NUMBER,
90 x_return_status OUT NOCOPY VARCHAR2,
91 x_msg_count OUT NOCOPY NUMBER,
92 x_msg_data OUT NOCOPY VARCHAR2,
93 p_batch_id IN NUMBER,
94 p_req_operating_unit_id IN NUMBER,
95 p_purch_operating_unit_id IN NUMBER,
96 x_document_id IN OUT NOCOPY NUMBER,
97 x_number_lines OUT NOCOPY NUMBER,
98 x_document_number OUT NOCOPY VARCHAR2
99 ,p_sourcing_k_doc_type IN VARCHAR2 DEFAULT NULL--<CONTERMS FPJ>
100 ,p_conterms_exist_flag IN VARCHAR2 DEFAULT 'N' --<CONTERMS FPJ>
101 ,p_document_creation_method IN VARCHAR2 DEFAULT NULL --<DBI FPJ>
102 ,p_orig_org_id IN NUMBER DEFAULT NULL -- <R12 MOAC>
103 ,p_group_shipments IN VARCHAR2 DEFAULT NULL --<Bug 14608120 Autocreate GE ER>
104 );
105 --<Shared Proc FPJ End>
106
107 -- CLM changes Start
108 PROCEDURE create_documents (
109 p_api_version IN NUMBER,
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_msg_count OUT NOCOPY NUMBER,
112 x_msg_data OUT NOCOPY VARCHAR2,
113 p_batch_id IN NUMBER,
114 p_req_operating_unit_id IN NUMBER,
115 p_purch_operating_unit_id IN NUMBER,
116 x_document_id IN OUT NOCOPY NUMBER,
117 x_number_lines OUT NOCOPY NUMBER,
118 x_document_number OUT NOCOPY VARCHAR2
119 ,p_sourcing_k_doc_type IN VARCHAR2 DEFAULT NULL--<CONTERMS FPJ>
120 ,p_conterms_exist_flag IN VARCHAR2 DEFAULT 'N' --<CONTERMS FPJ>
121 ,p_document_creation_method IN VARCHAR2 DEFAULT NULL --<DBI FPJ>
122 ,p_orig_org_id IN NUMBER DEFAULT NULL -- <R12 MOAC>
123 ,x_draft_id OUT NOCOPY NUMBER
124 ,x_error_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR2000 --CLM Phase 2
125 ,p_group_shipments IN VARCHAR2 DEFAULT NULL --<Bug 14608120 Autocreate GE ER>
126 );
127
128 -- <Complex Work R12>: Add parameters p_table_type, p_po_line_id
129 PROCEDURE update_award_distributions(
130 p_table_type IN VARCHAR2 DEFAULT 'INTERFACE'
131 , p_po_line_id IN NUMBER DEFAULT NULL
132 ); --<GRANTS FPJ>
133
134
135 PROCEDURE calibrate_last_dist_quantity (
136 p_line_location_id IN NUMBER
137 );
138
139 -- <Complex Work R12 End>
140
141 PROCEDURE calibrate_last_dist_amount -- <BUG 3322948>
142 ( p_line_location_id IN NUMBER
143 );
144
145 -- CLM changes End
146 END po_interface_s;