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