APPS.PA_TRX_IMPORT dependencies on PA_EXPENDITURES

Line 2783: --pa_expenditures_all.incurred_by_organization_id and G_Job_Id should be populated

2779: END IF ;
2780:
2781:
2782: --Bug 2719674: For AP EXPENSE, G_Org_Id equivalent to
2783: --pa_expenditures_all.incurred_by_organization_id and G_Job_Id should be populated
2784: --Since these values are derived while forming the grouping attributes,
2785: --just reuse the values.
2786: /* Bug 6498029: Base Bug 6339005: added OR ( X_trx_src= 'AP NRTAX' and X_system_linkage = 'ER' ) condition for populating G_Job_id if transaction source is 'Non-Recoverable Tax From Payables' */
2787: If ( X_trx_src= 'AP EXPENSE' OR ( X_trx_src= 'AP NRTAX' and X_system_linkage = 'ER' )) Then

Line 5388: from pa_expenditure_items ei, pa_expenditures exp

5384:
5385: /* Bug 4098920
5386: select sum(denom_raw_cost)
5387: into l_costed
5388: from pa_expenditure_items ei, pa_expenditures exp
5389: where ei.cost_distributed_flag = 'Y'
5390: and ei.project_id = G_project_id
5391: and ei.task_id = G_task_id
5392: and ei.po_line_id = P_Po_Line_Id

Line 5402: from pa_expenditure_items ei, pa_expenditures exp

5398:
5399: /*
5400: select sum(quantity)*l_po_rate
5401: into l_uncosted
5402: from pa_expenditure_items ei, pa_expenditures exp
5403: where ei.cost_distributed_flag = 'N'
5404: and ei.project_id = G_project_id
5405: and ei.task_id = G_task_id
5406: and ei.po_line_id = P_Po_Line_Id

Line 5418: from pa_expenditure_items ei, pa_expenditures exp

5414: into l_uncosted
5415: From
5416: (
5417: select ei.project_id , ei.task_id , ei.po_price_type , sum(quantity) Quantity
5418: from pa_expenditure_items ei, pa_expenditures exp
5419: where ei.cost_distributed_flag = 'N'
5420: and ei.project_id = G_project_id
5421: and ei.task_id = G_task_id
5422: and ei.po_line_id = P_Po_Line_Id

Line 5450: from pa_expenditure_items ei, pa_expenditures exp

5446: (
5447: select ei.po_price_type , ei.cost_distributed_flag,
5448: Sum(Decode(ei.cost_distributed_flag, 'N', ei.quantity,0)) Quantity,
5449: Sum(Decode(ei.cost_distributed_flag, 'Y', ei.denom_raw_cost,0)) denom_raw_cost
5450: from pa_expenditure_items ei, pa_expenditures exp
5451: where ei.project_id = G_project_id
5452: and ei.task_id = G_task_id
5453: and ei.po_line_id = P_Po_Line_Id
5454: and ei.system_linkage_function in ('ST','OT')

Line 5984: X_org_name := pa_expenditures_utils.getorgtlname(pa_utils.GetEmpOrgId(X_emp_id, expenditure_item_date));

5980: if X_emp_id is null then
5981: RETURN NULL;
5982: else
5983:
5984: X_org_name := pa_expenditures_utils.getorgtlname(pa_utils.GetEmpOrgId(X_emp_id, expenditure_item_date));
5985:
5986: G_OrgNameEmpNum := employee_number;
5987: G_OrgNameDate := expenditure_item_date;
5988: G_OrgNameBGName := business_group_name;

Line 7017: SELECT pa_expenditures_s.nextval

7013:
7014: G_expenditure_id := l_Expenditure_Id;
7015:
7016: ELSE
7017: SELECT pa_expenditures_s.nextval
7018: INTO G_expenditure_id
7019: FROM sys.dual;
7020: END IF;
7021:

Line 7114: UPDATE pa_expenditures

7110: pa_debug.G_err_Stage := 'Updating exp for SST';
7111: log_message('log_message: ' || pa_debug.G_err_Stage);
7112: END IF;
7113:
7114: UPDATE pa_expenditures
7115: SET expenditure_group = group_name
7116: WHERE expenditure_id = G_expenditure_id;
7117:
7118: ELSE