DBA Data[Home] [Help]

APPS.PA_BUDGET_LINES_UTILS dependencies on PA_NUM_TBL_TYPE

Line 27: l_non_rate_based_asgmt_id_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

23: FROM pa_resource_assignments
24: WHERE budget_version_id = p_budget_version_id
25: AND rate_based_flag = 'N';
26:
27: l_non_rate_based_asgmt_id_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
28: L_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
29: li_curr_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
30:
31: BEGIN

Line 69: p_resource_assignment_id_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type(),

65: procedure Populate_Display_Qty
66: (p_budget_version_id IN NUMBER,
67: p_context IN VARCHAR2,
68: p_use_temp_table_flag IN VARCHAR2 DEFAULT 'N',
69: p_resource_assignment_id_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type(),
70: p_set_disp_qty_null_for_nrbf IN VARCHAR2,
71: x_return_status OUT NOCOPY VARCHAR2) is
72:
73: CURSOR get_rate_based_assignments IS

Line 91: l_rate_based_asgmt_id_tab SYSTEM.pa_num_tbl_type;

87: CURSOR get_rate_based_asgmts_temp_wp IS
88: SELECT resource_assignment_id
89: FROM pa_resource_asgn_curr_tmp;
90:
91: l_rate_based_asgmt_id_tab SYSTEM.pa_num_tbl_type;
92: L_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
93: li_curr_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
94:
95: