DBA Data[Home] [Help]

APPS.PO_VAL_HEADERS dependencies on PO_VALIDATION_RESULTS_GT

Line 392: INSERT INTO PO_VALIDATION_RESULTS_GT

388: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
389: END IF;
390:
391: FORALL i IN 1 .. p_header_id_tbl.COUNT
392: INSERT INTO PO_VALIDATION_RESULTS_GT
393: ( result_set_id
394: , result_type
395: , entity_type
396: , entity_id

Line 722: INSERT INTO PO_VALIDATION_RESULTS_GT

718: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
719: END IF;
720:
721: FORALL i IN 1 .. p_header_id_tbl.COUNT
722: INSERT INTO PO_VALIDATION_RESULTS_GT
723: (
724: result_set_id
725: , entity_type
726: , entity_id

Line 805: INSERT INTO PO_VALIDATION_RESULTS_GT

801: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
802: END IF;
803:
804: FORALL i IN 1 .. p_header_id_tbl.COUNT
805: INSERT INTO PO_VALIDATION_RESULTS_GT
806: (
807: result_set_id
808: , entity_type
809: , entity_id

Line 879: INSERT INTO PO_VALIDATION_RESULTS_GT

875: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
876: END IF;
877:
878: FORALL i IN 1 .. p_header_id_tbl.COUNT
879: INSERT INTO PO_VALIDATION_RESULTS_GT
880: (
881: result_set_id
882: , entity_type
883: , entity_id

Line 953: INSERT INTO PO_VALIDATION_RESULTS_GT

949: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
950: END IF;
951:
952: FORALL i IN 1 .. p_header_id_tbl.COUNT
953: INSERT INTO PO_VALIDATION_RESULTS_GT
954: (
955: result_set_id
956: , entity_type
957: , entity_id

Line 1026: INSERT INTO PO_VALIDATION_RESULTS_GT

1022: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
1023: END IF;
1024:
1025: FORALL i IN 1 .. p_header_id_tbl.COUNT
1026: INSERT INTO PO_VALIDATION_RESULTS_GT
1027: (
1028: result_set_id
1029: , entity_type
1030: , entity_id

Line 1138: INSERT INTO PO_VALIDATION_RESULTS_GT

1134: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
1135: END IF;
1136:
1137: FORALL i IN 1 .. p_header_id_tbl.COUNT
1138: INSERT INTO PO_VALIDATION_RESULTS_GT
1139: (
1140: result_set_id
1141: , entity_type
1142: , entity_id

Line 1212: INSERT INTO PO_VALIDATION_RESULTS_GT

1208: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
1209: END IF;
1210:
1211: FORALL i IN 1 .. p_header_id_tbl.COUNT
1212: INSERT INTO PO_VALIDATION_RESULTS_GT
1213: (
1214: result_set_id
1215: , entity_type
1216: , entity_id

Line 1296: INSERT INTO PO_VALIDATION_RESULTS_GT

1292: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
1293: END IF;
1294:
1295: FORALL i IN 1 .. p_header_id_tbl.COUNT
1296: INSERT INTO PO_VALIDATION_RESULTS_GT
1297: ( result_set_id
1298: , entity_type
1299: , entity_id
1300: , column_name

Line 1380: INSERT INTO PO_VALIDATION_RESULTS_GT

1376: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
1377: END IF;
1378:
1379: FORALL i IN 1 .. p_header_id_tbl.COUNT
1380: INSERT INTO PO_VALIDATION_RESULTS_GT
1381: ( result_set_id
1382: , entity_type
1383: , entity_id
1384: , column_name

Line 1464: INSERT INTO PO_VALIDATION_RESULTS_GT

1460: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
1461: END IF;
1462:
1463: FORALL i IN 1 .. p_header_id_tbl.COUNT
1464: INSERT INTO PO_VALIDATION_RESULTS_GT
1465: ( result_set_id
1466: , entity_type
1467: , entity_id
1468: , column_name

Line 2296: INSERT INTO PO_VALIDATION_RESULTS_GT

2292: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
2293: END IF;
2294:
2295: FORALL i IN 1 .. p_header_id_tbl.COUNT
2296: INSERT INTO PO_VALIDATION_RESULTS_GT
2297: ( result_set_id
2298: , entity_type
2299: , entity_id
2300: , message_name

Line 2357: INSERT INTO po_validation_results_gt

2353: LOOP
2354: IF p_ship_via_lookup_code_tbl(i) IS NOT NULL THEN
2355:
2356:
2357: INSERT INTO po_validation_results_gt
2358: (result_set_id,
2359: result_type,
2360: entity_type,
2361: message_name,

Line 2440: INSERT INTO po_validation_results_gt

2436: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
2437: END IF;
2438:
2439: FORALL i IN 1..p_header_id_tbl.COUNT
2440: INSERT INTO po_validation_results_gt
2441: (result_set_id,
2442: entity_type,
2443: entity_id,
2444: message_name,

Line 2507: INSERT INTO po_validation_results_gt

2503: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
2504: END IF;
2505:
2506: FORALL i IN 1..p_header_id_tbl.COUNT
2507: INSERT INTO po_validation_results_gt
2508: (result_set_id,
2509: entity_type,
2510: entity_id,
2511: message_name,

Line 2564: INSERT INTO po_validation_results_gt

2560: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
2561: END IF;
2562:
2563: FORALL i IN 1..p_header_id_tbl.COUNT
2564: INSERT INTO po_validation_results_gt
2565: (result_set_id,
2566: entity_type,
2567: entity_id,
2568: message_name,