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.POS_PRODUCT_SERVICE_UTL_PKG dependencies on FND_FLEX_VALUES_VL

Line 438: l_description fnd_flex_values_vl.description%TYPE;

434: ) RETURN VARCHAR2
435: IS
436: l_id_or_value fnd_flex_validation_tables.id_column_name%TYPE;
437: l_cur cursor_ref_type;
438: l_description fnd_flex_values_vl.description%TYPE;
439: l_description2 fnd_flex_values_vl.description%TYPE;
440: BEGIN
441: IF g_product_segments(p_product_segment_index).validation_type = 'F' THEN -- table
442: -- build and cache the query if the query is not yet built

Line 439: l_description2 fnd_flex_values_vl.description%TYPE;

435: IS
436: l_id_or_value fnd_flex_validation_tables.id_column_name%TYPE;
437: l_cur cursor_ref_type;
438: l_description fnd_flex_values_vl.description%TYPE;
439: l_description2 fnd_flex_values_vl.description%TYPE;
440: BEGIN
441: IF g_product_segments(p_product_segment_index).validation_type = 'F' THEN -- table
442: -- build and cache the query if the query is not yet built
443: IF g_description_queries(p_product_segment_index) IS NULL THEN

Line 461: 'select description from fnd_flex_values_vl ' ||

457: using p_segment_value;
458: ELSIF g_product_segments(p_product_segment_index).validation_type IN ('I') THEN
459: -- validation type is independent
460: g_description_queries(p_product_segment_index) :=
461: 'select description from fnd_flex_values_vl ' ||
462: 'where flex_value_set_id = :1 and flex_value = :2 ';
463: OPEN l_cur FOR g_description_queries(p_product_segment_index)
464: using g_product_segments(p_product_segment_index).value_set_id, p_segment_value;
465: ELSIF g_product_segments(p_product_segment_index).validation_type IN ('D') THEN

Line 468: 'select description from fnd_flex_values_vl ' ||

464: using g_product_segments(p_product_segment_index).value_set_id, p_segment_value;
465: ELSIF g_product_segments(p_product_segment_index).validation_type IN ('D') THEN
466: -- validation type is dependent
467: g_description_queries(p_product_segment_index) :=
468: 'select description from fnd_flex_values_vl ' ||
469: ' where flex_value_set_id = :1 and flex_value = :2 and parent_flex_value_low = :3';
470: OPEN l_cur FOR g_description_queries(p_product_segment_index)
471: using g_product_segments(p_product_segment_index).value_set_id,
472: p_segment_value, p_parent_segment_value;

Line 998: from fnd_flex_values_vl

994: l_description varchar2(2000);
995: l_value varchar2(2000);
996: cursor parent_seg_value is
997: select *
998: from fnd_flex_values_vl
999: where flex_value_set_id = p_parent_seg_val_id;
1000:
1001: BEGIN
1002:

Line 1028: FROM fnd_flex_values_vl

1024: fnd_global.user_id,
1025: fnd_global.login_id,
1026: sysdate,
1027: fnd_global.user_id
1028: FROM fnd_flex_values_vl
1029: WHERE flex_value_set_id = p_curr_seg_val_id
1030: and not exists (select SEGMENT_VALUE_ID
1031: from pos_products_services_gt
1032: where SEGMENT_VALUE_ID = flex_value_id )

Line 1061: FROM fnd_flex_values_vl

1057: fnd_global.user_id,
1058: fnd_global.login_id,
1059: sysdate,
1060: fnd_global.user_id
1061: FROM fnd_flex_values_vl
1062: WHERE flex_value_set_id = p_curr_seg_val_id and
1063: parent_flex_value_low = c1.flex_value and
1064: not exists (select SEGMENT_VALUE_ID
1065: from pos_products_services_gt