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 182: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

178:
179: -- Local Variables for the sql string.
180: l_sql_string VARCHAR2(30000);
181: l_bind_index NUMBER;
182: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
183: -- dynamic cursor
184: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
185:
186: --Local Variables for search results

Line 184: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

180: l_sql_string VARCHAR2(30000);
181: l_bind_index NUMBER;
182: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
183: -- dynamic cursor
184: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
185:
186: --Local Variables for search results
187: l_rownum NUMBER;
188: l_visit_id NUMBER;

Line 318: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

314: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows;
315: l_bind_index := l_bind_index + 1;
316:
317: --open l_cur FOR l_sql_string;
318: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
319: (
320: p_conditions_tbl => l_bindvar_tbl,
321: p_sql_str => l_sql_string,
322: p_x_csr => l_cur

Line 490: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

486:
487: -- Local Variables for the sql string.
488: l_sql_string VARCHAR2(30000);
489: l_bind_index NUMBER;
490: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
491: -- dynamic cursor
492: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
493:
494: --Local Variables for search results

Line 492: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

488: l_sql_string VARCHAR2(30000);
489: l_bind_index NUMBER;
490: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
491: -- dynamic cursor
492: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
493:
494: --Local Variables for search results
495: l_rownum NUMBER;
496: l_uc_header_id NUMBER;

Line 590: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

586: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows ;
587: l_bind_index := l_bind_index + 1;
588:
589: --open l_cur FOR l_sql_string;
590: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
591: (
592: p_conditions_tbl => l_bindvar_tbl,
593: p_sql_str => l_sql_string,
594: p_x_csr => l_cur

Line 756: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

752:
753: -- Local Variables for the sql string.
754: l_sql_string VARCHAR2(30000);
755: l_bind_index NUMBER;
756: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
757: -- dynamic cursor
758: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
759:
760: --Local Variables for search results

Line 758: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

754: l_sql_string VARCHAR2(30000);
755: l_bind_index NUMBER;
756: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
757: -- dynamic cursor
758: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
759:
760: --Local Variables for search results
761: l_rownum NUMBER;
762: l_emp_num mtl_employees_current_view.EMPLOYEE_NUM%type;

Line 874: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

870: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows;
871: l_bind_index := l_bind_index + 1;
872:
873: --open l_cur FOR l_sql_string;
874: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
875: (
876: p_conditions_tbl => l_bindvar_tbl,
877: p_sql_str => l_sql_string,
878: p_x_csr => l_cur

Line 1046: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

1042:
1043: -- Local Variables for the sql string.
1044: l_sql_string VARCHAR2(30000);
1045: l_bind_index NUMBER;
1046: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
1047: -- dynamic cursor
1048: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
1049:
1050: --Local Variables for search results

Line 1048: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

1044: l_sql_string VARCHAR2(30000);
1045: l_bind_index NUMBER;
1046: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
1047: -- dynamic cursor
1048: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
1049:
1050: --Local Variables for search results
1051: l_rownum NUMBER ;
1052: l_Resource_ID NUMBER ;

Line 1139: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

1135: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows;
1136: l_bind_index := l_bind_index + 1;
1137:
1138: --open l_cur FOR l_sql_string;
1139: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
1140: (
1141: p_conditions_tbl => l_bindvar_tbl,
1142: p_sql_str => l_sql_string,
1143: p_x_csr => l_cur

Line 1271: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

1267:
1268: -- Local Variables for the sql string.
1269: l_sql_string VARCHAR2(30000);
1270: l_bind_index NUMBER;
1271: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
1272: -- dynamic cursor
1273: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
1274:
1275: --Local Variables for search results

Line 1273: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

1269: l_sql_string VARCHAR2(30000);
1270: l_bind_index NUMBER;
1271: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
1272: -- dynamic cursor
1273: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
1274:
1275: --Local Variables for search results
1276: l_code FND_LOOKUP_VALUES_VL.lookup_code%type;
1277: l_mean FND_LOOKUP_VALUES_VL.meaning%type;

Line 1332: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

1328: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows+1;
1329: l_bind_index := l_bind_index + 1;
1330:
1331: --open l_cur FOR l_sql_string;
1332: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
1333: (
1334: p_conditions_tbl => l_bindvar_tbl,
1335: p_sql_str => l_sql_string,
1336: p_x_csr => l_cur

Line 1495: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

1491:
1492: -- Local Variables for the sql string.
1493: l_sql_string VARCHAR2(30000);
1494: l_bind_index NUMBER;
1495: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
1496: -- dynamic cursor
1497: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
1498:
1499: --Local Variables for search results

Line 1497: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

1493: l_sql_string VARCHAR2(30000);
1494: l_bind_index NUMBER;
1495: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
1496: -- dynamic cursor
1497: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
1498:
1499: --Local Variables for search results
1500: l_rownum NUMBER;
1501: l_wo_oper_id NUMBER;

Line 1604: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

1600: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows;
1601: l_bind_index := l_bind_index + 1;
1602:
1603: --open l_cur FOR l_sql_string;
1604: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
1605: (
1606: p_conditions_tbl => l_bindvar_tbl,
1607: p_sql_str => l_sql_string,
1608: p_x_csr => l_cur

Line 1784: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

1780:
1781: -- Local Variables for the sql string.
1782: l_sql_string VARCHAR2(30000);
1783: l_bind_index NUMBER;
1784: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
1785: -- dynamic cursor
1786: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
1787:
1788: --Local Variables for search results

Line 1786: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

1782: l_sql_string VARCHAR2(30000);
1783: l_bind_index NUMBER;
1784: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
1785: -- dynamic cursor
1786: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
1787:
1788: --Local Variables for search results
1789: l_rownum NUMBER;
1790: l_res_id NUMBER;

Line 1889: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

1885: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows;
1886: l_bind_index := l_bind_index + 1;
1887:
1888: --open l_cur FOR l_sql_string;
1889: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
1890: (
1891: p_conditions_tbl => l_bindvar_tbl,
1892: p_sql_str => l_sql_string,
1893: p_x_csr => l_cur

Line 2055: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

2051:
2052: -- Local Variables for the sql string.
2053: l_sql_string VARCHAR2(30000);
2054: l_bind_index NUMBER;
2055: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
2056: -- dynamic cursor
2057: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
2058:
2059: --Local Variables for search results

Line 2057: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

2053: l_sql_string VARCHAR2(30000);
2054: l_bind_index NUMBER;
2055: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
2056: -- dynamic cursor
2057: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
2058:
2059: --Local Variables for search results
2060: l_rownum NUMBER;
2061: l_ata ahl_mc_relationships_v.ATA_MEANING%type;

Line 2125: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

2121: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows;
2122: l_bind_index := l_bind_index + 1;
2123:
2124: --open l_cur FOR l_sql_string;
2125: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
2126: (
2127: p_conditions_tbl => l_bindvar_tbl,
2128: p_sql_str => l_sql_string,
2129: p_x_csr => l_cur

Line 2287: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

2283:
2284: -- Local Variables for the sql string.
2285: l_sql_string VARCHAR2(30000);
2286: l_bind_index NUMBER;
2287: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
2288: -- dynamic cursor
2289: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
2290:
2291: --Local Variables for search results

Line 2289: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

2285: l_sql_string VARCHAR2(30000);
2286: l_bind_index NUMBER;
2287: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
2288: -- dynamic cursor
2289: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
2290:
2291: --Local Variables for search results
2292: l_rownum NUMBER;
2293: l_ata ahl_mc_relationships_v.ATA_MEANING%type;

Line 2357: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

2353: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows;
2354: l_bind_index := l_bind_index + 1;
2355:
2356: --open l_cur FOR l_sql_string;
2357: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
2358: (
2359: p_conditions_tbl => l_bindvar_tbl,
2360: p_sql_str => l_sql_string,
2361: p_x_csr => l_cur

Line 2507: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

2503:
2504: -- Local Variables for the sql string.
2505: l_sql_string VARCHAR2(30000);
2506: l_bind_index NUMBER;
2507: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
2508: -- dynamic cursor
2509: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
2510:
2511: --Local Variables for search results

Line 2509: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

2505: l_sql_string VARCHAR2(30000);
2506: l_bind_index NUMBER;
2507: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
2508: -- dynamic cursor
2509: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
2510:
2511: --Local Variables for search results
2512: l_rownum NUMBER;
2513: l_serial_num bom_dept_res_instances.SERIAL_NUMBER%type;

Line 2589: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

2585: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows;
2586: l_bind_index := l_bind_index + 1;
2587:
2588: --open l_cur FOR l_sql_string;
2589: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
2590: (
2591: p_conditions_tbl => l_bindvar_tbl,
2592: p_sql_str => l_sql_string,
2593: p_x_csr => l_cur

Line 2737: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

2733:
2734: -- Local Variables for the sql string.
2735: l_sql_string VARCHAR2(30000);
2736: l_bind_index NUMBER;
2737: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
2738: -- dynamic cursor
2739: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
2740:
2741: --Local Variables for search results

Line 2739: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

2735: l_sql_string VARCHAR2(30000);
2736: l_bind_index NUMBER;
2737: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
2738: -- dynamic cursor
2739: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
2740:
2741: --Local Variables for search results
2742: l_rownum NUMBER;
2743: l_serial_num bom_dept_res_instances.SERIAL_NUMBER%type;

Line 2819: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

2815: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows;
2816: l_bind_index := l_bind_index + 1;
2817:
2818: --open l_cur FOR l_sql_string;
2819: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
2820: (
2821: p_conditions_tbl => l_bindvar_tbl,
2822: p_sql_str => l_sql_string,
2823: p_x_csr => l_cur

Line 2976: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

2972:
2973: -- Local Variables for the sql string.
2974: l_sql_string VARCHAR2(30000);
2975: l_bind_index NUMBER;
2976: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
2977: -- dynamic cursor
2978: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
2979:
2980: --Local Variables for search results

Line 2978: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

2974: l_sql_string VARCHAR2(30000);
2975: l_bind_index NUMBER;
2976: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
2977: -- dynamic cursor
2978: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
2979:
2980: --Local Variables for search results
2981: l_rownum NUMBER;
2982: l_serial_num bom_dept_res_instances.SERIAL_NUMBER%type;

Line 3058: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

3054: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows;
3055: l_bind_index := l_bind_index + 1;
3056:
3057: --open l_cur FOR l_sql_string;
3058: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
3059: (
3060: p_conditions_tbl => l_bindvar_tbl,
3061: p_sql_str => l_sql_string,
3062: p_x_csr => l_cur

Line 3197: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

3193:
3194: -- Local Variables for the sql string.
3195: l_sql_string VARCHAR2(30000);
3196: l_bind_index NUMBER;
3197: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
3198: -- dynamic cursor
3199: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
3200:
3201: --Local Variables for search results

Line 3199: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

3195: l_sql_string VARCHAR2(30000);
3196: l_bind_index NUMBER;
3197: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
3198: -- dynamic cursor
3199: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
3200:
3201: --Local Variables for search results
3202: l_rownum NUMBER;
3203: l_status_id NUMBER;

Line 3270: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

3266: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows;
3267: l_bind_index := l_bind_index + 1;
3268:
3269: --open l_cur FOR l_sql_string;
3270: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
3271: (
3272: p_conditions_tbl => l_bindvar_tbl,
3273: p_sql_str => l_sql_string,
3274: p_x_csr => l_cur

Line 3404: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

3400:
3401: -- Local Variables for the sql string.
3402: l_sql_string VARCHAR2(30000);
3403: l_bind_index NUMBER;
3404: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
3405: -- dynamic cursor
3406: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
3407:
3408: --Local Variables for search results

Line 3406: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

3402: l_sql_string VARCHAR2(30000);
3403: l_bind_index NUMBER;
3404: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
3405: -- dynamic cursor
3406: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
3407:
3408: --Local Variables for search results
3409: l_rownum NUMBER;
3410: l_reason_name mtl_transaction_reasons.reason_name%type;

Line 3477: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

3473: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows;
3474: l_bind_index := l_bind_index + 1;
3475:
3476: --open l_cur FOR l_sql_string;
3477: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
3478: (
3479: p_conditions_tbl => l_bindvar_tbl,
3480: p_sql_str => l_sql_string,
3481: p_x_csr => l_cur

Line 3602: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

3598:
3599: -- Local Variables for the sql string.
3600: l_sql_string VARCHAR2(30000);
3601: l_bind_index NUMBER;
3602: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
3603: -- dynamic cursor
3604: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
3605:
3606: --Local Variables for search results

Line 3604: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

3600: l_sql_string VARCHAR2(30000);
3601: l_bind_index NUMBER;
3602: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
3603: -- dynamic cursor
3604: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
3605:
3606: --Local Variables for search results
3607: l_rownum NUMBER;
3608: l_code FND_LOOKUP_VALUES_VL.lookup_code%type;

Line 3667: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

3663: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows;
3664: l_bind_index := l_bind_index + 1;
3665:
3666: --open l_cur FOR l_sql_string;
3667: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
3668: (
3669: p_conditions_tbl => l_bindvar_tbl,
3670: p_sql_str => l_sql_string,
3671: p_x_csr => l_cur

Line 3786: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

3782:
3783: -- Local Variables for the sql string.
3784: l_sql_string VARCHAR2(30000);
3785: l_bind_index NUMBER;
3786: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
3787: -- dynamic cursor
3788: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
3789:
3790: --Local Variables for search results

Line 3788: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

3784: l_sql_string VARCHAR2(30000);
3785: l_bind_index NUMBER;
3786: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
3787: -- dynamic cursor
3788: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
3789:
3790: --Local Variables for search results
3791: l_rownum NUMBER;
3792: l_code FND_LOOKUP_VALUES_VL.lookup_code%type;

Line 3851: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

3847: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows;
3848: l_bind_index := l_bind_index + 1;
3849:
3850: --open l_cur FOR l_sql_string;
3851: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
3852: (
3853: p_conditions_tbl => l_bindvar_tbl,
3854: p_sql_str => l_sql_string,
3855: p_x_csr => l_cur

Line 3970: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

3966:
3967: -- Local Variables for the sql string.
3968: l_sql_string VARCHAR2(30000);
3969: l_bind_index NUMBER;
3970: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
3971: -- dynamic cursor
3972: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
3973:
3974: --Local Variables for search results

Line 3972: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

3968: l_sql_string VARCHAR2(30000);
3969: l_bind_index NUMBER;
3970: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
3971: -- dynamic cursor
3972: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
3973:
3974: --Local Variables for search results
3975: l_rownum NUMBER;
3976: l_code FND_LOOKUP_VALUES_VL.lookup_code%type;

Line 4040: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

4036: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows;
4037: l_bind_index := l_bind_index + 1;
4038:
4039: --open l_cur FOR l_sql_string;
4040: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
4041: (
4042: p_conditions_tbl => l_bindvar_tbl,
4043: p_sql_str => l_sql_string,
4044: p_x_csr => l_cur

Line 4168: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

4164:
4165: -- Local Variables for the sql string.
4166: l_sql_string VARCHAR2(30000);
4167: l_bind_index NUMBER;
4168: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
4169: -- dynamic cursor
4170: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
4171:
4172: --Local Variables for search results

Line 4170: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

4166: l_sql_string VARCHAR2(30000);
4167: l_bind_index NUMBER;
4168: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
4169: -- dynamic cursor
4170: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
4171:
4172: --Local Variables for search results
4173: l_rownum NUMBER;
4174: l_name cs_incident_severities_vl.name%type;

Line 4243: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

4239: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows;
4240: l_bind_index := l_bind_index + 1;
4241:
4242: --open l_cur FOR l_sql_string;
4243: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
4244: (
4245: p_conditions_tbl => l_bindvar_tbl,
4246: p_sql_str => l_sql_string,
4247: p_x_csr => l_cur

Line 4386: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

4382:
4383: -- Local Variables for the sql string.
4384: l_sql_string VARCHAR2(30000);
4385: l_bind_index NUMBER;
4386: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
4387: -- dynamic cursor
4388: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
4389:
4390: --Local Variables for search results

Line 4388: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

4384: l_sql_string VARCHAR2(30000);
4385: l_bind_index NUMBER;
4386: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
4387: -- dynamic cursor
4388: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
4389:
4390: --Local Variables for search results
4391: l_rownum NUMBER;
4392: l_instance csi_item_instances.instance_number%type;

Line 4471: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

4467: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows;
4468: l_bind_index := l_bind_index + 1;
4469:
4470: --open l_cur FOR l_sql_string;
4471: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
4472: (
4473: p_conditions_tbl => l_bindvar_tbl,
4474: p_sql_str => l_sql_string,
4475: p_x_csr => l_cur

Line 4619: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

4615: l_sql_string VARCHAR2(30000);
4616: l_sql_string1 VARCHAR2(30000);
4617: l_sql_string2 VARCHAR2(30000);
4618: l_bind_index NUMBER;
4619: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
4620: -- dynamic cursor
4621: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
4622:
4623: --Local Variables for search results

Line 4621: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

4617: l_sql_string2 VARCHAR2(30000);
4618: l_bind_index NUMBER;
4619: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
4620: -- dynamic cursor
4621: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
4622:
4623: --Local Variables for search results
4624: l_rownum NUMBER;
4625: l_inv_item_id NUMBER;

Line 4710: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

4706: l_bindvar_tbl(l_bind_index) := p_lov_input_rec.StartRow + p_lov_input_rec.NumberOfRows;
4707: l_bind_index := l_bind_index + 1;
4708:
4709: --open l_cur FOR l_sql_string;
4710: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
4711: (
4712: p_conditions_tbl => l_bindvar_tbl,
4713: p_sql_str => l_sql_string,
4714: p_x_csr => l_cur