DBA Data[Home] [Help]

APPS.PO_VAL_LINES2 dependencies on PO_PDOI_CONSTANTS

Line 170: IF p_expiration_date_tbl(i) = PO_PDOI_CONSTANTS.g_NULLIFY_DATE THEN

166: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
167: END IF;
168:
169: FOR i IN 1 .. p_id_tbl.COUNT LOOP
170: IF p_expiration_date_tbl(i) = PO_PDOI_CONSTANTS.g_NULLIFY_DATE THEN
171: x_results.add_result(p_entity_type => c_entity_type_line,
172: p_entity_id => p_id_tbl(i),
173: p_column_name => 'EXPIRATION_DATE',
174: p_column_val => p_expiration_date_tbl(i),

Line 3222: IF p_ip_category_id_tbl(i) = PO_PDOI_CONSTANTS.g_NULLIFY_NUM THEN

3218:
3219: x_result_type := po_validations.c_result_type_success;
3220:
3221: FOR i IN 1 .. p_id_tbl.COUNT LOOP
3222: IF p_ip_category_id_tbl(i) = PO_PDOI_CONSTANTS.g_NULLIFY_NUM THEN
3223: x_results.add_result(p_entity_type => c_entity_type_line,
3224: p_entity_id => p_id_tbl(i),
3225: p_column_name => 'IP_CATEGORY_ID',
3226: p_column_val => p_ip_category_id_tbl(i),

Line 3314: IF p_unit_meas_lookup_code_tbl(i) = PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR THEN

3310: END IF;
3311:
3312: x_result_type := po_validations.c_result_type_success;
3313: FOR i IN 1 .. p_id_tbl.COUNT LOOP
3314: IF p_unit_meas_lookup_code_tbl(i) = PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR THEN
3315: x_results.add_result(p_entity_type => c_entity_type_line,
3316: p_entity_id => p_id_tbl(i),
3317: p_column_name => 'UNIT_MEAS_LOOKUP_CODE',
3318: p_column_val => p_unit_meas_lookup_code_tbl(i),

Line 3424: IF p_item_description_tbl(i) = PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR THEN

3420: END IF;
3421:
3422: x_result_type := po_validations.c_result_type_success;
3423: FOR i IN 1 .. p_id_tbl.COUNT LOOP
3424: IF p_item_description_tbl(i) = PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR THEN
3425: x_results.add_result(p_entity_type => c_entity_type_line,
3426: p_entity_id => p_id_tbl(i),
3427: p_column_name => 'ITEM_DESCRIPTION',
3428: p_column_val => p_item_description_tbl(i),

Line 3581: IF p_negotiated_by_preparer_tbl(i) = PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR THEN

3577: END IF;
3578:
3579: x_result_type := po_validations.c_result_type_success;
3580: FOR i IN 1 .. p_id_tbl.COUNT LOOP
3581: IF p_negotiated_by_preparer_tbl(i) = PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR THEN
3582: x_results.add_result(p_entity_type => c_entity_type_line,
3583: p_entity_id => p_id_tbl(i),
3584: p_column_name => 'NEGOTIATED_BY_PREPARER',
3585: p_column_val => p_negotiated_by_preparer_tbl(i),

Line 3656: IF p_category_id_tbl(i) = PO_PDOI_CONSTANTS.g_NULLIFY_NUM THEN

3652: END IF;
3653:
3654: x_result_type := po_validations.c_result_type_success;
3655: FOR i IN 1 .. p_id_tbl.COUNT LOOP
3656: IF p_category_id_tbl(i) = PO_PDOI_CONSTANTS.g_NULLIFY_NUM THEN
3657: x_results.add_result(p_entity_type => c_entity_type_line,
3658: p_entity_id => p_id_tbl(i),
3659: p_column_name => 'CATEGORY_ID',
3660: p_column_val => p_category_id_tbl(i),

Line 3761: IF p_unit_price_tbl(i) = PO_PDOI_CONSTANTS.g_NULLIFY_NUM THEN

3757: x_result_type := po_validations.c_result_type_success;
3758:
3759: FOR i IN 1 .. p_id_tbl.COUNT LOOP
3760:
3761: IF p_unit_price_tbl(i) = PO_PDOI_CONSTANTS.g_NULLIFY_NUM THEN
3762: x_results.add_result(p_entity_type => c_entity_type_line,
3763: p_entity_id => p_id_tbl(i),
3764: p_column_name => 'UNIT_PRICE',
3765: p_column_val => p_unit_price_tbl(i),