APPS.PO_VAL_DISTRIBUTIONS2 dependencies on PO_VALIDATION_RESULTS_GT

Line 248: INSERT INTO po_validation_results_gt

244: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
245: END IF;
246:
247: FORALL i IN 1 .. p_id_tbl.COUNT
248: INSERT INTO po_validation_results_gt
249: (result_set_id,
250: result_type,
251: entity_type,
252: entity_id,

Line 363: INSERT INTO po_validation_results_gt

359:
360: -- bug 5454379: add hint to use index PER_PEOPLE_F_PK
361: -- which is more selective
362: FORALL i IN INDICES OF l_index_tbl
363: INSERT INTO po_validation_results_gt
364: (result_set_id,
365: result_type,
366: entity_type,
367: entity_id,

Line 581: INSERT INTO po_validation_results_gt

577:
578: d_position := 70;
579:
580: FORALL i IN 1 .. p_id_tbl.COUNT
581: INSERT INTO po_validation_results_gt
582: (result_set_id,
583: result_type,
584: entity_type,
585: entity_id,

Line 703: INSERT INTO po_validation_results_gt

699: END IF;
700: END LOOP;
701:
702: FORALL i IN 1 .. p_id_tbl.COUNT
703: INSERT INTO po_validation_results_gt
704: (result_set_id,
705: result_type,
706: entity_type,
707: entity_id,

Line 754: INSERT INTO po_validation_results_gt

750: END IF;
751:
752: -- Need to validate that SHIKYU item can only have asset subinventory (inventory_asset = 1).
753: FORALL i IN 1 .. p_id_tbl.COUNT
754: INSERT INTO po_validation_results_gt
755: (result_set_id,
756: result_type,
757: entity_type,
758: entity_id,

Line 865: INSERT INTO po_validation_results_gt

861: END IF;
862: END LOOP;
863:
864: FORALL i IN 1 .. p_id_tbl.COUNT
865: INSERT INTO po_validation_results_gt
866: (result_set_id,
867: result_type,
868: entity_type,
869: entity_id,

Line 901: INSERT INTO po_validation_results_gt

897: x_result_type := po_validations.c_result_type_failure;
898: END IF;
899:
900: FORALL i IN 1 .. p_id_tbl.COUNT
901: INSERT INTO po_validation_results_gt
902: (result_set_id,
903: result_type,
904: entity_type,
905: entity_id,

Line 1054: INSERT INTO po_validation_results_gt

1050: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1051: END IF;
1052:
1053: FORALL i IN 1 .. p_id_tbl.COUNT
1054: INSERT INTO po_validation_results_gt
1055: (result_set_id,
1056: result_type,
1057: entity_type,
1058: entity_id,

Line 1150: INSERT INTO po_validation_results_gt

1146: -- budget_account_id is empty; If destination_
1147: -- type_code is 'SHOP FLOOR', budget_account_id
1148: -- could be empty even when encumbrance is enabled
1149: FORALL i IN 1 .. p_id_tbl.COUNT
1150: INSERT INTO po_validation_results_gt
1151: (result_set_id,
1152: result_type,
1153: entity_type,
1154: entity_id,

Line 1244: INSERT INTO po_validation_results_gt

1240: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1241: END IF;
1242:
1243: FORALL i IN 1 .. p_id_tbl.COUNT
1244: INSERT INTO po_validation_results_gt
1245: (result_set_id,
1246: result_type,
1247: entity_type,
1248: entity_id,