1 PACKAGE po_interface_s AS
2 /* $Header: POXBWP1S.pls 120.0 2005/06/01 15:10:34 appldev noship $*/
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 );
42 /****************************************************************************/
43
44 /****************************************************************************
45 --<SOURCING TO PO FPH>
46 Name: CREATE_DOCUMENTS
47 DESC: This procedure is a wrapper with the original signature.
48 ARGS: x_batch_id IN number unique identifier for the all
49 the documents to be created.
50 It will be the same as
51 interface_header_id as we always
52 create 1 doc at a time.
53 x_document_id IN OUT number IN document id to ADD to N/A for
54 sourcing.
55 OUT returns the id of the document
56 created.
57 x_number_lines IN OUT number IN N/A
58 OUT returns the number of interface
59 records processed.
60 --<DBI FPJ>
61 p_document_creation_method IN VARCHAR2 - Stores the method by which
62 the document has been created.
63 *****************************************************************************/
64 procedure create_documents(x_batch_id IN number,
65 x_document_id IN OUT NOCOPY number,
66 x_number_lines IN OUT NOCOPY number,
67 p_document_creation_method IN VARCHAR2 DEFAULT NULL --<DBI FPJ>
68 ,p_orig_org_id IN NUMBER DEFAULT NULL -- <R12 MOAC>
69 );
70 /****************************************************************************/
71
72
73
74 -- Bug 2082757 :
75 FUNCTION source_blanket_line(x_po_header_id IN NUMBER,
76 x_requisition_line_id IN NUMBER,
77 x_interface_line_num IN NUMBER,
78 -- Bug 2707576 whether to allow the BPA to have
79 -- a different UOM from the requisition
80 x_allow_different_uoms IN VARCHAR2 DEFAULT 'Y',
81 p_purchasing_ou_id IN NUMBER --<Shared Proc FPJ>
82 ) RETURN NUMBER;
83 PRAGMA RESTRICT_REFERENCES (source_blanket_line, WNDS, RNPS);
84
85 --<Shared Proc FPJ Start>
86 PROCEDURE create_documents (
87 p_api_version IN NUMBER,
88 x_return_status OUT NOCOPY VARCHAR2,
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2,
91 p_batch_id IN NUMBER,
92 p_req_operating_unit_id IN NUMBER,
93 p_purch_operating_unit_id IN NUMBER,
94 x_document_id IN OUT NOCOPY NUMBER,
95 x_number_lines OUT NOCOPY NUMBER,
96 x_document_number OUT NOCOPY VARCHAR2
97 ,p_sourcing_k_doc_type IN VARCHAR2 DEFAULT NULL--<CONTERMS FPJ>
98 ,p_conterms_exist_flag IN VARCHAR2 DEFAULT 'N' --<CONTERMS FPJ>
99 ,p_document_creation_method IN VARCHAR2 DEFAULT NULL --<DBI FPJ>
100 ,p_orig_org_id IN NUMBER DEFAULT NULL -- <R12 MOAC>
101 );
102 --<Shared Proc FPJ End>
103
104
105 END po_interface_s;