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 POS_PRODUCTS_SERVICES_GT

Line 1004: insert into pos_products_services_gt(SEGMENT_VALUE ,

1000:
1001: BEGIN
1002:
1003: if (p_validation_type = 'I') then
1004: insert into pos_products_services_gt(SEGMENT_VALUE ,
1005: SEGMENT_VALUE_DESCRIPTION ,
1006: SUPPLIER_SELECTION ,
1007: PARENT_SEGMENT_VALUE ,
1008: PARENT_SEGMENT_VALUE_ID ,

Line 1031: from pos_products_services_gt

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 )
1033: );
1034: elsif (p_validation_type = 'D') then
1035: for c1 in parent_seg_value

Line 1037: insert into pos_products_services_gt(SEGMENT_VALUE ,

1033: );
1034: elsif (p_validation_type = 'D') then
1035: for c1 in parent_seg_value
1036: loop
1037: insert into pos_products_services_gt(SEGMENT_VALUE ,
1038: SEGMENT_VALUE_DESCRIPTION ,
1039: SUPPLIER_SELECTION ,
1040: PARENT_SEGMENT_VALUE ,
1041: PARENT_SEGMENT_VALUE_ID ,

Line 1065: from pos_products_services_gt

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
1066: where SEGMENT_VALUE_ID = flex_value_id)
1067:
1068: );
1069: end loop;

Line 1082: ' AND NOT EXISTS (select SEGMENT_VALUE_ID from pos_products_services_gt where SEGMENT_VALUE_ID = '||l_valorid_col||' ) ';

1078: l_tbl_sql := 'SELECT '||p_meaning||' description, '||
1079: l_valorid_col||' value '||
1080: ' FROM '||p_table_name||
1081: ' WHERE '||p_where_clause||
1082: ' AND NOT EXISTS (select SEGMENT_VALUE_ID from pos_products_services_gt where SEGMENT_VALUE_ID = '||l_valorid_col||' ) ';
1083:
1084: OPEN l_tblcur for l_tbl_sql;
1085: loop
1086: FETCH l_tblcur INTO l_description,l_value;

Line 1088: insert into pos_products_services_gt(SEGMENT_VALUE ,

1084: OPEN l_tblcur for l_tbl_sql;
1085: loop
1086: FETCH l_tblcur INTO l_description,l_value;
1087: EXIT WHEN l_tblcur%NOTFOUND;
1088: insert into pos_products_services_gt(SEGMENT_VALUE ,
1089: SEGMENT_VALUE_DESCRIPTION ,
1090: SUPPLIER_SELECTION ,
1091: PARENT_SEGMENT_VALUE ,
1092: PARENT_SEGMENT_VALUE_ID ,

Line 1135: FROM pos_products_services_gt

1131: l_contact_description VARCHAR2(4000) := null;
1132: l_segment_value_description VARCHAR2(240) := null;
1133: CURSOR c1 IS
1134: SELECT SEGMENT_VALUE_DESCRIPTION
1135: FROM pos_products_services_gt
1136: START WITH segment_value_id = x_segment_value_id
1137: CONNECT BY PRIOR parent_segment_value_id =segment_value_id
1138: ORDER BY parent_segment_value_id DESC;
1139:

Line 1166: FROM pos_products_services_gt

1162: l_contact_code VARCHAR2(4000) := null;
1163: l_segment_value_code VARCHAR2(240) := null;
1164: CURSOR c1 IS
1165: SELECT SEGMENT_VALUE
1166: FROM pos_products_services_gt
1167: START WITH segment_value_id = x_segment_value_id
1168: CONNECT BY PRIOR parent_segment_value_id =segment_value_id
1169: ORDER BY parent_segment_value_id DESC;
1170: