[Home] [Help]
PACKAGE: APPS.PO_SHARED_PROC_PVT
Source
1 PACKAGE PO_SHARED_PROC_PVT AUTHID CURRENT_USER AS
2 /* $Header: POXVSPSS.pls 120.0 2005/06/02 00:34:07 appldev noship $ */
3
4 PROCEDURE check_transaction_flow
5 (
6 p_init_msg_list IN VARCHAR2,
7 x_return_status OUT NOCOPY VARCHAR2,
8 p_start_ou_id IN NUMBER,
9 p_end_ou_id IN NUMBER,
10 p_ship_to_org_id IN NUMBER,
11 p_item_category_id IN NUMBER,
12 p_transaction_date IN DATE,
13 x_transaction_flow_header_id OUT NOCOPY NUMBER
14 );
15
16 FUNCTION get_coa_from_inv_org
17 (
18 p_inv_org_id IN NUMBER
19 )
20 RETURN NUMBER;
21
22 PROCEDURE get_ou_and_coa_from_inv_org
23 (
24 p_inv_org_id IN NUMBER,
25 x_coa_id OUT NOCOPY NUMBER,
26 x_ou_id OUT NOCOPY NUMBER,
27 x_return_status OUT NOCOPY VARCHAR2
28 );
29
30 FUNCTION is_SPS_distribution
31 (
32 p_destination_type_code IN VARCHAR2,
33 p_document_type_code IN VARCHAR2,
34 p_purchasing_ou_id IN NUMBER,
35 p_project_id IN NUMBER,
36 p_ship_to_ou_id IN NUMBER,
37 p_transaction_flow_header_id IN NUMBER
38 )
39 RETURN BOOLEAN;
40
41 FUNCTION is_pa_project_referenced
42 (
43 p_requisition_line_id IN NUMBER
44 )
45 RETURN BOOLEAN;
46
47 PROCEDURE validate_cross_ou_purchasing
48 (
49 p_api_version IN NUMBER,
50 p_requisition_line_id IN NUMBER,
51 p_requesting_org_id IN NUMBER,
52 p_purchasing_org_id IN NUMBER,
53 p_item_id IN NUMBER,
54 p_source_doc_id IN NUMBER,
55 p_vmi_flag IN VARCHAR2,
56 p_cons_from_supp_flag IN VARCHAR2,
57 x_return_status OUT NOCOPY VARCHAR2,
58 x_error_msg_name OUT NOCOPY VARCHAR2,
59 p_document_type IN VARCHAR2 := 'STANDARD' -- <HTMLAC>
60 );
61
62 PROCEDURE validate_cross_ou_tbl -- <HTMLAC START>
63 (
64 p_req_line_id_tbl IN PO_TBL_NUMBER
65 , p_requesting_org_id_tbl IN PO_TBL_NUMBER
66 , p_purchasing_org_id IN NUMBER
67 , p_document_type IN VARCHAR2
68 , p_item_id_tbl IN PO_TBL_NUMBER
69 , p_source_doc_id_tbl IN PO_TBL_NUMBER
70 , p_vmi_flag_tbl IN PO_TBL_VARCHAR1
71 , p_consigned_flag_tbl IN PO_TBL_VARCHAR1
72 , x_valid_flag_tbl OUT NOCOPY PO_TBL_VARCHAR1
73 , x_error_msg_tbl OUT NOCOPY PO_TBL_VARCHAR30
74 ); -- <HTMLAC END>
75
76 PROCEDURE check_item_in_inventory_org
77 (
78 p_init_msg_list IN VARCHAR2,
79 x_return_status OUT NOCOPY VARCHAR2,
80 p_item_id IN NUMBER,
81 p_item_revision IN VARCHAR2,
82 p_inv_org_id IN NUMBER,
83 x_in_inv_org OUT NOCOPY BOOLEAN
84 );
85
86 PROCEDURE validate_ship_to_org
87 (
88 p_init_msg_list IN VARCHAR2,
89 x_return_status OUT NOCOPY VARCHAR2,
90 p_ship_to_org_id IN NUMBER,
91 p_item_category_id IN NUMBER,
92 p_item_id IN NUMBER, -- Bug 3433867
93 x_is_valid OUT NOCOPY BOOLEAN,
94 x_in_current_sob OUT NOCOPY BOOLEAN,
95 x_check_txn_flow OUT NOCOPY BOOLEAN,
96 x_transaction_flow_header_id OUT NOCOPY NUMBER
97 );
98
99 FUNCTION is_txn_flow_supported RETURN BOOLEAN;
100
101 FUNCTION get_inv_qualifier_code RETURN NUMBER;
102
103 PROCEDURE do_item_validity_checks(
104 p_item_id IN NUMBER,
105 p_org_id IN NUMBER,
106 p_valid_org_id IN NUMBER,
107 p_do_osp_check IN BOOLEAN,
108 x_return_status OUT NOCOPY VARCHAR2,
109 x_item_valid_msg_name OUT NOCOPY VARCHAR2);
110
111 FUNCTION get_logical_inv_org_id
112 (
113 p_transaction_flow_header_id IN NUMBER
114 )
115 RETURN NUMBER;
116
117 PROCEDURE get_po_setup_parameters
118 (
119 p_org_id IN NUMBER,
120 x_po_num_code OUT NOCOPY VARCHAR2,
121 x_po_num_type OUT NOCOPY VARCHAR2
122 );
123
124 -- Bug 3433867: added the following procedure to perform extra item
125 -- validation for Shared Procurement
126 PROCEDURE check_item_in_linv_pou
127 (
128 x_return_status OUT NOCOPY VARCHAR2,
129 p_item_id IN NUMBER,
130 p_transaction_flow_header_id IN NUMBER,
131 x_item_in_linv_pou OUT NOCOPY VARCHAR2
132 );
133
134 END PO_SHARED_PROC_PVT;