APPS.POS_PRODUCT_SERVICE_UTL_PKG dependencies on FND_PROFILE_OPTION_VALUES

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 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 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