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_ALL

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 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 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