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.PO_VAL_LINES dependencies on PO_VALIDATIONS

Line 4: c_ENTITY_TYPE_LINE CONSTANT VARCHAR2(30) := PO_VALIDATIONS.C_ENTITY_TYPE_LINE;

1: PACKAGE BODY PO_VAL_LINES AS
2: -- $Header: PO_VAL_LINES.plb 120.21 2006/11/15 00:16:09 vinokris noship $
3:
4: c_ENTITY_TYPE_LINE CONSTANT VARCHAR2(30) := PO_VALIDATIONS.C_ENTITY_TYPE_LINE;
5:
6: c_RATE CONSTANT VARCHAR2(30) := 'RATE';
7: c_FIXED_PRICE CONSTANT VARCHAR2(30) := 'FIXED PRICE';
8: c_STANDARD CONSTANT VARCHAR2(30) := 'STANDARD';

Line 278: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

274: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
275: END IF;
276:
277: IF (x_result_set_id IS NULL) THEN
278: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
279: END IF;
280:
281: FORALL i IN 1 .. p_line_id_tbl.COUNT
282: INSERT INTO PO_VALIDATION_RESULTS_GT

Line 348: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

344: AND p_quantity_tbl(i) < POLL_TOTAL.qty_executed
345: ;
346:
347: IF (SQL%ROWCOUNT > 0) THEN
348: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
349: ELSE
350: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
351: END IF;
352:

Line 350: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

346:
347: IF (SQL%ROWCOUNT > 0) THEN
348: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
349: ELSE
350: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
351: END IF;
352:
353: IF PO_LOG.d_proc THEN
354: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);

Line 354: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);

350: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
351: END IF;
352:
353: IF PO_LOG.d_proc THEN
354: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
355: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
356: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
357: END IF;
358:

Line 412: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

408: END IF;
409: END LOOP;
410:
411: IF (l_results_count < x_results.result_type.COUNT) THEN
412: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
413: ELSE
414: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
415: END IF;
416: END IF;

Line 414: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

410:
411: IF (l_results_count < x_results.result_type.COUNT) THEN
412: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
413: ELSE
414: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
415: END IF;
416: END IF;
417:
418: END advance_amt_le_amt;

Line 445: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

441: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
442: END IF;
443:
444: IF (x_result_set_id IS NULL) THEN
445: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
446: END IF;
447:
448: FORALL i IN 1 .. p_line_id_tbl.COUNT
449: INSERT INTO PO_VALIDATION_RESULTS_GT

Line 489: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

485: AND p_quantity_tbl(i) < DIST_TOTAL.quantity_encumbered
486: ;
487:
488: IF (SQL%ROWCOUNT > 0) THEN
489: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
490: ELSE
491: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
492: END IF;
493:

Line 491: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

487:
488: IF (SQL%ROWCOUNT > 0) THEN
489: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
490: ELSE
491: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
492: END IF;
493:
494: IF PO_LOG.d_proc THEN
495: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);

Line 495: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);

491: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
492: END IF;
493:
494: IF PO_LOG.d_proc THEN
495: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
496: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
497: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
498: END IF;
499:

Line 602: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

598:
599: d_progress := 10.0;
600:
601: IF (x_result_set_id IS NULL) THEN
602: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
603: END IF;
604:
605: d_progress := 20.0;
606:

Line 737: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

733:
734: d_progress := 50.0;
735:
736: IF (SQL%ROWCOUNT > 0) THEN
737: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
738: ELSE
739: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
740: END IF;
741:

Line 739: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

735:
736: IF (SQL%ROWCOUNT > 0) THEN
737: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
738: ELSE
739: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
740: END IF;
741:
742: d_progress := 60.0;
743:

Line 745: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);

741:
742: d_progress := 60.0;
743:
744: IF PO_LOG.d_proc THEN
745: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
746: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
747: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
748: END IF;
749:

Line 869: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

865:
866: END LOOP;
867:
868: IF (l_results_count < x_results.result_type.COUNT) THEN
869: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
870: ELSE
871: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
872: END IF;
873:

Line 871: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

867:
868: IF (l_results_count < x_results.result_type.COUNT) THEN
869: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
870: ELSE
871: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
872: END IF;
873:
874: IF PO_LOG.d_proc THEN
875: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 985: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

981: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
982: END IF;
983:
984: IF (x_result_set_id IS NULL) THEN
985: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
986: END IF;
987:
988: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
989:

Line 988: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

984: IF (x_result_set_id IS NULL) THEN
985: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
986: END IF;
987:
988: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
989:
990: -- Get profile PO_VMI_DISPLAY_WARNING
991: fnd_profile.get(PO_PROFILES.PO_VMI_DISPLAY_WARNING,l_po_vmi_display_warning);
992:

Line 1007: , PO_VALIDATIONS.c_result_type_WARNING

1003: , message_name
1004: )
1005: SELECT
1006: x_result_set_id
1007: , PO_VALIDATIONS.c_result_type_WARNING
1008: , c_ENTITY_TYPE_LINE
1009: , p_line_id_tbl(i)
1010: , c_ITEM_ID
1011: , TO_CHAR(p_item_id_tbl(i))

Line 1040: x_result_type := PO_VALIDATIONS.c_result_type_WARNING;

1036: WHERE paa2.asl_id = pasl.asl_id
1037: AND paa2.using_organization_id IN (-1, p_org_id_tbl(i)));
1038:
1039: IF (SQL%ROWCOUNT > 0) THEN
1040: x_result_type := PO_VALIDATIONS.c_result_type_WARNING;
1041: END IF;
1042:
1043: END IF;
1044:

Line 1046: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);

1042:
1043: END IF;
1044:
1045: IF PO_LOG.d_proc THEN
1046: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1047: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1048: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1049: END IF;
1050:

Line 1348: PO_VALIDATIONS.validate_unit_price_change(

1344: ;
1345:
1346: IF (l_line_id_tbl.COUNT > 0) THEN
1347:
1348: PO_VALIDATIONS.validate_unit_price_change(
1349: p_line_id_tbl => l_line_id_tbl
1350: , p_price_break_lookup_code_tbl => l_price_break_lookup_code_tbl
1351: , x_result_type => x_result_type
1352: , x_result_set_id => x_result_set_id

Line 1358: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1354: );
1355:
1356: ELSE
1357:
1358: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1359:
1360: END IF;
1361:
1362:

Line 1364: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);

1360: END IF;
1361:
1362:
1363: IF PO_LOG.d_proc THEN
1364: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1365: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1366: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1367: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1368: END IF;

Line 1544: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

1540: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1541: END IF;
1542:
1543: IF (x_result_set_id IS NULL) THEN
1544: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
1545: END IF;
1546:
1547: -- : Fill in the following messages
1548: -- PO_MESSAGE_S.PO_PO_QTY_LT_MILESTONE_BILL

Line 1596: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1592: AND p_quantity_tbl(i) < POLL_TOTAL.max_qty_executed
1593: ;
1594:
1595: IF (SQL%ROWCOUNT > 0) THEN
1596: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1597: ELSE
1598: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1599: END IF;
1600:

Line 1598: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1594:
1595: IF (SQL%ROWCOUNT > 0) THEN
1596: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1597: ELSE
1598: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1599: END IF;
1600:
1601: IF PO_LOG.d_proc THEN
1602: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);

Line 1602: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);

1598: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1599: END IF;
1600:
1601: IF PO_LOG.d_proc THEN
1602: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1603: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1604: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1605: END IF;
1606:

Line 1639: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

1635: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1636: END IF;
1637:
1638: IF (x_result_set_id IS NULL) THEN
1639: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
1640: END IF;
1641:
1642: -- : Fill in the following messages
1643: -- PO_MESSAGE_S.PO_PO_QTY_LT_MILESTONE_BILL

Line 1684: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1680: AND p_price_tbl(i) < POLL_TOTAL.sum_price_executed
1681: ;
1682:
1683: IF (SQL%ROWCOUNT > 0) THEN
1684: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1685: ELSE
1686: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1687: END IF;
1688:

Line 1686: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1682:
1683: IF (SQL%ROWCOUNT > 0) THEN
1684: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1685: ELSE
1686: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1687: END IF;
1688:
1689: IF PO_LOG.d_proc THEN
1690: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);

Line 1690: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);

1686: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1687: END IF;
1688:
1689: IF PO_LOG.d_proc THEN
1690: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1691: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1692: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1693: END IF;
1694:

Line 1750: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1746: END IF;
1747: END LOOP;
1748:
1749: IF (l_results_count < x_results.result_type.COUNT) THEN
1750: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1751: ELSE
1752: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1753: END IF;
1754:

Line 1752: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1748:
1749: IF (l_results_count < x_results.result_type.COUNT) THEN
1750: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1751: ELSE
1752: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1753: END IF;
1754:
1755: IF PO_LOG.d_proc THEN
1756: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 1855: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

1851: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1852: END IF;
1853:
1854: IF (x_result_set_id IS NULL) THEN
1855: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
1856: END IF;
1857:
1858: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1859:

Line 1858: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1854: IF (x_result_set_id IS NULL) THEN
1855: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
1856: END IF;
1857:
1858: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1859:
1860: l_input_size := p_id_tbl.COUNT;
1861:
1862: l_id_tbl := PO_TBL_NUMBER();

Line 1908: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1904: AND PLT.outside_operation_flag = 'Y'
1905: ;
1906:
1907: IF (SQL%ROWCOUNT > 0) THEN
1908: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1909: END IF;
1910:
1911: END IF;
1912:

Line 1914: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);

1910:
1911: END IF;
1912:
1913: IF PO_LOG.d_proc THEN
1914: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1915: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1916: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1917: END IF;
1918:

Line 1972: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1968: END IF;
1969: END LOOP;
1970:
1971: IF (l_results_count < x_results.result_type.COUNT) THEN
1972: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1973: ELSE
1974: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1975: END IF;
1976:

Line 1974: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1970:
1971: IF (l_results_count < x_results.result_type.COUNT) THEN
1972: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1973: ELSE
1974: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1975: END IF;
1976:
1977: IF PO_LOG.d_proc THEN
1978: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 2035: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

2031: END IF;
2032: END LOOP;
2033:
2034: IF (l_results_count < x_results.result_type.COUNT) THEN
2035: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2036: ELSE
2037: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2038: END IF;
2039:

Line 2037: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

2033:
2034: IF (l_results_count < x_results.result_type.COUNT) THEN
2035: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2036: ELSE
2037: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2038: END IF;
2039:
2040: IF PO_LOG.d_proc THEN
2041: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 2121: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

2117: END IF;
2118: END LOOP;
2119:
2120: IF (l_results_count < x_results.result_type.COUNT) THEN
2121: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2122: ELSE
2123: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2124: END IF;
2125:

Line 2123: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

2119:
2120: IF (l_results_count < x_results.result_type.COUNT) THEN
2121: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2122: ELSE
2123: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2124: END IF;
2125:
2126: IF PO_LOG.d_proc THEN
2127: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 2337: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

2333:
2334: END LOOP;
2335:
2336: IF (l_results_count < x_results.result_type.COUNT) THEN
2337: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2338: ELSE
2339: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2340: END IF;
2341:

Line 2339: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

2335:
2336: IF (l_results_count < x_results.result_type.COUNT) THEN
2337: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2338: ELSE
2339: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2340: END IF;
2341:
2342: IF PO_LOG.d_proc THEN
2343: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 2410: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

2406: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2407: END IF;
2408:
2409: IF (x_result_set_id IS NULL) THEN
2410: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
2411: END IF;
2412:
2413: FORALL i IN 1 .. p_line_id_tbl.COUNT
2414: INSERT INTO PO_VALIDATION_RESULTS_GT

Line 2449: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

2445: p_max_retain_amt_tbl(i) < LOCATIONS_TOTAL.amount_retained
2446: ;
2447:
2448: IF (SQL%ROWCOUNT > 0) THEN
2449: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2450: ELSE
2451: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2452: END IF;
2453:

Line 2451: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

2447:
2448: IF (SQL%ROWCOUNT > 0) THEN
2449: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2450: ELSE
2451: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2452: END IF;
2453:
2454: IF PO_LOG.d_proc THEN
2455: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);

Line 2455: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);

2451: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2452: END IF;
2453:
2454: IF PO_LOG.d_proc THEN
2455: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
2456: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2457: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
2458: END IF;
2459: