[Home] [Help]
PACKAGE: APPS.PO_PDOI_DISTRIBUTIONS_SV3
Source
1 PACKAGE PO_PDOI_DISTRIBUTIONS_SV3 AUTHID CURRENT_USER AS
2 /* $Header: POXPIDVS.pls 120.0.12020000.2 2013/02/10 14:16:46 vegajula ship $ */
3
4 /*================================================================
5
6 PROCEDURE NAME: validate_po_dist()
7
8 ==================================================================*/
9
10 PROCEDURE validate_po_dist(x_interface_header_id in NUMBER,
11 x_interface_line_id in NUMBER,
12 x_interface_distribution_id in NUMBER,
13 x_po_distribution_id IN NUMBER,
14 x_charge_account_id IN NUMBER,
15 x_destination_organization_id IN NUMBER,
16 x_sob_id IN NUMBER,
17 x_item_id IN NUMBER,
18 x_ship_to_organization_id IN NUMBER,
19 x_deliver_to_person_id IN NUMBER,
20 x_deliver_to_location_id IN NUMBER,
21 x_header_processable_flag in out NOCOPY varchar2,
22 x_quantity_ordered IN NUMBER,
23 x_distribution_num IN NUMBER,
24 x_quantity_delivered IN NUMBER,
25 x_quantity_billed IN NUMBER,
26 x_quantity_cancelled IN NUMBER,
27 x_destination_type_code IN VARCHAR2,
28 x_accrue_on_receipt_flag IN VARCHAR2,
29 p_transaction_flow_header_id IN NUMBER, --<Shared Proc FPJ>
30 x_destination_subinventory IN VARCHAR2,
31 x_wip_entity_id IN NUMBER,
32 x_wip_repetitive_schedule_id IN NUMBER,
33 x_prevent_encumbrance_flag IN VARCHAR2,
34 x_budget_account_id IN NUMBER,
35 x_accrual_account_id IN NUMBER,
36 x_variance_account_id IN NUMBER,
37 -- Bug 2137906 fixed. added ussgl_transaction_code.
38 x_ussgl_transaction_code IN VARCHAR2,
39 x_gl_date IN DATE,
40 x_chart_of_accounts_id IN NUMBER,
41 x_project_account_context IN VARCHAR2,
42 x_project_id IN NUMBER,
43 x_task_id IN NUMBER,
44 x_expenditure_type IN VARCHAR2,
45 x_expenditure_organization_id IN NUMBER,
46 p_order_type_lookup_code IN VARCHAR2, --<SERVICES FPJ>
47 p_amount IN NUMBER, --<SERVICES FPJ>
48 -- <PO_PJM_VALIDATION FPI START>
49 x_need_by_date IN DATE,
50 x_promised_date IN DATE,
51 x_expenditure_item_date IN DATE, -- Bug 2892199
52 -- <PO_PJM_VALIDATION FPI END>
53 p_ship_to_ou_id IN NUMBER --< Bug 3265539 >
54 );
55
56 /*================================================================
57
58 FUNCTION NAME: validate_destination_type_code()
59
60 ==================================================================*/
61
62 FUNCTION validate_destination_type_code(
63 x_destination_type_code IN varchar2,
64 x_item_status in varchar2,
65 x_accrue_on_receipt_flag IN varchar2,
66 p_transaction_flow_header_id IN NUMBER --<Shared Proc FPJ>
67 ) RETURN VARCHAR2;
68
69 /*================================================================
70
71 FUNCTION NAME: validate_deliver_to_person_id()
72
73 ==================================================================*/
74
75 FUNCTION validate_deliver_to_person_id(
76 x_deliver_to_person_id IN NUMBER
77 ) RETURN VARCHAR2;
78
79 /*================================================================
80
81 FUNCTION NAME: validate_deliver_to_loc_id()
82
83 ==================================================================*/
84
85 FUNCTION validate_deliver_to_loc_id(
86 x_deliver_to_location_id IN varchar2,
87 x_ship_to_organization_id IN NUMBER
88 ) RETURN VARCHAR2;
89
90 /*================================================================
91
92 FUNCTION NAME: validate_dest_subinventory()
93
94 ==================================================================*/
95
96 FUNCTION validate_dest_subinventory(
97 x_destination_subinventory IN varchar2,
98 x_ship_to_organization_id IN NUMBER,
99 x_item_id IN NUMBER
100 ) RETURN VARCHAR2;
101
102 /*================================================================
103
104 FUNCTION NAME: validate_org()
105
106 ==================================================================*/
107
108 FUNCTION validate_org(x_org_id in NUMBER, x_sob_id in NUMBER)
109 RETURN VARCHAR2;
110
111 /*================================================================
112
113 FUNCTION NAME: validate_wip()
114
115 ==================================================================*/
116
117 FUNCTION validate_wip(x_wip_entity_id in NUMBER, x_destination_organization_id in NUMBER, x_wip_repetitive_schedule_id in NUMBER) RETURN VARCHAR2;
118
119 /*================================================================
120
121 FUNCTION NAME: validate_account()
122
123 ==================================================================*/
124
125 FUNCTION validate_account(x_account_id in NUMBER, x_gl_date in date, x_chart_of_accounts_id in NUMBER) RETURN VARCHAR2;
126
127 /*================================================================
128
129 PROCEDURE NAME: validate_project_info()
130
131 ==================================================================*/
132
133 PROCEDURE validate_project_info
134 (
135 x_destination_type_code IN VARCHAR2,
136 x_project_id IN NUMBER,
137 x_task_id IN NUMBER,
138 x_expenditure_type IN VARCHAR2,
139 x_expenditure_organization_id IN NUMBER ,
140 -- <PO_PJM_VALIDATION FPI START>
141 x_ship_to_organization_id IN NUMBER,
142 x_need_by_date IN DATE,
143 x_promised_date IN DATE,
144 x_expenditure_item_date IN DATE, -- Bug 2892199
145 -- <PO_PJM_VALIDATION FPI END>
146 p_ship_to_ou_id IN NUMBER, --< Bug 3265539 >
147 p_deliver_to_person_id IN NUMBER, --<Bug 3793395>
148 x_valid OUT NOCOPY VARCHAR2, --<Bug 14662559>
149 x_msg_name OUT NOCOPY VARCHAR2 --<Bug 14662559>
150 ) ;
151
152 END PO_PDOI_DISTRIBUTIONS_SV3;