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 70: -- This method is called only for Standard PO and quotation documents

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

Line 453: OR p_doc_type <> 'STANDARD')

449: x_result_type := po_validations.c_result_type_success;
450:
451: FOR i IN 1 .. p_id_tbl.COUNT LOOP
452: IF (p_purchase_basis_tbl(i) <> 'TEMP LABOR'
453: OR p_doc_type <> 'STANDARD')
454: AND (p_contractor_last_name_tbl(i) IS NOT NULL
455: OR p_contractor_first_name_tbl(i) IS NOT NULL) THEN
456: x_results.add_result(p_entity_type => c_entity_type_line,
457: p_entity_id => p_id_tbl(i),

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

2730: RAISE;
2731: END price_type_lookup_code;
2732:
2733: -------------------------------------------------------------------------
2734: --Start date is required for Standard PO with purchase basis 'TEMP LABOR'
2735: --Expiration date if provided should be later than the start date
2736: --If purchase basis is not 'TEMP LABOR', start_date and expiration_date have to be null
2737: -------------------------------------------------------------------------
2738: PROCEDURE start_date_standard(

Line 2738: PROCEDURE start_date_standard(

2734: --Start date is required for Standard PO with purchase basis 'TEMP LABOR'
2735: --Expiration date if provided should be later than the start date
2736: --If purchase basis is not 'TEMP LABOR', start_date and expiration_date have to be null
2737: -------------------------------------------------------------------------
2738: PROCEDURE start_date_standard(
2739: p_id_tbl IN po_tbl_number,
2740: p_start_date_tbl IN po_tbl_date,
2741: p_expiration_date_tbl IN po_tbl_date,
2742: p_purchase_basis_tbl IN po_tbl_varchar30,

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

2742: p_purchase_basis_tbl IN po_tbl_varchar30,
2743: x_results IN OUT NOCOPY po_validation_results_type,
2744: x_result_type OUT NOCOPY VARCHAR2)
2745: IS
2746: d_mod CONSTANT VARCHAR2(100) := d_start_date_standard;
2747: BEGIN
2748: IF (x_results IS NULL) THEN
2749: x_results := po_validation_results_type.new_instance();
2750: END IF;

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

2761:
2762: FOR i IN 1 .. p_id_tbl.COUNT LOOP
2763: IF (p_purchase_basis_tbl(i) = 'TEMP LABOR') THEN
2764: IF (p_start_date_tbl(i) IS NULL) THEN
2765: -- --Start date is required for Standard PO with purchase basis 'TEMP LABOR'
2766: x_results.add_result(p_entity_type => c_entity_type_line,
2767: p_entity_id => p_id_tbl(i),
2768: p_column_name => 'START_DATE',
2769: p_column_val => p_start_date_tbl(i),

Line 2816: END start_date_standard;

2812: po_log.exc(d_mod, 0, NULL);
2813: END IF;
2814:
2815: RAISE;
2816: END start_date_standard;
2817:
2818: -------------------------------------------------------------------------
2819: -- If order_type_lookup_code is not 'RATE' or 'FIXED PRICE', and item_id is not null,
2820: -- then bom_item_type cannot be 1 or 2.

Line 2822: PROCEDURE item_id_standard(

2818: -------------------------------------------------------------------------
2819: -- If order_type_lookup_code is not 'RATE' or 'FIXED PRICE', and item_id is not null,
2820: -- then bom_item_type cannot be 1 or 2.
2821: -------------------------------------------------------------------------
2822: PROCEDURE item_id_standard(
2823: p_id_tbl IN po_tbl_number,
2824: p_item_id_tbl IN po_tbl_number,
2825: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2826: p_inventory_org_id IN NUMBER,

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

2826: p_inventory_org_id IN NUMBER,
2827: x_result_set_id IN OUT NOCOPY NUMBER,
2828: x_result_type OUT NOCOPY VARCHAR2)
2829: IS
2830: d_mod CONSTANT VARCHAR2(100) := d_item_id_standard;
2831: BEGIN
2832: IF x_result_set_id IS NULL THEN
2833: x_result_set_id := po_validations.next_result_set_id();
2834: END IF;

Line 2891: END item_id_standard;

2887: po_log.exc(d_mod, 0, NULL);
2888: END IF;
2889:
2890: RAISE;
2891: END item_id_standard;
2892:
2893: -------------------------------------------------------------------------
2894: -- Quantity cannot be zero for SPO
2895: -------------------------------------------------------------------------

Line 2896: PROCEDURE quantity_standard(

2892:
2893: -------------------------------------------------------------------------
2894: -- Quantity cannot be zero for SPO
2895: -------------------------------------------------------------------------
2896: PROCEDURE quantity_standard(
2897: p_id_tbl IN po_tbl_number,
2898: p_quantity_tbl IN po_tbl_number,
2899: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2900: x_results IN OUT NOCOPY po_validation_results_type,

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

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

Line 2947: END quantity_standard;

2943: po_log.exc(d_mod, 0, NULL);
2944: END IF;
2945:
2946: RAISE;
2947: END quantity_standard;
2948:
2949: -------------------------------------------------------------------------
2950: -- If order_type_lookup_code is 'FIXED PRICE' or 'RATE', amount cannot be null;
2951: -- If order_type_lookup_code is 'FIXED PRICE' or 'RATE' and amount is not

Line 2954: PROCEDURE amount_standard(

2950: -- If order_type_lookup_code is 'FIXED PRICE' or 'RATE', amount cannot be null;
2951: -- If order_type_lookup_code is 'FIXED PRICE' or 'RATE' and amount is not
2952: -- empty, amount value must be greater than zero
2953: -------------------------------------------------------------------------
2954: PROCEDURE amount_standard(
2955: p_id_tbl IN po_tbl_number,
2956: p_amount_tbl IN po_tbl_number,
2957: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2958: x_results IN OUT NOCOPY po_validation_results_type,

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

2957: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2958: x_results IN OUT NOCOPY po_validation_results_type,
2959: x_result_type OUT NOCOPY VARCHAR2)
2960: IS
2961: d_mod CONSTANT VARCHAR2(100) := d_amount_standard;
2962: BEGIN
2963: IF (x_results IS NULL) THEN
2964: x_results := po_validation_results_type.new_instance();
2965: END IF;

Line 3013: END amount_standard;

3009: po_log.exc(d_mod, 0, NULL);
3010: END IF;
3011:
3012: RAISE;
3013: END amount_standard;
3014:
3015: -------------------------------------------------------------------------
3016: -- Price break lookup code should be valid
3017: -------------------------------------------------------------------------