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.AHL_PRD_LOV_SERVICE_PVT dependencies on AHL_OSP_UTIL_PKG

Line 149: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

145:
146: -- Local Variables for the sql string.
147: l_sql_string VARCHAR2(30000);
148: l_bind_index NUMBER;
149: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
150: -- dynamic cursor
151: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
152:
153: --Local Variables for search results

Line 151: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

147: l_sql_string VARCHAR2(30000);
148: l_bind_index NUMBER;
149: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
150: -- dynamic cursor
151: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
152:
153: --Local Variables for search results
154: l_rownum NUMBER;
155: l_visit_id NUMBER;

Line 285: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

281: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows;
282: l_bind_index := l_bind_index + 1;
283:
284: --open l_cur FOR l_sql_string;
285: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
286: (
287: p_conditions_tbl => l_bindvar_tbl,
288: p_sql_str => l_sql_string,
289: p_x_csr => l_cur

Line 457: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

453:
454: -- Local Variables for the sql string.
455: l_sql_string VARCHAR2(30000);
456: l_bind_index NUMBER;
457: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
458: -- dynamic cursor
459: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
460:
461: --Local Variables for search results

Line 459: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

455: l_sql_string VARCHAR2(30000);
456: l_bind_index NUMBER;
457: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
458: -- dynamic cursor
459: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
460:
461: --Local Variables for search results
462: l_rownum NUMBER;
463: l_uc_header_id NUMBER;

Line 557: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

553: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows ;
554: l_bind_index := l_bind_index + 1;
555:
556: --open l_cur FOR l_sql_string;
557: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
558: (
559: p_conditions_tbl => l_bindvar_tbl,
560: p_sql_str => l_sql_string,
561: p_x_csr => l_cur

Line 723: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

719:
720: -- Local Variables for the sql string.
721: l_sql_string VARCHAR2(30000);
722: l_bind_index NUMBER;
723: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
724: -- dynamic cursor
725: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
726:
727: --Local Variables for search results

Line 725: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

721: l_sql_string VARCHAR2(30000);
722: l_bind_index NUMBER;
723: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
724: -- dynamic cursor
725: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
726:
727: --Local Variables for search results
728: l_rownum NUMBER;
729: l_emp_num mtl_employees_current_view.EMPLOYEE_NUM%type;

Line 841: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

837: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows;
838: l_bind_index := l_bind_index + 1;
839:
840: --open l_cur FOR l_sql_string;
841: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
842: (
843: p_conditions_tbl => l_bindvar_tbl,
844: p_sql_str => l_sql_string,
845: p_x_csr => l_cur

Line 1013: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

1009:
1010: -- Local Variables for the sql string.
1011: l_sql_string VARCHAR2(30000);
1012: l_bind_index NUMBER;
1013: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
1014: -- dynamic cursor
1015: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
1016:
1017: --Local Variables for search results

Line 1015: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

1011: l_sql_string VARCHAR2(30000);
1012: l_bind_index NUMBER;
1013: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
1014: -- dynamic cursor
1015: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
1016:
1017: --Local Variables for search results
1018: l_rownum NUMBER ;
1019: l_Resource_ID NUMBER ;

Line 1106: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

1102: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows;
1103: l_bind_index := l_bind_index + 1;
1104:
1105: --open l_cur FOR l_sql_string;
1106: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
1107: (
1108: p_conditions_tbl => l_bindvar_tbl,
1109: p_sql_str => l_sql_string,
1110: p_x_csr => l_cur

Line 1238: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

1234:
1235: -- Local Variables for the sql string.
1236: l_sql_string VARCHAR2(30000);
1237: l_bind_index NUMBER;
1238: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
1239: -- dynamic cursor
1240: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
1241:
1242: --Local Variables for search results

Line 1240: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

1236: l_sql_string VARCHAR2(30000);
1237: l_bind_index NUMBER;
1238: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
1239: -- dynamic cursor
1240: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
1241:
1242: --Local Variables for search results
1243: l_code FND_LOOKUP_VALUES_VL.lookup_code%type;
1244: l_mean FND_LOOKUP_VALUES_VL.meaning%type;

Line 1299: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

1295: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows+1;
1296: l_bind_index := l_bind_index + 1;
1297:
1298: --open l_cur FOR l_sql_string;
1299: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
1300: (
1301: p_conditions_tbl => l_bindvar_tbl,
1302: p_sql_str => l_sql_string,
1303: p_x_csr => l_cur

Line 1418: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

1414:
1415: -- Local Variables for the sql string.
1416: l_sql_string VARCHAR2(30000);
1417: l_bind_index NUMBER;
1418: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
1419: -- dynamic cursor
1420: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
1421:
1422: --Local Variables for search results

Line 1420: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

1416: l_sql_string VARCHAR2(30000);
1417: l_bind_index NUMBER;
1418: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
1419: -- dynamic cursor
1420: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
1421:
1422: --Local Variables for search results
1423: l_code FND_LOOKUP_VALUES_VL.lookup_code%type;
1424: l_mean FND_LOOKUP_VALUES_VL.meaning%type;

Line 1477: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

1473: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows+1;
1474: l_bind_index := l_bind_index + 1;
1475:
1476: --open l_cur FOR l_sql_string;
1477: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
1478: (
1479: p_conditions_tbl => l_bindvar_tbl,
1480: p_sql_str => l_sql_string,
1481: p_x_csr => l_cur

Line 1640: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

1636:
1637: -- Local Variables for the sql string.
1638: l_sql_string VARCHAR2(30000);
1639: l_bind_index NUMBER;
1640: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
1641: -- dynamic cursor
1642: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
1643:
1644: --Local Variables for search results

Line 1642: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

1638: l_sql_string VARCHAR2(30000);
1639: l_bind_index NUMBER;
1640: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
1641: -- dynamic cursor
1642: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
1643:
1644: --Local Variables for search results
1645: l_rownum NUMBER;
1646: l_wo_oper_id NUMBER;

Line 1749: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

1745: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows;
1746: l_bind_index := l_bind_index + 1;
1747:
1748: --open l_cur FOR l_sql_string;
1749: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
1750: (
1751: p_conditions_tbl => l_bindvar_tbl,
1752: p_sql_str => l_sql_string,
1753: p_x_csr => l_cur

Line 1929: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

1925:
1926: -- Local Variables for the sql string.
1927: l_sql_string VARCHAR2(30000);
1928: l_bind_index NUMBER;
1929: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
1930: -- dynamic cursor
1931: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
1932:
1933: --Local Variables for search results

Line 1931: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

1927: l_sql_string VARCHAR2(30000);
1928: l_bind_index NUMBER;
1929: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
1930: -- dynamic cursor
1931: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
1932:
1933: --Local Variables for search results
1934: l_rownum NUMBER;
1935: l_res_id NUMBER;

Line 2034: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

2030: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows;
2031: l_bind_index := l_bind_index + 1;
2032:
2033: --open l_cur FOR l_sql_string;
2034: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
2035: (
2036: p_conditions_tbl => l_bindvar_tbl,
2037: p_sql_str => l_sql_string,
2038: p_x_csr => l_cur

Line 2200: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

2196:
2197: -- Local Variables for the sql string.
2198: l_sql_string VARCHAR2(30000);
2199: l_bind_index NUMBER;
2200: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
2201: -- dynamic cursor
2202: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
2203:
2204: --Local Variables for search results

Line 2202: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

2198: l_sql_string VARCHAR2(30000);
2199: l_bind_index NUMBER;
2200: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
2201: -- dynamic cursor
2202: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
2203:
2204: --Local Variables for search results
2205: l_rownum NUMBER;
2206: l_ata ahl_mc_relationships_v.ATA_MEANING%type;

Line 2271: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

2267: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows;
2268: l_bind_index := l_bind_index + 1;
2269:
2270: --open l_cur FOR l_sql_string;
2271: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
2272: (
2273: p_conditions_tbl => l_bindvar_tbl,
2274: p_sql_str => l_sql_string,
2275: p_x_csr => l_cur

Line 2433: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

2429:
2430: -- Local Variables for the sql string.
2431: l_sql_string VARCHAR2(30000);
2432: l_bind_index NUMBER;
2433: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
2434: -- dynamic cursor
2435: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
2436:
2437: --Local Variables for search results

Line 2435: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

2431: l_sql_string VARCHAR2(30000);
2432: l_bind_index NUMBER;
2433: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
2434: -- dynamic cursor
2435: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
2436:
2437: --Local Variables for search results
2438: l_rownum NUMBER;
2439: l_ata ahl_mc_relationships_v.ATA_MEANING%type;

Line 2503: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

2499: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows;
2500: l_bind_index := l_bind_index + 1;
2501:
2502: --open l_cur FOR l_sql_string;
2503: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
2504: (
2505: p_conditions_tbl => l_bindvar_tbl,
2506: p_sql_str => l_sql_string,
2507: p_x_csr => l_cur

Line 2653: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

2649:
2650: -- Local Variables for the sql string.
2651: l_sql_string VARCHAR2(30000);
2652: l_bind_index NUMBER;
2653: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
2654: -- dynamic cursor
2655: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
2656:
2657: --Local Variables for search results

Line 2655: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

2651: l_sql_string VARCHAR2(30000);
2652: l_bind_index NUMBER;
2653: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
2654: -- dynamic cursor
2655: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
2656:
2657: --Local Variables for search results
2658: l_rownum NUMBER;
2659: l_serial_num bom_dept_res_instances.SERIAL_NUMBER%type;

Line 2735: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

2731: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows;
2732: l_bind_index := l_bind_index + 1;
2733:
2734: --open l_cur FOR l_sql_string;
2735: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
2736: (
2737: p_conditions_tbl => l_bindvar_tbl,
2738: p_sql_str => l_sql_string,
2739: p_x_csr => l_cur

Line 2883: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

2879:
2880: -- Local Variables for the sql string.
2881: l_sql_string VARCHAR2(30000);
2882: l_bind_index NUMBER;
2883: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
2884: -- dynamic cursor
2885: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
2886:
2887: --Local Variables for search results

Line 2885: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

2881: l_sql_string VARCHAR2(30000);
2882: l_bind_index NUMBER;
2883: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
2884: -- dynamic cursor
2885: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
2886:
2887: --Local Variables for search results
2888: l_rownum NUMBER;
2889: l_serial_num bom_dept_res_instances.SERIAL_NUMBER%type;

Line 2965: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

2961: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows;
2962: l_bind_index := l_bind_index + 1;
2963:
2964: --open l_cur FOR l_sql_string;
2965: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
2966: (
2967: p_conditions_tbl => l_bindvar_tbl,
2968: p_sql_str => l_sql_string,
2969: p_x_csr => l_cur

Line 3122: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

3118:
3119: -- Local Variables for the sql string.
3120: l_sql_string VARCHAR2(30000);
3121: l_bind_index NUMBER;
3122: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
3123: -- dynamic cursor
3124: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
3125:
3126: --Local Variables for search results

Line 3124: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

3120: l_sql_string VARCHAR2(30000);
3121: l_bind_index NUMBER;
3122: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
3123: -- dynamic cursor
3124: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
3125:
3126: --Local Variables for search results
3127: l_rownum NUMBER;
3128: l_serial_num bom_dept_res_instances.SERIAL_NUMBER%type;

Line 3204: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

3200: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows;
3201: l_bind_index := l_bind_index + 1;
3202:
3203: --open l_cur FOR l_sql_string;
3204: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
3205: (
3206: p_conditions_tbl => l_bindvar_tbl,
3207: p_sql_str => l_sql_string,
3208: p_x_csr => l_cur

Line 3343: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

3339:
3340: -- Local Variables for the sql string.
3341: l_sql_string VARCHAR2(30000);
3342: l_bind_index NUMBER;
3343: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
3344: -- dynamic cursor
3345: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
3346:
3347: --Local Variables for search results

Line 3345: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

3341: l_sql_string VARCHAR2(30000);
3342: l_bind_index NUMBER;
3343: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
3344: -- dynamic cursor
3345: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
3346:
3347: --Local Variables for search results
3348: l_rownum NUMBER;
3349: l_status_id NUMBER;

Line 3416: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

3412: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows;
3413: l_bind_index := l_bind_index + 1;
3414:
3415: --open l_cur FOR l_sql_string;
3416: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
3417: (
3418: p_conditions_tbl => l_bindvar_tbl,
3419: p_sql_str => l_sql_string,
3420: p_x_csr => l_cur

Line 3550: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

3546:
3547: -- Local Variables for the sql string.
3548: l_sql_string VARCHAR2(30000);
3549: l_bind_index NUMBER;
3550: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
3551: -- dynamic cursor
3552: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
3553:
3554: --Local Variables for search results

Line 3552: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

3548: l_sql_string VARCHAR2(30000);
3549: l_bind_index NUMBER;
3550: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
3551: -- dynamic cursor
3552: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
3553:
3554: --Local Variables for search results
3555: l_rownum NUMBER;
3556: l_reason_name mtl_transaction_reasons.reason_name%type;

Line 3623: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

3619: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows;
3620: l_bind_index := l_bind_index + 1;
3621:
3622: --open l_cur FOR l_sql_string;
3623: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
3624: (
3625: p_conditions_tbl => l_bindvar_tbl,
3626: p_sql_str => l_sql_string,
3627: p_x_csr => l_cur

Line 3748: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

3744:
3745: -- Local Variables for the sql string.
3746: l_sql_string VARCHAR2(30000);
3747: l_bind_index NUMBER;
3748: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
3749: -- dynamic cursor
3750: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
3751:
3752: --Local Variables for search results

Line 3750: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

3746: l_sql_string VARCHAR2(30000);
3747: l_bind_index NUMBER;
3748: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
3749: -- dynamic cursor
3750: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
3751:
3752: --Local Variables for search results
3753: l_rownum NUMBER;
3754: l_code FND_LOOKUP_VALUES_VL.lookup_code%type;

Line 3813: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

3809: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows;
3810: l_bind_index := l_bind_index + 1;
3811:
3812: --open l_cur FOR l_sql_string;
3813: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
3814: (
3815: p_conditions_tbl => l_bindvar_tbl,
3816: p_sql_str => l_sql_string,
3817: p_x_csr => l_cur

Line 3932: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

3928:
3929: -- Local Variables for the sql string.
3930: l_sql_string VARCHAR2(30000);
3931: l_bind_index NUMBER;
3932: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
3933: -- dynamic cursor
3934: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
3935:
3936: --Local Variables for search results

Line 3934: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

3930: l_sql_string VARCHAR2(30000);
3931: l_bind_index NUMBER;
3932: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
3933: -- dynamic cursor
3934: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
3935:
3936: --Local Variables for search results
3937: l_rownum NUMBER;
3938: l_code FND_LOOKUP_VALUES_VL.lookup_code%type;

Line 3997: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

3993: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows;
3994: l_bind_index := l_bind_index + 1;
3995:
3996: --open l_cur FOR l_sql_string;
3997: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
3998: (
3999: p_conditions_tbl => l_bindvar_tbl,
4000: p_sql_str => l_sql_string,
4001: p_x_csr => l_cur

Line 4116: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

4112:
4113: -- Local Variables for the sql string.
4114: l_sql_string VARCHAR2(30000);
4115: l_bind_index NUMBER;
4116: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
4117: -- dynamic cursor
4118: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
4119:
4120: --Local Variables for search results

Line 4118: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

4114: l_sql_string VARCHAR2(30000);
4115: l_bind_index NUMBER;
4116: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
4117: -- dynamic cursor
4118: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
4119:
4120: --Local Variables for search results
4121: l_rownum NUMBER;
4122: l_code FND_LOOKUP_VALUES_VL.lookup_code%type;

Line 4186: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

4182: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows;
4183: l_bind_index := l_bind_index + 1;
4184:
4185: --open l_cur FOR l_sql_string;
4186: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
4187: (
4188: p_conditions_tbl => l_bindvar_tbl,
4189: p_sql_str => l_sql_string,
4190: p_x_csr => l_cur

Line 4314: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

4310:
4311: -- Local Variables for the sql string.
4312: l_sql_string VARCHAR2(30000);
4313: l_bind_index NUMBER;
4314: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
4315: -- dynamic cursor
4316: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
4317:
4318: --Local Variables for search results

Line 4316: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

4312: l_sql_string VARCHAR2(30000);
4313: l_bind_index NUMBER;
4314: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
4315: -- dynamic cursor
4316: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
4317:
4318: --Local Variables for search results
4319: l_rownum NUMBER;
4320: l_name cs_incident_severities_vl.name%type;

Line 4389: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

4385: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows;
4386: l_bind_index := l_bind_index + 1;
4387:
4388: --open l_cur FOR l_sql_string;
4389: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
4390: (
4391: p_conditions_tbl => l_bindvar_tbl,
4392: p_sql_str => l_sql_string,
4393: p_x_csr => l_cur

Line 4532: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

4528:
4529: -- Local Variables for the sql string.
4530: l_sql_string VARCHAR2(30000);
4531: l_bind_index NUMBER;
4532: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
4533: -- dynamic cursor
4534: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
4535:
4536: --Local Variables for search results

Line 4534: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

4530: l_sql_string VARCHAR2(30000);
4531: l_bind_index NUMBER;
4532: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
4533: -- dynamic cursor
4534: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
4535:
4536: --Local Variables for search results
4537: l_rownum NUMBER;
4538: l_instance csi_item_instances.instance_number%type;

Line 4617: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

4613: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows;
4614: l_bind_index := l_bind_index + 1;
4615:
4616: --open l_cur FOR l_sql_string;
4617: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
4618: (
4619: p_conditions_tbl => l_bindvar_tbl,
4620: p_sql_str => l_sql_string,
4621: p_x_csr => l_cur

Line 4765: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

4761: l_sql_string VARCHAR2(30000);
4762: l_sql_string1 VARCHAR2(30000);
4763: l_sql_string2 VARCHAR2(30000);
4764: l_bind_index NUMBER;
4765: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
4766: -- dynamic cursor
4767: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
4768:
4769: --Local Variables for search results

Line 4767: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

4763: l_sql_string2 VARCHAR2(30000);
4764: l_bind_index NUMBER;
4765: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
4766: -- dynamic cursor
4767: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
4768:
4769: --Local Variables for search results
4770: l_rownum NUMBER;
4771: l_inv_item_id NUMBER;

Line 4856: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

4852: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows;
4853: l_bind_index := l_bind_index + 1;
4854:
4855: --open l_cur FOR l_sql_string;
4856: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
4857: (
4858: p_conditions_tbl => l_bindvar_tbl,
4859: p_sql_str => l_sql_string,
4860: p_x_csr => l_cur