DBA Data[Home] [Help]

APPS.PA_OUTPUT_TAX dependencies on PA_PLSQL_DATATYPES

Line 96: P_Expenditure_item_id IN PA_PLSQL_DATATYPES.IdTabTyp,

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 ,

Line 97: P_Line_num IN PA_PLSQL_DATATYPES.IdTabTyp,

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

Line 102: P_bill_trans_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,

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,

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

Line 104: P_bill_trans_bill_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,

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,

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

Line 106: P_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

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

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

Line 121: P_Expenditure_item_id IN PA_PLSQL_DATATYPES.IdTabTyp,

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 ,

Line 122: P_Line_num IN PA_PLSQL_DATATYPES.IdTabTyp,

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

Line 127: P_bill_trans_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,

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,

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

Line 129: P_bill_trans_bill_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,

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,

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

Line 131: P_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

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,

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

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

Line 194: P_Expenditure_item_id IN PA_PLSQL_DATATYPES.IdTabTyp ,

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,

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

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

Line 200: X_Output_tax_code OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

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,

Line 201: X_Output_tax_exempt_flag OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,

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

Line 202: X_Output_tax_exempt_number OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

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:

Line 203: X_Output_exempt_reason_code OUT NOCOPY PA_PLSQL_DATATYPES.Char80TabTyp,

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,