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_PROFILE

Line 62: g_product_segment_definition fnd_profile_option_values.profile_option_value%TYPE;

58: -- cached meta data about product service
59: g_initialized BOOLEAN := FALSE;
60: g_default_po_category_set_id NUMBER;
61: g_structure_id NUMBER;
62: g_product_segment_definition fnd_profile_option_values.profile_option_value%TYPE;
63: g_product_segment_count NUMBER := 0;
64: g_product_segments product_segment_table;
65: g_structure_segment_count NUMBER := 0;
66: g_structure_segments structure_segment_table;

Line 99: l_temp fnd_profile_option_values.profile_option_value%TYPE;

95:
96: PROCEDURE validate_segment_definition
97: (x_status OUT NOCOPY VARCHAR2,
98: x_error_message OUT NOCOPY VARCHAR2) IS
99: l_temp fnd_profile_option_values.profile_option_value%TYPE;
100: l_char VARCHAR2(10);
101: l_index NUMBER;
102: l_length NUMBER;
103: l_dot_positions number_table;

Line 105: l_number_string fnd_profile_option_values.profile_option_value%TYPE;

101: l_index NUMBER;
102: l_length NUMBER;
103: l_dot_positions number_table;
104: l_number_of_dots NUMBER;
105: l_number_string fnd_profile_option_values.profile_option_value%TYPE;
106: l_start_pos NUMBER;
107: l_end_pos NUMBER;
108: l_number INTEGER;
109: l_segments_in_structure number_table;

Line 349: FROM fnd_profile_option_values

345:
346: -- get product and service segments definition
347:
348: FOR x IN (SELECT profile_option_value
349: FROM fnd_profile_option_values
350: WHERE profile_option_id IN
351: (SELECT profile_option_id
352: FROM fnd_profile_options
353: WHERE profile_option_name = g_product_segment_profile_name

Line 352: FROM fnd_profile_options

348: FOR x IN (SELECT profile_option_value
349: FROM fnd_profile_option_values
350: WHERE profile_option_id IN
351: (SELECT profile_option_id
352: FROM fnd_profile_options
353: WHERE profile_option_name = g_product_segment_profile_name
354: AND level_id = 10001
355: AND level_value = 0
356: )

Line 418: IF NOT fnd_profile.save(g_product_segment_profile_name, p_product_segment_definition, 'SITE') THEN

414: , x_error_message OUT NOCOPY VARCHAR2
415: ) IS
416: BEGIN
417:
418: IF NOT fnd_profile.save(g_product_segment_profile_name, p_product_segment_definition, 'SITE') THEN
419: x_status := g_no;
420: x_error_message := sqlerrm;
421: clear_cache;
422: RETURN;

Line 1203: l_seg_def fnd_profile_option_values.profile_option_value%TYPE;

1199: l_segcode_val varchar2(2000) := null;
1200: l_sql varchar2(4000) := null;
1201: l_parent_sql varchar2(4000) := null;
1202: l_pscur cursor_ref_type;
1203: l_seg_def fnd_profile_option_values.profile_option_value%TYPE;
1204: l_product_segment_profile_name CONSTANT VARCHAR2(30) := 'POS_PRODUCT_SERVICE_SEGMENTS';
1205:
1206: begin
1207:

Line 1208: l_seg_def := fnd_profile.value(l_product_segment_profile_name);

1204: l_product_segment_profile_name CONSTANT VARCHAR2(30) := 'POS_PRODUCT_SERVICE_SEGMENTS';
1205:
1206: begin
1207:
1208: l_seg_def := fnd_profile.value(l_product_segment_profile_name);
1209: l_segcode_val := x_segment_code;
1210:
1211: while (length(l_seg_def)) > l_start_pos
1212: loop

Line 1296: l_seg_def fnd_profile_option_values.profile_option_value%TYPE;

1292: l_segcode_val varchar2(2000) := null;
1293: l_sql varchar2(4000) := null;
1294: l_parent_sql varchar2(4000) := null;
1295: l_pscur cursor_ref_type;
1296: l_seg_def fnd_profile_option_values.profile_option_value%TYPE;
1297: l_product_segment_profile_name CONSTANT VARCHAR2(30) := 'POS_PRODUCT_SERVICE_SEGMENTS';
1298:
1299:
1300: begin

Line 1302: l_seg_def := fnd_profile.value(l_product_segment_profile_name);

1298:
1299:
1300: begin
1301:
1302: l_seg_def := fnd_profile.value(l_product_segment_profile_name);
1303:
1304: l_segcode_val := x_segment_code;
1305:
1306: while (length(l_seg_def)) > l_start_pos