APPS.AHL_UMP_SMRINSTANCE_PVT dependencies on AHL_OSP_UTIL_PKG

Line 118: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

114: --Fix for Bug 2745891
115: l_early_exit_status boolean;
116: -- Bind variable index and table
117: l_bind_index NUMBER;
118: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
119: -- dynamic cursor
120: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
121: -- Logging purposes
122: l_sql_segment_count NUMBER;

Line 120: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

116: -- Bind variable index and table
117: l_bind_index NUMBER;
118: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
119: -- dynamic cursor
120: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
121: -- Logging purposes
122: l_sql_segment_count NUMBER;
123: -- Added for deferral details.
124: CURSOR ahl_defer_to_ue_csr(p_unit_effectivity_id IN NUMBER) IS

Line 1052: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

1048: l_early_exit_status := false;
1049: END IF;
1050:
1051: --open l_cur FOR l_sql_string;
1052: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
1053: (
1054: p_conditions_tbl => l_bindvar_tbl,
1055: p_sql_str => l_sql_string,
1056: p_x_csr => l_cur

Line 1411: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

1407:
1408: l_unit_related_ii_sql VARCHAR2(4000);
1409:
1410: l_bind_index NUMBER;
1411: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
1412:
1413: -- dynamic cursor
1414: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
1415: --l_instance_id NUMBER;

Line 1414: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

1410: l_bind_index NUMBER;
1411: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
1412:
1413: -- dynamic cursor
1414: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
1415: --l_instance_id NUMBER;
1416:
1417: l_inst_tbl nbr_tbl_type;
1418: l_buffer_limit number := 500;

Line 1494: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

1490: IF p_search_mr_instance_rec.components_flag = 'N' THEN
1491: 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)';
1492: END IF;
1493:
1494: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
1495: (
1496: p_conditions_tbl => l_bindvar_tbl,
1497: p_sql_str => l_unit_related_ii_sql,
1498: p_x_csr => l_cur

Line 1530: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

1526:
1527: l_unit_related_ii_sql VARCHAR2(4000);
1528:
1529: l_bind_index NUMBER;
1530: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
1531:
1532: -- dynamic cursor
1533: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
1534: --l_instance_id NUMBER;

Line 1533: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

1529: l_bind_index NUMBER;
1530: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
1531:
1532: -- dynamic cursor
1533: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
1534: --l_instance_id NUMBER;
1535:
1536: l_inst_tbl nbr_tbl_type;
1537: L_BUFFER_LIMIT NUMBER := 500;

Line 1586: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

1582: L_UNIT_RELATED_II_SQL := L_UNIT_RELATED_II_SQL || 'AND AUS.EST_ARRIVAL_TIME <= NVL(:TO_DATE , AUS.EST_ARRIVAL_TIME) ';
1583: L_BINDVAR_TBL(L_BIND_INDEX) := L_DUE_TO; -- a second before midnight
1584: L_BIND_INDEX := L_BIND_INDEX + 1;
1585: END IF;
1586: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
1587: (
1588: p_conditions_tbl => l_bindvar_tbl,
1589: p_sql_str => l_unit_related_ii_sql,
1590: P_X_CSR => L_CUR

Line 1703: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

1699:
1700: IF NVL(p_search_ump_rec.SHOW_DEPENDENT_REQUIREMENTS,'N') = 'N' THEN
1701: 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)';
1702: END IF;
1703: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
1704: (
1705: p_conditions_tbl => l_bindvar_tbl,
1706: p_sql_str => l_unit_related_ii_sql,
1707: p_x_csr => l_cur