[Home] [Help]
PACKAGE: APPS.PO_ACCOUNT_HELPER
Source
1 PACKAGE PO_ACCOUNT_HELPER AS
2 -- $Header: PO_ACCOUNT_HELPER.pls 120.1 2005/08/31 16:56 jmellen noship $
3
4 -- initial revision uses FPJ/complex work signature
5 FUNCTION build_accounts(
6 x_purchasing_ou_id IN NUMBER -- POU's org ID
7 , x_transaction_flow_header_id IN NUMBER
8 , x_dest_charge_success IN OUT NOCOPY BOOLEAN
9 , x_dest_variance_success IN OUT NOCOPY BOOLEAN
10 , x_dest_charge_account_id IN OUT NOCOPY NUMBER
11 , x_dest_variance_account_id IN OUT NOCOPY NUMBER
12 , x_dest_charge_account_desc IN OUT NOCOPY VARCHAR2
13 , x_dest_variance_account_desc IN OUT NOCOPY VARCHAR2
14 , x_dest_charge_account_flex IN OUT NOCOPY VARCHAR2
15 , x_dest_variance_account_flex IN OUT NOCOPY VARCHAR2
16
17 , x_charge_success IN OUT NOCOPY BOOLEAN
18 , x_budget_success IN OUT NOCOPY BOOLEAN
19 , x_accrual_success IN OUT NOCOPY BOOLEAN
20 , x_variance_success IN OUT NOCOPY BOOLEAN
21 , x_code_combination_id IN OUT NOCOPY NUMBER
22 , x_budget_account_id IN OUT NOCOPY NUMBER
23 , x_accrual_account_id IN OUT NOCOPY NUMBER
24 , x_variance_account_id IN OUT NOCOPY NUMBER
25 , x_charge_account_flex IN OUT NOCOPY VARCHAR2
26 , x_budget_account_flex IN OUT NOCOPY VARCHAR2
27 , x_accrual_account_flex IN OUT NOCOPY VARCHAR2
28 , x_variance_account_flex IN OUT NOCOPY VARCHAR2
29 , x_charge_account_desc IN OUT NOCOPY VARCHAR2
30 , x_budget_account_desc IN OUT NOCOPY VARCHAR2
31 , x_accrual_account_desc IN OUT NOCOPY VARCHAR2
32 , x_variance_account_desc IN OUT NOCOPY VARCHAR2
33 , x_coa_id NUMBER
34 , x_bom_resource_id NUMBER
35 , x_bom_cost_element_id NUMBER
36 , x_category_id NUMBER
37 , x_destination_type_code VARCHAR2
38 , x_deliver_to_location_id NUMBER
39 , x_destination_organization_id NUMBER
40 , x_destination_subinventory VARCHAR2
41 , x_expenditure_type VARCHAR2
42 , x_expenditure_organization_id NUMBER
43 , x_expenditure_item_date DATE
44 , x_item_id NUMBER
45 , x_line_type_id NUMBER
46 , x_result_billable_flag VARCHAR2
47 , x_agent_id NUMBER
48 , x_project_id NUMBER
49 , x_from_type_lookup_code VARCHAR2
50 , x_from_header_id NUMBER
51 , x_from_line_id NUMBER
52 , x_task_id NUMBER
53 , x_deliver_to_person_id NUMBER
54 , x_type_lookup_code VARCHAR2
55 , x_vendor_id NUMBER
56 , x_wip_entity_id NUMBER
57 , x_wip_entity_type VARCHAR2
58 , x_wip_line_id NUMBER
59 , x_wip_repetitive_schedule_id NUMBER
60 , x_wip_operation_seq_num NUMBER
61 , x_wip_resource_seq_num NUMBER
62 , x_po_encumberance_flag VARCHAR2
63 , x_gl_encumbered_date DATE
64
65 , wf_itemkey IN OUT NOCOPY VARCHAR2
66 , x_new_combination IN OUT NOCOPY BOOLEAN
67
68 , header_att1 VARCHAR2
69 , header_att2 VARCHAR2
70 , header_att3 VARCHAR2
71 , header_att4 VARCHAR2
72 , header_att5 VARCHAR2
73 , header_att6 VARCHAR2
74 , header_att7 VARCHAR2
75 , header_att8 VARCHAR2
76 , header_att9 VARCHAR2
77 , header_att10 VARCHAR2
78 , header_att11 VARCHAR2
79 , header_att12 VARCHAR2
80 , header_att13 VARCHAR2
81 , header_att14 VARCHAR2
82 , header_att15 VARCHAR2
83
84 , line_att1 VARCHAR2
85 , line_att2 VARCHAR2
86 , line_att3 VARCHAR2
87 , line_att4 VARCHAR2
88 , line_att5 VARCHAR2
89 , line_att6 VARCHAR2
90 , line_att7 VARCHAR2
91 , line_att8 VARCHAR2
92 , line_att9 VARCHAR2
93 , line_att10 VARCHAR2
94 , line_att11 VARCHAR2
95 , line_att12 VARCHAR2
96 , line_att13 VARCHAR2
97 , line_att14 VARCHAR2
98 , line_att15 VARCHAR2
99
100 , shipment_att1 VARCHAR2
101 , shipment_att2 VARCHAR2
102 , shipment_att3 VARCHAR2
103 , shipment_att4 VARCHAR2
104 , shipment_att5 VARCHAR2
105 , shipment_att6 VARCHAR2
106 , shipment_att7 VARCHAR2
107 , shipment_att8 VARCHAR2
108 , shipment_att9 VARCHAR2
109 , shipment_att10 VARCHAR2
110 , shipment_att11 VARCHAR2
111 , shipment_att12 VARCHAR2
112 , shipment_att13 VARCHAR2
113 , shipment_att14 VARCHAR2
114 , shipment_att15 VARCHAR2
115
116 , distribution_att1 VARCHAR2
117 , distribution_att2 VARCHAR2
118 , distribution_att3 VARCHAR2
119 , distribution_att4 VARCHAR2
120 , distribution_att5 VARCHAR2
121 , distribution_att6 VARCHAR2
122 , distribution_att7 VARCHAR2
123 , distribution_att8 VARCHAR2
124 , distribution_att9 VARCHAR2
125 , distribution_att10 VARCHAR2
126 , distribution_att11 VARCHAR2
127 , distribution_att12 VARCHAR2
128 , distribution_att13 VARCHAR2
129 , distribution_att14 VARCHAR2
130 , distribution_att15 VARCHAR2
131
132 , FB_ERROR_MSG IN OUT NOCOPY VARCHAR2
133 , p_distribution_type IN VARCHAR2 DEFAULT NULL
134 , p_payment_type IN VARCHAR2 DEFAULT NULL
135 , x_award_id NUMBER DEFAULT NULL
136 , x_vendor_site_id NUMBER DEFAULT NULL
137 , p_func_unit_price IN NUMBER DEFAULT NULL
138 , p_distribution_id IN NUMBER --<HTML Orders/Agreements R12>
139 , p_award_number IN VARCHAR2 --<HTML Orders/Agreements R12>
140 ) RETURN BOOLEAN;
141
142 END PO_ACCOUNT_HELPER;