DBA Data[Home] [Help]

APPS.PA_OUTPUT_TAX dependencies on PA_PLSQL_DATATYPES

Line 100: P_Expenditure_item_id IN PA_PLSQL_DATATYPES.IdTabTyp,

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 ,

Line 101: P_Line_num IN PA_PLSQL_DATATYPES.IdTabTyp,

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

Line 106: P_bill_trans_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,

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,

Line 107: P_bill_trans_invoice_amount IN 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,

Line 108: P_bill_trans_bill_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,

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,

Line 109: P_invproc_invoice_amount 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,

Line 110: P_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

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

Line 112: P_status_code IN OUT NOCOPY 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
115: );
116:

Line 125: P_Expenditure_item_id IN PA_PLSQL_DATATYPES.IdTabTyp,

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 ,

Line 126: P_Line_num IN PA_PLSQL_DATATYPES.IdTabTyp,

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

Line 131: P_bill_trans_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,

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,

Line 132: P_bill_trans_invoice_amount IN 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,

Line 133: P_bill_trans_bill_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,

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,

Line 134: P_invproc_invoice_amount 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,

Line 135: P_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

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,

Line 137: P_status_code IN OUT NOCOPY 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,
140: Pship_to_customer_id IN NUMBER,
141: P_shared_funds_consumption IN NUMBER, /* Federal */

Line 142: P_expenditure_item_date IN PA_PLSQL_DATATYPES.Char30TabTyp, /* 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

Line 198: P_Expenditure_item_id IN PA_PLSQL_DATATYPES.IdTabTyp ,

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,

Line 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,

Line 203: P_Error_Code IN 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,

Line 204: X_Output_tax_code OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

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,

Line 205: X_Output_tax_exempt_flag OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,

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);

Line 206: X_Output_tax_exempt_number OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

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:

Line 207: X_Output_exempt_reason_code OUT NOCOPY PA_PLSQL_DATATYPES.Char80TabTyp,

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,