APPS.AHL_UMP_SMRINSTANCE_PVT dependencies on AHL_OSP_UTIL_PKG

Line 113: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

109: --Fix for Bug 2745891
110: l_early_exit_status boolean;
111: -- Bind variable index and table
112: l_bind_index NUMBER;
113: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
114: -- dynamic cursor
115: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
116: -- Logging purposes
117: l_sql_segment_count NUMBER;

Line 115: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

111: -- Bind variable index and table
112: l_bind_index NUMBER;
113: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
114: -- dynamic cursor
115: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
116: -- Logging purposes
117: l_sql_segment_count NUMBER;
118: -- Added for deferral details.
119: CURSOR ahl_defer_to_ue_csr(p_unit_effectivity_id IN NUMBER) IS

Line 919: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

915: l_early_exit_status := false;
916: END IF;
917:
918: --open l_cur FOR l_sql_string;
919: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
920: (
921: p_conditions_tbl => l_bindvar_tbl,
922: p_sql_str => l_sql_string,
923: p_x_csr => l_cur

Line 1220: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

1216:
1217: l_unit_related_ii_sql VARCHAR2(4000);
1218:
1219: l_bind_index NUMBER;
1220: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
1221:
1222: -- dynamic cursor
1223: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
1224: --l_instance_id NUMBER;

Line 1223: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

1219: l_bind_index NUMBER;
1220: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
1221:
1222: -- dynamic cursor
1223: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
1224: --l_instance_id NUMBER;
1225:
1226: l_inst_tbl nbr_tbl_type;
1227: l_buffer_limit number := 500;

Line 1303: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

1299: IF p_search_mr_instance_rec.components_flag = 'N' THEN
1300: l_unit_related_ii_sql := l_unit_related_ii_sql || 'and EXISTS (select ''x'' from ahl_unit_effectivities_b UE where UE.csi_item_instance_id = csii.instance_id)';
1301: END IF;
1302:
1303: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
1304: (
1305: p_conditions_tbl => l_bindvar_tbl,
1306: p_sql_str => l_unit_related_ii_sql,
1307: p_x_csr => l_cur