[Home] [Help]
446: -- Validates currency_code not null and against FND_CURRENCIES.
447: --Parameters:
448: --IN:
449: --p_key
450: -- Key used to access records in PO_SESSION_GT table.
451: --IN/OUT:
452: --p_headers_rec
453: -- A record of plsql tables containing a batch of headers. If this validation
454: -- fails, the 'has_errors' column is set to 'Y'.
512: -- Get the errored rows into GT table.
513: -- SQL Why : It will be used to mark the record in plsql table as error.
514: -- SQL Join: currency_code
515: FORALL i IN 1 .. p_headers_rec.currency_code.COUNT
516: INSERT INTO PO_SESSION_GT(key,
517: num1,
518: num2,
519: index_char1)
520: SELECT p_key
542: l_progress := '030';
543: -- SQL What: Transfer from session GT table to local arrays
544: -- SQL Why : It will be used to mark the error records.
545: -- SQL Join: key
546: DELETE FROM PO_SESSION_GT
547: WHERE key = p_key
548: RETURNING num1, num2, index_char1
549: BULK COLLECT INTO l_indexes, l_interface_header_ids, l_err_currency_code_list;
550:
599: -- validate vendor site CCR if approval status is APPROVED.
600: --Parameters:
601: --IN:
602: --p_key
603: -- Key used to access records in PO_SESSION_GT table.
604: --IN/OUT:
605: --p_headers_rec
606: -- A record of plsql tables containing a batch of headers. If this validation
607: -- fails, the 'has_errors' column is set to 'Y'.
660: -- Insert the error rows into GT table.
661: -- SQL Why : It will be used to mark the record in plsql table as error.
662: -- SQL Join: vendor_id
663: FORALL i IN 1 .. p_headers_rec.vendor_id.COUNT
664: INSERT INTO PO_SESSION_GT(key,
665: num1,
666: num2,
667: num3,
668: char1)
685: l_progress := '030';
686: -- SQL What: Transfer from session GT table to local arrays
687: -- SQL Why : It will be used to mark the error records.
688: -- SQL Join: key
689: DELETE FROM PO_SESSION_GT
690: WHERE key = p_key
691: RETURNING num1, num2, num3, char1
692: BULK COLLECT INTO l_indexes, l_interface_header_ids, l_vendor_id_list, l_vendor_name_list;
693:
720: -- Insert the error rows into GT table.
721: -- SQL Why : It will be used to mark the record in plsql table as error.
722: -- SQL Join: vendor_id
723: FORALL i IN 1 .. p_headers_rec.vendor_id.COUNT
724: INSERT INTO PO_SESSION_GT(key,
725: num1,
726: num2,
727: num3,
728: char1)
752: l_progress := '060';
753: -- SQL What: Transfer from session GT table to local arrays
754: -- SQL Why : It will be used to mark the error records.
755: -- SQL Join: key
756: DELETE FROM PO_SESSION_GT
757: WHERE key = p_key
758: RETURNING num1, num2, num3, char1
759: BULK COLLECT INTO l_indexes, l_interface_header_ids, l_vendor_id_list, l_vendor_name_list;
760:
795: -- Insert the error rows into GT table.
796: -- SQL Why : It will be used to mark the record in plsql table as error.
797: -- SQL Join: vendor_site_id
798: FORALL i IN 1 .. p_headers_rec.vendor_site_id.COUNT
799: INSERT INTO PO_SESSION_GT(key,
800: num1,
801: num2,
802: num3,
803: char1)
833: l_progress := '090';
834: -- SQL What: Transfer from session GT table to local arrays
835: -- SQL Why : It will be used to mark the error records.
836: -- SQL Join: key
837: DELETE FROM PO_SESSION_GT
838: WHERE key = p_key
839: RETURNING num1, num2, num3, char1
840: BULK COLLECT INTO l_indexes, l_interface_header_ids,
841: l_vendor_site_id_list, l_vendor_site_code_list;
869: -- Insert the error rows into GT table.
870: -- SQL Why : It will be used to mark the record in plsql table as error.
871: -- SQL Join: vendor_site_id
872: FORALL i IN 1 .. p_headers_rec.vendor_site_id.COUNT
873: INSERT INTO PO_SESSION_GT(key,
874: num1,
875: num2,
876: num3,
877: char1)
901: l_progress := '120';
902: -- SQL What: Transfer from session GT table to local arrays
903: -- SQL Why : It will be used to mark the error records.
904: -- SQL Join: key
905: DELETE FROM PO_SESSION_GT
906: WHERE key = p_key
907: RETURNING num1, num2, num3, char1
908: BULK COLLECT INTO l_indexes, l_interface_header_ids,
909: l_vendor_site_id_list, l_vendor_site_code_list;
943: -- Insert the error rows into GT table.
944: -- SQL Why : It will be used to mark the record in plsql table as error.
945: -- SQL Join: vendor_id
946: FORALL i IN 1 .. p_headers_rec.vendor_contact_id.COUNT
947: INSERT INTO PO_SESSION_GT(key,
948: num1,
949: num2,
950: num3)
951: SELECT p_key
968: l_progress := '150';
969: -- SQL What: Transfer from session GT table to local arrays
970: -- SQL Why : It will be used to mark the error records.
971: -- SQL Join: key
972: DELETE FROM PO_SESSION_GT
973: WHERE key = p_key
974: RETURNING num1, num2, num3
975: BULK COLLECT INTO l_indexes, l_interface_header_ids, l_vendor_contact_id_list;
976:
1144: -- Validates ship_to_location_id not null and against HR_LOCATIONS.
1145: --Parameters:
1146: --IN:
1147: --p_key
1148: -- Key used to access records in PO_SESSION_GT table.
1149: --IN/OUT:
1150: --p_headers_rec
1151: -- A record of plsql tables containing a batch of headers. If this validation
1152: -- fails, the 'has_errors' column is set to 'Y'.
1194: -- Get the errored rows into GT table.
1195: -- SQL Why : It will be used to mark the record in plsql table as error.
1196: -- SQL Join: ship_to_location_id
1197: FORALL i IN 1 .. p_headers_rec.ship_to_location_id.COUNT
1198: INSERT INTO PO_SESSION_GT(key,
1199: num1,
1200: num2,
1201: num3)
1202: SELECT p_key
1216: l_progress := '030';
1217: -- SQL What: Transfer from session GT table to local arrays
1218: -- SQL Why : It will be used to mark the error records.
1219: -- SQL Join: key
1220: DELETE FROM PO_SESSION_GT
1221: WHERE key = p_key
1222: RETURNING num1, num2, num3
1223: BULK COLLECT INTO l_indexes, l_interface_header_ids, l_err_ship_to_loc_id_list;
1224:
1250: -- Get the errored rows into GT table.
1251: -- SQL Why : It will be used to mark the record in plsql table as error.
1252: -- SQL Join: ship_to_location_id
1253: FORALL i IN 1 .. p_headers_rec.ship_to_location_id.COUNT
1254: INSERT INTO PO_SESSION_GT(key,
1255: num1,
1256: num2,
1257: num3)
1258: SELECT p_key
1281: l_progress := '060';
1282: -- SQL What: Transfer from session GT table to local arrays
1283: -- SQL Why : It will be used to mark the error records.
1284: -- SQL Join: key
1285: DELETE FROM PO_SESSION_GT
1286: WHERE key = p_key
1287: RETURNING num1, num2, num3
1288: BULK COLLECT INTO l_indexes, l_interface_header_ids, l_err_ship_to_loc_id_list;
1289:
1342: -- Validates bill_to_location_id not null and against HR_LOCATIONS.
1343: --Parameters:
1344: --IN:
1345: --p_key
1346: -- Key used to access records in PO_SESSION_GT table.
1347: --IN/OUT:
1348: --p_headers_rec
1349: -- A record of plsql tables containing a batch of headers. If this validation
1350: -- fails, the 'has_errors' column is set to 'Y'.
1389: -- Get the errored rows into GT table.
1390: -- SQL Why : It will be used to mark the record in plsql table as error.
1391: -- SQL Join: bill_to_location_id
1392: FORALL i IN 1 .. p_headers_rec.bill_to_location_id.COUNT
1393: INSERT INTO PO_SESSION_GT(key,
1394: num1,
1395: num2,
1396: num3)
1397: SELECT p_key
1411: l_progress := '030';
1412: -- SQL What: Transfer from session GT table to local arrays
1413: -- SQL Why : It will be used to mark the error records.
1414: -- SQL Join: key
1415: DELETE FROM PO_SESSION_GT
1416: WHERE key = p_key
1417: RETURNING num1, num2, num3
1418: BULK COLLECT INTO l_indexes, l_interface_header_ids, l_err_bill_to_loc_id_list;
1419:
1444: -- Get the errored rows into GT table.
1445: -- SQL Why : It will be used to mark the record in plsql table as error.
1446: -- SQL Join: bill_to_location_id
1447: FORALL i IN 1 .. p_headers_rec.bill_to_location_id.COUNT
1448: INSERT INTO PO_SESSION_GT(key,
1449: num1,
1450: num2,
1451: num3)
1452: SELECT p_key
1475: l_progress := '060';
1476: -- SQL What: Transfer from session GT table to local arrays
1477: -- SQL Why : It will be used to mark the error records.
1478: -- SQL Join: key
1479: DELETE FROM PO_SESSION_GT
1480: WHERE key = p_key
1481: RETURNING num1, num2, num3
1482: BULK COLLECT INTO l_indexes, l_interface_header_ids, l_err_bill_to_loc_id_list;
1483:
1607: -- Validates fob_lookup_code against PO_LOOKUP_CODES.
1608: --Parameters:
1609: --IN:
1610: --p_key
1611: -- Key used to access records in PO_SESSION_GT table.
1612: --IN/OUT:
1613: --p_headers_rec
1614: -- A record of plsql tables containing a batch of headers. If this validation
1615: -- fails, the 'has_errors' column is set to 'Y'.
1655: -- Get the errored rows into GT table.
1656: -- SQL Why : It will be used to mark the record in plsql table as error.
1657: -- SQL Join: bill_to_location_id
1658: FORALL i IN 1 .. p_headers_rec.fob.COUNT
1659: INSERT INTO PO_SESSION_GT(key,
1660: num1,
1661: num2,
1662: char1)
1663: SELECT p_key
1679: l_progress := '030';
1680: -- SQL What: Transfer from session GT table to local arrays
1681: -- SQL Why : It will be used to mark the error records.
1682: -- SQL Join: key
1683: DELETE FROM PO_SESSION_GT
1684: WHERE key = p_key
1685: RETURNING num1, num2, char1
1686: BULK COLLECT INTO l_indexes, l_interface_header_ids, l_err_fob_lookup_code_list;
1687:
1742: -- Validates ship_via_lookup_code against ORG_FREIGHTS.
1743: --Parameters:
1744: --IN:
1745: --p_key
1746: -- Key used to access records in PO_SESSION_GT table.
1747: --IN/OUT:
1748: --p_headers_rec
1749: -- A record of plsql tables containing a batch of headers. If this validation
1750: -- fails, the 'has_errors' column is set to 'Y'.
1791:
1792: -- bug5601416: use default inv org id instead of master org
1793:
1794: FORALL i IN 1 .. p_headers_rec.freight_carrier.COUNT
1795: INSERT INTO PO_SESSION_GT(key,
1796: num1,
1797: num2,
1798: char1)
1799: SELECT p_key
1815: l_progress := '030';
1816: -- SQL What: Transfer from session GT table to local arrays
1817: -- SQL Why : It will be used to mark the error records.
1818: -- SQL Join: key
1819: DELETE FROM PO_SESSION_GT
1820: WHERE key = p_key
1821: RETURNING num1, num2, char1
1822: BULK COLLECT INTO l_indexes, l_interface_header_ids, l_err_ship_via_luc_list;
1823:
1866: -- Validates freight_terms_lookup_code against PO_LOOKUP_CODES.
1867: --Parameters:
1868: --IN:
1869: --p_key
1870: -- Key used to access records in PO_SESSION_GT table.
1871: --IN/OUT:
1872: --p_headers_rec
1873: -- A record of plsql tables containing a batch of headers. If this validation
1874: -- fails, the 'has_errors' column is set to 'Y'.
1914: -- Get the errored rows into GT table.
1915: -- SQL Why : It will be used to mark the record in plsql table as error.
1916: -- SQL Join: ship_via_lookup_code
1917: FORALL i IN 1 .. p_headers_rec.freight_terms.COUNT
1918: INSERT INTO PO_SESSION_GT(key,
1919: num1,
1920: num2,
1921: char1)
1922: SELECT p_key
1939: l_progress := '030';
1940: -- SQL What: Transfer from session GT table to local arrays
1941: -- SQL Why : It will be used to mark the error records.
1942: -- SQL Join: key
1943: DELETE FROM PO_SESSION_GT
1944: WHERE key = p_key
1945: RETURNING num1, num2, char1
1946: BULK COLLECT INTO l_indexes, l_interface_header_ids, l_err_freight_terms_list;
1947:
2067: -- Validates terms_id against AP_TERMS.
2068: --Parameters:
2069: --IN:
2070: --p_key
2071: -- Key used to access records in PO_SESSION_GT table.
2072: --IN/OUT:
2073: --p_headers_rec
2074: -- A record of plsql tables containing a batch of headers. If this validation
2075: -- fails, the 'has_errors' column is set to 'Y'.
2115: -- Get the errored rows into GT table.
2116: -- SQL Why : It will be used to mark the record in plsql table as error.
2117: -- SQL Join: ship_via_lookup_code
2118: FORALL i IN 1 .. p_headers_rec.terms_id.COUNT
2119: INSERT INTO PO_SESSION_GT(key,
2120: num1,
2121: num2,
2122: num3)
2123: SELECT p_key
2141: l_progress := '030';
2142: -- SQL What: Transfer from session GT table to local arrays
2143: -- SQL Why : It will be used to mark the error records.
2144: -- SQL Join: key
2145: DELETE FROM PO_SESSION_GT
2146: WHERE key = p_key
2147: RETURNING num1, num2, num3
2148: BULK COLLECT INTO l_indexes, l_interface_header_ids, l_err_terms_id_list;
2149:
2203: -- Validates shipping_control against PO_LOOKUP_CODES.
2204: --Parameters:
2205: --IN:
2206: --p_key
2207: -- Key used to access records in PO_SESSION_GT table.
2208: --IN/OUT:
2209: --p_headers_rec
2210: -- A record of plsql tables containing a batch of headers. If this validation
2211: -- fails, the 'has_errors' column is set to 'Y'.
2251: -- Get the errored rows into GT table.
2252: -- SQL Why : It will be used to mark the record in plsql table as error.
2253: -- SQL Join: ship_via_lookup_code
2254: FORALL i IN 1 .. p_headers_rec.shipping_control.COUNT
2255: INSERT INTO PO_SESSION_GT(key,
2256: num1,
2257: num2,
2258: char1)
2259: SELECT p_key
2276: l_progress := '030';
2277: -- SQL What: Transfer from session GT table to local arrays
2278: -- SQL Why : It will be used to mark the error records.
2279: -- SQL Join: key
2280: DELETE FROM PO_SESSION_GT
2281: WHERE key = p_key
2282: RETURNING num1, num2, char1
2283: BULK COLLECT INTO l_indexes, l_interface_header_ids, l_err_shipping_control_list;
2284:
2339: -- Validates rate_type_code against GL_DAILY_CONVERSION_TYPES_V.
2340: --Parameters:
2341: --IN:
2342: --p_key
2343: -- Key used to access records in PO_SESSION_GT table.
2344: --IN/OUT:
2345: --p_headers_rec
2346: -- A record of plsql tables containing a batch of headers. If this validation
2347: -- fails, the 'has_errors' column is set to 'Y'.
2410: -- Get the errored rows into GT table.
2411: -- SQL Why : It will be used to mark the record in plsql table as error.
2412: -- SQL Join: rate_type
2413: FORALL i IN 1 .. p_headers_rec.rate_type_code.COUNT
2414: INSERT INTO PO_SESSION_GT(key,
2415: num1,
2416: num2,
2417: char1)
2418: SELECT p_key
2434: l_progress := '040';
2435: -- SQL What: Transfer from session GT table to local arrays
2436: -- SQL Why : It will be used to mark the error records.
2437: -- SQL Join: key
2438: DELETE FROM PO_SESSION_GT
2439: WHERE key = p_key
2440: RETURNING num1, num2, char1
2441: BULK COLLECT INTO l_indexes, l_interface_header_ids, l_err_rate_type_code_list;
2442:
2515: l_api_name CONSTANT VARCHAR2(30) := 'validate_headers';
2516: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
2517: l_progress VARCHAR2(3) := '000';
2518:
2519: l_key PO_SESSION_GT.key%TYPE;
2520: i NUMBER;
2521: BEGIN
2522: l_progress := '010';
2523: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
2522: l_progress := '010';
2523: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
2524:
2525: -- pick a new key from temp table which will be used in all validate logic
2526: SELECT PO_SESSION_GT_S.nextval
2527: INTO l_key
2528: FROM DUAL;
2529:
2530: l_progress := '020';
2644: -- MTL_SYSTEM_ITEMS table.
2645: --Parameters:
2646: --IN:
2647: --p_key
2648: -- Key used to access records in PO_SESSION_GT table.
2649: --IN/OUT:
2650: --p_lines_rec
2651: -- A record of plsql tables containing a batch of lines. If this validation
2652: -- fails, the 'has_errors' column is set to 'Y'.
2685: -- Insert the error rows into GT table.
2686: -- SQL Why : It will be used to mark the record in plsql table as error.
2687: -- SQL Join: item_id
2688: FORALL i IN 1 .. p_lines_rec.item_id.COUNT
2689: INSERT INTO PO_SESSION_GT(key,
2690: num1,
2691: num2,
2692: num3,
2693: num4)
2719: l_progress := '030';
2720: -- SQL What: Transfer from session GT table to local arrays
2721: -- SQL Why : It will be used to mark the error records.
2722: -- SQL Join: key
2723: DELETE FROM PO_SESSION_GT
2724: WHERE key = p_key
2725: RETURNING num1, num2, num3, num4
2726: BULK COLLECT INTO l_indexes, l_interface_header_ids,
2727: l_interface_line_ids, l_item_id_list;
2782: -- if it is different from what is setup for the item.
2783: --Parameters:
2784: --IN:
2785: --p_key
2786: -- Key used to access records in PO_SESSION_GT table.
2787: --IN/OUT:
2788: --p_lines_rec
2789: -- A record of plsql tables containing a batch of lines. If this validation
2790: -- fails, the 'has_errors' column is set to 'Y'.
2824: -- Insert the error rows into GT table.
2825: -- SQL Why : It will be used to mark the record in plsql table as error.
2826: -- SQL Join: item_id
2827: FORALL i IN 1 .. p_lines_rec.item_id.COUNT
2828: INSERT INTO PO_SESSION_GT(key,
2829: num1,
2830: num2,
2831: num3,
2832: char1)
2853: l_progress := '030';
2854: -- SQL What: Transfer from session GT table to local arrays
2855: -- SQL Why : It will be used to mark the error records.
2856: -- SQL Join: key
2857: DELETE FROM PO_SESSION_GT
2858: WHERE key = p_key
2859: RETURNING num1, num2, num3, char1
2860: BULK COLLECT INTO l_indexes, l_interface_header_ids,
2861: l_interface_line_ids, l_item_description_list;
2909: -- check to see if unit_meas_lookup_code is valid in mtl_item_uoms_view
2910: --Parameters:
2911: --IN:
2912: --p_key
2913: -- Key used to access records in PO_SESSION_GT table.
2914: --IN/OUT:
2915: --p_lines_rec
2916: -- A record of plsql tables containing a batch of lines. If this validation
2917: -- fails, the 'has_errors' column is set to 'Y'.
3074: -- Insert the error rows into GT table.
3075: -- SQL Why : It will be used to mark the record in plsql table as error.
3076: -- SQL Join: item_id, unit_of_measure, inv_org_id
3077: FORALL i IN 1 .. p_lines_rec.item_id.COUNT
3078: INSERT INTO PO_SESSION_GT(key,
3079: num1,
3080: num2,
3081: num3,
3082: char1,
3110: l_progress := '080';
3111: -- SQL What: Transfer from session GT table to local arrays
3112: -- SQL Why : It will be used to mark the error records.
3113: -- SQL Join: key
3114: DELETE FROM PO_SESSION_GT
3115: WHERE key = p_key
3116: RETURNING num1, num2, num3, char1, char2
3117: BULK COLLECT INTO l_indexes, l_interface_header_ids,
3118: l_interface_line_ids, l_unit_of_measure_list, l_uom_code_list;
3168: -- Check to see if the item_revision exists in mtl_item_revisions table
3169: --Parameters:
3170: --IN:
3171: --p_key
3172: -- Key used to access records in PO_SESSION_GT table.
3173: --IN/OUT:
3174: --p_lines_rec
3175: -- A record of plsql tables containing a batch of lines. If this validation
3176: -- fails, the 'has_errors' column is set to 'Y'.
3240: -- Insert the error rows into GT table.
3241: -- SQL Why : It will be used to mark the record in plsql table as error.
3242: -- SQL Join: item_id, item_revision
3243: FORALL i IN 1 .. p_lines_rec.item_id.COUNT
3244: INSERT INTO PO_SESSION_GT(key,
3245: num1,
3246: num2,
3247: num3,
3248: num4,
3268: l_progress := '060';
3269: -- SQL What: Transfer from session GT table to local arrays
3270: -- SQL Why : It will be used to mark the error records.
3271: -- SQL Join: key
3272: DELETE FROM PO_SESSION_GT
3273: WHERE key = p_key
3274: RETURNING num1, num2, num3, num4, char1
3275: BULK COLLECT INTO l_indexes, l_interface_header_ids,
3276: l_interface_line_ids, l_item_id_list, l_item_revision_list;
3490: -- we will just validate if the category is Enable and Active.
3491: --Parameters:
3492: --IN:
3493: --p_key
3494: -- Key used to access records in PO_SESSION_GT table.
3495: --IN/OUT:
3496: --p_lines_rec
3497: -- A record of plsql tables containing a batch of lines. If this validation
3498: -- fails, the 'has_errors' column is set to 'Y'.
3614: -- Insert the error rows into GT table.
3615: -- SQL Why : It will be used to mark the record in plsql table as error.
3616: -- SQL Join: item_id, category_id
3617: FORALL i IN 1 .. p_lines_rec.item_id.COUNT
3618: INSERT INTO PO_SESSION_GT(key,
3619: num1,
3620: num2,
3621: num3,
3622: num4,
3652: l_progress := '070';
3653: -- SQL What: Transfer from session GT table to local arrays
3654: -- SQL Why : It will be used to mark the error records.
3655: -- SQL Join: key
3656: DELETE FROM PO_SESSION_GT
3657: WHERE key = p_key
3658: RETURNING num1, num2, num3, num4, num5, char1
3659: BULK COLLECT INTO l_indexes, l_interface_header_ids,
3660: l_interface_line_ids, l_item_id_list,
3706: -- Insert the error rows into GT table.
3707: -- SQL Why : It will be used to mark the record in plsql table as error.
3708: -- SQL Join: category_id
3709: FORALL i IN 1 .. p_lines_rec.item_id.COUNT
3710: INSERT INTO PO_SESSION_GT(key,
3711: num1,
3712: num2,
3713: num3,
3714: num4,
3740: l_progress := '110';
3741: -- SQL What: Transfer from session GT table to local arrays
3742: -- SQL Why : It will be used to mark the error records.
3743: -- SQL Join: key
3744: DELETE FROM PO_SESSION_GT
3745: WHERE key = p_key
3746: RETURNING num1, num2, num3, num4, char1
3747: BULK COLLECT INTO l_indexes, l_interface_header_ids,
3748: l_interface_line_ids,
3794: -- Insert the error rows into GT table.
3795: -- SQL Why : It will be used to mark the record in plsql table as error.
3796: -- SQL Join: category_id
3797: FORALL i IN 1 .. p_lines_rec.item_id.COUNT
3798: INSERT INTO PO_SESSION_GT(key,
3799: num1,
3800: num2,
3801: num3,
3802: num4,
3825: l_progress := '150';
3826: -- SQL What: Transfer from session GT table to local arrays
3827: -- SQL Why : It will be used to mark the error records.
3828: -- SQL Join: key
3829: DELETE FROM PO_SESSION_GT
3830: WHERE key = p_key
3831: RETURNING num1, num2, num3, num4, char1
3832: BULK COLLECT INTO l_indexes, l_interface_header_ids,
3833: l_interface_line_ids,
3895: -- and cannot be less than zero.
3896: --Parameters:
3897: --IN:
3898: --p_key
3899: -- Key used to access records in PO_SESSION_GT table.
3900: --IN/OUT:
3901: --p_lines_rec
3902: -- A record of plsql tables containing a batch of lines. If this validation
3903: -- fails, the 'has_errors' column is set to 'Y'.
4013: l_api_name CONSTANT VARCHAR2(30) := 'validate_lines';
4014: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
4015: l_progress VARCHAR2(3) := '000';
4016:
4017: l_key PO_SESSION_GT.key%TYPE;
4018: i NUMBER;
4019: BEGIN
4020: l_progress := '010';
4021: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
4020: l_progress := '010';
4021: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
4022:
4023: -- pick a new key from temp table which will be used in all validate logic
4024: SELECT PO_SESSION_GT_S.nextval
4025: INTO l_key
4026: FROM DUAL;
4027:
4028: l_progress := '020';