APPS.PA_TRX_IMPORT dependencies on PA_PLSQL_DATATYPES

Line 243: g_xface_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

239: G_Cbs_Element_Id NUMBER DEFAULT NULL; -- Added for CBS Enhancement Bug 16220146
240: -- R12 funds management uptake : Below global variables stores adjusting expenditures data
241: -- which will be accessed by fundscheck autonomous API's
242:
243: g_xface_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
244: g_xface_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
245: g_xface_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
246: g_xface_ei_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
247: g_xface_exp_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 244: g_xface_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

240: -- R12 funds management uptake : Below global variables stores adjusting expenditures data
241: -- which will be accessed by fundscheck autonomous API's
242:
243: g_xface_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
244: g_xface_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
245: g_xface_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
246: g_xface_ei_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
247: g_xface_exp_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
248: g_xface_bud_ver_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 245: g_xface_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

241: -- which will be accessed by fundscheck autonomous API's
242:
243: g_xface_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
244: g_xface_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
245: g_xface_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
246: g_xface_ei_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
247: g_xface_exp_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
248: g_xface_bud_ver_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
249: g_xface_Entered_Cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;

Line 246: g_xface_ei_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;

242:
243: g_xface_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
244: g_xface_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
245: g_xface_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
246: g_xface_ei_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
247: g_xface_exp_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
248: g_xface_bud_ver_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
249: g_xface_Entered_Cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
250: g_xface_Entered_Dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;

Line 247: g_xface_exp_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

243: g_xface_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
244: g_xface_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
245: g_xface_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
246: g_xface_ei_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
247: g_xface_exp_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
248: g_xface_bud_ver_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
249: g_xface_Entered_Cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
250: g_xface_Entered_Dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
251: g_xface_acct_Cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;

Line 248: g_xface_bud_ver_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

244: g_xface_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
245: g_xface_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
246: g_xface_ei_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
247: g_xface_exp_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
248: g_xface_bud_ver_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
249: g_xface_Entered_Cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
250: g_xface_Entered_Dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
251: g_xface_acct_Cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
252: g_xface_acct_Dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;

Line 249: g_xface_Entered_Cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;

245: g_xface_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
246: g_xface_ei_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
247: g_xface_exp_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
248: g_xface_bud_ver_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
249: g_xface_Entered_Cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
250: g_xface_Entered_Dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
251: g_xface_acct_Cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
252: g_xface_acct_Dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
253: g_xface_Txn_Ccid_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 250: g_xface_Entered_Dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;

246: g_xface_ei_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
247: g_xface_exp_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
248: g_xface_bud_ver_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
249: g_xface_Entered_Cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
250: g_xface_Entered_Dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
251: g_xface_acct_Cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
252: g_xface_acct_Dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
253: g_xface_Txn_Ccid_tbl PA_PLSQL_DATATYPES.IdTabTyp;
254: g_xface_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 251: g_xface_acct_Cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;

247: g_xface_exp_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
248: g_xface_bud_ver_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
249: g_xface_Entered_Cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
250: g_xface_Entered_Dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
251: g_xface_acct_Cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
252: g_xface_acct_Dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
253: g_xface_Txn_Ccid_tbl PA_PLSQL_DATATYPES.IdTabTyp;
254: g_xface_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
255: g_xface_Txn_interface_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 252: g_xface_acct_Dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;

248: g_xface_bud_ver_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
249: g_xface_Entered_Cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
250: g_xface_Entered_Dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
251: g_xface_acct_Cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
252: g_xface_acct_Dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
253: g_xface_Txn_Ccid_tbl PA_PLSQL_DATATYPES.IdTabTyp;
254: g_xface_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
255: g_xface_Txn_interface_tbl PA_PLSQL_DATATYPES.IdTabTyp;
256: g_xface_vendor_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 253: g_xface_Txn_Ccid_tbl PA_PLSQL_DATATYPES.IdTabTyp;

249: g_xface_Entered_Cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
250: g_xface_Entered_Dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
251: g_xface_acct_Cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
252: g_xface_acct_Dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
253: g_xface_Txn_Ccid_tbl PA_PLSQL_DATATYPES.IdTabTyp;
254: g_xface_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
255: g_xface_Txn_interface_tbl PA_PLSQL_DATATYPES.IdTabTyp;
256: g_xface_vendor_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
257: g_vendor_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 254: g_xface_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

250: g_xface_Entered_Dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
251: g_xface_acct_Cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
252: g_xface_acct_Dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
253: g_xface_Txn_Ccid_tbl PA_PLSQL_DATATYPES.IdTabTyp;
254: g_xface_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
255: g_xface_Txn_interface_tbl PA_PLSQL_DATATYPES.IdTabTyp;
256: g_xface_vendor_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
257: g_vendor_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
258:

Line 255: g_xface_Txn_interface_tbl PA_PLSQL_DATATYPES.IdTabTyp;

251: g_xface_acct_Cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
252: g_xface_acct_Dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
253: g_xface_Txn_Ccid_tbl PA_PLSQL_DATATYPES.IdTabTyp;
254: g_xface_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
255: g_xface_Txn_interface_tbl PA_PLSQL_DATATYPES.IdTabTyp;
256: g_xface_vendor_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
257: g_vendor_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
258:
259: g_sob_Id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 256: g_xface_vendor_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

252: g_xface_acct_Dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
253: g_xface_Txn_Ccid_tbl PA_PLSQL_DATATYPES.IdTabTyp;
254: g_xface_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
255: g_xface_Txn_interface_tbl PA_PLSQL_DATATYPES.IdTabTyp;
256: g_xface_vendor_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
257: g_vendor_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
258:
259: g_sob_Id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
260: g_Period_Year_tbl PA_PLSQL_DATATYPES.NumTabTyp;

Line 257: g_vendor_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

253: g_xface_Txn_Ccid_tbl PA_PLSQL_DATATYPES.IdTabTyp;
254: g_xface_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
255: g_xface_Txn_interface_tbl PA_PLSQL_DATATYPES.IdTabTyp;
256: g_xface_vendor_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
257: g_vendor_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
258:
259: g_sob_Id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
260: g_Period_Year_tbl PA_PLSQL_DATATYPES.NumTabTyp;
261: g_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 259: g_sob_Id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

255: g_xface_Txn_interface_tbl PA_PLSQL_DATATYPES.IdTabTyp;
256: g_xface_vendor_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
257: g_vendor_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
258:
259: g_sob_Id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
260: g_Period_Year_tbl PA_PLSQL_DATATYPES.NumTabTyp;
261: g_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
262: g_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
263: g_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

Line 260: g_Period_Year_tbl PA_PLSQL_DATATYPES.NumTabTyp;

256: g_xface_vendor_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
257: g_vendor_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
258:
259: g_sob_Id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
260: g_Period_Year_tbl PA_PLSQL_DATATYPES.NumTabTyp;
261: g_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
262: g_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
263: g_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
264: g_ei_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;

Line 261: g_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

257: g_vendor_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
258:
259: g_sob_Id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
260: g_Period_Year_tbl PA_PLSQL_DATATYPES.NumTabTyp;
261: g_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
262: g_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
263: g_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
264: g_ei_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
265: g_exp_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 262: g_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

258:
259: g_sob_Id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
260: g_Period_Year_tbl PA_PLSQL_DATATYPES.NumTabTyp;
261: g_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
262: g_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
263: g_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
264: g_ei_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
265: g_exp_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
266: g_bud_ver_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 263: g_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

259: g_sob_Id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
260: g_Period_Year_tbl PA_PLSQL_DATATYPES.NumTabTyp;
261: g_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
262: g_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
263: g_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
264: g_ei_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
265: g_exp_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
266: g_bud_ver_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
267: g_budget_line_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- R12 Funds Management uptake

Line 264: g_ei_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;

260: g_Period_Year_tbl PA_PLSQL_DATATYPES.NumTabTyp;
261: g_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
262: g_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
263: g_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
264: g_ei_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
265: g_exp_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
266: g_bud_ver_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
267: g_budget_line_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- R12 Funds Management uptake
268: g_Document_Type_tbl PA_PLSQL_DATATYPES.Char10TabTyp;

Line 265: g_exp_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

261: g_project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
262: g_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
263: g_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
264: g_ei_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
265: g_exp_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
266: g_bud_ver_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
267: g_budget_line_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- R12 Funds Management uptake
268: g_Document_Type_tbl PA_PLSQL_DATATYPES.Char10TabTyp;
269: g_Doc_Header_Id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 266: g_bud_ver_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

262: g_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
263: g_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
264: g_ei_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
265: g_exp_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
266: g_bud_ver_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
267: g_budget_line_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- R12 Funds Management uptake
268: g_Document_Type_tbl PA_PLSQL_DATATYPES.Char10TabTyp;
269: g_Doc_Header_Id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
270: g_Doc_dist_Id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 267: g_budget_line_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- R12 Funds Management uptake

263: g_exp_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
264: g_ei_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
265: g_exp_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
266: g_bud_ver_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
267: g_budget_line_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- R12 Funds Management uptake
268: g_Document_Type_tbl PA_PLSQL_DATATYPES.Char10TabTyp;
269: g_Doc_Header_Id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
270: g_Doc_dist_Id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
271: g_Entered_Cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;

Line 268: g_Document_Type_tbl PA_PLSQL_DATATYPES.Char10TabTyp;

264: g_ei_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
265: g_exp_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
266: g_bud_ver_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
267: g_budget_line_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- R12 Funds Management uptake
268: g_Document_Type_tbl PA_PLSQL_DATATYPES.Char10TabTyp;
269: g_Doc_Header_Id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
270: g_Doc_dist_Id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
271: g_Entered_Cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
272: g_Entered_Dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;

Line 269: g_Doc_Header_Id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

265: g_exp_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
266: g_bud_ver_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
267: g_budget_line_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- R12 Funds Management uptake
268: g_Document_Type_tbl PA_PLSQL_DATATYPES.Char10TabTyp;
269: g_Doc_Header_Id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
270: g_Doc_dist_Id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
271: g_Entered_Cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
272: g_Entered_Dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
273: g_acct_Cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;

Line 270: g_Doc_dist_Id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

266: g_bud_ver_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
267: g_budget_line_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- R12 Funds Management uptake
268: g_Document_Type_tbl PA_PLSQL_DATATYPES.Char10TabTyp;
269: g_Doc_Header_Id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
270: g_Doc_dist_Id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
271: g_Entered_Cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
272: g_Entered_Dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
273: g_acct_Cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
274: g_acct_Dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;

Line 271: g_Entered_Cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;

267: g_budget_line_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- R12 Funds Management uptake
268: g_Document_Type_tbl PA_PLSQL_DATATYPES.Char10TabTyp;
269: g_Doc_Header_Id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
270: g_Doc_dist_Id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
271: g_Entered_Cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
272: g_Entered_Dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
273: g_acct_Cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
274: g_acct_Dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
275: g_Actual_Flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;

Line 272: g_Entered_Dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;

268: g_Document_Type_tbl PA_PLSQL_DATATYPES.Char10TabTyp;
269: g_Doc_Header_Id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
270: g_Doc_dist_Id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
271: g_Entered_Cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
272: g_Entered_Dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
273: g_acct_Cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
274: g_acct_Dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
275: g_Actual_Flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
276: g_Txn_Ccid_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 273: g_acct_Cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;

269: g_Doc_Header_Id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
270: g_Doc_dist_Id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
271: g_Entered_Cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
272: g_Entered_Dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
273: g_acct_Cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
274: g_acct_Dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
275: g_Actual_Flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
276: g_Txn_Ccid_tbl PA_PLSQL_DATATYPES.IdTabTyp;
277: g_Je_Catg_Name_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

Line 274: g_acct_Dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;

270: g_Doc_dist_Id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
271: g_Entered_Cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
272: g_Entered_Dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
273: g_acct_Cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
274: g_acct_Dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
275: g_Actual_Flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
276: g_Txn_Ccid_tbl PA_PLSQL_DATATYPES.IdTabTyp;
277: g_Je_Catg_Name_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
278: g_Je_sorce_Name_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

Line 275: g_Actual_Flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;

271: g_Entered_Cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
272: g_Entered_Dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
273: g_acct_Cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
274: g_acct_Dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
275: g_Actual_Flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
276: g_Txn_Ccid_tbl PA_PLSQL_DATATYPES.IdTabTyp;
277: g_Je_Catg_Name_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
278: g_Je_sorce_Name_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
279: g_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 276: g_Txn_Ccid_tbl PA_PLSQL_DATATYPES.IdTabTyp;

272: g_Entered_Dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
273: g_acct_Cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
274: g_acct_Dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
275: g_Actual_Flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
276: g_Txn_Ccid_tbl PA_PLSQL_DATATYPES.IdTabTyp;
277: g_Je_Catg_Name_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
278: g_Je_sorce_Name_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
279: g_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
280: g_Pa_Date_tbl PA_PLSQL_DATATYPES.DateTabTyp;

Line 277: g_Je_Catg_Name_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

273: g_acct_Cr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
274: g_acct_Dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
275: g_Actual_Flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
276: g_Txn_Ccid_tbl PA_PLSQL_DATATYPES.IdTabTyp;
277: g_Je_Catg_Name_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
278: g_Je_sorce_Name_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
279: g_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
280: g_Pa_Date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
281: g_packet_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 278: g_Je_sorce_Name_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

274: g_acct_Dr_tbl PA_PLSQL_DATATYPES.NumTabTyp;
275: g_Actual_Flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
276: g_Txn_Ccid_tbl PA_PLSQL_DATATYPES.IdTabTyp;
277: g_Je_Catg_Name_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
278: g_Je_sorce_Name_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
279: g_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
280: g_Pa_Date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
281: g_packet_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
282: g_bc_packet_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 279: g_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

275: g_Actual_Flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
276: g_Txn_Ccid_tbl PA_PLSQL_DATATYPES.IdTabTyp;
277: g_Je_Catg_Name_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
278: g_Je_sorce_Name_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
279: g_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
280: g_Pa_Date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
281: g_packet_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
282: g_bc_packet_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
283: g_bc_parent_pkt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 280: g_Pa_Date_tbl PA_PLSQL_DATATYPES.DateTabTyp;

276: g_Txn_Ccid_tbl PA_PLSQL_DATATYPES.IdTabTyp;
277: g_Je_Catg_Name_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
278: g_Je_sorce_Name_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
279: g_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
280: g_Pa_Date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
281: g_packet_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
282: g_bc_packet_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
283: g_bc_parent_pkt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
284: g_enc_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 281: g_packet_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

277: g_Je_Catg_Name_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
278: g_Je_sorce_Name_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
279: g_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
280: g_Pa_Date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
281: g_packet_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
282: g_bc_packet_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
283: g_bc_parent_pkt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
284: g_enc_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
285: g_doc_hdr_id_2_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 282: g_bc_packet_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

278: g_Je_sorce_Name_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
279: g_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
280: g_Pa_Date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
281: g_packet_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
282: g_bc_packet_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
283: g_bc_parent_pkt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
284: g_enc_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
285: g_doc_hdr_id_2_tbl PA_PLSQL_DATATYPES.IdTabTyp;
286: g_doc_dist_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

Line 283: g_bc_parent_pkt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

279: g_org_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
280: g_Pa_Date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
281: g_packet_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
282: g_bc_packet_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
283: g_bc_parent_pkt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
284: g_enc_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
285: g_doc_hdr_id_2_tbl PA_PLSQL_DATATYPES.IdTabTyp;
286: g_doc_dist_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
287: g_bc_comt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 284: g_enc_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

280: g_Pa_Date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
281: g_packet_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
282: g_bc_packet_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
283: g_bc_parent_pkt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
284: g_enc_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
285: g_doc_hdr_id_2_tbl PA_PLSQL_DATATYPES.IdTabTyp;
286: g_doc_dist_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
287: g_bc_comt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
288:

Line 285: g_doc_hdr_id_2_tbl PA_PLSQL_DATATYPES.IdTabTyp;

281: g_packet_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
282: g_bc_packet_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
283: g_bc_parent_pkt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
284: g_enc_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
285: g_doc_hdr_id_2_tbl PA_PLSQL_DATATYPES.IdTabTyp;
286: g_doc_dist_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
287: g_bc_comt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
288:
289:

Line 286: g_doc_dist_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

282: g_bc_packet_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
283: g_bc_parent_pkt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
284: g_enc_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
285: g_doc_hdr_id_2_tbl PA_PLSQL_DATATYPES.IdTabTyp;
286: g_doc_dist_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
287: g_bc_comt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
288:
289:
290:

Line 287: g_bc_comt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

283: g_bc_parent_pkt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
284: g_enc_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
285: g_doc_hdr_id_2_tbl PA_PLSQL_DATATYPES.IdTabTyp;
286: g_doc_dist_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
287: g_bc_comt_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
288:
289:
290:
291:

Line 6011: V_src_txnifIDTab PA_PLSQL_DATATYPES.IdTabTyp;

6007: PROCEDURE set_supplier_cost_eidate( X_transaction_source IN VARCHAR2
6008: , X_batch IN VARCHAR2
6009: , X_xface_id IN NUMBER )
6010: IS
6011: V_src_txnifIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6012: V_dst_txnifIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6013: V_dst_ifIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6014: v_src_EiDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6015: v_dst_EiDateTab PA_PLSQL_DATATYPES.DateTabTyp;

Line 6012: V_dst_txnifIDTab PA_PLSQL_DATATYPES.IdTabTyp;

6008: , X_batch IN VARCHAR2
6009: , X_xface_id IN NUMBER )
6010: IS
6011: V_src_txnifIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6012: V_dst_txnifIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6013: V_dst_ifIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6014: v_src_EiDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6015: v_dst_EiDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6016: v_dst_txnstatcdTab PA_PLSQL_DATATYPES.Char1TabTyp;

Line 6013: V_dst_ifIDTab PA_PLSQL_DATATYPES.IdTabTyp;

6009: , X_xface_id IN NUMBER )
6010: IS
6011: V_src_txnifIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6012: V_dst_txnifIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6013: V_dst_ifIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6014: v_src_EiDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6015: v_dst_EiDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6016: v_dst_txnstatcdTab PA_PLSQL_DATATYPES.Char1TabTyp;
6017: v_doc_headerIDTab PA_PLSQL_DATATYPES.IdTabTyp;

Line 6014: v_src_EiDateTab PA_PLSQL_DATATYPES.DateTabTyp;

6010: IS
6011: V_src_txnifIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6012: V_dst_txnifIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6013: V_dst_ifIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6014: v_src_EiDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6015: v_dst_EiDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6016: v_dst_txnstatcdTab PA_PLSQL_DATATYPES.Char1TabTyp;
6017: v_doc_headerIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6018: v_week_ending_dtTab PA_PLSQL_DATATYPES.DateTabTyp;

Line 6015: v_dst_EiDateTab PA_PLSQL_DATATYPES.DateTabTyp;

6011: V_src_txnifIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6012: V_dst_txnifIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6013: V_dst_ifIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6014: v_src_EiDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6015: v_dst_EiDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6016: v_dst_txnstatcdTab PA_PLSQL_DATATYPES.Char1TabTyp;
6017: v_doc_headerIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6018: v_week_ending_dtTab PA_PLSQL_DATATYPES.DateTabTyp;
6019:

Line 6016: v_dst_txnstatcdTab PA_PLSQL_DATATYPES.Char1TabTyp;

6012: V_dst_txnifIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6013: V_dst_ifIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6014: v_src_EiDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6015: v_dst_EiDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6016: v_dst_txnstatcdTab PA_PLSQL_DATATYPES.Char1TabTyp;
6017: v_doc_headerIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6018: v_week_ending_dtTab PA_PLSQL_DATATYPES.DateTabTyp;
6019:
6020:

Line 6017: v_doc_headerIDTab PA_PLSQL_DATATYPES.IdTabTyp;

6013: V_dst_ifIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6014: v_src_EiDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6015: v_dst_EiDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6016: v_dst_txnstatcdTab PA_PLSQL_DATATYPES.Char1TabTyp;
6017: v_doc_headerIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6018: v_week_ending_dtTab PA_PLSQL_DATATYPES.DateTabTyp;
6019:
6020:
6021: BEGIN

Line 6018: v_week_ending_dtTab PA_PLSQL_DATATYPES.DateTabTyp;

6014: v_src_EiDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6015: v_dst_EiDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6016: v_dst_txnstatcdTab PA_PLSQL_DATATYPES.Char1TabTyp;
6017: v_doc_headerIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6018: v_week_ending_dtTab PA_PLSQL_DATATYPES.DateTabTyp;
6019:
6020:
6021: BEGIN
6022: pa_cc_utils.set_curr_function('Set_supplier_cost_eidate');

Line 6599: l_SysLinkTab PA_PLSQL_DATATYPES.Char30TabTyp;

6595:
6596: --PA-K Changes: Declaration of the tables used for TrxRecs Bulk Fetch
6597: --l_ExpendTab
6598: --l_Expend2Tab
6599: l_SysLinkTab PA_PLSQL_DATATYPES.Char30TabTyp;
6600: l_EmpNumTab PA_PLSQL_DATATYPES.Char30TabTyp;
6601: l_EiEndDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6602: l_OrganizationNameTab PA_PLSQL_DATATYPES.Char240TabTyp;
6603: l_EiDateTab PA_PLSQL_DATATYPES.DateTabTyp;

Line 6600: l_EmpNumTab PA_PLSQL_DATATYPES.Char30TabTyp;

6596: --PA-K Changes: Declaration of the tables used for TrxRecs Bulk Fetch
6597: --l_ExpendTab
6598: --l_Expend2Tab
6599: l_SysLinkTab PA_PLSQL_DATATYPES.Char30TabTyp;
6600: l_EmpNumTab PA_PLSQL_DATATYPES.Char30TabTyp;
6601: l_EiEndDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6602: l_OrganizationNameTab PA_PLSQL_DATATYPES.Char240TabTyp;
6603: l_EiDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6604: l_PrjNumTab PA_PLSQL_DATATYPES.Char25TabTyp;

Line 6601: l_EiEndDateTab PA_PLSQL_DATATYPES.DateTabTyp;

6597: --l_ExpendTab
6598: --l_Expend2Tab
6599: l_SysLinkTab PA_PLSQL_DATATYPES.Char30TabTyp;
6600: l_EmpNumTab PA_PLSQL_DATATYPES.Char30TabTyp;
6601: l_EiEndDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6602: l_OrganizationNameTab PA_PLSQL_DATATYPES.Char240TabTyp;
6603: l_EiDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6604: l_PrjNumTab PA_PLSQL_DATATYPES.Char25TabTyp;
6605: l_TaskNumTab PA_PLSQL_DATATYPES.Char25TabTyp;

Line 6602: l_OrganizationNameTab PA_PLSQL_DATATYPES.Char240TabTyp;

6598: --l_Expend2Tab
6599: l_SysLinkTab PA_PLSQL_DATATYPES.Char30TabTyp;
6600: l_EmpNumTab PA_PLSQL_DATATYPES.Char30TabTyp;
6601: l_EiEndDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6602: l_OrganizationNameTab PA_PLSQL_DATATYPES.Char240TabTyp;
6603: l_EiDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6604: l_PrjNumTab PA_PLSQL_DATATYPES.Char25TabTyp;
6605: l_TaskNumTab PA_PLSQL_DATATYPES.Char25TabTyp;
6606: l_ETypeTab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 6603: l_EiDateTab PA_PLSQL_DATATYPES.DateTabTyp;

6599: l_SysLinkTab PA_PLSQL_DATATYPES.Char30TabTyp;
6600: l_EmpNumTab PA_PLSQL_DATATYPES.Char30TabTyp;
6601: l_EiEndDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6602: l_OrganizationNameTab PA_PLSQL_DATATYPES.Char240TabTyp;
6603: l_EiDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6604: l_PrjNumTab PA_PLSQL_DATATYPES.Char25TabTyp;
6605: l_TaskNumTab PA_PLSQL_DATATYPES.Char25TabTyp;
6606: l_ETypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6607: l_NlrTab PA_PLSQL_DATATYPES.Char20TabTyp;

Line 6604: l_PrjNumTab PA_PLSQL_DATATYPES.Char25TabTyp;

6600: l_EmpNumTab PA_PLSQL_DATATYPES.Char30TabTyp;
6601: l_EiEndDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6602: l_OrganizationNameTab PA_PLSQL_DATATYPES.Char240TabTyp;
6603: l_EiDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6604: l_PrjNumTab PA_PLSQL_DATATYPES.Char25TabTyp;
6605: l_TaskNumTab PA_PLSQL_DATATYPES.Char25TabTyp;
6606: l_ETypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6607: l_NlrTab PA_PLSQL_DATATYPES.Char20TabTyp;
6608: l_NlrOrgNameTab PA_PLSQL_DATATYPES.Char240TabTyp;

Line 6605: l_TaskNumTab PA_PLSQL_DATATYPES.Char25TabTyp;

6601: l_EiEndDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6602: l_OrganizationNameTab PA_PLSQL_DATATYPES.Char240TabTyp;
6603: l_EiDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6604: l_PrjNumTab PA_PLSQL_DATATYPES.Char25TabTyp;
6605: l_TaskNumTab PA_PLSQL_DATATYPES.Char25TabTyp;
6606: l_ETypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6607: l_NlrTab PA_PLSQL_DATATYPES.Char20TabTyp;
6608: l_NlrOrgNameTab PA_PLSQL_DATATYPES.Char240TabTyp;
6609: l_QtyTab PA_PLSQL_DATATYPES.QtyTabtyp;

Line 6606: l_ETypeTab PA_PLSQL_DATATYPES.Char30TabTyp;

6602: l_OrganizationNameTab PA_PLSQL_DATATYPES.Char240TabTyp;
6603: l_EiDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6604: l_PrjNumTab PA_PLSQL_DATATYPES.Char25TabTyp;
6605: l_TaskNumTab PA_PLSQL_DATATYPES.Char25TabTyp;
6606: l_ETypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6607: l_NlrTab PA_PLSQL_DATATYPES.Char20TabTyp;
6608: l_NlrOrgNameTab PA_PLSQL_DATATYPES.Char240TabTyp;
6609: l_QtyTab PA_PLSQL_DATATYPES.QtyTabtyp;
6610: l_rawCostTab PA_PLSQL_DATATYPES.NumTabTyp; -- Bug 5959023: Changed to NumTabTyp from QtyTabtyp

Line 6607: l_NlrTab PA_PLSQL_DATATYPES.Char20TabTyp;

6603: l_EiDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6604: l_PrjNumTab PA_PLSQL_DATATYPES.Char25TabTyp;
6605: l_TaskNumTab PA_PLSQL_DATATYPES.Char25TabTyp;
6606: l_ETypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6607: l_NlrTab PA_PLSQL_DATATYPES.Char20TabTyp;
6608: l_NlrOrgNameTab PA_PLSQL_DATATYPES.Char240TabTyp;
6609: l_QtyTab PA_PLSQL_DATATYPES.QtyTabtyp;
6610: l_rawCostTab PA_PLSQL_DATATYPES.NumTabTyp; -- Bug 5959023: Changed to NumTabTyp from QtyTabtyp
6611: l_rawCostRateTab PA_PLSQL_DATATYPES.NumTabTyp; -- Bug 5959023: Changed to NumTabTyp from AmtTabTyp

Line 6608: l_NlrOrgNameTab PA_PLSQL_DATATYPES.Char240TabTyp;

6604: l_PrjNumTab PA_PLSQL_DATATYPES.Char25TabTyp;
6605: l_TaskNumTab PA_PLSQL_DATATYPES.Char25TabTyp;
6606: l_ETypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6607: l_NlrTab PA_PLSQL_DATATYPES.Char20TabTyp;
6608: l_NlrOrgNameTab PA_PLSQL_DATATYPES.Char240TabTyp;
6609: l_QtyTab PA_PLSQL_DATATYPES.QtyTabtyp;
6610: l_rawCostTab PA_PLSQL_DATATYPES.NumTabTyp; -- Bug 5959023: Changed to NumTabTyp from QtyTabtyp
6611: l_rawCostRateTab PA_PLSQL_DATATYPES.NumTabTyp; -- Bug 5959023: Changed to NumTabTyp from AmtTabTyp
6612: l_OrigTxnRefTab PA_PLSQL_DATATYPES.Char50TabTyp; --bug 12371923 : Changed the size from 30 to 50

Line 6609: l_QtyTab PA_PLSQL_DATATYPES.QtyTabtyp;

6605: l_TaskNumTab PA_PLSQL_DATATYPES.Char25TabTyp;
6606: l_ETypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6607: l_NlrTab PA_PLSQL_DATATYPES.Char20TabTyp;
6608: l_NlrOrgNameTab PA_PLSQL_DATATYPES.Char240TabTyp;
6609: l_QtyTab PA_PLSQL_DATATYPES.QtyTabtyp;
6610: l_rawCostTab PA_PLSQL_DATATYPES.NumTabTyp; -- Bug 5959023: Changed to NumTabTyp from QtyTabtyp
6611: l_rawCostRateTab PA_PLSQL_DATATYPES.NumTabTyp; -- Bug 5959023: Changed to NumTabTyp from AmtTabTyp
6612: l_OrigTxnRefTab PA_PLSQL_DATATYPES.Char50TabTyp; --bug 12371923 : Changed the size from 30 to 50
6613: l_AttCatTab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 6610: l_rawCostTab PA_PLSQL_DATATYPES.NumTabTyp; -- Bug 5959023: Changed to NumTabTyp from QtyTabtyp

6606: l_ETypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6607: l_NlrTab PA_PLSQL_DATATYPES.Char20TabTyp;
6608: l_NlrOrgNameTab PA_PLSQL_DATATYPES.Char240TabTyp;
6609: l_QtyTab PA_PLSQL_DATATYPES.QtyTabtyp;
6610: l_rawCostTab PA_PLSQL_DATATYPES.NumTabTyp; -- Bug 5959023: Changed to NumTabTyp from QtyTabtyp
6611: l_rawCostRateTab PA_PLSQL_DATATYPES.NumTabTyp; -- Bug 5959023: Changed to NumTabTyp from AmtTabTyp
6612: l_OrigTxnRefTab PA_PLSQL_DATATYPES.Char50TabTyp; --bug 12371923 : Changed the size from 30 to 50
6613: l_AttCatTab PA_PLSQL_DATATYPES.Char30TabTyp;
6614: l_Att1Tab PA_PLSQL_DATATYPES.Char150TabTyp;

Line 6611: l_rawCostRateTab PA_PLSQL_DATATYPES.NumTabTyp; -- Bug 5959023: Changed to NumTabTyp from AmtTabTyp

6607: l_NlrTab PA_PLSQL_DATATYPES.Char20TabTyp;
6608: l_NlrOrgNameTab PA_PLSQL_DATATYPES.Char240TabTyp;
6609: l_QtyTab PA_PLSQL_DATATYPES.QtyTabtyp;
6610: l_rawCostTab PA_PLSQL_DATATYPES.NumTabTyp; -- Bug 5959023: Changed to NumTabTyp from QtyTabtyp
6611: l_rawCostRateTab PA_PLSQL_DATATYPES.NumTabTyp; -- Bug 5959023: Changed to NumTabTyp from AmtTabTyp
6612: l_OrigTxnRefTab PA_PLSQL_DATATYPES.Char50TabTyp; --bug 12371923 : Changed the size from 30 to 50
6613: l_AttCatTab PA_PLSQL_DATATYPES.Char30TabTyp;
6614: l_Att1Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6615: l_Att2Tab PA_PLSQL_DATATYPES.Char150TabTyp;

Line 6612: l_OrigTxnRefTab PA_PLSQL_DATATYPES.Char50TabTyp; --bug 12371923 : Changed the size from 30 to 50

6608: l_NlrOrgNameTab PA_PLSQL_DATATYPES.Char240TabTyp;
6609: l_QtyTab PA_PLSQL_DATATYPES.QtyTabtyp;
6610: l_rawCostTab PA_PLSQL_DATATYPES.NumTabTyp; -- Bug 5959023: Changed to NumTabTyp from QtyTabtyp
6611: l_rawCostRateTab PA_PLSQL_DATATYPES.NumTabTyp; -- Bug 5959023: Changed to NumTabTyp from AmtTabTyp
6612: l_OrigTxnRefTab PA_PLSQL_DATATYPES.Char50TabTyp; --bug 12371923 : Changed the size from 30 to 50
6613: l_AttCatTab PA_PLSQL_DATATYPES.Char30TabTyp;
6614: l_Att1Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6615: l_Att2Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6616: l_Att3Tab PA_PLSQL_DATATYPES.Char150TabTyp;

Line 6613: l_AttCatTab PA_PLSQL_DATATYPES.Char30TabTyp;

6609: l_QtyTab PA_PLSQL_DATATYPES.QtyTabtyp;
6610: l_rawCostTab PA_PLSQL_DATATYPES.NumTabTyp; -- Bug 5959023: Changed to NumTabTyp from QtyTabtyp
6611: l_rawCostRateTab PA_PLSQL_DATATYPES.NumTabTyp; -- Bug 5959023: Changed to NumTabTyp from AmtTabTyp
6612: l_OrigTxnRefTab PA_PLSQL_DATATYPES.Char50TabTyp; --bug 12371923 : Changed the size from 30 to 50
6613: l_AttCatTab PA_PLSQL_DATATYPES.Char30TabTyp;
6614: l_Att1Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6615: l_Att2Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6616: l_Att3Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6617: l_Att4Tab PA_PLSQL_DATATYPES.Char150TabTyp;

Line 6614: l_Att1Tab PA_PLSQL_DATATYPES.Char150TabTyp;

6610: l_rawCostTab PA_PLSQL_DATATYPES.NumTabTyp; -- Bug 5959023: Changed to NumTabTyp from QtyTabtyp
6611: l_rawCostRateTab PA_PLSQL_DATATYPES.NumTabTyp; -- Bug 5959023: Changed to NumTabTyp from AmtTabTyp
6612: l_OrigTxnRefTab PA_PLSQL_DATATYPES.Char50TabTyp; --bug 12371923 : Changed the size from 30 to 50
6613: l_AttCatTab PA_PLSQL_DATATYPES.Char30TabTyp;
6614: l_Att1Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6615: l_Att2Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6616: l_Att3Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6617: l_Att4Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6618: l_Att5Tab PA_PLSQL_DATATYPES.Char150TabTyp;

Line 6615: l_Att2Tab PA_PLSQL_DATATYPES.Char150TabTyp;

6611: l_rawCostRateTab PA_PLSQL_DATATYPES.NumTabTyp; -- Bug 5959023: Changed to NumTabTyp from AmtTabTyp
6612: l_OrigTxnRefTab PA_PLSQL_DATATYPES.Char50TabTyp; --bug 12371923 : Changed the size from 30 to 50
6613: l_AttCatTab PA_PLSQL_DATATYPES.Char30TabTyp;
6614: l_Att1Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6615: l_Att2Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6616: l_Att3Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6617: l_Att4Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6618: l_Att5Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6619: l_Att6Tab PA_PLSQL_DATATYPES.Char150TabTyp;

Line 6616: l_Att3Tab PA_PLSQL_DATATYPES.Char150TabTyp;

6612: l_OrigTxnRefTab PA_PLSQL_DATATYPES.Char50TabTyp; --bug 12371923 : Changed the size from 30 to 50
6613: l_AttCatTab PA_PLSQL_DATATYPES.Char30TabTyp;
6614: l_Att1Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6615: l_Att2Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6616: l_Att3Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6617: l_Att4Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6618: l_Att5Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6619: l_Att6Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6620: l_Att7Tab PA_PLSQL_DATATYPES.Char150TabTyp;

Line 6617: l_Att4Tab PA_PLSQL_DATATYPES.Char150TabTyp;

6613: l_AttCatTab PA_PLSQL_DATATYPES.Char30TabTyp;
6614: l_Att1Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6615: l_Att2Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6616: l_Att3Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6617: l_Att4Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6618: l_Att5Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6619: l_Att6Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6620: l_Att7Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6621: l_Att8Tab PA_PLSQL_DATATYPES.Char150TabTyp;

Line 6618: l_Att5Tab PA_PLSQL_DATATYPES.Char150TabTyp;

6614: l_Att1Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6615: l_Att2Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6616: l_Att3Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6617: l_Att4Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6618: l_Att5Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6619: l_Att6Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6620: l_Att7Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6621: l_Att8Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6622: l_Att9Tab PA_PLSQL_DATATYPES.Char150TabTyp;

Line 6619: l_Att6Tab PA_PLSQL_DATATYPES.Char150TabTyp;

6615: l_Att2Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6616: l_Att3Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6617: l_Att4Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6618: l_Att5Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6619: l_Att6Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6620: l_Att7Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6621: l_Att8Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6622: l_Att9Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6623: l_Att10Tab PA_PLSQL_DATATYPES.Char150TabTyp;

Line 6620: l_Att7Tab PA_PLSQL_DATATYPES.Char150TabTyp;

6616: l_Att3Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6617: l_Att4Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6618: l_Att5Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6619: l_Att6Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6620: l_Att7Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6621: l_Att8Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6622: l_Att9Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6623: l_Att10Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6624: l_ExpCommentTab PA_PLSQL_DATATYPES.Char240TabTyp;

Line 6621: l_Att8Tab PA_PLSQL_DATATYPES.Char150TabTyp;

6617: l_Att4Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6618: l_Att5Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6619: l_Att6Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6620: l_Att7Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6621: l_Att8Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6622: l_Att9Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6623: l_Att10Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6624: l_ExpCommentTab PA_PLSQL_DATATYPES.Char240TabTyp;
6625: l_InterfaceIdTab PA_PLSQL_DATATYPES.Num15TabTyp;

Line 6622: l_Att9Tab PA_PLSQL_DATATYPES.Char150TabTyp;

6618: l_Att5Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6619: l_Att6Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6620: l_Att7Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6621: l_Att8Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6622: l_Att9Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6623: l_Att10Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6624: l_ExpCommentTab PA_PLSQL_DATATYPES.Char240TabTyp;
6625: l_InterfaceIdTab PA_PLSQL_DATATYPES.Num15TabTyp;
6626: l_ExpIdTab PA_PLSQL_DATATYPES.Num15TabTyp;

Line 6623: l_Att10Tab PA_PLSQL_DATATYPES.Char150TabTyp;

6619: l_Att6Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6620: l_Att7Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6621: l_Att8Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6622: l_Att9Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6623: l_Att10Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6624: l_ExpCommentTab PA_PLSQL_DATATYPES.Char240TabTyp;
6625: l_InterfaceIdTab PA_PLSQL_DATATYPES.Num15TabTyp;
6626: l_ExpIdTab PA_PLSQL_DATATYPES.Num15TabTyp;
6627: l_UnMatchNegFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;

Line 6624: l_ExpCommentTab PA_PLSQL_DATATYPES.Char240TabTyp;

6620: l_Att7Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6621: l_Att8Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6622: l_Att9Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6623: l_Att10Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6624: l_ExpCommentTab PA_PLSQL_DATATYPES.Char240TabTyp;
6625: l_InterfaceIdTab PA_PLSQL_DATATYPES.Num15TabTyp;
6626: l_ExpIdTab PA_PLSQL_DATATYPES.Num15TabTyp;
6627: l_UnMatchNegFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;
6628: l_ExpItemIdTab PA_PLSQL_DATATYPES.Num15TabTyp;

Line 6625: l_InterfaceIdTab PA_PLSQL_DATATYPES.Num15TabTyp;

6621: l_Att8Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6622: l_Att9Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6623: l_Att10Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6624: l_ExpCommentTab PA_PLSQL_DATATYPES.Char240TabTyp;
6625: l_InterfaceIdTab PA_PLSQL_DATATYPES.Num15TabTyp;
6626: l_ExpIdTab PA_PLSQL_DATATYPES.Num15TabTyp;
6627: l_UnMatchNegFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;
6628: l_ExpItemIdTab PA_PLSQL_DATATYPES.Num15TabTyp;
6629: --l_JobIdTab PA_PLSQL_DATATYPES.

Line 6626: l_ExpIdTab PA_PLSQL_DATATYPES.Num15TabTyp;

6622: l_Att9Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6623: l_Att10Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6624: l_ExpCommentTab PA_PLSQL_DATATYPES.Char240TabTyp;
6625: l_InterfaceIdTab PA_PLSQL_DATATYPES.Num15TabTyp;
6626: l_ExpIdTab PA_PLSQL_DATATYPES.Num15TabTyp;
6627: l_UnMatchNegFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;
6628: l_ExpItemIdTab PA_PLSQL_DATATYPES.Num15TabTyp;
6629: --l_JobIdTab PA_PLSQL_DATATYPES.
6630: l_OrgIdTab PA_PLSQL_DATATYPES.Num15TabTyp;

Line 6627: l_UnMatchNegFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;

6623: l_Att10Tab PA_PLSQL_DATATYPES.Char150TabTyp;
6624: l_ExpCommentTab PA_PLSQL_DATATYPES.Char240TabTyp;
6625: l_InterfaceIdTab PA_PLSQL_DATATYPES.Num15TabTyp;
6626: l_ExpIdTab PA_PLSQL_DATATYPES.Num15TabTyp;
6627: l_UnMatchNegFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;
6628: l_ExpItemIdTab PA_PLSQL_DATATYPES.Num15TabTyp;
6629: --l_JobIdTab PA_PLSQL_DATATYPES.
6630: l_OrgIdTab PA_PLSQL_DATATYPES.Num15TabTyp;
6631: l_DRCCIDTab PA_PLSQL_DATATYPES.Num15TabTyp;

Line 6628: l_ExpItemIdTab PA_PLSQL_DATATYPES.Num15TabTyp;

6624: l_ExpCommentTab PA_PLSQL_DATATYPES.Char240TabTyp;
6625: l_InterfaceIdTab PA_PLSQL_DATATYPES.Num15TabTyp;
6626: l_ExpIdTab PA_PLSQL_DATATYPES.Num15TabTyp;
6627: l_UnMatchNegFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;
6628: l_ExpItemIdTab PA_PLSQL_DATATYPES.Num15TabTyp;
6629: --l_JobIdTab PA_PLSQL_DATATYPES.
6630: l_OrgIdTab PA_PLSQL_DATATYPES.Num15TabTyp;
6631: l_DRCCIDTab PA_PLSQL_DATATYPES.Num15TabTyp;
6632: l_CRCCIDTab PA_PLSQL_DATATYPES.Num15TabTyp;

Line 6629: --l_JobIdTab PA_PLSQL_DATATYPES.

6625: l_InterfaceIdTab PA_PLSQL_DATATYPES.Num15TabTyp;
6626: l_ExpIdTab PA_PLSQL_DATATYPES.Num15TabTyp;
6627: l_UnMatchNegFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;
6628: l_ExpItemIdTab PA_PLSQL_DATATYPES.Num15TabTyp;
6629: --l_JobIdTab PA_PLSQL_DATATYPES.
6630: l_OrgIdTab PA_PLSQL_DATATYPES.Num15TabTyp;
6631: l_DRCCIDTab PA_PLSQL_DATATYPES.Num15TabTyp;
6632: l_CRCCIDTab PA_PLSQL_DATATYPES.Num15TabTyp;
6633: l_SysRef1Tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 6630: l_OrgIdTab PA_PLSQL_DATATYPES.Num15TabTyp;

6626: l_ExpIdTab PA_PLSQL_DATATYPES.Num15TabTyp;
6627: l_UnMatchNegFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;
6628: l_ExpItemIdTab PA_PLSQL_DATATYPES.Num15TabTyp;
6629: --l_JobIdTab PA_PLSQL_DATATYPES.
6630: l_OrgIdTab PA_PLSQL_DATATYPES.Num15TabTyp;
6631: l_DRCCIDTab PA_PLSQL_DATATYPES.Num15TabTyp;
6632: l_CRCCIDTab PA_PLSQL_DATATYPES.Num15TabTyp;
6633: l_SysRef1Tab PA_PLSQL_DATATYPES.Char30TabTyp;
6634: l_SysRef2Tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 6631: l_DRCCIDTab PA_PLSQL_DATATYPES.Num15TabTyp;

6627: l_UnMatchNegFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;
6628: l_ExpItemIdTab PA_PLSQL_DATATYPES.Num15TabTyp;
6629: --l_JobIdTab PA_PLSQL_DATATYPES.
6630: l_OrgIdTab PA_PLSQL_DATATYPES.Num15TabTyp;
6631: l_DRCCIDTab PA_PLSQL_DATATYPES.Num15TabTyp;
6632: l_CRCCIDTab PA_PLSQL_DATATYPES.Num15TabTyp;
6633: l_SysRef1Tab PA_PLSQL_DATATYPES.Char30TabTyp;
6634: l_SysRef2Tab PA_PLSQL_DATATYPES.Char30TabTyp;
6635: l_SysRef3Tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 6632: l_CRCCIDTab PA_PLSQL_DATATYPES.Num15TabTyp;

6628: l_ExpItemIdTab PA_PLSQL_DATATYPES.Num15TabTyp;
6629: --l_JobIdTab PA_PLSQL_DATATYPES.
6630: l_OrgIdTab PA_PLSQL_DATATYPES.Num15TabTyp;
6631: l_DRCCIDTab PA_PLSQL_DATATYPES.Num15TabTyp;
6632: l_CRCCIDTab PA_PLSQL_DATATYPES.Num15TabTyp;
6633: l_SysRef1Tab PA_PLSQL_DATATYPES.Char30TabTyp;
6634: l_SysRef2Tab PA_PLSQL_DATATYPES.Char30TabTyp;
6635: l_SysRef3Tab PA_PLSQL_DATATYPES.Char30TabTyp;
6636: l_Sysref4Tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 6633: l_SysRef1Tab PA_PLSQL_DATATYPES.Char30TabTyp;

6629: --l_JobIdTab PA_PLSQL_DATATYPES.
6630: l_OrgIdTab PA_PLSQL_DATATYPES.Num15TabTyp;
6631: l_DRCCIDTab PA_PLSQL_DATATYPES.Num15TabTyp;
6632: l_CRCCIDTab PA_PLSQL_DATATYPES.Num15TabTyp;
6633: l_SysRef1Tab PA_PLSQL_DATATYPES.Char30TabTyp;
6634: l_SysRef2Tab PA_PLSQL_DATATYPES.Char30TabTyp;
6635: l_SysRef3Tab PA_PLSQL_DATATYPES.Char30TabTyp;
6636: l_Sysref4Tab PA_PLSQL_DATATYPES.Char30TabTyp;
6637: TYPE Char30TabTyp IS TABLE OF VARCHAR2(30) index by varchar2(30) ;

Line 6634: l_SysRef2Tab PA_PLSQL_DATATYPES.Char30TabTyp;

6630: l_OrgIdTab PA_PLSQL_DATATYPES.Num15TabTyp;
6631: l_DRCCIDTab PA_PLSQL_DATATYPES.Num15TabTyp;
6632: l_CRCCIDTab PA_PLSQL_DATATYPES.Num15TabTyp;
6633: l_SysRef1Tab PA_PLSQL_DATATYPES.Char30TabTyp;
6634: l_SysRef2Tab PA_PLSQL_DATATYPES.Char30TabTyp;
6635: l_SysRef3Tab PA_PLSQL_DATATYPES.Char30TabTyp;
6636: l_Sysref4Tab PA_PLSQL_DATATYPES.Char30TabTyp;
6637: TYPE Char30TabTyp IS TABLE OF VARCHAR2(30) index by varchar2(30) ;
6638: l_txn_rejected_sr4Tab Char30TabTyp;

Line 6635: l_SysRef3Tab PA_PLSQL_DATATYPES.Char30TabTyp;

6631: l_DRCCIDTab PA_PLSQL_DATATYPES.Num15TabTyp;
6632: l_CRCCIDTab PA_PLSQL_DATATYPES.Num15TabTyp;
6633: l_SysRef1Tab PA_PLSQL_DATATYPES.Char30TabTyp;
6634: l_SysRef2Tab PA_PLSQL_DATATYPES.Char30TabTyp;
6635: l_SysRef3Tab PA_PLSQL_DATATYPES.Char30TabTyp;
6636: l_Sysref4Tab PA_PLSQL_DATATYPES.Char30TabTyp;
6637: TYPE Char30TabTyp IS TABLE OF VARCHAR2(30) index by varchar2(30) ;
6638: l_txn_rejected_sr4Tab Char30TabTyp;
6639:

Line 6636: l_Sysref4Tab PA_PLSQL_DATATYPES.Char30TabTyp;

6632: l_CRCCIDTab PA_PLSQL_DATATYPES.Num15TabTyp;
6633: l_SysRef1Tab PA_PLSQL_DATATYPES.Char30TabTyp;
6634: l_SysRef2Tab PA_PLSQL_DATATYPES.Char30TabTyp;
6635: l_SysRef3Tab PA_PLSQL_DATATYPES.Char30TabTyp;
6636: l_Sysref4Tab PA_PLSQL_DATATYPES.Char30TabTyp;
6637: TYPE Char30TabTyp IS TABLE OF VARCHAR2(30) index by varchar2(30) ;
6638: l_txn_rejected_sr4Tab Char30TabTyp;
6639:
6640: /* REL12-AP Lines uptake START

Line 6644: l_Sysref5Tab PA_PLSQL_DATATYPES.IdTabTyp;

6640: /* REL12-AP Lines uptake START
6641: ** Support for cdl_system_reference5
6642: ** cdl_system_reference5 to store invoice distribution ID
6643: */
6644: l_Sysref5Tab PA_PLSQL_DATATYPES.IdTabTyp;
6645: l_txn_rejected_sr5tab PA_PLSQL_DATATYPES.IdTabTyp;
6646: l_AdjExpItemIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6647: l_FcDocTypeTab PA_PLSQL_DATATYPES.Char3TabTyp;
6648: l_AdjTxnInterfaceIDTab PA_PLSQL_DATATYPES.IdTabTyp;

Line 6645: l_txn_rejected_sr5tab PA_PLSQL_DATATYPES.IdTabTyp;

6641: ** Support for cdl_system_reference5
6642: ** cdl_system_reference5 to store invoice distribution ID
6643: */
6644: l_Sysref5Tab PA_PLSQL_DATATYPES.IdTabTyp;
6645: l_txn_rejected_sr5tab PA_PLSQL_DATATYPES.IdTabTyp;
6646: l_AdjExpItemIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6647: l_FcDocTypeTab PA_PLSQL_DATATYPES.Char3TabTyp;
6648: l_AdjTxnInterfaceIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6649: l_NZAdjFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;

Line 6646: l_AdjExpItemIdTab PA_PLSQL_DATATYPES.IdTabTyp;

6642: ** cdl_system_reference5 to store invoice distribution ID
6643: */
6644: l_Sysref5Tab PA_PLSQL_DATATYPES.IdTabTyp;
6645: l_txn_rejected_sr5tab PA_PLSQL_DATATYPES.IdTabTyp;
6646: l_AdjExpItemIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6647: l_FcDocTypeTab PA_PLSQL_DATATYPES.Char3TabTyp;
6648: l_AdjTxnInterfaceIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6649: l_NZAdjFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;
6650: l_AdjTxnEiIDTab PA_PLSQL_DATATYPES.IdTabTyp;

Line 6647: l_FcDocTypeTab PA_PLSQL_DATATYPES.Char3TabTyp;

6643: */
6644: l_Sysref5Tab PA_PLSQL_DATATYPES.IdTabTyp;
6645: l_txn_rejected_sr5tab PA_PLSQL_DATATYPES.IdTabTyp;
6646: l_AdjExpItemIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6647: l_FcDocTypeTab PA_PLSQL_DATATYPES.Char3TabTyp;
6648: l_AdjTxnInterfaceIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6649: l_NZAdjFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;
6650: l_AdjTxnEiIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6651: l_temp_adjItemID NUMBER ;

Line 6648: l_AdjTxnInterfaceIDTab PA_PLSQL_DATATYPES.IdTabTyp;

6644: l_Sysref5Tab PA_PLSQL_DATATYPES.IdTabTyp;
6645: l_txn_rejected_sr5tab PA_PLSQL_DATATYPES.IdTabTyp;
6646: l_AdjExpItemIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6647: l_FcDocTypeTab PA_PLSQL_DATATYPES.Char3TabTyp;
6648: l_AdjTxnInterfaceIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6649: l_NZAdjFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;
6650: l_AdjTxnEiIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6651: l_temp_adjItemID NUMBER ;
6652: l_scXferCdTab PA_PLSQL_DATATYPES.Char1TabTyp ;

Line 6649: l_NZAdjFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;

6645: l_txn_rejected_sr5tab PA_PLSQL_DATATYPES.IdTabTyp;
6646: l_AdjExpItemIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6647: l_FcDocTypeTab PA_PLSQL_DATATYPES.Char3TabTyp;
6648: l_AdjTxnInterfaceIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6649: l_NZAdjFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;
6650: l_AdjTxnEiIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6651: l_temp_adjItemID NUMBER ;
6652: l_scXferCdTab PA_PLSQL_DATATYPES.Char1TabTyp ;
6653:

Line 6650: l_AdjTxnEiIDTab PA_PLSQL_DATATYPES.IdTabTyp;

6646: l_AdjExpItemIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6647: l_FcDocTypeTab PA_PLSQL_DATATYPES.Char3TabTyp;
6648: l_AdjTxnInterfaceIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6649: l_NZAdjFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;
6650: l_AdjTxnEiIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6651: l_temp_adjItemID NUMBER ;
6652: l_scXferCdTab PA_PLSQL_DATATYPES.Char1TabTyp ;
6653:
6654: -- REL12 AP Lines Uptake

Line 6652: l_scXferCdTab PA_PLSQL_DATATYPES.Char1TabTyp ;

6648: l_AdjTxnInterfaceIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6649: l_NZAdjFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;
6650: l_AdjTxnEiIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6651: l_temp_adjItemID NUMBER ;
6652: l_scXferCdTab PA_PLSQL_DATATYPES.Char1TabTyp ;
6653:
6654: -- REL12 AP Lines Uptake
6655: -- Cash based accounting support
6656: --

Line 6659: l_finalPaymentIdTab PA_PLSQL_DATATYPES.IdTabTyp ;

6655: -- Cash based accounting support
6656: --
6657: -- bug 4902112 declaration was changed from Char1TabTyp to IdTabTyp.
6658: --
6659: l_finalPaymentIdTab PA_PLSQL_DATATYPES.IdTabTyp ;
6660:
6661: --REL12 Changes
6662: l_siaAddFlagTab PA_PLSQL_DATATYPES.Char1TabTyp ;
6663: l_old_SysRef1 varchar2(30) ;

Line 6662: l_siaAddFlagTab PA_PLSQL_DATATYPES.Char1TabTyp ;

6658: --
6659: l_finalPaymentIdTab PA_PLSQL_DATATYPES.IdTabTyp ;
6660:
6661: --REL12 Changes
6662: l_siaAddFlagTab PA_PLSQL_DATATYPES.Char1TabTyp ;
6663: l_old_SysRef1 varchar2(30) ;
6664: l_old_SysRef2 varchar2(30) ;
6665: l_old_SysRef3 varchar2(30) ;
6666: l_old_SysRef4 varchar2(30) ;

Line 6674: l_DocumentTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;

6670: l_doc_distribution_id NUMBER ;
6671: l_doc_payment_id NUMBER ;
6672: l_doc_line_number NUMBER ;
6673: l_gms_fundscheck varchar2(1) ;
6674: l_DocumentTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6675: l_DocumentDistTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6676:
6677: /* REL12-AP Lines uptake END */
6678:

Line 6675: l_DocumentDistTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;

6671: l_doc_payment_id NUMBER ;
6672: l_doc_line_number NUMBER ;
6673: l_gms_fundscheck varchar2(1) ;
6674: l_DocumentTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6675: l_DocumentDistTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6676:
6677: /* REL12-AP Lines uptake END */
6678:
6679:

Line 6680: l_GlDateTab PA_PLSQL_DATATYPES.DateTabTyp;

6676:
6677: /* REL12-AP Lines uptake END */
6678:
6679:
6680: l_GlDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6681: l_burdenedCostTab PA_PLSQL_DATATYPES.NumTabTyp; -- Bug 5959023: Changed to NumTabTyp from AmtTabTyp
6682: l_BdCostRateTab PA_PLSQL_DATATYPES.NumTabTyp; -- Bug 5959023: Changed to NumTabTyp from AmtTabTyp
6683: l_RcptCurrAmtTab PA_PLSQL_DATATYPES.NumTabTyp;
6684: l_RcptCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;

Line 6681: l_burdenedCostTab PA_PLSQL_DATATYPES.NumTabTyp; -- Bug 5959023: Changed to NumTabTyp from AmtTabTyp

6677: /* REL12-AP Lines uptake END */
6678:
6679:
6680: l_GlDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6681: l_burdenedCostTab PA_PLSQL_DATATYPES.NumTabTyp; -- Bug 5959023: Changed to NumTabTyp from AmtTabTyp
6682: l_BdCostRateTab PA_PLSQL_DATATYPES.NumTabTyp; -- Bug 5959023: Changed to NumTabTyp from AmtTabTyp
6683: l_RcptCurrAmtTab PA_PLSQL_DATATYPES.NumTabTyp;
6684: l_RcptCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;
6685: l_RcptExchRateTab PA_PLSQL_DATATYPES.NumTabTyp;

Line 6682: l_BdCostRateTab PA_PLSQL_DATATYPES.NumTabTyp; -- Bug 5959023: Changed to NumTabTyp from AmtTabTyp

6678:
6679:
6680: l_GlDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6681: l_burdenedCostTab PA_PLSQL_DATATYPES.NumTabTyp; -- Bug 5959023: Changed to NumTabTyp from AmtTabTyp
6682: l_BdCostRateTab PA_PLSQL_DATATYPES.NumTabTyp; -- Bug 5959023: Changed to NumTabTyp from AmtTabTyp
6683: l_RcptCurrAmtTab PA_PLSQL_DATATYPES.NumTabTyp;
6684: l_RcptCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;
6685: l_RcptExchRateTab PA_PLSQL_DATATYPES.NumTabTyp;
6686: l_DenomCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;

Line 6683: l_RcptCurrAmtTab PA_PLSQL_DATATYPES.NumTabTyp;

6679:
6680: l_GlDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6681: l_burdenedCostTab PA_PLSQL_DATATYPES.NumTabTyp; -- Bug 5959023: Changed to NumTabTyp from AmtTabTyp
6682: l_BdCostRateTab PA_PLSQL_DATATYPES.NumTabTyp; -- Bug 5959023: Changed to NumTabTyp from AmtTabTyp
6683: l_RcptCurrAmtTab PA_PLSQL_DATATYPES.NumTabTyp;
6684: l_RcptCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;
6685: l_RcptExchRateTab PA_PLSQL_DATATYPES.NumTabTyp;
6686: l_DenomCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;
6687: l_DenomRawCostTab PA_PLSQL_DATATYPES.NumTabTyp;

Line 6684: l_RcptCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;

6680: l_GlDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6681: l_burdenedCostTab PA_PLSQL_DATATYPES.NumTabTyp; -- Bug 5959023: Changed to NumTabTyp from AmtTabTyp
6682: l_BdCostRateTab PA_PLSQL_DATATYPES.NumTabTyp; -- Bug 5959023: Changed to NumTabTyp from AmtTabTyp
6683: l_RcptCurrAmtTab PA_PLSQL_DATATYPES.NumTabTyp;
6684: l_RcptCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;
6685: l_RcptExchRateTab PA_PLSQL_DATATYPES.NumTabTyp;
6686: l_DenomCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;
6687: l_DenomRawCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6688: l_DenomBdCostTab PA_PLSQL_DATATYPES.NumTabTyp;

Line 6685: l_RcptExchRateTab PA_PLSQL_DATATYPES.NumTabTyp;

6681: l_burdenedCostTab PA_PLSQL_DATATYPES.NumTabTyp; -- Bug 5959023: Changed to NumTabTyp from AmtTabTyp
6682: l_BdCostRateTab PA_PLSQL_DATATYPES.NumTabTyp; -- Bug 5959023: Changed to NumTabTyp from AmtTabTyp
6683: l_RcptCurrAmtTab PA_PLSQL_DATATYPES.NumTabTyp;
6684: l_RcptCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;
6685: l_RcptExchRateTab PA_PLSQL_DATATYPES.NumTabTyp;
6686: l_DenomCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;
6687: l_DenomRawCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6688: l_DenomBdCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6689: l_AcctRateDateTab PA_PLSQL_DATATYPES.DateTabTyp;

Line 6686: l_DenomCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;

6682: l_BdCostRateTab PA_PLSQL_DATATYPES.NumTabTyp; -- Bug 5959023: Changed to NumTabTyp from AmtTabTyp
6683: l_RcptCurrAmtTab PA_PLSQL_DATATYPES.NumTabTyp;
6684: l_RcptCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;
6685: l_RcptExchRateTab PA_PLSQL_DATATYPES.NumTabTyp;
6686: l_DenomCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;
6687: l_DenomRawCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6688: l_DenomBdCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6689: l_AcctRateDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6690: l_AcctRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 6687: l_DenomRawCostTab PA_PLSQL_DATATYPES.NumTabTyp;

6683: l_RcptCurrAmtTab PA_PLSQL_DATATYPES.NumTabTyp;
6684: l_RcptCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;
6685: l_RcptExchRateTab PA_PLSQL_DATATYPES.NumTabTyp;
6686: l_DenomCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;
6687: l_DenomRawCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6688: l_DenomBdCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6689: l_AcctRateDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6690: l_AcctRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6691: l_AcctExchRateTab PA_PLSQL_DATATYPES.NumTabTyp;

Line 6688: l_DenomBdCostTab PA_PLSQL_DATATYPES.NumTabTyp;

6684: l_RcptCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;
6685: l_RcptExchRateTab PA_PLSQL_DATATYPES.NumTabTyp;
6686: l_DenomCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;
6687: l_DenomRawCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6688: l_DenomBdCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6689: l_AcctRateDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6690: l_AcctRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6691: l_AcctExchRateTab PA_PLSQL_DATATYPES.NumTabTyp;
6692: l_AcctRawCostTab PA_PLSQL_DATATYPES.NumTabTyp;

Line 6689: l_AcctRateDateTab PA_PLSQL_DATATYPES.DateTabTyp;

6685: l_RcptExchRateTab PA_PLSQL_DATATYPES.NumTabTyp;
6686: l_DenomCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;
6687: l_DenomRawCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6688: l_DenomBdCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6689: l_AcctRateDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6690: l_AcctRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6691: l_AcctExchRateTab PA_PLSQL_DATATYPES.NumTabTyp;
6692: l_AcctRawCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6693: l_AcctBdCostTab PA_PLSQL_DATATYPES.NumTabTyp;

Line 6690: l_AcctRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;

6686: l_DenomCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;
6687: l_DenomRawCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6688: l_DenomBdCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6689: l_AcctRateDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6690: l_AcctRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6691: l_AcctExchRateTab PA_PLSQL_DATATYPES.NumTabTyp;
6692: l_AcctRawCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6693: l_AcctBdCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6694: l_AcctExchRndLimitTab PA_PLSQL_DATATYPES.NumTabTyp;

Line 6691: l_AcctExchRateTab PA_PLSQL_DATATYPES.NumTabTyp;

6687: l_DenomRawCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6688: l_DenomBdCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6689: l_AcctRateDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6690: l_AcctRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6691: l_AcctExchRateTab PA_PLSQL_DATATYPES.NumTabTyp;
6692: l_AcctRawCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6693: l_AcctBdCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6694: l_AcctExchRndLimitTab PA_PLSQL_DATATYPES.NumTabTyp;
6695: l_ProjCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;

Line 6692: l_AcctRawCostTab PA_PLSQL_DATATYPES.NumTabTyp;

6688: l_DenomBdCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6689: l_AcctRateDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6690: l_AcctRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6691: l_AcctExchRateTab PA_PLSQL_DATATYPES.NumTabTyp;
6692: l_AcctRawCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6693: l_AcctBdCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6694: l_AcctExchRndLimitTab PA_PLSQL_DATATYPES.NumTabTyp;
6695: l_ProjCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;
6696: l_prjRateDateTab PA_PLSQL_DATATYPES.DateTabTyp;

Line 6693: l_AcctBdCostTab PA_PLSQL_DATATYPES.NumTabTyp;

6689: l_AcctRateDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6690: l_AcctRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6691: l_AcctExchRateTab PA_PLSQL_DATATYPES.NumTabTyp;
6692: l_AcctRawCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6693: l_AcctBdCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6694: l_AcctExchRndLimitTab PA_PLSQL_DATATYPES.NumTabTyp;
6695: l_ProjCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;
6696: l_prjRateDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6697: l_PrjRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 6694: l_AcctExchRndLimitTab PA_PLSQL_DATATYPES.NumTabTyp;

6690: l_AcctRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6691: l_AcctExchRateTab PA_PLSQL_DATATYPES.NumTabTyp;
6692: l_AcctRawCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6693: l_AcctBdCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6694: l_AcctExchRndLimitTab PA_PLSQL_DATATYPES.NumTabTyp;
6695: l_ProjCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;
6696: l_prjRateDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6697: l_PrjRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6698: l_PrjExchRateTab PA_PLSQL_DATATYPES.NumTabTyp;

Line 6695: l_ProjCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;

6691: l_AcctExchRateTab PA_PLSQL_DATATYPES.NumTabTyp;
6692: l_AcctRawCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6693: l_AcctBdCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6694: l_AcctExchRndLimitTab PA_PLSQL_DATATYPES.NumTabTyp;
6695: l_ProjCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;
6696: l_prjRateDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6697: l_PrjRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6698: l_PrjExchRateTab PA_PLSQL_DATATYPES.NumTabTyp;
6699: l_OrigExpTxnRef1Tab PA_PLSQL_DATATYPES.Char60TabTyp;

Line 6696: l_prjRateDateTab PA_PLSQL_DATATYPES.DateTabTyp;

6692: l_AcctRawCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6693: l_AcctBdCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6694: l_AcctExchRndLimitTab PA_PLSQL_DATATYPES.NumTabTyp;
6695: l_ProjCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;
6696: l_prjRateDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6697: l_PrjRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6698: l_PrjExchRateTab PA_PLSQL_DATATYPES.NumTabTyp;
6699: l_OrigExpTxnRef1Tab PA_PLSQL_DATATYPES.Char60TabTyp;
6700: l_OrigUsrExpTxnRefTab PA_PLSQL_DATATYPES.Char60TabTyp;

Line 6697: l_PrjRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;

6693: l_AcctBdCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6694: l_AcctExchRndLimitTab PA_PLSQL_DATATYPES.NumTabTyp;
6695: l_ProjCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;
6696: l_prjRateDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6697: l_PrjRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6698: l_PrjExchRateTab PA_PLSQL_DATATYPES.NumTabTyp;
6699: l_OrigExpTxnRef1Tab PA_PLSQL_DATATYPES.Char60TabTyp;
6700: l_OrigUsrExpTxnRefTab PA_PLSQL_DATATYPES.Char60TabTyp;
6701: l_VendorNumTab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 6698: l_PrjExchRateTab PA_PLSQL_DATATYPES.NumTabTyp;

6694: l_AcctExchRndLimitTab PA_PLSQL_DATATYPES.NumTabTyp;
6695: l_ProjCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;
6696: l_prjRateDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6697: l_PrjRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6698: l_PrjExchRateTab PA_PLSQL_DATATYPES.NumTabTyp;
6699: l_OrigExpTxnRef1Tab PA_PLSQL_DATATYPES.Char60TabTyp;
6700: l_OrigUsrExpTxnRefTab PA_PLSQL_DATATYPES.Char60TabTyp;
6701: l_VendorNumTab PA_PLSQL_DATATYPES.Char30TabTyp;
6702: l_OrigExpTxnRef2Tab PA_PLSQL_DATATYPES.Char60TabTyp;

Line 6699: l_OrigExpTxnRef1Tab PA_PLSQL_DATATYPES.Char60TabTyp;

6695: l_ProjCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;
6696: l_prjRateDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6697: l_PrjRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6698: l_PrjExchRateTab PA_PLSQL_DATATYPES.NumTabTyp;
6699: l_OrigExpTxnRef1Tab PA_PLSQL_DATATYPES.Char60TabTyp;
6700: l_OrigUsrExpTxnRefTab PA_PLSQL_DATATYPES.Char60TabTyp;
6701: l_VendorNumTab PA_PLSQL_DATATYPES.Char30TabTyp;
6702: l_OrigExpTxnRef2Tab PA_PLSQL_DATATYPES.Char60TabTyp;
6703: l_OrigExpTxnRef3Tab PA_PLSQL_DATATYPES.Char60TabTyp;

Line 6700: l_OrigUsrExpTxnRefTab PA_PLSQL_DATATYPES.Char60TabTyp;

6696: l_prjRateDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6697: l_PrjRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6698: l_PrjExchRateTab PA_PLSQL_DATATYPES.NumTabTyp;
6699: l_OrigExpTxnRef1Tab PA_PLSQL_DATATYPES.Char60TabTyp;
6700: l_OrigUsrExpTxnRefTab PA_PLSQL_DATATYPES.Char60TabTyp;
6701: l_VendorNumTab PA_PLSQL_DATATYPES.Char30TabTyp;
6702: l_OrigExpTxnRef2Tab PA_PLSQL_DATATYPES.Char60TabTyp;
6703: l_OrigExpTxnRef3Tab PA_PLSQL_DATATYPES.Char60TabTyp;
6704: l_OverrideOrgNameTab PA_PLSQL_DATATYPES.Char240TabTyp;

Line 6701: l_VendorNumTab PA_PLSQL_DATATYPES.Char30TabTyp;

6697: l_PrjRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6698: l_PrjExchRateTab PA_PLSQL_DATATYPES.NumTabTyp;
6699: l_OrigExpTxnRef1Tab PA_PLSQL_DATATYPES.Char60TabTyp;
6700: l_OrigUsrExpTxnRefTab PA_PLSQL_DATATYPES.Char60TabTyp;
6701: l_VendorNumTab PA_PLSQL_DATATYPES.Char30TabTyp;
6702: l_OrigExpTxnRef2Tab PA_PLSQL_DATATYPES.Char60TabTyp;
6703: l_OrigExpTxnRef3Tab PA_PLSQL_DATATYPES.Char60TabTyp;
6704: l_OverrideOrgNameTab PA_PLSQL_DATATYPES.Char240TabTyp;
6705: l_RevOrigTxnRefTab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 6702: l_OrigExpTxnRef2Tab PA_PLSQL_DATATYPES.Char60TabTyp;

6698: l_PrjExchRateTab PA_PLSQL_DATATYPES.NumTabTyp;
6699: l_OrigExpTxnRef1Tab PA_PLSQL_DATATYPES.Char60TabTyp;
6700: l_OrigUsrExpTxnRefTab PA_PLSQL_DATATYPES.Char60TabTyp;
6701: l_VendorNumTab PA_PLSQL_DATATYPES.Char30TabTyp;
6702: l_OrigExpTxnRef2Tab PA_PLSQL_DATATYPES.Char60TabTyp;
6703: l_OrigExpTxnRef3Tab PA_PLSQL_DATATYPES.Char60TabTyp;
6704: l_OverrideOrgNameTab PA_PLSQL_DATATYPES.Char240TabTyp;
6705: l_RevOrigTxnRefTab PA_PLSQL_DATATYPES.Char30TabTyp;
6706: l_billableFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;

Line 6703: l_OrigExpTxnRef3Tab PA_PLSQL_DATATYPES.Char60TabTyp;

6699: l_OrigExpTxnRef1Tab PA_PLSQL_DATATYPES.Char60TabTyp;
6700: l_OrigUsrExpTxnRefTab PA_PLSQL_DATATYPES.Char60TabTyp;
6701: l_VendorNumTab PA_PLSQL_DATATYPES.Char30TabTyp;
6702: l_OrigExpTxnRef2Tab PA_PLSQL_DATATYPES.Char60TabTyp;
6703: l_OrigExpTxnRef3Tab PA_PLSQL_DATATYPES.Char60TabTyp;
6704: l_OverrideOrgNameTab PA_PLSQL_DATATYPES.Char240TabTyp;
6705: l_RevOrigTxnRefTab PA_PLSQL_DATATYPES.Char30TabTyp;
6706: l_billableFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;
6707: l_TxnIfIdTab PA_PLSQL_DATATYPES.Num15TabTyp;

Line 6704: l_OverrideOrgNameTab PA_PLSQL_DATATYPES.Char240TabTyp;

6700: l_OrigUsrExpTxnRefTab PA_PLSQL_DATATYPES.Char60TabTyp;
6701: l_VendorNumTab PA_PLSQL_DATATYPES.Char30TabTyp;
6702: l_OrigExpTxnRef2Tab PA_PLSQL_DATATYPES.Char60TabTyp;
6703: l_OrigExpTxnRef3Tab PA_PLSQL_DATATYPES.Char60TabTyp;
6704: l_OverrideOrgNameTab PA_PLSQL_DATATYPES.Char240TabTyp;
6705: l_RevOrigTxnRefTab PA_PLSQL_DATATYPES.Char30TabTyp;
6706: l_billableFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;
6707: l_TxnIfIdTab PA_PLSQL_DATATYPES.Num15TabTyp;
6708: l_PerBusGrpNameTab PA_PLSQL_DATATYPES.Char60TabTyp;

Line 6705: l_RevOrigTxnRefTab PA_PLSQL_DATATYPES.Char30TabTyp;

6701: l_VendorNumTab PA_PLSQL_DATATYPES.Char30TabTyp;
6702: l_OrigExpTxnRef2Tab PA_PLSQL_DATATYPES.Char60TabTyp;
6703: l_OrigExpTxnRef3Tab PA_PLSQL_DATATYPES.Char60TabTyp;
6704: l_OverrideOrgNameTab PA_PLSQL_DATATYPES.Char240TabTyp;
6705: l_RevOrigTxnRefTab PA_PLSQL_DATATYPES.Char30TabTyp;
6706: l_billableFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;
6707: l_TxnIfIdTab PA_PLSQL_DATATYPES.Num15TabTyp;
6708: l_PerBusGrpNameTab PA_PLSQL_DATATYPES.Char60TabTyp;
6709: l_ProjFuncCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;

Line 6706: l_billableFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;

6702: l_OrigExpTxnRef2Tab PA_PLSQL_DATATYPES.Char60TabTyp;
6703: l_OrigExpTxnRef3Tab PA_PLSQL_DATATYPES.Char60TabTyp;
6704: l_OverrideOrgNameTab PA_PLSQL_DATATYPES.Char240TabTyp;
6705: l_RevOrigTxnRefTab PA_PLSQL_DATATYPES.Char30TabTyp;
6706: l_billableFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;
6707: l_TxnIfIdTab PA_PLSQL_DATATYPES.Num15TabTyp;
6708: l_PerBusGrpNameTab PA_PLSQL_DATATYPES.Char60TabTyp;
6709: l_ProjFuncCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;
6710: l_PrjFuncRateDateTab PA_PLSQL_DATATYPES.DateTabTyp;

Line 6707: l_TxnIfIdTab PA_PLSQL_DATATYPES.Num15TabTyp;

6703: l_OrigExpTxnRef3Tab PA_PLSQL_DATATYPES.Char60TabTyp;
6704: l_OverrideOrgNameTab PA_PLSQL_DATATYPES.Char240TabTyp;
6705: l_RevOrigTxnRefTab PA_PLSQL_DATATYPES.Char30TabTyp;
6706: l_billableFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;
6707: l_TxnIfIdTab PA_PLSQL_DATATYPES.Num15TabTyp;
6708: l_PerBusGrpNameTab PA_PLSQL_DATATYPES.Char60TabTyp;
6709: l_ProjFuncCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;
6710: l_PrjFuncRateDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6711: l_PrjFuncRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 6708: l_PerBusGrpNameTab PA_PLSQL_DATATYPES.Char60TabTyp;

6704: l_OverrideOrgNameTab PA_PLSQL_DATATYPES.Char240TabTyp;
6705: l_RevOrigTxnRefTab PA_PLSQL_DATATYPES.Char30TabTyp;
6706: l_billableFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;
6707: l_TxnIfIdTab PA_PLSQL_DATATYPES.Num15TabTyp;
6708: l_PerBusGrpNameTab PA_PLSQL_DATATYPES.Char60TabTyp;
6709: l_ProjFuncCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;
6710: l_PrjFuncRateDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6711: l_PrjFuncRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6712: l_PrjFuncExchRateTab PA_PLSQL_DATATYPES.NumTabTyp;

Line 6709: l_ProjFuncCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;

6705: l_RevOrigTxnRefTab PA_PLSQL_DATATYPES.Char30TabTyp;
6706: l_billableFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;
6707: l_TxnIfIdTab PA_PLSQL_DATATYPES.Num15TabTyp;
6708: l_PerBusGrpNameTab PA_PLSQL_DATATYPES.Char60TabTyp;
6709: l_ProjFuncCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;
6710: l_PrjFuncRateDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6711: l_PrjFuncRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6712: l_PrjFuncExchRateTab PA_PLSQL_DATATYPES.NumTabTyp;
6713: l_ProjRawCostTab PA_PLSQL_DATATYPES.NumTabTyp;

Line 6710: l_PrjFuncRateDateTab PA_PLSQL_DATATYPES.DateTabTyp;

6706: l_billableFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;
6707: l_TxnIfIdTab PA_PLSQL_DATATYPES.Num15TabTyp;
6708: l_PerBusGrpNameTab PA_PLSQL_DATATYPES.Char60TabTyp;
6709: l_ProjFuncCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;
6710: l_PrjFuncRateDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6711: l_PrjFuncRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6712: l_PrjFuncExchRateTab PA_PLSQL_DATATYPES.NumTabTyp;
6713: l_ProjRawCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6714: l_ProjBdCostTab PA_PLSQL_DATATYPES.NumTabTyp;

Line 6711: l_PrjFuncRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;

6707: l_TxnIfIdTab PA_PLSQL_DATATYPES.Num15TabTyp;
6708: l_PerBusGrpNameTab PA_PLSQL_DATATYPES.Char60TabTyp;
6709: l_ProjFuncCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;
6710: l_PrjFuncRateDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6711: l_PrjFuncRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6712: l_PrjFuncExchRateTab PA_PLSQL_DATATYPES.NumTabTyp;
6713: l_ProjRawCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6714: l_ProjBdCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6715: l_AsgnNameTab PA_PLSQL_DATATYPES.Char80TabTyp;

Line 6712: l_PrjFuncExchRateTab PA_PLSQL_DATATYPES.NumTabTyp;

6708: l_PerBusGrpNameTab PA_PLSQL_DATATYPES.Char60TabTyp;
6709: l_ProjFuncCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;
6710: l_PrjFuncRateDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6711: l_PrjFuncRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6712: l_PrjFuncExchRateTab PA_PLSQL_DATATYPES.NumTabTyp;
6713: l_ProjRawCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6714: l_ProjBdCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6715: l_AsgnNameTab PA_PLSQL_DATATYPES.Char80TabTyp;
6716: l_WorkTypeNameTab PA_PLSQL_DATATYPES.Char80TabTyp;

Line 6713: l_ProjRawCostTab PA_PLSQL_DATATYPES.NumTabTyp;

6709: l_ProjFuncCurrCodeTab PA_PLSQL_DATATYPES.Char15TabTyp;
6710: l_PrjFuncRateDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6711: l_PrjFuncRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6712: l_PrjFuncExchRateTab PA_PLSQL_DATATYPES.NumTabTyp;
6713: l_ProjRawCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6714: l_ProjBdCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6715: l_AsgnNameTab PA_PLSQL_DATATYPES.Char80TabTyp;
6716: l_WorkTypeNameTab PA_PLSQL_DATATYPES.Char80TabTyp;
6717: l_AccrualFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;

Line 6714: l_ProjBdCostTab PA_PLSQL_DATATYPES.NumTabTyp;

6710: l_PrjFuncRateDateTab PA_PLSQL_DATATYPES.DateTabTyp;
6711: l_PrjFuncRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6712: l_PrjFuncExchRateTab PA_PLSQL_DATATYPES.NumTabTyp;
6713: l_ProjRawCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6714: l_ProjBdCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6715: l_AsgnNameTab PA_PLSQL_DATATYPES.Char80TabTyp;
6716: l_WorkTypeNameTab PA_PLSQL_DATATYPES.Char80TabTyp;
6717: l_AccrualFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;
6718: l_PrjIdTab PA_PLSQL_DATATYPES.IdTabTyp;

Line 6715: l_AsgnNameTab PA_PLSQL_DATATYPES.Char80TabTyp;

6711: l_PrjFuncRateTypeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6712: l_PrjFuncExchRateTab PA_PLSQL_DATATYPES.NumTabTyp;
6713: l_ProjRawCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6714: l_ProjBdCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6715: l_AsgnNameTab PA_PLSQL_DATATYPES.Char80TabTyp;
6716: l_WorkTypeNameTab PA_PLSQL_DATATYPES.Char80TabTyp;
6717: l_AccrualFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;
6718: l_PrjIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6719: l_TaskIdTab PA_PLSQL_DATATYPES.IdTabTyp;

Line 6716: l_WorkTypeNameTab PA_PLSQL_DATATYPES.Char80TabTyp;

6712: l_PrjFuncExchRateTab PA_PLSQL_DATATYPES.NumTabTyp;
6713: l_ProjRawCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6714: l_ProjBdCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6715: l_AsgnNameTab PA_PLSQL_DATATYPES.Char80TabTyp;
6716: l_WorkTypeNameTab PA_PLSQL_DATATYPES.Char80TabTyp;
6717: l_AccrualFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;
6718: l_PrjIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6719: l_TaskIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6720: l_PersonIdTab PA_PLSQL_DATATYPES.IdTabTyp;

Line 6717: l_AccrualFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;

6713: l_ProjRawCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6714: l_ProjBdCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6715: l_AsgnNameTab PA_PLSQL_DATATYPES.Char80TabTyp;
6716: l_WorkTypeNameTab PA_PLSQL_DATATYPES.Char80TabTyp;
6717: l_AccrualFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;
6718: l_PrjIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6719: l_TaskIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6720: l_PersonIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6721: l_OrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;

Line 6718: l_PrjIdTab PA_PLSQL_DATATYPES.IdTabTyp;

6714: l_ProjBdCostTab PA_PLSQL_DATATYPES.NumTabTyp;
6715: l_AsgnNameTab PA_PLSQL_DATATYPES.Char80TabTyp;
6716: l_WorkTypeNameTab PA_PLSQL_DATATYPES.Char80TabTyp;
6717: l_AccrualFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;
6718: l_PrjIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6719: l_TaskIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6720: l_PersonIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6721: l_OrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6722: l_NLROrgIDTab PA_PLSQL_DATATYPES.IdTabTyp;

Line 6719: l_TaskIdTab PA_PLSQL_DATATYPES.IdTabTyp;

6715: l_AsgnNameTab PA_PLSQL_DATATYPES.Char80TabTyp;
6716: l_WorkTypeNameTab PA_PLSQL_DATATYPES.Char80TabTyp;
6717: l_AccrualFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;
6718: l_PrjIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6719: l_TaskIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6720: l_PersonIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6721: l_OrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6722: l_NLROrgIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6723: l_VendorIdTab PA_PLSQL_DATATYPES.IdTabTyp;

Line 6720: l_PersonIdTab PA_PLSQL_DATATYPES.IdTabTyp;

6716: l_WorkTypeNameTab PA_PLSQL_DATATYPES.Char80TabTyp;
6717: l_AccrualFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;
6718: l_PrjIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6719: l_TaskIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6720: l_PersonIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6721: l_OrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6722: l_NLROrgIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6723: l_VendorIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6724: l_OverrideOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;

Line 6721: l_OrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;

6717: l_AccrualFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;
6718: l_PrjIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6719: l_TaskIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6720: l_PersonIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6721: l_OrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6722: l_NLROrgIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6723: l_VendorIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6724: l_OverrideOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6725: l_AsgnIdTab PA_PLSQL_DATATYPES.IdTabTyp;

Line 6722: l_NLROrgIDTab PA_PLSQL_DATATYPES.IdTabTyp;

6718: l_PrjIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6719: l_TaskIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6720: l_PersonIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6721: l_OrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6722: l_NLROrgIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6723: l_VendorIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6724: l_OverrideOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6725: l_AsgnIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6726: l_WorkTypeIdTab PA_PLSQL_DATATYPES.IdTabTyp;

Line 6723: l_VendorIdTab PA_PLSQL_DATATYPES.IdTabTyp;

6719: l_TaskIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6720: l_PersonIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6721: l_OrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6722: l_NLROrgIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6723: l_VendorIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6724: l_OverrideOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6725: l_AsgnIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6726: l_WorkTypeIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6727: l_PersonBusGrpIdTab PA_PLSQL_DATATYPES.IdTabTyp;

Line 6724: l_OverrideOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;

6720: l_PersonIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6721: l_OrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6722: l_NLROrgIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6723: l_VendorIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6724: l_OverrideOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6725: l_AsgnIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6726: l_WorkTypeIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6727: l_PersonBusGrpIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6728: l_EmpOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;

Line 6725: l_AsgnIdTab PA_PLSQL_DATATYPES.IdTabTyp;

6721: l_OrganizationIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6722: l_NLROrgIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6723: l_VendorIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6724: l_OverrideOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6725: l_AsgnIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6726: l_WorkTypeIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6727: l_PersonBusGrpIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6728: l_EmpOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6729: l_EmpJobIdTab PA_PLSQL_DATATYPES.IdTabTyp;

Line 6726: l_WorkTypeIdTab PA_PLSQL_DATATYPES.IdTabTyp;

6722: l_NLROrgIDTab PA_PLSQL_DATATYPES.IdTabTyp;
6723: l_VendorIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6724: l_OverrideOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6725: l_AsgnIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6726: l_WorkTypeIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6727: l_PersonBusGrpIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6728: l_EmpOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6729: l_EmpJobIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6730: l_po_numberTab PA_PLSQL_DATATYPES.Char20TabTyp; /* cwk */

Line 6727: l_PersonBusGrpIdTab PA_PLSQL_DATATYPES.IdTabTyp;

6723: l_VendorIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6724: l_OverrideOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6725: l_AsgnIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6726: l_WorkTypeIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6727: l_PersonBusGrpIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6728: l_EmpOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6729: l_EmpJobIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6730: l_po_numberTab PA_PLSQL_DATATYPES.Char20TabTyp; /* cwk */
6731: l_po_header_idTab PA_PLSQL_DATATYPES.IdTabTyp;

Line 6728: l_EmpOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;

6724: l_OverrideOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6725: l_AsgnIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6726: l_WorkTypeIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6727: l_PersonBusGrpIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6728: l_EmpOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6729: l_EmpJobIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6730: l_po_numberTab PA_PLSQL_DATATYPES.Char20TabTyp; /* cwk */
6731: l_po_header_idTab PA_PLSQL_DATATYPES.IdTabTyp;
6732: l_po_line_numTab PA_PLSQL_DATATYPES.NumTabTyp;

Line 6729: l_EmpJobIdTab PA_PLSQL_DATATYPES.IdTabTyp;

6725: l_AsgnIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6726: l_WorkTypeIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6727: l_PersonBusGrpIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6728: l_EmpOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6729: l_EmpJobIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6730: l_po_numberTab PA_PLSQL_DATATYPES.Char20TabTyp; /* cwk */
6731: l_po_header_idTab PA_PLSQL_DATATYPES.IdTabTyp;
6732: l_po_line_numTab PA_PLSQL_DATATYPES.NumTabTyp;
6733: l_po_line_idTab PA_PLSQL_DATATYPES.IdTabTyp;

Line 6730: l_po_numberTab PA_PLSQL_DATATYPES.Char20TabTyp; /* cwk */

6726: l_WorkTypeIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6727: l_PersonBusGrpIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6728: l_EmpOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6729: l_EmpJobIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6730: l_po_numberTab PA_PLSQL_DATATYPES.Char20TabTyp; /* cwk */
6731: l_po_header_idTab PA_PLSQL_DATATYPES.IdTabTyp;
6732: l_po_line_numTab PA_PLSQL_DATATYPES.NumTabTyp;
6733: l_po_line_idTab PA_PLSQL_DATATYPES.IdTabTyp;
6734: l_person_typeTab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 6731: l_po_header_idTab PA_PLSQL_DATATYPES.IdTabTyp;

6727: l_PersonBusGrpIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6728: l_EmpOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6729: l_EmpJobIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6730: l_po_numberTab PA_PLSQL_DATATYPES.Char20TabTyp; /* cwk */
6731: l_po_header_idTab PA_PLSQL_DATATYPES.IdTabTyp;
6732: l_po_line_numTab PA_PLSQL_DATATYPES.NumTabTyp;
6733: l_po_line_idTab PA_PLSQL_DATATYPES.IdTabTyp;
6734: l_person_typeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6735: l_po_price_typeTab PA_PLSQL_DATATYPES.Char20TabTyp;

Line 6732: l_po_line_numTab PA_PLSQL_DATATYPES.NumTabTyp;

6728: l_EmpOrgIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6729: l_EmpJobIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6730: l_po_numberTab PA_PLSQL_DATATYPES.Char20TabTyp; /* cwk */
6731: l_po_header_idTab PA_PLSQL_DATATYPES.IdTabTyp;
6732: l_po_line_numTab PA_PLSQL_DATATYPES.NumTabTyp;
6733: l_po_line_idTab PA_PLSQL_DATATYPES.IdTabTyp;
6734: l_person_typeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6735: l_po_price_typeTab PA_PLSQL_DATATYPES.Char20TabTyp;
6736: l_wip_resource_idTab PA_PLSQL_DATATYPES.IdTabTyp;

Line 6733: l_po_line_idTab PA_PLSQL_DATATYPES.IdTabTyp;

6729: l_EmpJobIdTab PA_PLSQL_DATATYPES.IdTabTyp;
6730: l_po_numberTab PA_PLSQL_DATATYPES.Char20TabTyp; /* cwk */
6731: l_po_header_idTab PA_PLSQL_DATATYPES.IdTabTyp;
6732: l_po_line_numTab PA_PLSQL_DATATYPES.NumTabTyp;
6733: l_po_line_idTab PA_PLSQL_DATATYPES.IdTabTyp;
6734: l_person_typeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6735: l_po_price_typeTab PA_PLSQL_DATATYPES.Char20TabTyp;
6736: l_wip_resource_idTab PA_PLSQL_DATATYPES.IdTabTyp;
6737: l_inventory_item_idTab PA_PLSQL_DATATYPES.IdTabTyp;

Line 6734: l_person_typeTab PA_PLSQL_DATATYPES.Char30TabTyp;

6730: l_po_numberTab PA_PLSQL_DATATYPES.Char20TabTyp; /* cwk */
6731: l_po_header_idTab PA_PLSQL_DATATYPES.IdTabTyp;
6732: l_po_line_numTab PA_PLSQL_DATATYPES.NumTabTyp;
6733: l_po_line_idTab PA_PLSQL_DATATYPES.IdTabTyp;
6734: l_person_typeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6735: l_po_price_typeTab PA_PLSQL_DATATYPES.Char20TabTyp;
6736: l_wip_resource_idTab PA_PLSQL_DATATYPES.IdTabTyp;
6737: l_inventory_item_idTab PA_PLSQL_DATATYPES.IdTabTyp;
6738: l_unit_of_measureTab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 6735: l_po_price_typeTab PA_PLSQL_DATATYPES.Char20TabTyp;

6731: l_po_header_idTab PA_PLSQL_DATATYPES.IdTabTyp;
6732: l_po_line_numTab PA_PLSQL_DATATYPES.NumTabTyp;
6733: l_po_line_idTab PA_PLSQL_DATATYPES.IdTabTyp;
6734: l_person_typeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6735: l_po_price_typeTab PA_PLSQL_DATATYPES.Char20TabTyp;
6736: l_wip_resource_idTab PA_PLSQL_DATATYPES.IdTabTyp;
6737: l_inventory_item_idTab PA_PLSQL_DATATYPES.IdTabTyp;
6738: l_unit_of_measureTab PA_PLSQL_DATATYPES.Char30TabTyp;
6739:

Line 6736: l_wip_resource_idTab PA_PLSQL_DATATYPES.IdTabTyp;

6732: l_po_line_numTab PA_PLSQL_DATATYPES.NumTabTyp;
6733: l_po_line_idTab PA_PLSQL_DATATYPES.IdTabTyp;
6734: l_person_typeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6735: l_po_price_typeTab PA_PLSQL_DATATYPES.Char20TabTyp;
6736: l_wip_resource_idTab PA_PLSQL_DATATYPES.IdTabTyp;
6737: l_inventory_item_idTab PA_PLSQL_DATATYPES.IdTabTyp;
6738: l_unit_of_measureTab PA_PLSQL_DATATYPES.Char30TabTyp;
6739:
6740: l_Batch_Size NUMBER;

Line 6737: l_inventory_item_idTab PA_PLSQL_DATATYPES.IdTabTyp;

6733: l_po_line_idTab PA_PLSQL_DATATYPES.IdTabTyp;
6734: l_person_typeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6735: l_po_price_typeTab PA_PLSQL_DATATYPES.Char20TabTyp;
6736: l_wip_resource_idTab PA_PLSQL_DATATYPES.IdTabTyp;
6737: l_inventory_item_idTab PA_PLSQL_DATATYPES.IdTabTyp;
6738: l_unit_of_measureTab PA_PLSQL_DATATYPES.Char30TabTyp;
6739:
6740: l_Batch_Size NUMBER;
6741: l_CommitSizeRecCount NUMBER;

Line 6738: l_unit_of_measureTab PA_PLSQL_DATATYPES.Char30TabTyp;

6734: l_person_typeTab PA_PLSQL_DATATYPES.Char30TabTyp;
6735: l_po_price_typeTab PA_PLSQL_DATATYPES.Char20TabTyp;
6736: l_wip_resource_idTab PA_PLSQL_DATATYPES.IdTabTyp;
6737: l_inventory_item_idTab PA_PLSQL_DATATYPES.IdTabTyp;
6738: l_unit_of_measureTab PA_PLSQL_DATATYPES.Char30TabTyp;
6739:
6740: l_Batch_Size NUMBER;
6741: l_CommitSizeRecCount NUMBER;
6742: l_BatchRecCount NUMBER;

Line 6755: l_job_idtab PA_PLSQL_DATATYPES.IdTabTyp;

6751:
6752: l_src_system_linkage_function VARCHAR2(30); -- 4057874
6753:
6754: -- 10253400: Payroll integration enhancement for 12.2.. start
6755: l_job_idtab PA_PLSQL_DATATYPES.IdTabTyp;
6756: l_job_nametab PA_PLSQL_DATATYPES.Char80TabTyp;
6757: l_location_idtab PA_PLSQL_DATATYPES.IdTabTyp;
6758: l_location_codetab PA_PLSQL_DATATYPES.Char60TabTyp;
6759: l_pay_element_type_idtab PA_PLSQL_DATATYPES.IdTabTyp;

Line 6756: l_job_nametab PA_PLSQL_DATATYPES.Char80TabTyp;

6752: l_src_system_linkage_function VARCHAR2(30); -- 4057874
6753:
6754: -- 10253400: Payroll integration enhancement for 12.2.. start
6755: l_job_idtab PA_PLSQL_DATATYPES.IdTabTyp;
6756: l_job_nametab PA_PLSQL_DATATYPES.Char80TabTyp;
6757: l_location_idtab PA_PLSQL_DATATYPES.IdTabTyp;
6758: l_location_codetab PA_PLSQL_DATATYPES.Char60TabTyp;
6759: l_pay_element_type_idtab PA_PLSQL_DATATYPES.IdTabTyp;
6760: l_pay_element_nametab PA_PLSQL_DATATYPES.Char80TabTyp;

Line 6757: l_location_idtab PA_PLSQL_DATATYPES.IdTabTyp;

6753:
6754: -- 10253400: Payroll integration enhancement for 12.2.. start
6755: l_job_idtab PA_PLSQL_DATATYPES.IdTabTyp;
6756: l_job_nametab PA_PLSQL_DATATYPES.Char80TabTyp;
6757: l_location_idtab PA_PLSQL_DATATYPES.IdTabTyp;
6758: l_location_codetab PA_PLSQL_DATATYPES.Char60TabTyp;
6759: l_pay_element_type_idtab PA_PLSQL_DATATYPES.IdTabTyp;
6760: l_pay_element_nametab PA_PLSQL_DATATYPES.Char80TabTyp;
6761: l_pay_element_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 6758: l_location_codetab PA_PLSQL_DATATYPES.Char60TabTyp;

6754: -- 10253400: Payroll integration enhancement for 12.2.. start
6755: l_job_idtab PA_PLSQL_DATATYPES.IdTabTyp;
6756: l_job_nametab PA_PLSQL_DATATYPES.Char80TabTyp;
6757: l_location_idtab PA_PLSQL_DATATYPES.IdTabTyp;
6758: l_location_codetab PA_PLSQL_DATATYPES.Char60TabTyp;
6759: l_pay_element_type_idtab PA_PLSQL_DATATYPES.IdTabTyp;
6760: l_pay_element_nametab PA_PLSQL_DATATYPES.Char80TabTyp;
6761: l_pay_element_tab PA_PLSQL_DATATYPES.Char30TabTyp;
6762: -- 10253400: Payroll integration enhancement for 12.2.. end

Line 6759: l_pay_element_type_idtab PA_PLSQL_DATATYPES.IdTabTyp;

6755: l_job_idtab PA_PLSQL_DATATYPES.IdTabTyp;
6756: l_job_nametab PA_PLSQL_DATATYPES.Char80TabTyp;
6757: l_location_idtab PA_PLSQL_DATATYPES.IdTabTyp;
6758: l_location_codetab PA_PLSQL_DATATYPES.Char60TabTyp;
6759: l_pay_element_type_idtab PA_PLSQL_DATATYPES.IdTabTyp;
6760: l_pay_element_nametab PA_PLSQL_DATATYPES.Char80TabTyp;
6761: l_pay_element_tab PA_PLSQL_DATATYPES.Char30TabTyp;
6762: -- 10253400: Payroll integration enhancement for 12.2.. end
6763:

Line 6760: l_pay_element_nametab PA_PLSQL_DATATYPES.Char80TabTyp;

6756: l_job_nametab PA_PLSQL_DATATYPES.Char80TabTyp;
6757: l_location_idtab PA_PLSQL_DATATYPES.IdTabTyp;
6758: l_location_codetab PA_PLSQL_DATATYPES.Char60TabTyp;
6759: l_pay_element_type_idtab PA_PLSQL_DATATYPES.IdTabTyp;
6760: l_pay_element_nametab PA_PLSQL_DATATYPES.Char80TabTyp;
6761: l_pay_element_tab PA_PLSQL_DATATYPES.Char30TabTyp;
6762: -- 10253400: Payroll integration enhancement for 12.2.. end
6763:
6764: -- l_agreement_idTab PA_PLSQL_DATATYPES.IdTabTyp; --FSIO Changes

Line 6761: l_pay_element_tab PA_PLSQL_DATATYPES.Char30TabTyp;

6757: l_location_idtab PA_PLSQL_DATATYPES.IdTabTyp;
6758: l_location_codetab PA_PLSQL_DATATYPES.Char60TabTyp;
6759: l_pay_element_type_idtab PA_PLSQL_DATATYPES.IdTabTyp;
6760: l_pay_element_nametab PA_PLSQL_DATATYPES.Char80TabTyp;
6761: l_pay_element_tab PA_PLSQL_DATATYPES.Char30TabTyp;
6762: -- 10253400: Payroll integration enhancement for 12.2.. end
6763:
6764: -- l_agreement_idTab PA_PLSQL_DATATYPES.IdTabTyp; --FSIO Changes
6765: -- l_agreement_numberTab PA_PLSQL_DATATYPES.Char50TabTyp;

Line 6764: -- l_agreement_idTab PA_PLSQL_DATATYPES.IdTabTyp; --FSIO Changes

6760: l_pay_element_nametab PA_PLSQL_DATATYPES.Char80TabTyp;
6761: l_pay_element_tab PA_PLSQL_DATATYPES.Char30TabTyp;
6762: -- 10253400: Payroll integration enhancement for 12.2.. end
6763:
6764: -- l_agreement_idTab PA_PLSQL_DATATYPES.IdTabTyp; --FSIO Changes
6765: -- l_agreement_numberTab PA_PLSQL_DATATYPES.Char50TabTyp;
6766:
6767: -- Start: Added for bug 16220146
6768: l_cbs_element_idtab PA_PLSQL_DATATYPES.Num15TabTyp;

Line 6765: -- l_agreement_numberTab PA_PLSQL_DATATYPES.Char50TabTyp;

6761: l_pay_element_tab PA_PLSQL_DATATYPES.Char30TabTyp;
6762: -- 10253400: Payroll integration enhancement for 12.2.. end
6763:
6764: -- l_agreement_idTab PA_PLSQL_DATATYPES.IdTabTyp; --FSIO Changes
6765: -- l_agreement_numberTab PA_PLSQL_DATATYPES.Char50TabTyp;
6766:
6767: -- Start: Added for bug 16220146
6768: l_cbs_element_idtab PA_PLSQL_DATATYPES.Num15TabTyp;
6769: l_cbs_element_nametab PA_PLSQL_DATATYPES.Char250TabTyp;

Line 6768: l_cbs_element_idtab PA_PLSQL_DATATYPES.Num15TabTyp;

6764: -- l_agreement_idTab PA_PLSQL_DATATYPES.IdTabTyp; --FSIO Changes
6765: -- l_agreement_numberTab PA_PLSQL_DATATYPES.Char50TabTyp;
6766:
6767: -- Start: Added for bug 16220146
6768: l_cbs_element_idtab PA_PLSQL_DATATYPES.Num15TabTyp;
6769: l_cbs_element_nametab PA_PLSQL_DATATYPES.Char250TabTyp;
6770: -- End: Added for bug 16220146
6771:
6772: /* Added for bug 13554435 */

Line 6769: l_cbs_element_nametab PA_PLSQL_DATATYPES.Char250TabTyp;

6765: -- l_agreement_numberTab PA_PLSQL_DATATYPES.Char50TabTyp;
6766:
6767: -- Start: Added for bug 16220146
6768: l_cbs_element_idtab PA_PLSQL_DATATYPES.Num15TabTyp;
6769: l_cbs_element_nametab PA_PLSQL_DATATYPES.Char250TabTyp;
6770: -- End: Added for bug 16220146
6771:
6772: /* Added for bug 13554435 */
6773: PROCEDURE populate_person_type ( p_person_id IN NUMBER

Line 10499: l_ExpItemId_temp_Tab PA_PLSQL_DATATYPES.Num15TabTyp;

10495: l_sys_ref2 NUMBER ;
10496: l_sys_ref3 NUMBER ;
10497: l_sys_ref4 VARCHAR2(30) ;
10498: l_doc_dist_id pa_bc_packets.document_distribution_id%TYPE ;
10499: l_ExpItemId_temp_Tab PA_PLSQL_DATATYPES.Num15TabTyp;
10500: l_budget_ccid NUMBER ;
10501: l_old_pkt NUMBER := 0;
10502: l_project_id NUMBER ;
10503: l_bc_pkt_id pa_bc_packets.bc_packet_id%TYPE;