APPS.PO_VAL_DISTRIBUTIONS2 dependencies on PO_VALIDATION_RESULTS_GT

Line 236: INSERT INTO po_validation_results_gt

232: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
233: END IF;
234:
235: FORALL i IN 1 .. p_id_tbl.COUNT
236: INSERT INTO po_validation_results_gt
237: (result_set_id,
238: result_type,
239: entity_type,
240: entity_id,

Line 351: INSERT INTO po_validation_results_gt

347:
348: -- bug 5454379: add hint to use index PER_PEOPLE_F_PK
349: -- which is more selective
350: FORALL i IN INDICES OF l_index_tbl
351: INSERT INTO po_validation_results_gt
352: (result_set_id,
353: result_type,
354: entity_type,
355: entity_id,

Line 569: INSERT INTO po_validation_results_gt

565:
566: d_position := 70;
567:
568: FORALL i IN 1 .. p_id_tbl.COUNT
569: INSERT INTO po_validation_results_gt
570: (result_set_id,
571: result_type,
572: entity_type,
573: entity_id,

Line 691: INSERT INTO po_validation_results_gt

687: END IF;
688: END LOOP;
689:
690: FORALL i IN 1 .. p_id_tbl.COUNT
691: INSERT INTO po_validation_results_gt
692: (result_set_id,
693: result_type,
694: entity_type,
695: entity_id,

Line 742: INSERT INTO po_validation_results_gt

738: END IF;
739:
740: -- Need to validate that SHIKYU item can only have asset subinventory (inventory_asset = 1).
741: FORALL i IN 1 .. p_id_tbl.COUNT
742: INSERT INTO po_validation_results_gt
743: (result_set_id,
744: result_type,
745: entity_type,
746: entity_id,

Line 853: INSERT INTO po_validation_results_gt

849: END IF;
850: END LOOP;
851:
852: FORALL i IN 1 .. p_id_tbl.COUNT
853: INSERT INTO po_validation_results_gt
854: (result_set_id,
855: result_type,
856: entity_type,
857: entity_id,

Line 889: INSERT INTO po_validation_results_gt

885: x_result_type := po_validations.c_result_type_failure;
886: END IF;
887:
888: FORALL i IN 1 .. p_id_tbl.COUNT
889: INSERT INTO po_validation_results_gt
890: (result_set_id,
891: result_type,
892: entity_type,
893: entity_id,

Line 1020: INSERT INTO po_validation_results_gt

1016: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1017: END IF;
1018:
1019: FORALL i IN 1 .. p_id_tbl.COUNT
1020: INSERT INTO po_validation_results_gt
1021: (result_set_id,
1022: result_type,
1023: entity_type,
1024: entity_id,

Line 1112: INSERT INTO po_validation_results_gt

1108: -- budget_account_id is empty; If destination_
1109: -- type_code is 'SHOP FLOOR', budget_account_id
1110: -- could be empty even when encumbrance is enabled
1111: FORALL i IN 1 .. p_id_tbl.COUNT
1112: INSERT INTO po_validation_results_gt
1113: (result_set_id,
1114: result_type,
1115: entity_type,
1116: entity_id,

Line 1203: INSERT INTO po_validation_results_gt

1199: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1200: END IF;
1201:
1202: FORALL i IN 1 .. p_id_tbl.COUNT
1203: INSERT INTO po_validation_results_gt
1204: (result_set_id,
1205: result_type,
1206: entity_type,
1207: entity_id,