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 63: g_product_segment_definition fnd_profile_option_values.profile_option_value%TYPE;

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

Line 100: l_temp fnd_profile_option_values.profile_option_value%TYPE;

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

Line 106: l_number_string fnd_profile_option_values.profile_option_value%TYPE;

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

Line 350: FROM fnd_profile_option_values

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

Line 353: FROM fnd_profile_options

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

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

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

Line 1369: l_seg_def fnd_profile_option_values.profile_option_value%TYPE;

1365: l_segcode_val varchar2(2000) := null;
1366: l_sql varchar2(4000) := null;
1367: l_parent_sql varchar2(4000) := null;
1368: l_pscur cursor_ref_type;
1369: l_seg_def fnd_profile_option_values.profile_option_value%TYPE;
1370: l_product_segment_profile_name CONSTANT VARCHAR2(30) := 'POS_PRODUCT_SERVICE_SEGMENTS';
1371:
1372: begin
1373:

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

1370: l_product_segment_profile_name CONSTANT VARCHAR2(30) := 'POS_PRODUCT_SERVICE_SEGMENTS';
1371:
1372: begin
1373:
1374: l_seg_def := fnd_profile.value(l_product_segment_profile_name);
1375: l_segcode_val := x_segment_code;
1376:
1377: while (length(l_seg_def)) > l_start_pos
1378: loop

Line 1467: l_seg_def fnd_profile_option_values.profile_option_value%TYPE;

1463: l_segcode_val varchar2(2000) := null;
1464: l_sql varchar2(4000) := null;
1465: l_parent_sql varchar2(4000) := null;
1466: l_pscur cursor_ref_type;
1467: l_seg_def fnd_profile_option_values.profile_option_value%TYPE;
1468: l_product_segment_profile_name CONSTANT VARCHAR2(30) := 'POS_PRODUCT_SERVICE_SEGMENTS';
1469:
1470:
1471: begin

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

1469:
1470:
1471: begin
1472:
1473: l_seg_def := fnd_profile.value(l_product_segment_profile_name);
1474:
1475: l_segcode_val := x_segment_code;
1476:
1477: while (length(l_seg_def)) > l_start_pos