DBA Data[Home] [Help]

APPS.PO_VAL_HEADERS2 dependencies on PO_VALIDATION_RESULTS_GT

Line 56: INSERT INTO po_validation_results_gt

52: END IF;
53:
54: x_result_type := po_validations.c_result_type_success;
55: FORALL i IN 1 .. p_id_tbl.COUNT
56: INSERT INTO po_validation_results_gt
57: (result_set_id,
58: result_type,
59: entity_type,
60: entity_id,

Line 143: INSERT INTO po_validation_results_gt

139:
140: x_result_type := po_validations.c_result_type_success;
141: -- Bulk validate document_num uniqueness
142: FORALL i IN 1 .. p_id_tbl.COUNT
143: INSERT INTO po_validation_results_gt
144: (result_set_id,
145: result_type,
146: entity_type,
147: entity_id,

Line 350: INSERT INTO po_validation_results_gt

346:
347: x_result_type := po_validations.c_result_type_success;
348: -- Bulk validate currency_code not null and against FND_CURRENCIES
349: FORALL i IN 1 .. p_id_tbl.COUNT
350: INSERT INTO po_validation_results_gt
351: (result_set_id,
352: result_type,
353: entity_type,
354: entity_id,

Line 573: INSERT INTO po_validation_results_gt

569: END LOOP;
570:
571: -- validate rate_type against GL_DAILY_CONVERSION_TYPES
572: FORALL i IN 1 .. p_id_tbl.COUNT
573: INSERT INTO po_validation_results_gt
574: (result_set_id,
575: result_type,
576: entity_type,
577: entity_id,

Line 644: INSERT INTO po_validation_results_gt

640:
641: x_result_type := po_validations.c_result_type_success;
642: -- validate agent_id against PO_AGENTS
643: FORALL i IN 1 .. p_id_tbl.COUNT
644: INSERT INTO po_validation_results_gt
645: (result_set_id,
646: result_type,
647: entity_type,
648: entity_id,

Line 751: INSERT INTO po_validation_results_gt

747: END IF;
748:
749: x_result_type := po_validations.c_result_type_success;
750: FORALL i IN 1 .. p_id_tbl.COUNT
751: INSERT INTO po_validation_results_gt
752: (result_set_id,
753: result_type,
754: entity_type,
755: entity_id,

Line 788: INSERT INTO po_validation_results_gt

784: x_result_type := po_validations.c_result_type_failure;
785: END IF;
786:
787: FORALL i IN 1 .. p_id_tbl.COUNT
788: INSERT INTO po_validation_results_gt
789: (result_set_id,
790: result_type,
791: entity_type,
792: entity_id,

Line 828: INSERT INTO po_validation_results_gt

824: x_result_type := po_validations.c_result_type_failure;
825: END IF;
826:
827: FORALL i IN 1 .. p_id_tbl.COUNT
828: INSERT INTO po_validation_results_gt
829: (result_set_id,
830: result_type,
831: entity_type,
832: entity_id,

Line 940: INSERT INTO po_validation_results_gt

936:
937: x_result_type := po_validations.c_result_type_success;
938: -- validate ship_to_location_id is not null (for PO and BPA) and valid in HR_LOCATIONS
939: FORALL i IN 1 .. p_id_tbl.COUNT
940: INSERT INTO po_validation_results_gt
941: (result_set_id,
942: result_type,
943: entity_type,
944: entity_id,

Line 1023: INSERT INTO po_validation_results_gt

1019:
1020: x_result_type := po_validations.c_result_type_success;
1021: -- validate bill_to_location_id is not null (for PO and BPA) and valid in HR_LOCATIONS
1022: FORALL i IN 1 .. p_id_tbl.COUNT
1023: INSERT INTO po_validation_results_gt
1024: (result_set_id,
1025: result_type,
1026: entity_type,
1027: entity_id,

Line 1104: INSERT INTO po_validation_results_gt

1100: END IF;
1101:
1102: x_result_type := po_validations.c_result_type_success;
1103: FORALL i IN 1 .. p_id_tbl.COUNT
1104: INSERT INTO po_validation_results_gt
1105: (result_set_id,
1106: result_type,
1107: entity_type,
1108: entity_id,

Line 1175: INSERT INTO po_validation_results_gt

1171: END IF;
1172:
1173: x_result_type := po_validations.c_result_type_success;
1174: FORALL i IN 1 .. p_id_tbl.COUNT
1175: INSERT INTO po_validation_results_gt
1176: (result_set_id,
1177: result_type,
1178: entity_type,
1179: entity_id,

Line 1246: INSERT INTO po_validation_results_gt

1242: END IF;
1243:
1244: x_result_type := po_validations.c_result_type_success;
1245: FORALL i IN 1 .. p_id_tbl.COUNT
1246: INSERT INTO po_validation_results_gt
1247: (result_set_id,
1248: result_type,
1249: entity_type,
1250: entity_id,

Line 1317: INSERT INTO po_validation_results_gt

1313: END IF;
1314:
1315: x_result_type := po_validations.c_result_type_success;
1316: FORALL i IN 1 .. p_id_tbl.COUNT
1317: INSERT INTO po_validation_results_gt
1318: (result_set_id,
1319: result_type,
1320: entity_type,
1321: entity_id,

Line 1709: INSERT INTO po_validation_results_gt

1705: x_result_type := po_validations.c_result_type_success;
1706:
1707: -- validate that the style_id exists in the system and the status is ACTIVE.
1708: FORALL i IN 1 .. p_id_tbl.COUNT
1709: INSERT INTO po_validation_results_gt
1710: (result_set_id,
1711: result_type,
1712: entity_type,
1713: entity_id,

Line 1744: INSERT INTO po_validation_results_gt

1740: /* PDOI for Complex PO Project: Allow Complex PO styles: Reverting the changes
1741: -- Bug 13018193 Disabling the validation of complex work PO
1742: -- validate that complex work is not enabled
1743: FORALL i IN 1 .. p_id_tbl.COUNT
1744: INSERT INTO po_validation_results_gt
1745: (result_set_id,
1746: result_type,
1747: entity_type,
1748: entity_id,