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 STANDARD

Line 43: d_start_date_standard CONSTANT VARCHAR2(100)

39: d_line_type_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'LINE_TYPE_ID');
40: d_style_related_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'STYLE_RELATED_INFO');
41: d_price_type_lookup_code CONSTANT VARCHAR2(100)
42: := po_log.get_subprogram_base(d_package_base, 'PRICE_TYPE_LOOKUP_CODE');
43: d_start_date_standard CONSTANT VARCHAR2(100)
44: := po_log.get_subprogram_base(d_package_base, 'START_DATE_STANDARD');
45: d_item_id_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_ID_STANDARD');
46: d_quantity_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY_STANDARD');
47: d_amount_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT_STANDARD');

Line 44: := po_log.get_subprogram_base(d_package_base, 'START_DATE_STANDARD');

40: d_style_related_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'STYLE_RELATED_INFO');
41: d_price_type_lookup_code CONSTANT VARCHAR2(100)
42: := po_log.get_subprogram_base(d_package_base, 'PRICE_TYPE_LOOKUP_CODE');
43: d_start_date_standard CONSTANT VARCHAR2(100)
44: := po_log.get_subprogram_base(d_package_base, 'START_DATE_STANDARD');
45: d_item_id_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_ID_STANDARD');
46: d_quantity_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY_STANDARD');
47: d_amount_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT_STANDARD');
48: d_price_break_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK_LOOKUP_CODE');

Line 45: d_item_id_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_ID_STANDARD');

41: d_price_type_lookup_code CONSTANT VARCHAR2(100)
42: := po_log.get_subprogram_base(d_package_base, 'PRICE_TYPE_LOOKUP_CODE');
43: d_start_date_standard CONSTANT VARCHAR2(100)
44: := po_log.get_subprogram_base(d_package_base, 'START_DATE_STANDARD');
45: d_item_id_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_ID_STANDARD');
46: d_quantity_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY_STANDARD');
47: d_amount_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT_STANDARD');
48: d_price_break_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK_LOOKUP_CODE');
49: d_not_to_exceed_price CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'NOT_TO_EXCEED_PRICE');

Line 46: d_quantity_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY_STANDARD');

42: := po_log.get_subprogram_base(d_package_base, 'PRICE_TYPE_LOOKUP_CODE');
43: d_start_date_standard CONSTANT VARCHAR2(100)
44: := po_log.get_subprogram_base(d_package_base, 'START_DATE_STANDARD');
45: d_item_id_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_ID_STANDARD');
46: d_quantity_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY_STANDARD');
47: d_amount_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT_STANDARD');
48: d_price_break_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK_LOOKUP_CODE');
49: d_not_to_exceed_price CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'NOT_TO_EXCEED_PRICE');
50: d_ip_category_id_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'IP_CATEGORY_ID_UPDATE');

Line 47: d_amount_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT_STANDARD');

43: d_start_date_standard CONSTANT VARCHAR2(100)
44: := po_log.get_subprogram_base(d_package_base, 'START_DATE_STANDARD');
45: d_item_id_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_ID_STANDARD');
46: d_quantity_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY_STANDARD');
47: d_amount_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT_STANDARD');
48: d_price_break_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK_LOOKUP_CODE');
49: d_not_to_exceed_price CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'NOT_TO_EXCEED_PRICE');
50: d_ip_category_id_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'IP_CATEGORY_ID_UPDATE');
51: d_uom_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'UOM_UPDATE');

Line 65: -- This method is called only for Standard PO and quotation documents

61:
62: -------------------------------------------------------------------------
63: -- The lookup code specified in over_tolerance_error_flag with the lookup type
64: -- 'RECEIVING CONTROL LEVEL' has to exist in po_lookup_codes and still active.
65: -- This method is called only for Standard PO and quotation documents
66: -------------------------------------------------------------------------
67: PROCEDURE over_tolerance_err_flag(
68: p_id_tbl IN po_tbl_number,
69: p_over_tolerance_err_flag_tbl IN po_tbl_varchar30,

Line 444: OR p_doc_type <> 'STANDARD')

440: x_result_type := po_validations.c_result_type_success;
441:
442: FOR i IN 1 .. p_id_tbl.COUNT LOOP
443: IF (p_purchase_basis_tbl(i) <> 'TEMP LABOR'
444: OR p_doc_type <> 'STANDARD')
445: AND (p_contractor_last_name_tbl(i) IS NOT NULL
446: OR p_contractor_first_name_tbl(i) IS NOT NULL) THEN
447: x_results.add_result(p_entity_type => c_entity_type_line,
448: p_entity_id => p_id_tbl(i),

Line 2673: --Start date is required for Standard PO with purchase basis 'TEMP LABOR'

2669: RAISE;
2670: END price_type_lookup_code;
2671:
2672: -------------------------------------------------------------------------
2673: --Start date is required for Standard PO with purchase basis 'TEMP LABOR'
2674: --Expiration date if provided should be later than the start date
2675: --If purchase basis is not 'TEMP LABOR', start_date and expiration_date have to be null
2676: -------------------------------------------------------------------------
2677: PROCEDURE start_date_standard(

Line 2677: PROCEDURE start_date_standard(

2673: --Start date is required for Standard PO with purchase basis 'TEMP LABOR'
2674: --Expiration date if provided should be later than the start date
2675: --If purchase basis is not 'TEMP LABOR', start_date and expiration_date have to be null
2676: -------------------------------------------------------------------------
2677: PROCEDURE start_date_standard(
2678: p_id_tbl IN po_tbl_number,
2679: p_start_date_tbl IN po_tbl_date,
2680: p_expiration_date_tbl IN po_tbl_date,
2681: p_purchase_basis_tbl IN po_tbl_varchar30,

Line 2685: d_mod CONSTANT VARCHAR2(100) := d_start_date_standard;

2681: p_purchase_basis_tbl IN po_tbl_varchar30,
2682: x_results IN OUT NOCOPY po_validation_results_type,
2683: x_result_type OUT NOCOPY VARCHAR2)
2684: IS
2685: d_mod CONSTANT VARCHAR2(100) := d_start_date_standard;
2686: BEGIN
2687: IF (x_results IS NULL) THEN
2688: x_results := po_validation_results_type.new_instance();
2689: END IF;

Line 2704: -- --Start date is required for Standard PO with purchase basis 'TEMP LABOR'

2700:
2701: FOR i IN 1 .. p_id_tbl.COUNT LOOP
2702: IF (p_purchase_basis_tbl(i) = 'TEMP LABOR') THEN
2703: IF (p_start_date_tbl(i) IS NULL) THEN
2704: -- --Start date is required for Standard PO with purchase basis 'TEMP LABOR'
2705: x_results.add_result(p_entity_type => c_entity_type_line,
2706: p_entity_id => p_id_tbl(i),
2707: p_column_name => 'START_DATE',
2708: p_column_val => p_start_date_tbl(i),

Line 2755: END start_date_standard;

2751: po_log.exc(d_mod, 0, NULL);
2752: END IF;
2753:
2754: RAISE;
2755: END start_date_standard;
2756:
2757: -------------------------------------------------------------------------
2758: -- If order_type_lookup_code is not 'RATE' or 'FIXED PRICE', and item_id is not null,
2759: -- then bom_item_type cannot be 1 or 2.

Line 2761: PROCEDURE item_id_standard(

2757: -------------------------------------------------------------------------
2758: -- If order_type_lookup_code is not 'RATE' or 'FIXED PRICE', and item_id is not null,
2759: -- then bom_item_type cannot be 1 or 2.
2760: -------------------------------------------------------------------------
2761: PROCEDURE item_id_standard(
2762: p_id_tbl IN po_tbl_number,
2763: p_item_id_tbl IN po_tbl_number,
2764: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2765: p_inventory_org_id IN NUMBER,

Line 2769: d_mod CONSTANT VARCHAR2(100) := d_item_id_standard;

2765: p_inventory_org_id IN NUMBER,
2766: x_result_set_id IN OUT NOCOPY NUMBER,
2767: x_result_type OUT NOCOPY VARCHAR2)
2768: IS
2769: d_mod CONSTANT VARCHAR2(100) := d_item_id_standard;
2770: BEGIN
2771: IF x_result_set_id IS NULL THEN
2772: x_result_set_id := po_validations.next_result_set_id();
2773: END IF;

Line 2830: END item_id_standard;

2826: po_log.exc(d_mod, 0, NULL);
2827: END IF;
2828:
2829: RAISE;
2830: END item_id_standard;
2831:
2832: -------------------------------------------------------------------------
2833: -- Quantity cannot be zero for SPO
2834: -------------------------------------------------------------------------

Line 2835: PROCEDURE quantity_standard(

2831:
2832: -------------------------------------------------------------------------
2833: -- Quantity cannot be zero for SPO
2834: -------------------------------------------------------------------------
2835: PROCEDURE quantity_standard(
2836: p_id_tbl IN po_tbl_number,
2837: p_quantity_tbl IN po_tbl_number,
2838: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2839: x_results IN OUT NOCOPY po_validation_results_type,

Line 2842: d_mod CONSTANT VARCHAR2(100) := d_quantity_standard;

2838: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2839: x_results IN OUT NOCOPY po_validation_results_type,
2840: x_result_type OUT NOCOPY VARCHAR2)
2841: IS
2842: d_mod CONSTANT VARCHAR2(100) := d_quantity_standard;
2843: BEGIN
2844: IF (x_results IS NULL) THEN
2845: x_results := po_validation_results_type.new_instance();
2846: END IF;

Line 2886: END quantity_standard;

2882: po_log.exc(d_mod, 0, NULL);
2883: END IF;
2884:
2885: RAISE;
2886: END quantity_standard;
2887:
2888: -------------------------------------------------------------------------
2889: -- If order_type_lookup_code is 'FIXED PRICE' or 'RATE', amount cannot be null;
2890: -- If order_type_lookup_code is 'FIXED PRICE' or 'RATE' and amount is not

Line 2893: PROCEDURE amount_standard(

2889: -- If order_type_lookup_code is 'FIXED PRICE' or 'RATE', amount cannot be null;
2890: -- If order_type_lookup_code is 'FIXED PRICE' or 'RATE' and amount is not
2891: -- empty, amount value must be greater than zero
2892: -------------------------------------------------------------------------
2893: PROCEDURE amount_standard(
2894: p_id_tbl IN po_tbl_number,
2895: p_amount_tbl IN po_tbl_number,
2896: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2897: x_results IN OUT NOCOPY po_validation_results_type,

Line 2900: d_mod CONSTANT VARCHAR2(100) := d_amount_standard;

2896: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2897: x_results IN OUT NOCOPY po_validation_results_type,
2898: x_result_type OUT NOCOPY VARCHAR2)
2899: IS
2900: d_mod CONSTANT VARCHAR2(100) := d_amount_standard;
2901: BEGIN
2902: IF (x_results IS NULL) THEN
2903: x_results := po_validation_results_type.new_instance();
2904: END IF;

Line 2952: END amount_standard;

2948: po_log.exc(d_mod, 0, NULL);
2949: END IF;
2950:
2951: RAISE;
2952: END amount_standard;
2953:
2954: -------------------------------------------------------------------------
2955: -- Price break lookup code should be valid
2956: -------------------------------------------------------------------------