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