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 1079: FROM pa_expenditure_items ei

1075: FROM
1076: sys.dual
1077: WHERE EXISTS
1078: ( SELECT 1
1079: FROM pa_expenditure_items ei
1080: WHERE ei.orig_transaction_reference = X_trx_ref
1081: AND ei.transaction_source = X_trx_source );
1082:
1083: EXCEPTION

Line 4568: pa_expenditure_items

4564: expenditure_item_id
4565: INTO
4566: dummy
4567: FROM
4568: pa_expenditure_items
4569: WHERE
4570: expenditure_item_id = G_adj_item_id
4571: FOR UPDATE NOWAIT;
4572:

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

5537: log_message('log_message: ' || pa_debug.G_err_Stage);
5538: END IF;
5539:
5540: pa_transactions_pub.validate_dff(
5541: p_dff_name => 'PA_EXPENDITURE_ITEMS_DESC_FLEX',
5542: p_attribute_category => X_att_cat,
5543: p_attribute1 => X_att1,
5544: p_attribute2 => X_att2,
5545: p_attribute3 => X_att3,

Line 10394: pa_expenditure_items c

10390: a.budget_line_id ,
10391: a.budget_version_id
10392: from pa_bc_packets a,
10393: pa_transaction_interface b,-- moac changes
10394: pa_expenditure_items c
10395: where a.txn_interface_id = b.txn_interface_id
10396: and a.document_header_id = b.expenditure_item_id
10397: and a.document_distribution_id = 1
10398: and a.document_type = decode(p_calling_mode, 'AP DISCOUNTS', 'EXP')

Line 10504: l_exp_item_id pa_expenditure_items_all.expenditure_item_id%TYPE;

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;
10504: l_exp_item_id pa_expenditure_items_all.expenditure_item_id%TYPE;
10505: l_budget_line_id pa_bc_packets.budget_line_id%TYPE;
10506: l_budget_version_id pa_bc_packets.budget_version_id%TYPE;
10507:
10508:

Line 10672: from pa_expenditure_items_all ei

10668: l_ExpItemId_temp_Tab.DELETE ;
10669:
10670: select ei.expenditure_item_id
10671: bulk collect into l_ExpItemId_temp_Tab
10672: from pa_expenditure_items_all ei
10673: where ei.document_header_id = l_sys_ref2
10674: 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
10675:
10676: IF l_ExpItemId_temp_Tab.COUNT > 0 THEN

Line 10767: from pa_expenditure_items_all ei

10763: l_ExpItemId_temp_Tab.DELETE ;
10764:
10765: select ei.expenditure_item_id
10766: bulk collect into l_ExpItemId_temp_Tab
10767: from pa_expenditure_items_all ei
10768: where ei.document_header_id = l_sys_ref2
10769: and ei.document_distribution_id = l_doc_dist_id; /*REL12 : AP Lines Uptake changes*/
10770:
10771: IF l_ExpItemId_temp_Tab.COUNT > 0 THEN

Line 10866: from pa_expenditure_items_all ei

10862: l_ExpItemId_temp_Tab.DELETE ;
10863:
10864: select ei.expenditure_item_id
10865: bulk collect into l_ExpItemId_temp_Tab
10866: from pa_expenditure_items_all ei
10867: where ei.document_header_id = l_sys_ref2
10868: and ei.document_distribution_id = l_doc_dist_id
10869: and ei.document_payment_id = to_number(l_sys_ref4);
10870:

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

12089: , P_po_header_id IN NUMBER
12090: , P_po_line_id IN NUMBER
12091: , P_person_type IN VARCHAR2
12092: , P_po_price_type IN VARCHAR2
12093: , p_vendor_id In Number /* Bug# 3601024 : Vendor ID is not passed to the PA_EXPENDITURE_ITEMS_ALL.VENDOR_ID in OTL timecards */
12094: , p_location_id IN NUMBER
12095: , p_cbs_element_id IN NUMBER DEFAULT NULL -- Added for bug 16592018
12096: )
12097: IS

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

12129: G_Person_Id := P_Person_Id;
12130:
12131: G_Org_Id := P_Emp_Org_Id;
12132:
12133: G_Vendor_Id := P_Vendor_ID; /* Bug# 3601024 : Vendor ID is not passed to the PA_EXPENDITURE_ITEMS_ALL.VENDOR_ID in OTL timecards */
12134:
12135: /*S.N. 5297060*/
12136: IF X_match_flag = 'N' THEN
12137:

Line 12297: pa_expenditure_items

12293: expenditure_item_id
12294: INTO
12295: dummy
12296: FROM
12297: pa_expenditure_items
12298: WHERE
12299: expenditure_item_id = G_adj_item_id
12300: FOR UPDATE NOWAIT;
12301:

Line 14987: l_expenditure_item_date pa_expenditure_items_all.expenditure_item_date%TYPE; -- Aded for 16451280

14983: l_rec_bc_comm_exists VARCHAR2(1); -- Variable to identify whether commitment record exists in pa_bc_commitments
14984: l_rec_pkt_comm_exists VARCHAR2(1); -- Variable to identify whether commitment record exists in pa_bc_packets
14985: l_Raw_Bc_Packet_Id pa_bc_packets.bc_packet_id%TYPE;
14986: l_po_line_id po_distributions_all.po_line_id%TYPE;
14987: l_expenditure_item_date pa_expenditure_items_all.expenditure_item_date%TYPE; -- Aded for 16451280
14988:
14989: BEGIN
14990:
14991: IF PG_DEBUG = 'Y' THEN