APPS.PA_TRX_IMPORT dependencies on PA_EXPENDITURES

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

2516: END IF ;
2517:
2518:
2519: --Bug 2719674: For AP EXPENSE, G_Org_Id equivalent to
2520: --pa_expenditures_all.incurred_by_organization_id and G_Job_Id should be populated
2521: --Since these values are derived while forming the grouping attributes,
2522: --just reuse the values.
2523: /* 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' */
2524: If ( X_trx_src= 'AP EXPENSE' OR ( X_trx_src= 'AP NRTAX' and X_system_linkage = 'ER' )) Then

Line 4952: from pa_expenditure_items ei, pa_expenditures exp

4948:
4949: /* Bug 4098920
4950: select sum(denom_raw_cost)
4951: into l_costed
4952: from pa_expenditure_items ei, pa_expenditures exp
4953: where ei.cost_distributed_flag = 'Y'
4954: and ei.project_id = G_project_id
4955: and ei.task_id = G_task_id
4956: and ei.po_line_id = P_Po_Line_Id

Line 4966: from pa_expenditure_items ei, pa_expenditures exp

4962:
4963: /*
4964: select sum(quantity)*l_po_rate
4965: into l_uncosted
4966: from pa_expenditure_items ei, pa_expenditures exp
4967: where ei.cost_distributed_flag = 'N'
4968: and ei.project_id = G_project_id
4969: and ei.task_id = G_task_id
4970: and ei.po_line_id = P_Po_Line_Id

Line 4982: from pa_expenditure_items ei, pa_expenditures exp

4978: into l_uncosted
4979: From
4980: (
4981: select ei.project_id , ei.task_id , ei.po_price_type , sum(quantity) Quantity
4982: from pa_expenditure_items ei, pa_expenditures exp
4983: where ei.cost_distributed_flag = 'N'
4984: and ei.project_id = G_project_id
4985: and ei.task_id = G_task_id
4986: and ei.po_line_id = P_Po_Line_Id

Line 5014: from pa_expenditure_items ei, pa_expenditures exp

5010: (
5011: select ei.po_price_type , ei.cost_distributed_flag,
5012: Sum(Decode(ei.cost_distributed_flag, 'N', ei.quantity,0)) Quantity,
5013: Sum(Decode(ei.cost_distributed_flag, 'Y', ei.denom_raw_cost,0)) denom_raw_cost
5014: from pa_expenditure_items ei, pa_expenditures exp
5015: where ei.project_id = G_project_id
5016: and ei.task_id = G_task_id
5017: and ei.po_line_id = P_Po_Line_Id
5018: and ei.system_linkage_function in ('ST','OT')

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

5516: if X_emp_id is null then
5517: RETURN NULL;
5518: else
5519:
5520: X_org_name := pa_expenditures_utils.getorgtlname(pa_utils.GetEmpOrgId(X_emp_id, expenditure_item_date));
5521:
5522: G_OrgNameEmpNum := employee_number;
5523: G_OrgNameDate := expenditure_item_date;
5524: G_OrgNameBGName := business_group_name;

Line 6454: SELECT pa_expenditures_s.nextval

6450:
6451: G_expenditure_id := l_Expenditure_Id;
6452:
6453: ELSE
6454: SELECT pa_expenditures_s.nextval
6455: INTO G_expenditure_id
6456: FROM sys.dual;
6457: END IF;
6458:

Line 6550: UPDATE pa_expenditures

6546: pa_debug.G_err_Stage := 'Updating exp for SST';
6547: log_message('log_message: ' || pa_debug.G_err_Stage);
6548: END IF;
6549:
6550: UPDATE pa_expenditures
6551: SET expenditure_group = group_name
6552: WHERE expenditure_id = G_expenditure_id;
6553:
6554: ELSE