eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_VAL_LINES2 dependencies on PO_VALIDATION_RESULTS_GT

Line 86: INSERT INTO po_validation_results_gt

82: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
83: END IF;
84:
85: FORALL i IN 1 .. p_id_tbl.COUNT
86: INSERT INTO po_validation_results_gt
87: (result_set_id,
88: result_type,
89: entity_type,
90: entity_id,

Line 250: INSERT INTO po_validation_results_gt

246: END IF;
247: END LOOP;
248:
249: FORALL i IN 1 .. p_id_tbl.COUNT
250: INSERT INTO po_validation_results_gt
251: (result_set_id,
252: result_type,
253: entity_type,
254: entity_id,

Line 528: INSERT INTO po_validation_results_gt

524: --check that job_id is valid within the relevant business group.
525: IF NVL(hr_general.get_xbg_profile, 'N') = 'N' THEN
526: -- xbg profile is N or job business_group_id is null
527: FORALL i IN 1 .. p_id_tbl.COUNT
528: INSERT INTO po_validation_results_gt
529: (result_set_id,
530: result_type,
531: entity_type,
532: entity_id,

Line 573: INSERT INTO po_validation_results_gt

569: END IF;
570: ELSE
571: -- Cross Business group profile is 'Y'
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 622: INSERT INTO po_validation_results_gt

618: END IF;
619:
620: -- job must be valid for the specified category
621: FORALL i IN 1 .. p_id_tbl.COUNT
622: INSERT INTO po_validation_results_gt
623: (result_set_id,
624: result_type,
625: entity_type,
626: entity_id,

Line 702: INSERT INTO po_validation_results_gt

698:
699: IF NVL(hr_general.get_xbg_profile, 'N') = 'N' THEN
700: -- xbg profile is N but job_business_group_id not in FSP
701: FORALL i IN 1 .. p_id_tbl.COUNT
702: INSERT INTO po_validation_results_gt
703: (result_set_id,
704: result_type,
705: entity_type,
706: entity_id,

Line 732: INSERT INTO po_validation_results_gt

728: END IF;
729: ELSE
730: -- Cross Business group profile is 'Y', need to validate job business group id
731: FORALL i IN 1 .. p_id_tbl.COUNT
732: INSERT INTO po_validation_results_gt
733: (result_set_id,
734: result_type,
735: entity_type,
736: entity_id,

Line 872: INSERT INTO po_validation_results_gt

868: END IF;
869: END LOOP;
870:
871: FORALL i IN 1 .. p_id_tbl.COUNT
872: INSERT INTO po_validation_results_gt
873: (result_set_id,
874: result_type,
875: entity_type,
876: entity_id,

Line 963: INSERT INTO po_validation_results_gt

959: END IF;
960: END LOOP;
961:
962: FORALL i IN 1 .. p_id_tbl.COUNT
963: INSERT INTO po_validation_results_gt
964: (result_set_id,
965: result_type,
966: entity_type,
967: entity_id,

Line 1073: INSERT INTO po_validation_results_gt

1069:
1070: -- If order_type_lookup_code is Quantity and outside_operation flag is 'Y'
1071: -- , then the item_id cannot be null
1072: FORALL i IN 1 .. p_id_tbl.COUNT
1073: INSERT INTO po_validation_results_gt
1074: (result_set_id,
1075: result_type,
1076: entity_type,
1077: entity_id,

Line 1106: INSERT INTO po_validation_results_gt

1102: END IF;
1103:
1104: -- if item id is not null, it has to exist in mtl_system_items table
1105: FORALL i IN 1 .. p_id_tbl.COUNT
1106: INSERT INTO po_validation_results_gt
1107: (result_set_id,
1108: result_type,
1109: entity_type,
1110: entity_id,

Line 1198: INSERT INTO po_validation_results_gt

1194:
1195: /* Bug 5366732 Modified the inner query to select item description from mtl_system_items_tl instead of from mtl_system_items */
1196: x_result_type := po_validations.c_result_type_success;
1197: FORALL i IN 1 .. p_id_tbl.COUNT
1198: INSERT INTO po_validation_results_gt
1199: (result_set_id,
1200: result_type,
1201: entity_type,
1202: entity_id,

Line 1321: INSERT INTO po_validation_results_gt

1317: END IF;
1318: END LOOP;
1319:
1320: FORALL i IN 1 .. p_id_tbl.COUNT
1321: INSERT INTO po_validation_results_gt
1322: (result_set_id,
1323: result_type,
1324: entity_type,
1325: entity_id,

Line 1367: INSERT INTO po_validation_results_gt

1363: END IF;
1364:
1365: -- check to see if x_uom_code is valid in po_units_of_measure_val_v
1366: FORALL i IN 1 .. p_id_tbl.COUNT
1367: INSERT INTO po_validation_results_gt
1368: (result_set_id,
1369: result_type,
1370: entity_type,
1371: entity_id,

Line 1402: INSERT INTO po_validation_results_gt

1398: END IF;
1399:
1400: -- validation for AMOUNT based line type
1401: FORALL i IN 1 .. p_id_tbl.COUNT
1402: INSERT INTO po_validation_results_gt
1403: (result_set_id,
1404: result_type,
1405: entity_type,
1406: entity_id,

Line 1443: INSERT INTO po_validation_results_gt

1439:
1440: -- validation for 'RATE' based line
1441: l_service_uom_class := NVL(FND_PROFILE.value('PO_RATE_UOM_CLASS'), '999');
1442: FORALL i IN 1 .. p_id_tbl.COUNT
1443: INSERT INTO po_validation_results_gt
1444: (result_set_id,
1445: result_type,
1446: entity_type,
1447: entity_id,

Line 1544: INSERT INTO po_validation_results_gt

1540:
1541: -- check to see if there are x_item_revision exists in mtl_item_revisions
1542: -- table
1543: FORALL i IN 1 .. p_id_tbl.COUNT
1544: INSERT INTO po_validation_results_gt
1545: (result_set_id,
1546: result_type,
1547: entity_type,
1548: entity_id,

Line 1656: INSERT INTO po_validation_results_gt

1652: WHERE functional_area_id = 2); /*** purchasing***/
1653:
1654: -- Validate if X_category_id belong to the X_item
1655: FORALL i IN 1 .. p_id_tbl.COUNT
1656: INSERT INTO po_validation_results_gt
1657: (result_set_id,
1658: result_type,
1659: entity_type,
1660: entity_id,

Line 1706: INSERT INTO po_validation_results_gt

1702: END IF;
1703:
1704: IF x_flag = 'Y' THEN
1705: FORALL i IN 1 .. p_id_tbl.COUNT
1706: INSERT INTO po_validation_results_gt
1707: (result_set_id,
1708: result_type,
1709: entity_type,
1710: entity_id,

Line 1747: INSERT INTO po_validation_results_gt

1743: x_result_type := po_validations.c_result_type_failure;
1744: END IF;
1745: ELSE
1746: FORALL i IN 1 .. p_id_tbl.COUNT
1747: INSERT INTO po_validation_results_gt
1748: (result_set_id,
1749: result_type,
1750: entity_type,
1751: entity_id,

Line 1845: INSERT INTO po_validation_results_gt

1841: x_result_type => x_result_type);
1842:
1843: -- Validate if x_category_id is valid if not empty
1844: FORALL i IN 1 .. p_id_tbl.COUNT
1845: INSERT INTO po_validation_results_gt
1846: (result_set_id,
1847: result_type,
1848: entity_type,
1849: entity_id,

Line 1964: INSERT INTO po_validation_results_gt

1960:
1961: -- If line_type_id is not null and order_type_lookup_code is 'AMOUNT',
1962: -- unit_price should be the same as the one defined in the line_type.
1963: FORALL i IN 1 .. p_id_tbl.COUNT
1964: INSERT INTO po_validation_results_gt
1965: (result_set_id,
1966: result_type,
1967: entity_type,
1968: entity_id,

Line 2271: INSERT INTO po_validation_results_gt

2267: -- Log error if there's line number duplicate in draft table as well
2268:
2269: -- check for uniqueness
2270: FORALL i IN 1 .. p_id_tbl.COUNT
2271: INSERT INTO po_validation_results_gt
2272: (result_set_id,
2273: result_type,
2274: entity_type,
2275: entity_id,

Line 2354: INSERT INTO po_validation_results_gt

2350: END IF;
2351:
2352: x_result_type := po_validations.c_result_type_success;
2353: FORALL i IN 1 .. p_id_tbl.COUNT
2354: INSERT INTO po_validation_results_gt
2355: (result_set_id,
2356: result_type,
2357: entity_type,
2358: entity_id,

Line 2429: INSERT INTO po_validation_results_gt

2425: END IF;
2426:
2427: x_result_type := po_validations.c_result_type_success;
2428: FORALL i IN 1 .. p_id_tbl.COUNT
2429: INSERT INTO po_validation_results_gt
2430: (result_set_id,
2431: result_type,
2432: entity_type,
2433: entity_id,

Line 2507: INSERT INTO po_validation_results_gt

2503: x_result_type := po_validations.c_result_type_success;
2504:
2505: -- validate line_type_id is valid for the given style
2506: FORALL i IN 1 .. p_id_tbl.COUNT
2507: INSERT INTO po_validation_results_gt
2508: (result_set_id,
2509: result_type,
2510: entity_type,
2511: entity_id,

Line 2549: INSERT INTO po_validation_results_gt

2545: END IF;
2546:
2547: -- validate the purchase_basis is valid for the given style
2548: FORALL i IN 1 .. p_id_tbl.COUNT
2549: INSERT INTO po_validation_results_gt
2550: (result_set_id,
2551: result_type,
2552: entity_type,
2553: entity_id,

Line 2624: INSERT INTO po_validation_results_gt

2620: END IF;
2621:
2622: x_result_type := po_validations.c_result_type_success;
2623: FORALL i IN 1 .. p_id_tbl.COUNT
2624: INSERT INTO po_validation_results_gt
2625: (result_set_id,
2626: result_type,
2627: entity_type,
2628: entity_id,

Line 2785: INSERT INTO po_validation_results_gt

2781: END IF;
2782:
2783: x_result_type := po_validations.c_result_type_success;
2784: FORALL i IN 1 .. p_id_tbl.COUNT
2785: INSERT INTO po_validation_results_gt
2786: (result_set_id,
2787: result_type,
2788: entity_type,
2789: entity_id,

Line 2989: INSERT INTO po_validation_results_gt

2985: -- If price break lookup code is provided, it has to be a valid lookup
2986: -- code
2987: x_result_type := po_validations.c_result_type_success;
2988: FORALL i IN 1 .. p_id_tbl.COUNT
2989: INSERT INTO po_validation_results_gt
2990: (result_set_id,
2991: result_type,
2992: entity_type,
2993: entity_id,

Line 3176: INSERT INTO po_validation_results_gt

3172: END LOOP;
3173:
3174: -- Validate if x_category_id is valid if not empty
3175: FORALL i IN 1 .. p_id_tbl.COUNT
3176: INSERT INTO po_validation_results_gt
3177: (result_set_id,
3178: result_type,
3179: entity_type,
3180: entity_id,

Line 3267: INSERT INTO po_validation_results_gt

3263: END IF;
3264: END LOOP;
3265:
3266: FORALL i IN 1 .. p_id_tbl.COUNT
3267: INSERT INTO po_validation_results_gt
3268: (result_set_id,
3269: result_type,
3270: entity_type,
3271: entity_id,

Line 3377: INSERT INTO po_validation_results_gt

3373: /* Bug 5366732 Modified the inner query to select item description from mtl_system_items_tl instead of from mtl_system_items */
3374:
3375:
3376: FORALL i IN 1 .. p_id_tbl.COUNT
3377: INSERT INTO po_validation_results_gt
3378: (result_set_id,
3379: result_type,
3380: entity_type,
3381: entity_id,

Line 3606: INSERT INTO po_validation_results_gt

3602: END IF;
3603: END LOOP;
3604:
3605: FORALL i IN 1 .. p_id_tbl.COUNT
3606: INSERT INTO po_validation_results_gt
3607: (result_set_id,
3608: result_type,
3609: entity_type,
3610: entity_id,

Line 3726: INSERT INTO po_validation_results_gt

3722:
3723: -- bug5258790
3724: -- For fixed price line update, unit price has to be NULL
3725: FORALL i IN 1..p_id_tbl.COUNT
3726: INSERT INTO po_validation_results_gt
3727: (result_set_id,
3728: result_type,
3729: entity_type,
3730: entity_id,

Line 3770: INSERT INTO po_validation_results_gt

3766:
3767: -- bug5008026
3768: -- Make sure that the new price does not exceed price limit
3769: FORALL i IN 1 .. p_id_tbl.COUNT
3770: INSERT INTO po_validation_results_gt
3771: (result_set_id,
3772: result_type,
3773: entity_type,
3774: entity_id,

Line 3851: INSERT INTO po_validation_results_gt

3847:
3848: -- bug5258790
3849: -- For fixed price line update, unit price has to be NULL
3850: FORALL i IN 1..p_id_tbl.COUNT
3851: INSERT INTO po_validation_results_gt
3852: (result_set_id,
3853: result_type,
3854: entity_type,
3855: entity_id,