96: p_agreement_id IN NUMBER,
97: P_Bill_to_site_use_id IN NUMBER ,
98: P_Ship_to_site_use_id IN NUMBER ,
99: P_Sets_of_books_id IN NUMBER ,
100: P_Expenditure_item_id IN PA_PLSQL_DATATYPES.IdTabTyp,
101: P_Line_num IN PA_PLSQL_DATATYPES.IdTabTyp,
102: P_User_Id IN NUMBER ,
103: P_Request_id IN NUMBER ,
104: P_No_of_rec IN NUMBER ,
97: P_Bill_to_site_use_id IN NUMBER ,
98: P_Ship_to_site_use_id IN NUMBER ,
99: P_Sets_of_books_id IN NUMBER ,
100: P_Expenditure_item_id IN PA_PLSQL_DATATYPES.IdTabTyp,
101: P_Line_num IN PA_PLSQL_DATATYPES.IdTabTyp,
102: P_User_Id IN NUMBER ,
103: P_Request_id IN NUMBER ,
104: P_No_of_rec IN NUMBER ,
105: X_Rec_upd OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
102: P_User_Id IN NUMBER ,
103: P_Request_id IN NUMBER ,
104: P_No_of_rec IN NUMBER ,
105: X_Rec_upd OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
106: P_bill_trans_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
107: P_bill_trans_invoice_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
108: P_bill_trans_bill_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
109: P_invproc_invoice_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
110: P_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
103: P_Request_id IN NUMBER ,
104: P_No_of_rec IN NUMBER ,
105: X_Rec_upd OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
106: P_bill_trans_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
107: P_bill_trans_invoice_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
108: P_bill_trans_bill_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
109: P_invproc_invoice_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
110: P_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
111: p_retention_percentage IN VARCHAR2,
104: P_No_of_rec IN NUMBER ,
105: X_Rec_upd OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
106: P_bill_trans_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
107: P_bill_trans_invoice_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
108: P_bill_trans_bill_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
109: P_invproc_invoice_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
110: P_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
111: p_retention_percentage IN VARCHAR2,
112: P_status_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
105: X_Rec_upd OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
106: P_bill_trans_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
107: P_bill_trans_invoice_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
108: P_bill_trans_bill_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
109: P_invproc_invoice_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
110: P_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
111: p_retention_percentage IN VARCHAR2,
112: P_status_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
113: p_invoice_date IN VARCHAR2,
106: P_bill_trans_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
107: P_bill_trans_invoice_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
108: P_bill_trans_bill_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
109: P_invproc_invoice_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
110: P_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
111: p_retention_percentage IN VARCHAR2,
112: P_status_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
113: p_invoice_date IN VARCHAR2,
114: x_return_status IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
108: P_bill_trans_bill_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
109: P_invproc_invoice_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
110: P_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
111: p_retention_percentage IN VARCHAR2,
112: P_status_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
113: p_invoice_date IN VARCHAR2,
114: x_return_status IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
115: );
116:
121: p_agreement_id IN NUMBER,
122: P_Bill_to_site_use_id IN NUMBER ,
123: P_Ship_to_site_use_id IN NUMBER ,
124: P_Sets_of_books_id IN NUMBER ,
125: P_Expenditure_item_id IN PA_PLSQL_DATATYPES.IdTabTyp,
126: P_Line_num IN PA_PLSQL_DATATYPES.IdTabTyp,
127: P_User_Id IN NUMBER ,
128: P_Request_id IN NUMBER ,
129: P_No_of_rec IN NUMBER ,
122: P_Bill_to_site_use_id IN NUMBER ,
123: P_Ship_to_site_use_id IN NUMBER ,
124: P_Sets_of_books_id IN NUMBER ,
125: P_Expenditure_item_id IN PA_PLSQL_DATATYPES.IdTabTyp,
126: P_Line_num IN PA_PLSQL_DATATYPES.IdTabTyp,
127: P_User_Id IN NUMBER ,
128: P_Request_id IN NUMBER ,
129: P_No_of_rec IN NUMBER ,
130: X_Rec_upd OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
127: P_User_Id IN NUMBER ,
128: P_Request_id IN NUMBER ,
129: P_No_of_rec IN NUMBER ,
130: X_Rec_upd OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
131: P_bill_trans_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
132: P_bill_trans_invoice_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
133: P_bill_trans_bill_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
134: P_invproc_invoice_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
135: P_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
128: P_Request_id IN NUMBER ,
129: P_No_of_rec IN NUMBER ,
130: X_Rec_upd OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
131: P_bill_trans_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
132: P_bill_trans_invoice_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
133: P_bill_trans_bill_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
134: P_invproc_invoice_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
135: P_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
136: p_retention_percentage IN VARCHAR2,
129: P_No_of_rec IN NUMBER ,
130: X_Rec_upd OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
131: P_bill_trans_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
132: P_bill_trans_invoice_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
133: P_bill_trans_bill_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
134: P_invproc_invoice_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
135: P_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
136: p_retention_percentage IN VARCHAR2,
137: P_status_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
130: X_Rec_upd OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
131: P_bill_trans_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
132: P_bill_trans_invoice_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
133: P_bill_trans_bill_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
134: P_invproc_invoice_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
135: P_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
136: p_retention_percentage IN VARCHAR2,
137: P_status_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
138: p_invoice_date IN VARCHAR2,
131: P_bill_trans_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
132: P_bill_trans_invoice_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
133: P_bill_trans_bill_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
134: P_invproc_invoice_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
135: P_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
136: p_retention_percentage IN VARCHAR2,
137: P_status_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
138: p_invoice_date IN VARCHAR2,
139: Pbill_to_customer_id IN NUMBER,
133: P_bill_trans_bill_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
134: P_invproc_invoice_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
135: P_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
136: p_retention_percentage IN VARCHAR2,
137: P_status_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
138: p_invoice_date IN VARCHAR2,
139: Pbill_to_customer_id IN NUMBER,
140: Pship_to_customer_id IN NUMBER,
141: P_shared_funds_consumption IN NUMBER, /* Federal */
138: p_invoice_date IN VARCHAR2,
139: Pbill_to_customer_id IN NUMBER,
140: Pship_to_customer_id IN NUMBER,
141: P_shared_funds_consumption IN NUMBER, /* Federal */
142: P_expenditure_item_date IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Federal */
143: x_return_status IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
144: );
145:
146: -- Function : IS_AR_INSTALLED
194: P_Customer_Id IN number ,
195: P_Bill_to_site_use_id IN number ,
196: P_Ship_to_site_use_id IN number ,
197: P_Set_of_books_id IN number ,
198: P_Expenditure_item_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
199: P_User_Id IN NUMBER ,
200: P_Request_id IN NUMBER ,
201: P_No_of_records IN NUMBER ,
202: P_Compute_flag IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
198: P_Expenditure_item_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
199: P_User_Id IN NUMBER ,
200: P_Request_id IN NUMBER ,
201: P_No_of_records IN NUMBER ,
202: P_Compute_flag IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
203: P_Error_Code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
204: X_Output_tax_code OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
205: X_Output_tax_exempt_flag OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
206: X_Output_tax_exempt_number OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
199: P_User_Id IN NUMBER ,
200: P_Request_id IN NUMBER ,
201: P_No_of_records IN NUMBER ,
202: P_Compute_flag IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
203: P_Error_Code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
204: X_Output_tax_code OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
205: X_Output_tax_exempt_flag OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
206: X_Output_tax_exempt_number OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
207: X_Output_exempt_reason_code OUT NOCOPY PA_PLSQL_DATATYPES.Char80TabTyp,
200: P_Request_id IN NUMBER ,
201: P_No_of_records IN NUMBER ,
202: P_Compute_flag IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
203: P_Error_Code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
204: X_Output_tax_code OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
205: X_Output_tax_exempt_flag OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
206: X_Output_tax_exempt_number OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
207: X_Output_exempt_reason_code OUT NOCOPY PA_PLSQL_DATATYPES.Char80TabTyp,
208: Pbill_to_customer_id IN NUMBER DEFAULT NULL,
201: P_No_of_records IN NUMBER ,
202: P_Compute_flag IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
203: P_Error_Code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
204: X_Output_tax_code OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
205: X_Output_tax_exempt_flag OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
206: X_Output_tax_exempt_number OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
207: X_Output_exempt_reason_code OUT NOCOPY PA_PLSQL_DATATYPES.Char80TabTyp,
208: Pbill_to_customer_id IN NUMBER DEFAULT NULL,
209: Pship_to_customer_id IN NUMBER DEFAULT NULL);
202: P_Compute_flag IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
203: P_Error_Code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
204: X_Output_tax_code OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
205: X_Output_tax_exempt_flag OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
206: X_Output_tax_exempt_number OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
207: X_Output_exempt_reason_code OUT NOCOPY PA_PLSQL_DATATYPES.Char80TabTyp,
208: Pbill_to_customer_id IN NUMBER DEFAULT NULL,
209: Pship_to_customer_id IN NUMBER DEFAULT NULL);
210:
203: P_Error_Code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
204: X_Output_tax_code OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
205: X_Output_tax_exempt_flag OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
206: X_Output_tax_exempt_number OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
207: X_Output_exempt_reason_code OUT NOCOPY PA_PLSQL_DATATYPES.Char80TabTyp,
208: Pbill_to_customer_id IN NUMBER DEFAULT NULL,
209: Pship_to_customer_id IN NUMBER DEFAULT NULL);
210:
211: FUNCTION TAXID_2_CODE_CONV (p_org_id in number,