DBA Data[Home] [Help]

APPS.PO_VAL_LINES2 dependencies on PO_PDOI_CONSTANTS

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

161: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
162: END IF;
163:
164: FOR i IN 1 .. p_id_tbl.COUNT LOOP
165: IF p_expiration_date_tbl(i) = PO_PDOI_CONSTANTS.g_NULLIFY_DATE THEN
166: x_results.add_result(p_entity_type => c_entity_type_line,
167: p_entity_id => p_id_tbl(i),
168: p_column_name => 'EXPIRATION_DATE',
169: p_column_val => p_expiration_date_tbl(i),

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

3157:
3158: x_result_type := po_validations.c_result_type_success;
3159:
3160: FOR i IN 1 .. p_id_tbl.COUNT LOOP
3161: IF p_ip_category_id_tbl(i) = PO_PDOI_CONSTANTS.g_NULLIFY_NUM THEN
3162: x_results.add_result(p_entity_type => c_entity_type_line,
3163: p_entity_id => p_id_tbl(i),
3164: p_column_name => 'IP_CATEGORY_ID',
3165: p_column_val => p_ip_category_id_tbl(i),

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

3249: END IF;
3250:
3251: x_result_type := po_validations.c_result_type_success;
3252: FOR i IN 1 .. p_id_tbl.COUNT LOOP
3253: IF p_unit_meas_lookup_code_tbl(i) = PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR THEN
3254: x_results.add_result(p_entity_type => c_entity_type_line,
3255: p_entity_id => p_id_tbl(i),
3256: p_column_name => 'UNIT_MEAS_LOOKUP_CODE',
3257: p_column_val => p_unit_meas_lookup_code_tbl(i),

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

3356: END IF;
3357:
3358: x_result_type := po_validations.c_result_type_success;
3359: FOR i IN 1 .. p_id_tbl.COUNT LOOP
3360: IF p_item_description_tbl(i) = PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR THEN
3361: x_results.add_result(p_entity_type => c_entity_type_line,
3362: p_entity_id => p_id_tbl(i),
3363: p_column_name => 'ITEM_DESCRIPTION',
3364: p_column_val => p_item_description_tbl(i),

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

3513: END IF;
3514:
3515: x_result_type := po_validations.c_result_type_success;
3516: FOR i IN 1 .. p_id_tbl.COUNT LOOP
3517: IF p_negotiated_by_preparer_tbl(i) = PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR THEN
3518: x_results.add_result(p_entity_type => c_entity_type_line,
3519: p_entity_id => p_id_tbl(i),
3520: p_column_name => 'NEGOTIATED_BY_PREPARER',
3521: p_column_val => p_negotiated_by_preparer_tbl(i),

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

3588: END IF;
3589:
3590: x_result_type := po_validations.c_result_type_success;
3591: FOR i IN 1 .. p_id_tbl.COUNT LOOP
3592: IF p_category_id_tbl(i) = PO_PDOI_CONSTANTS.g_NULLIFY_NUM THEN
3593: x_results.add_result(p_entity_type => c_entity_type_line,
3594: p_entity_id => p_id_tbl(i),
3595: p_column_name => 'CATEGORY_ID',
3596: p_column_val => p_category_id_tbl(i),

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

3693: x_result_type := po_validations.c_result_type_success;
3694:
3695: FOR i IN 1 .. p_id_tbl.COUNT LOOP
3696:
3697: IF p_unit_price_tbl(i) = PO_PDOI_CONSTANTS.g_NULLIFY_NUM THEN
3698: x_results.add_result(p_entity_type => c_entity_type_line,
3699: p_entity_id => p_id_tbl(i),
3700: p_column_name => 'UNIT_PRICE',
3701: p_column_val => p_unit_price_tbl(i),