eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_TRX_IMPORT dependencies on PA_EXPENDITURE_ITEMS

Line 128: G_CrossChargeType pa_expenditure_items_all.cc_cross_charge_type%TYPE;

124: /* added for the bug# 1428216, ends here */
125: -- End SST Changes
126:
127: -- IC Changes
128: G_CrossChargeType pa_expenditure_items_all.cc_cross_charge_type%TYPE;
129: G_CrossChargeCode pa_expenditure_items_all.cc_cross_charge_code%TYPE;
130: G_PrvdrOrganizationId hr_organization_units.organization_id%TYPE;
131: G_RecvrOrganizationId hr_organization_units.organization_id%TYPE;
132: G_RecvrOrgId hr_organization_units.organization_id%TYPE;

Line 129: G_CrossChargeCode pa_expenditure_items_all.cc_cross_charge_code%TYPE;

125: -- End SST Changes
126:
127: -- IC Changes
128: G_CrossChargeType pa_expenditure_items_all.cc_cross_charge_type%TYPE;
129: G_CrossChargeCode pa_expenditure_items_all.cc_cross_charge_code%TYPE;
130: G_PrvdrOrganizationId hr_organization_units.organization_id%TYPE;
131: G_RecvrOrganizationId hr_organization_units.organization_id%TYPE;
132: G_RecvrOrgId hr_organization_units.organization_id%TYPE;
133: G_BrowLentDistCode pa_expenditure_items_all.cc_bl_distributed_code%TYPE;

Line 133: G_BrowLentDistCode pa_expenditure_items_all.cc_bl_distributed_code%TYPE;

129: G_CrossChargeCode pa_expenditure_items_all.cc_cross_charge_code%TYPE;
130: G_PrvdrOrganizationId hr_organization_units.organization_id%TYPE;
131: G_RecvrOrganizationId hr_organization_units.organization_id%TYPE;
132: G_RecvrOrgId hr_organization_units.organization_id%TYPE;
133: G_BrowLentDistCode pa_expenditure_items_all.cc_bl_distributed_code%TYPE;
134: G_IcProcessed_Code pa_expenditure_items_all.cc_ic_processed_code%TYPE;
135: -- END IC Changes
136: current_etype_classcode VARCHAR2(100) DEFAULT NULL;
137:

Line 134: G_IcProcessed_Code pa_expenditure_items_all.cc_ic_processed_code%TYPE;

130: G_PrvdrOrganizationId hr_organization_units.organization_id%TYPE;
131: G_RecvrOrganizationId hr_organization_units.organization_id%TYPE;
132: G_RecvrOrgId hr_organization_units.organization_id%TYPE;
133: G_BrowLentDistCode pa_expenditure_items_all.cc_bl_distributed_code%TYPE;
134: G_IcProcessed_Code pa_expenditure_items_all.cc_ic_processed_code%TYPE;
135: -- END IC Changes
136: current_etype_classcode VARCHAR2(100) DEFAULT NULL;
137:
138: -- Oct 2001 Enhanced Period Processing

Line 1003: FROM pa_expenditure_items ei

999: FROM
1000: sys.dual
1001: WHERE EXISTS
1002: ( SELECT 1
1003: FROM pa_expenditure_items ei
1004: WHERE ei.orig_transaction_reference = X_trx_ref
1005: AND ei.transaction_source = X_trx_source );
1006:
1007: EXCEPTION

Line 4136: pa_expenditure_items

4132: expenditure_item_id
4133: INTO
4134: dummy
4135: FROM
4136: pa_expenditure_items
4137: WHERE
4138: expenditure_item_id = G_adj_item_id
4139: FOR UPDATE NOWAIT;
4140:

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 5105: p_dff_name => 'PA_EXPENDITURE_ITEMS_DESC_FLEX',

5101: log_message('log_message: ' || pa_debug.G_err_Stage);
5102: END IF;
5103:
5104: pa_transactions_pub.validate_dff(
5105: p_dff_name => 'PA_EXPENDITURE_ITEMS_DESC_FLEX',
5106: p_attribute_category => X_att_cat,
5107: p_attribute1 => X_att1,
5108: p_attribute2 => X_att2,
5109: p_attribute3 => X_att3,

Line 9601: pa_expenditure_items c

9597: a.budget_line_id ,
9598: a.budget_version_id
9599: from pa_bc_packets a,
9600: pa_transaction_interface b,-- moac changes
9601: pa_expenditure_items c
9602: where a.txn_interface_id = b.txn_interface_id
9603: and a.document_header_id = b.expenditure_item_id
9604: and a.document_distribution_id = 1
9605: and a.document_type = decode(p_calling_mode, 'AP DISCOUNTS', 'EXP')

Line 9686: l_exp_item_id pa_expenditure_items_all.expenditure_item_id%TYPE;

9682: l_budget_ccid NUMBER ;
9683: l_old_pkt NUMBER := 0;
9684: l_project_id NUMBER ;
9685: l_bc_pkt_id pa_bc_packets.bc_packet_id%TYPE;
9686: l_exp_item_id pa_expenditure_items_all.expenditure_item_id%TYPE;
9687: l_budget_line_id pa_bc_packets.budget_line_id%TYPE;
9688: l_budget_version_id pa_bc_packets.budget_version_id%TYPE;
9689:
9690:

Line 9854: from pa_expenditure_items_all ei

9850: l_ExpItemId_temp_Tab.DELETE ;
9851:
9852: select ei.expenditure_item_id
9853: bulk collect into l_ExpItemId_temp_Tab
9854: from pa_expenditure_items_all ei
9855: where ei.document_header_id = l_sys_ref2
9856: and ei.document_distribution_id = DECODE(p_calling_mode,'AP VARIANCE',l_doc_dist_id,'AP ERV',l_doc_dist_id,l_sys_ref4); -- Bug 5560524
9857:
9858: IF l_ExpItemId_temp_Tab.COUNT > 0 THEN

Line 9949: from pa_expenditure_items_all ei

9945: l_ExpItemId_temp_Tab.DELETE ;
9946:
9947: select ei.expenditure_item_id
9948: bulk collect into l_ExpItemId_temp_Tab
9949: from pa_expenditure_items_all ei
9950: where ei.document_header_id = l_sys_ref2
9951: and ei.document_distribution_id = l_doc_dist_id; /*REL12 : AP Lines Uptake changes*/
9952:
9953: IF l_ExpItemId_temp_Tab.COUNT > 0 THEN

Line 10048: from pa_expenditure_items_all ei

10044: l_ExpItemId_temp_Tab.DELETE ;
10045:
10046: select ei.expenditure_item_id
10047: bulk collect into l_ExpItemId_temp_Tab
10048: from pa_expenditure_items_all ei
10049: where ei.document_header_id = l_sys_ref2
10050: and ei.document_distribution_id = l_doc_dist_id
10051: and ei.document_payment_id = to_number(l_sys_ref4);
10052:

Line 11212: , p_vendor_id In Number /* Bug# 3601024 : Vendor ID is not passed to the PA_EXPENDITURE_ITEMS_ALL.VENDOR_ID in OTL timecards */

11208: , P_po_header_id IN NUMBER
11209: , P_po_line_id IN NUMBER
11210: , P_person_type IN VARCHAR2
11211: , P_po_price_type IN VARCHAR2
11212: , p_vendor_id In Number /* Bug# 3601024 : Vendor ID is not passed to the PA_EXPENDITURE_ITEMS_ALL.VENDOR_ID in OTL timecards */
11213: )
11214: IS
11215:
11216: temp_status VARCHAR2(30) DEFAULT NULL;

Line 11250: G_Vendor_Id := P_Vendor_ID; /* Bug# 3601024 : Vendor ID is not passed to the PA_EXPENDITURE_ITEMS_ALL.VENDOR_ID in OTL timecards */

11246: G_Person_Id := P_Person_Id;
11247:
11248: G_Org_Id := P_Emp_Org_Id;
11249:
11250: G_Vendor_Id := P_Vendor_ID; /* Bug# 3601024 : Vendor ID is not passed to the PA_EXPENDITURE_ITEMS_ALL.VENDOR_ID in OTL timecards */
11251:
11252: /*S.N. 5297060*/
11253: IF X_match_flag = 'N' THEN
11254:

Line 11412: pa_expenditure_items

11408: expenditure_item_id
11409: INTO
11410: dummy
11411: FROM
11412: pa_expenditure_items
11413: WHERE
11414: expenditure_item_id = G_adj_item_id
11415: FOR UPDATE NOWAIT;
11416: