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_FIN_PLAN_UTILS2 dependencies on PA_VARCHAR2_30_TBL_TYPE

Line 26: p_resource_class_code_tab IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE

22: * If old and new UOM values are different then x_uom_changed_flag_tab will be set to 'Y'
23: * NOTE: Since this is PLSQL table LOOPING , this api should be called in batch of 100 records only
24: */
25: PROCEDURE Get_UOM_RateBasedFlag (
26: p_resource_class_code_tab IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
27: ,p_inventory_item_id_tab IN SYSTEM.PA_NUM_TBL_TYPE
28: ,p_rate_organization_id_tab IN SYSTEM.PA_NUM_TBL_TYPE
29: ,p_expenditure_type_tab IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
30: ,p_rate_expenditure_type_tab IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE

Line 29: ,p_expenditure_type_tab IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE

25: PROCEDURE Get_UOM_RateBasedFlag (
26: p_resource_class_code_tab IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
27: ,p_inventory_item_id_tab IN SYSTEM.PA_NUM_TBL_TYPE
28: ,p_rate_organization_id_tab IN SYSTEM.PA_NUM_TBL_TYPE
29: ,p_expenditure_type_tab IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
30: ,p_rate_expenditure_type_tab IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
31: ,p_old_UOM_tab IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
32: ,p_old_rate_based_flag_tab IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
33: ,x_New_UOM_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE

Line 30: ,p_rate_expenditure_type_tab IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE

26: p_resource_class_code_tab IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
27: ,p_inventory_item_id_tab IN SYSTEM.PA_NUM_TBL_TYPE
28: ,p_rate_organization_id_tab IN SYSTEM.PA_NUM_TBL_TYPE
29: ,p_expenditure_type_tab IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
30: ,p_rate_expenditure_type_tab IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
31: ,p_old_UOM_tab IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
32: ,p_old_rate_based_flag_tab IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
33: ,x_New_UOM_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
34: ,x_uom_changed_flag_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE

Line 31: ,p_old_UOM_tab IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE

27: ,p_inventory_item_id_tab IN SYSTEM.PA_NUM_TBL_TYPE
28: ,p_rate_organization_id_tab IN SYSTEM.PA_NUM_TBL_TYPE
29: ,p_expenditure_type_tab IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
30: ,p_rate_expenditure_type_tab IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
31: ,p_old_UOM_tab IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
32: ,p_old_rate_based_flag_tab IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
33: ,x_New_UOM_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
34: ,x_uom_changed_flag_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE
35: ,x_new_rate_based_flag_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE

Line 33: ,x_New_UOM_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE

29: ,p_expenditure_type_tab IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
30: ,p_rate_expenditure_type_tab IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
31: ,p_old_UOM_tab IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
32: ,p_old_rate_based_flag_tab IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
33: ,x_New_UOM_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
34: ,x_uom_changed_flag_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE
35: ,x_new_rate_based_flag_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE
36: ,x_rate_based_flag_changed_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE
37: ,x_return_status OUT NOCOPY VARCHAR2

Line 328: ,x_cost_rejection_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE

324: ,x_markup_percent_tab OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
325: ,x_txn_currency_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE
326: ,x_cost_txn_curr_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE
327: ,x_rev_txn_curr_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE
328: ,x_cost_rejection_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
329: ,x_burden_rejection_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
330: ,x_revenue_rejection_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
331: ,x_return_status OUT NOCOPY VARCHAR2
332: ,x_msg_data OUT NOCOPY VARCHAR2

Line 329: ,x_burden_rejection_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE

325: ,x_txn_currency_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE
326: ,x_cost_txn_curr_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE
327: ,x_rev_txn_curr_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE
328: ,x_cost_rejection_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
329: ,x_burden_rejection_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
330: ,x_revenue_rejection_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
331: ,x_return_status OUT NOCOPY VARCHAR2
332: ,x_msg_data OUT NOCOPY VARCHAR2
333: ,x_msg_count OUT NOCOPY NUMBER

Line 330: ,x_revenue_rejection_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE

326: ,x_cost_txn_curr_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE
327: ,x_rev_txn_curr_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE
328: ,x_cost_rejection_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
329: ,x_burden_rejection_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
330: ,x_revenue_rejection_code_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
331: ,x_return_status OUT NOCOPY VARCHAR2
332: ,x_msg_data OUT NOCOPY VARCHAR2
333: ,x_msg_count OUT NOCOPY NUMBER
334: ) ;