APPS.PV_ATTRIBUTE_PKG dependencies on FND_API

Line 59: p_display_style VARCHAR2 := FND_API.G_MISS_CHAR,

55: p_short_name VARCHAR2,
56:
57: --new columns added
58:
59: p_display_style VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_character_width NUMBER := FND_API.G_MISS_NUM,
61: p_decimal_points NUMBER := FND_API.G_MISS_NUM,
62: p_no_of_lines NUMBER := FND_API.G_MISS_NUM,
63: p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,

Line 60: p_character_width NUMBER := FND_API.G_MISS_NUM,

56:
57: --new columns added
58:
59: p_display_style VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_character_width NUMBER := FND_API.G_MISS_NUM,
61: p_decimal_points NUMBER := FND_API.G_MISS_NUM,
62: p_no_of_lines NUMBER := FND_API.G_MISS_NUM,
63: p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,

Line 61: p_decimal_points NUMBER := FND_API.G_MISS_NUM,

57: --new columns added
58:
59: p_display_style VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_character_width NUMBER := FND_API.G_MISS_NUM,
61: p_decimal_points NUMBER := FND_API.G_MISS_NUM,
62: p_no_of_lines NUMBER := FND_API.G_MISS_NUM,
63: p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,

Line 62: p_no_of_lines NUMBER := FND_API.G_MISS_NUM,

58:
59: p_display_style VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_character_width NUMBER := FND_API.G_MISS_NUM,
61: p_decimal_points NUMBER := FND_API.G_MISS_NUM,
62: p_no_of_lines NUMBER := FND_API.G_MISS_NUM,
63: p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_performance_flag VARCHAR2 := FND_API.G_MISS_CHAR,

Line 63: p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,

59: p_display_style VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_character_width NUMBER := FND_API.G_MISS_NUM,
61: p_decimal_points NUMBER := FND_API.G_MISS_NUM,
62: p_no_of_lines NUMBER := FND_API.G_MISS_NUM,
63: p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_performance_flag VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_additive_flag VARCHAR2 := FND_API.G_MISS_CHAR,

Line 64: p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,

60: p_character_width NUMBER := FND_API.G_MISS_NUM,
61: p_decimal_points NUMBER := FND_API.G_MISS_NUM,
62: p_no_of_lines NUMBER := FND_API.G_MISS_NUM,
63: p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_performance_flag VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_additive_flag VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_sequence_number NUMBER := FND_API.G_MISS_NUM

Line 65: p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,

61: p_decimal_points NUMBER := FND_API.G_MISS_NUM,
62: p_no_of_lines NUMBER := FND_API.G_MISS_NUM,
63: p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_performance_flag VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_additive_flag VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_sequence_number NUMBER := FND_API.G_MISS_NUM
69: )

Line 66: p_performance_flag VARCHAR2 := FND_API.G_MISS_CHAR,

62: p_no_of_lines NUMBER := FND_API.G_MISS_NUM,
63: p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_performance_flag VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_additive_flag VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_sequence_number NUMBER := FND_API.G_MISS_NUM
69: )
70:

Line 67: p_additive_flag VARCHAR2 := FND_API.G_MISS_CHAR,

63: p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_performance_flag VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_additive_flag VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_sequence_number NUMBER := FND_API.G_MISS_NUM
69: )
70:
71: IS

Line 68: p_sequence_number NUMBER := FND_API.G_MISS_NUM

64: p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_performance_flag VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_additive_flag VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_sequence_number NUMBER := FND_API.G_MISS_NUM
69: )
70:
71: IS
72: x_rowid VARCHAR2(30);

Line 108: DECODE( px_attribute_id, FND_API.g_miss_num, NULL, px_attribute_id),

104: performance_flag,
105: additive_flag,
106: sequence_number
107: ) VALUES (
108: DECODE( px_attribute_id, FND_API.g_miss_num, NULL, px_attribute_id),
109: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
110: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
111: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
112: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

Line 109: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

105: additive_flag,
106: sequence_number
107: ) VALUES (
108: DECODE( px_attribute_id, FND_API.g_miss_num, NULL, px_attribute_id),
109: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
110: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
111: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
112: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
113: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

Line 110: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

106: sequence_number
107: ) VALUES (
108: DECODE( px_attribute_id, FND_API.g_miss_num, NULL, px_attribute_id),
109: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
110: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
111: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
112: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
113: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
114: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

Line 111: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

107: ) VALUES (
108: DECODE( px_attribute_id, FND_API.g_miss_num, NULL, px_attribute_id),
109: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
110: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
111: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
112: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
113: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
114: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
115: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),

Line 112: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

108: DECODE( px_attribute_id, FND_API.g_miss_num, NULL, px_attribute_id),
109: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
110: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
111: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
112: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
113: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
114: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
115: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
116: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),

Line 113: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

109: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
110: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
111: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
112: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
113: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
114: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
115: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
116: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
117: DECODE( p_attribute_type, FND_API.g_miss_char, NULL, p_attribute_type),

Line 114: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

110: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
111: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
112: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
113: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
114: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
115: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
116: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
117: DECODE( p_attribute_type, FND_API.g_miss_char, NULL, p_attribute_type),
118: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),

Line 115: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),

111: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
112: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
113: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
114: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
115: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
116: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
117: DECODE( p_attribute_type, FND_API.g_miss_char, NULL, p_attribute_type),
118: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
119: DECODE( p_seeded_flag, FND_API.g_miss_char, NULL, p_seeded_flag),

Line 116: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),

112: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
113: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
114: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
115: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
116: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
117: DECODE( p_attribute_type, FND_API.g_miss_char, NULL, p_attribute_type),
118: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
119: DECODE( p_seeded_flag, FND_API.g_miss_char, NULL, p_seeded_flag),
120: DECODE( p_lov_function_name, FND_API.g_miss_char, NULL, p_lov_function_name),

Line 117: DECODE( p_attribute_type, FND_API.g_miss_char, NULL, p_attribute_type),

113: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
114: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
115: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
116: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
117: DECODE( p_attribute_type, FND_API.g_miss_char, NULL, p_attribute_type),
118: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
119: DECODE( p_seeded_flag, FND_API.g_miss_char, NULL, p_seeded_flag),
120: DECODE( p_lov_function_name, FND_API.g_miss_char, NULL, p_lov_function_name),
121: DECODE( p_return_type, FND_API.g_miss_char, NULL, p_return_type),

Line 118: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),

114: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
115: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
116: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
117: DECODE( p_attribute_type, FND_API.g_miss_char, NULL, p_attribute_type),
118: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
119: DECODE( p_seeded_flag, FND_API.g_miss_char, NULL, p_seeded_flag),
120: DECODE( p_lov_function_name, FND_API.g_miss_char, NULL, p_lov_function_name),
121: DECODE( p_return_type, FND_API.g_miss_char, NULL, p_return_type),
122: DECODE( p_max_value_flag, FND_API.g_miss_char, NULL, p_max_value_flag),

Line 119: DECODE( p_seeded_flag, FND_API.g_miss_char, NULL, p_seeded_flag),

115: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
116: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
117: DECODE( p_attribute_type, FND_API.g_miss_char, NULL, p_attribute_type),
118: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
119: DECODE( p_seeded_flag, FND_API.g_miss_char, NULL, p_seeded_flag),
120: DECODE( p_lov_function_name, FND_API.g_miss_char, NULL, p_lov_function_name),
121: DECODE( p_return_type, FND_API.g_miss_char, NULL, p_return_type),
122: DECODE( p_max_value_flag, FND_API.g_miss_char, NULL, p_max_value_flag),
123: DECODE( p_display_style, FND_API.g_miss_char, NULL, p_display_style),

Line 120: DECODE( p_lov_function_name, FND_API.g_miss_char, NULL, p_lov_function_name),

116: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
117: DECODE( p_attribute_type, FND_API.g_miss_char, NULL, p_attribute_type),
118: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
119: DECODE( p_seeded_flag, FND_API.g_miss_char, NULL, p_seeded_flag),
120: DECODE( p_lov_function_name, FND_API.g_miss_char, NULL, p_lov_function_name),
121: DECODE( p_return_type, FND_API.g_miss_char, NULL, p_return_type),
122: DECODE( p_max_value_flag, FND_API.g_miss_char, NULL, p_max_value_flag),
123: DECODE( p_display_style, FND_API.g_miss_char, NULL, p_display_style),
124: DECODE( p_character_width, FND_API.g_miss_num, NULL, p_character_width),

Line 121: DECODE( p_return_type, FND_API.g_miss_char, NULL, p_return_type),

117: DECODE( p_attribute_type, FND_API.g_miss_char, NULL, p_attribute_type),
118: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
119: DECODE( p_seeded_flag, FND_API.g_miss_char, NULL, p_seeded_flag),
120: DECODE( p_lov_function_name, FND_API.g_miss_char, NULL, p_lov_function_name),
121: DECODE( p_return_type, FND_API.g_miss_char, NULL, p_return_type),
122: DECODE( p_max_value_flag, FND_API.g_miss_char, NULL, p_max_value_flag),
123: DECODE( p_display_style, FND_API.g_miss_char, NULL, p_display_style),
124: DECODE( p_character_width, FND_API.g_miss_num, NULL, p_character_width),
125: DECODE( p_decimal_points, FND_API.g_miss_num, NULL, p_decimal_points),

Line 122: DECODE( p_max_value_flag, FND_API.g_miss_char, NULL, p_max_value_flag),

118: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
119: DECODE( p_seeded_flag, FND_API.g_miss_char, NULL, p_seeded_flag),
120: DECODE( p_lov_function_name, FND_API.g_miss_char, NULL, p_lov_function_name),
121: DECODE( p_return_type, FND_API.g_miss_char, NULL, p_return_type),
122: DECODE( p_max_value_flag, FND_API.g_miss_char, NULL, p_max_value_flag),
123: DECODE( p_display_style, FND_API.g_miss_char, NULL, p_display_style),
124: DECODE( p_character_width, FND_API.g_miss_num, NULL, p_character_width),
125: DECODE( p_decimal_points, FND_API.g_miss_num, NULL, p_decimal_points),
126: DECODE( p_no_of_lines, FND_API.g_miss_num, NULL, p_no_of_lines),

Line 123: DECODE( p_display_style, FND_API.g_miss_char, NULL, p_display_style),

119: DECODE( p_seeded_flag, FND_API.g_miss_char, NULL, p_seeded_flag),
120: DECODE( p_lov_function_name, FND_API.g_miss_char, NULL, p_lov_function_name),
121: DECODE( p_return_type, FND_API.g_miss_char, NULL, p_return_type),
122: DECODE( p_max_value_flag, FND_API.g_miss_char, NULL, p_max_value_flag),
123: DECODE( p_display_style, FND_API.g_miss_char, NULL, p_display_style),
124: DECODE( p_character_width, FND_API.g_miss_num, NULL, p_character_width),
125: DECODE( p_decimal_points, FND_API.g_miss_num, NULL, p_decimal_points),
126: DECODE( p_no_of_lines, FND_API.g_miss_num, NULL, p_no_of_lines),
127: DECODE( p_expose_to_partner_flag, FND_API.g_miss_char, NULL, p_expose_to_partner_flag),

Line 124: DECODE( p_character_width, FND_API.g_miss_num, NULL, p_character_width),

120: DECODE( p_lov_function_name, FND_API.g_miss_char, NULL, p_lov_function_name),
121: DECODE( p_return_type, FND_API.g_miss_char, NULL, p_return_type),
122: DECODE( p_max_value_flag, FND_API.g_miss_char, NULL, p_max_value_flag),
123: DECODE( p_display_style, FND_API.g_miss_char, NULL, p_display_style),
124: DECODE( p_character_width, FND_API.g_miss_num, NULL, p_character_width),
125: DECODE( p_decimal_points, FND_API.g_miss_num, NULL, p_decimal_points),
126: DECODE( p_no_of_lines, FND_API.g_miss_num, NULL, p_no_of_lines),
127: DECODE( p_expose_to_partner_flag, FND_API.g_miss_char, NULL, p_expose_to_partner_flag),
128: DECODE( p_value_extn_return_type, FND_API.g_miss_char, NULL, p_value_extn_return_type),

Line 125: DECODE( p_decimal_points, FND_API.g_miss_num, NULL, p_decimal_points),

121: DECODE( p_return_type, FND_API.g_miss_char, NULL, p_return_type),
122: DECODE( p_max_value_flag, FND_API.g_miss_char, NULL, p_max_value_flag),
123: DECODE( p_display_style, FND_API.g_miss_char, NULL, p_display_style),
124: DECODE( p_character_width, FND_API.g_miss_num, NULL, p_character_width),
125: DECODE( p_decimal_points, FND_API.g_miss_num, NULL, p_decimal_points),
126: DECODE( p_no_of_lines, FND_API.g_miss_num, NULL, p_no_of_lines),
127: DECODE( p_expose_to_partner_flag, FND_API.g_miss_char, NULL, p_expose_to_partner_flag),
128: DECODE( p_value_extn_return_type, FND_API.g_miss_char, NULL, p_value_extn_return_type),
129: DECODE( p_enable_matching_flag, FND_API.g_miss_char, NULL, p_enable_matching_flag),

Line 126: DECODE( p_no_of_lines, FND_API.g_miss_num, NULL, p_no_of_lines),

122: DECODE( p_max_value_flag, FND_API.g_miss_char, NULL, p_max_value_flag),
123: DECODE( p_display_style, FND_API.g_miss_char, NULL, p_display_style),
124: DECODE( p_character_width, FND_API.g_miss_num, NULL, p_character_width),
125: DECODE( p_decimal_points, FND_API.g_miss_num, NULL, p_decimal_points),
126: DECODE( p_no_of_lines, FND_API.g_miss_num, NULL, p_no_of_lines),
127: DECODE( p_expose_to_partner_flag, FND_API.g_miss_char, NULL, p_expose_to_partner_flag),
128: DECODE( p_value_extn_return_type, FND_API.g_miss_char, NULL, p_value_extn_return_type),
129: DECODE( p_enable_matching_flag, FND_API.g_miss_char, NULL, p_enable_matching_flag),
130: DECODE( p_performance_flag, FND_API.g_miss_char, NULL, p_performance_flag),

Line 127: DECODE( p_expose_to_partner_flag, FND_API.g_miss_char, NULL, p_expose_to_partner_flag),

123: DECODE( p_display_style, FND_API.g_miss_char, NULL, p_display_style),
124: DECODE( p_character_width, FND_API.g_miss_num, NULL, p_character_width),
125: DECODE( p_decimal_points, FND_API.g_miss_num, NULL, p_decimal_points),
126: DECODE( p_no_of_lines, FND_API.g_miss_num, NULL, p_no_of_lines),
127: DECODE( p_expose_to_partner_flag, FND_API.g_miss_char, NULL, p_expose_to_partner_flag),
128: DECODE( p_value_extn_return_type, FND_API.g_miss_char, NULL, p_value_extn_return_type),
129: DECODE( p_enable_matching_flag, FND_API.g_miss_char, NULL, p_enable_matching_flag),
130: DECODE( p_performance_flag, FND_API.g_miss_char, NULL, p_performance_flag),
131: DECODE( p_additive_flag, FND_API.g_miss_char, NULL, p_additive_flag),

Line 128: DECODE( p_value_extn_return_type, FND_API.g_miss_char, NULL, p_value_extn_return_type),

124: DECODE( p_character_width, FND_API.g_miss_num, NULL, p_character_width),
125: DECODE( p_decimal_points, FND_API.g_miss_num, NULL, p_decimal_points),
126: DECODE( p_no_of_lines, FND_API.g_miss_num, NULL, p_no_of_lines),
127: DECODE( p_expose_to_partner_flag, FND_API.g_miss_char, NULL, p_expose_to_partner_flag),
128: DECODE( p_value_extn_return_type, FND_API.g_miss_char, NULL, p_value_extn_return_type),
129: DECODE( p_enable_matching_flag, FND_API.g_miss_char, NULL, p_enable_matching_flag),
130: DECODE( p_performance_flag, FND_API.g_miss_char, NULL, p_performance_flag),
131: DECODE( p_additive_flag, FND_API.g_miss_char, NULL, p_additive_flag),
132: DECODE( p_sequence_number, FND_API.g_miss_num, NULL, p_sequence_number)

Line 129: DECODE( p_enable_matching_flag, FND_API.g_miss_char, NULL, p_enable_matching_flag),

125: DECODE( p_decimal_points, FND_API.g_miss_num, NULL, p_decimal_points),
126: DECODE( p_no_of_lines, FND_API.g_miss_num, NULL, p_no_of_lines),
127: DECODE( p_expose_to_partner_flag, FND_API.g_miss_char, NULL, p_expose_to_partner_flag),
128: DECODE( p_value_extn_return_type, FND_API.g_miss_char, NULL, p_value_extn_return_type),
129: DECODE( p_enable_matching_flag, FND_API.g_miss_char, NULL, p_enable_matching_flag),
130: DECODE( p_performance_flag, FND_API.g_miss_char, NULL, p_performance_flag),
131: DECODE( p_additive_flag, FND_API.g_miss_char, NULL, p_additive_flag),
132: DECODE( p_sequence_number, FND_API.g_miss_num, NULL, p_sequence_number)
133:

Line 130: DECODE( p_performance_flag, FND_API.g_miss_char, NULL, p_performance_flag),

126: DECODE( p_no_of_lines, FND_API.g_miss_num, NULL, p_no_of_lines),
127: DECODE( p_expose_to_partner_flag, FND_API.g_miss_char, NULL, p_expose_to_partner_flag),
128: DECODE( p_value_extn_return_type, FND_API.g_miss_char, NULL, p_value_extn_return_type),
129: DECODE( p_enable_matching_flag, FND_API.g_miss_char, NULL, p_enable_matching_flag),
130: DECODE( p_performance_flag, FND_API.g_miss_char, NULL, p_performance_flag),
131: DECODE( p_additive_flag, FND_API.g_miss_char, NULL, p_additive_flag),
132: DECODE( p_sequence_number, FND_API.g_miss_num, NULL, p_sequence_number)
133:
134: );

Line 131: DECODE( p_additive_flag, FND_API.g_miss_char, NULL, p_additive_flag),

127: DECODE( p_expose_to_partner_flag, FND_API.g_miss_char, NULL, p_expose_to_partner_flag),
128: DECODE( p_value_extn_return_type, FND_API.g_miss_char, NULL, p_value_extn_return_type),
129: DECODE( p_enable_matching_flag, FND_API.g_miss_char, NULL, p_enable_matching_flag),
130: DECODE( p_performance_flag, FND_API.g_miss_char, NULL, p_performance_flag),
131: DECODE( p_additive_flag, FND_API.g_miss_char, NULL, p_additive_flag),
132: DECODE( p_sequence_number, FND_API.g_miss_num, NULL, p_sequence_number)
133:
134: );
135:

Line 132: DECODE( p_sequence_number, FND_API.g_miss_num, NULL, p_sequence_number)

128: DECODE( p_value_extn_return_type, FND_API.g_miss_char, NULL, p_value_extn_return_type),
129: DECODE( p_enable_matching_flag, FND_API.g_miss_char, NULL, p_enable_matching_flag),
130: DECODE( p_performance_flag, FND_API.g_miss_char, NULL, p_performance_flag),
131: DECODE( p_additive_flag, FND_API.g_miss_char, NULL, p_additive_flag),
132: DECODE( p_sequence_number, FND_API.g_miss_num, NULL, p_sequence_number)
133:
134: );
135:
136: INSERT INTO pv_attributes_tl(

Line 150: decode( px_attribute_ID, FND_API.G_MISS_NUM, NULL, px_attribute_ID),

146: description,
147: short_name
148: )
149: SELECT
150: decode( px_attribute_ID, FND_API.G_MISS_NUM, NULL, px_attribute_ID),
151: l.language_code,
152: SYSDATE,
153: FND_GLOBAL.user_id,
154: SYSDATE,

Line 158: decode( p_name, FND_API.G_MISS_CHAR, NULL, p_name),

154: SYSDATE,
155: FND_GLOBAL.user_id,
156: FND_GLOBAL.conc_login_id,
157: USERENV('LANG'),
158: decode( p_name, FND_API.G_MISS_CHAR, NULL, p_name),
159: decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description),
160: decode( p_short_name, FND_API.G_MISS_CHAR, NULL, p_short_name)
161: FROM fnd_languages l
162: WHERE l.installed_flag in ('I', 'B')

Line 159: decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description),

155: FND_GLOBAL.user_id,
156: FND_GLOBAL.conc_login_id,
157: USERENV('LANG'),
158: decode( p_name, FND_API.G_MISS_CHAR, NULL, p_name),
159: decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description),
160: decode( p_short_name, FND_API.G_MISS_CHAR, NULL, p_short_name)
161: FROM fnd_languages l
162: WHERE l.installed_flag in ('I', 'B')
163: AND NOT EXISTS(

Line 160: decode( p_short_name, FND_API.G_MISS_CHAR, NULL, p_short_name)

156: FND_GLOBAL.conc_login_id,
157: USERENV('LANG'),
158: decode( p_name, FND_API.G_MISS_CHAR, NULL, p_name),
159: decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description),
160: decode( p_short_name, FND_API.G_MISS_CHAR, NULL, p_short_name)
161: FROM fnd_languages l
162: WHERE l.installed_flag in ('I', 'B')
163: AND NOT EXISTS(
164: SELECT NULL

Line 166: WHERE t.attribute_id = decode( px_attribute_id, FND_API.G_MISS_NUM, NULL, px_attribute_id)

162: WHERE l.installed_flag in ('I', 'B')
163: AND NOT EXISTS(
164: SELECT NULL
165: FROM pv_attributes_tl t
166: WHERE t.attribute_id = decode( px_attribute_id, FND_API.G_MISS_NUM, NULL, px_attribute_id)
167: AND t.language = l.language_code );
168:
169:
170: END Insert_Row;

Line 212: p_display_style VARCHAR2 := FND_API.G_MISS_CHAR,

208: p_short_name VARCHAR2,
209:
210: --new columns added
211:
212: p_display_style VARCHAR2 := FND_API.G_MISS_CHAR,
213: p_character_width NUMBER := FND_API.G_MISS_NUM,
214: p_decimal_points NUMBER := FND_API.G_MISS_NUM,
215: p_no_of_lines NUMBER := FND_API.G_MISS_NUM,
216: p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,

Line 213: p_character_width NUMBER := FND_API.G_MISS_NUM,

209:
210: --new columns added
211:
212: p_display_style VARCHAR2 := FND_API.G_MISS_CHAR,
213: p_character_width NUMBER := FND_API.G_MISS_NUM,
214: p_decimal_points NUMBER := FND_API.G_MISS_NUM,
215: p_no_of_lines NUMBER := FND_API.G_MISS_NUM,
216: p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,
217: p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,

Line 214: p_decimal_points NUMBER := FND_API.G_MISS_NUM,

210: --new columns added
211:
212: p_display_style VARCHAR2 := FND_API.G_MISS_CHAR,
213: p_character_width NUMBER := FND_API.G_MISS_NUM,
214: p_decimal_points NUMBER := FND_API.G_MISS_NUM,
215: p_no_of_lines NUMBER := FND_API.G_MISS_NUM,
216: p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,
217: p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,
218: p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,

Line 215: p_no_of_lines NUMBER := FND_API.G_MISS_NUM,

211:
212: p_display_style VARCHAR2 := FND_API.G_MISS_CHAR,
213: p_character_width NUMBER := FND_API.G_MISS_NUM,
214: p_decimal_points NUMBER := FND_API.G_MISS_NUM,
215: p_no_of_lines NUMBER := FND_API.G_MISS_NUM,
216: p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,
217: p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,
218: p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,
219: p_performance_flag VARCHAR2 := FND_API.G_MISS_CHAR,

Line 216: p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,

212: p_display_style VARCHAR2 := FND_API.G_MISS_CHAR,
213: p_character_width NUMBER := FND_API.G_MISS_NUM,
214: p_decimal_points NUMBER := FND_API.G_MISS_NUM,
215: p_no_of_lines NUMBER := FND_API.G_MISS_NUM,
216: p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,
217: p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,
218: p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,
219: p_performance_flag VARCHAR2 := FND_API.G_MISS_CHAR,
220: p_additive_flag VARCHAR2 := FND_API.G_MISS_CHAR,

Line 217: p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,

213: p_character_width NUMBER := FND_API.G_MISS_NUM,
214: p_decimal_points NUMBER := FND_API.G_MISS_NUM,
215: p_no_of_lines NUMBER := FND_API.G_MISS_NUM,
216: p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,
217: p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,
218: p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,
219: p_performance_flag VARCHAR2 := FND_API.G_MISS_CHAR,
220: p_additive_flag VARCHAR2 := FND_API.G_MISS_CHAR,
221: p_sequence_number NUMBER := FND_API.G_MISS_NUM

Line 218: p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,

214: p_decimal_points NUMBER := FND_API.G_MISS_NUM,
215: p_no_of_lines NUMBER := FND_API.G_MISS_NUM,
216: p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,
217: p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,
218: p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,
219: p_performance_flag VARCHAR2 := FND_API.G_MISS_CHAR,
220: p_additive_flag VARCHAR2 := FND_API.G_MISS_CHAR,
221: p_sequence_number NUMBER := FND_API.G_MISS_NUM
222: )

Line 219: p_performance_flag VARCHAR2 := FND_API.G_MISS_CHAR,

215: p_no_of_lines NUMBER := FND_API.G_MISS_NUM,
216: p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,
217: p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,
218: p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,
219: p_performance_flag VARCHAR2 := FND_API.G_MISS_CHAR,
220: p_additive_flag VARCHAR2 := FND_API.G_MISS_CHAR,
221: p_sequence_number NUMBER := FND_API.G_MISS_NUM
222: )
223:

Line 220: p_additive_flag VARCHAR2 := FND_API.G_MISS_CHAR,

216: p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,
217: p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,
218: p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,
219: p_performance_flag VARCHAR2 := FND_API.G_MISS_CHAR,
220: p_additive_flag VARCHAR2 := FND_API.G_MISS_CHAR,
221: p_sequence_number NUMBER := FND_API.G_MISS_NUM
222: )
223:
224: IS

Line 221: p_sequence_number NUMBER := FND_API.G_MISS_NUM

217: p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,
218: p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,
219: p_performance_flag VARCHAR2 := FND_API.G_MISS_CHAR,
220: p_additive_flag VARCHAR2 := FND_API.G_MISS_CHAR,
221: p_sequence_number NUMBER := FND_API.G_MISS_NUM
222: )
223:
224: IS
225: BEGIN

Line 228: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),

224: IS
225: BEGIN
226: Update PV_ATTRIBUTES_B
227: SET
228: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),
229: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
230: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
231: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
232: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

Line 229: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

225: BEGIN
226: Update PV_ATTRIBUTES_B
227: SET
228: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),
229: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
230: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
231: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
232: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
233: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

Line 230: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

226: Update PV_ATTRIBUTES_B
227: SET
228: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),
229: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
230: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
231: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
232: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
233: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
234: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),

Line 231: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),

227: SET
228: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),
229: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
230: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
231: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
232: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
233: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
234: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
235: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),

Line 232: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

228: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),
229: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
230: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
231: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
232: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
233: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
234: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
235: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
236: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),

Line 233: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

229: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
230: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
231: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
232: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
233: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
234: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
235: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
236: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
237: attribute_type = DECODE( p_attribute_type, FND_API.g_miss_char, attribute_type, p_attribute_type),

Line 234: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),

230: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
231: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
232: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
233: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
234: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
235: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
236: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
237: attribute_type = DECODE( p_attribute_type, FND_API.g_miss_char, attribute_type, p_attribute_type),
238: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),

Line 235: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),

231: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
232: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
233: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
234: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
235: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
236: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
237: attribute_type = DECODE( p_attribute_type, FND_API.g_miss_char, attribute_type, p_attribute_type),
238: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
239: seeded_flag = DECODE( p_seeded_flag, FND_API.g_miss_char, seeded_flag, p_seeded_flag),

Line 236: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),

232: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
233: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
234: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
235: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
236: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
237: attribute_type = DECODE( p_attribute_type, FND_API.g_miss_char, attribute_type, p_attribute_type),
238: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
239: seeded_flag = DECODE( p_seeded_flag, FND_API.g_miss_char, seeded_flag, p_seeded_flag),
240: lov_function_name = DECODE( p_lov_function_name, FND_API.g_miss_char, lov_function_name, p_lov_function_name),

Line 237: attribute_type = DECODE( p_attribute_type, FND_API.g_miss_char, attribute_type, p_attribute_type),

233: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
234: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
235: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
236: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
237: attribute_type = DECODE( p_attribute_type, FND_API.g_miss_char, attribute_type, p_attribute_type),
238: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
239: seeded_flag = DECODE( p_seeded_flag, FND_API.g_miss_char, seeded_flag, p_seeded_flag),
240: lov_function_name = DECODE( p_lov_function_name, FND_API.g_miss_char, lov_function_name, p_lov_function_name),
241: return_type = DECODE( p_return_type, FND_API.g_miss_char, return_type, p_return_type),

Line 238: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),

234: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
235: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
236: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
237: attribute_type = DECODE( p_attribute_type, FND_API.g_miss_char, attribute_type, p_attribute_type),
238: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
239: seeded_flag = DECODE( p_seeded_flag, FND_API.g_miss_char, seeded_flag, p_seeded_flag),
240: lov_function_name = DECODE( p_lov_function_name, FND_API.g_miss_char, lov_function_name, p_lov_function_name),
241: return_type = DECODE( p_return_type, FND_API.g_miss_char, return_type, p_return_type),
242: max_value_flag = DECODE( p_max_value_flag, FND_API.g_miss_char, max_value_flag, p_max_value_flag),

Line 239: seeded_flag = DECODE( p_seeded_flag, FND_API.g_miss_char, seeded_flag, p_seeded_flag),

235: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
236: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
237: attribute_type = DECODE( p_attribute_type, FND_API.g_miss_char, attribute_type, p_attribute_type),
238: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
239: seeded_flag = DECODE( p_seeded_flag, FND_API.g_miss_char, seeded_flag, p_seeded_flag),
240: lov_function_name = DECODE( p_lov_function_name, FND_API.g_miss_char, lov_function_name, p_lov_function_name),
241: return_type = DECODE( p_return_type, FND_API.g_miss_char, return_type, p_return_type),
242: max_value_flag = DECODE( p_max_value_flag, FND_API.g_miss_char, max_value_flag, p_max_value_flag),
243:

Line 240: lov_function_name = DECODE( p_lov_function_name, FND_API.g_miss_char, lov_function_name, p_lov_function_name),

236: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
237: attribute_type = DECODE( p_attribute_type, FND_API.g_miss_char, attribute_type, p_attribute_type),
238: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
239: seeded_flag = DECODE( p_seeded_flag, FND_API.g_miss_char, seeded_flag, p_seeded_flag),
240: lov_function_name = DECODE( p_lov_function_name, FND_API.g_miss_char, lov_function_name, p_lov_function_name),
241: return_type = DECODE( p_return_type, FND_API.g_miss_char, return_type, p_return_type),
242: max_value_flag = DECODE( p_max_value_flag, FND_API.g_miss_char, max_value_flag, p_max_value_flag),
243:
244: display_style = DECODE( p_display_style, FND_API.g_miss_char, display_style, p_display_style),

Line 241: return_type = DECODE( p_return_type, FND_API.g_miss_char, return_type, p_return_type),

237: attribute_type = DECODE( p_attribute_type, FND_API.g_miss_char, attribute_type, p_attribute_type),
238: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
239: seeded_flag = DECODE( p_seeded_flag, FND_API.g_miss_char, seeded_flag, p_seeded_flag),
240: lov_function_name = DECODE( p_lov_function_name, FND_API.g_miss_char, lov_function_name, p_lov_function_name),
241: return_type = DECODE( p_return_type, FND_API.g_miss_char, return_type, p_return_type),
242: max_value_flag = DECODE( p_max_value_flag, FND_API.g_miss_char, max_value_flag, p_max_value_flag),
243:
244: display_style = DECODE( p_display_style, FND_API.g_miss_char, display_style, p_display_style),
245: character_width = DECODE( p_character_width, FND_API.g_miss_num, character_width, p_character_width),

Line 242: max_value_flag = DECODE( p_max_value_flag, FND_API.g_miss_char, max_value_flag, p_max_value_flag),

238: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
239: seeded_flag = DECODE( p_seeded_flag, FND_API.g_miss_char, seeded_flag, p_seeded_flag),
240: lov_function_name = DECODE( p_lov_function_name, FND_API.g_miss_char, lov_function_name, p_lov_function_name),
241: return_type = DECODE( p_return_type, FND_API.g_miss_char, return_type, p_return_type),
242: max_value_flag = DECODE( p_max_value_flag, FND_API.g_miss_char, max_value_flag, p_max_value_flag),
243:
244: display_style = DECODE( p_display_style, FND_API.g_miss_char, display_style, p_display_style),
245: character_width = DECODE( p_character_width, FND_API.g_miss_num, character_width, p_character_width),
246: decimal_points = DECODE( p_decimal_points, FND_API.g_miss_num, decimal_points, p_decimal_points),

Line 244: display_style = DECODE( p_display_style, FND_API.g_miss_char, display_style, p_display_style),

240: lov_function_name = DECODE( p_lov_function_name, FND_API.g_miss_char, lov_function_name, p_lov_function_name),
241: return_type = DECODE( p_return_type, FND_API.g_miss_char, return_type, p_return_type),
242: max_value_flag = DECODE( p_max_value_flag, FND_API.g_miss_char, max_value_flag, p_max_value_flag),
243:
244: display_style = DECODE( p_display_style, FND_API.g_miss_char, display_style, p_display_style),
245: character_width = DECODE( p_character_width, FND_API.g_miss_num, character_width, p_character_width),
246: decimal_points = DECODE( p_decimal_points, FND_API.g_miss_num, decimal_points, p_decimal_points),
247: no_of_lines = DECODE( p_no_of_lines, FND_API.g_miss_num, no_of_lines, p_no_of_lines),
248: expose_to_partner_flag = DECODE( p_expose_to_partner_flag, FND_API.g_miss_char, expose_to_partner_flag, p_expose_to_partner_flag),

Line 245: character_width = DECODE( p_character_width, FND_API.g_miss_num, character_width, p_character_width),

241: return_type = DECODE( p_return_type, FND_API.g_miss_char, return_type, p_return_type),
242: max_value_flag = DECODE( p_max_value_flag, FND_API.g_miss_char, max_value_flag, p_max_value_flag),
243:
244: display_style = DECODE( p_display_style, FND_API.g_miss_char, display_style, p_display_style),
245: character_width = DECODE( p_character_width, FND_API.g_miss_num, character_width, p_character_width),
246: decimal_points = DECODE( p_decimal_points, FND_API.g_miss_num, decimal_points, p_decimal_points),
247: no_of_lines = DECODE( p_no_of_lines, FND_API.g_miss_num, no_of_lines, p_no_of_lines),
248: expose_to_partner_flag = DECODE( p_expose_to_partner_flag, FND_API.g_miss_char, expose_to_partner_flag, p_expose_to_partner_flag),
249: value_extn_return_type = DECODE( p_value_extn_return_type, FND_API.g_miss_char, value_extn_return_type, p_value_extn_return_type),

Line 246: decimal_points = DECODE( p_decimal_points, FND_API.g_miss_num, decimal_points, p_decimal_points),

242: max_value_flag = DECODE( p_max_value_flag, FND_API.g_miss_char, max_value_flag, p_max_value_flag),
243:
244: display_style = DECODE( p_display_style, FND_API.g_miss_char, display_style, p_display_style),
245: character_width = DECODE( p_character_width, FND_API.g_miss_num, character_width, p_character_width),
246: decimal_points = DECODE( p_decimal_points, FND_API.g_miss_num, decimal_points, p_decimal_points),
247: no_of_lines = DECODE( p_no_of_lines, FND_API.g_miss_num, no_of_lines, p_no_of_lines),
248: expose_to_partner_flag = DECODE( p_expose_to_partner_flag, FND_API.g_miss_char, expose_to_partner_flag, p_expose_to_partner_flag),
249: value_extn_return_type = DECODE( p_value_extn_return_type, FND_API.g_miss_char, value_extn_return_type, p_value_extn_return_type),
250: enable_matching_flag = DECODE( p_enable_matching_flag, FND_API.g_miss_char, enable_matching_flag, p_enable_matching_flag),

Line 247: no_of_lines = DECODE( p_no_of_lines, FND_API.g_miss_num, no_of_lines, p_no_of_lines),

243:
244: display_style = DECODE( p_display_style, FND_API.g_miss_char, display_style, p_display_style),
245: character_width = DECODE( p_character_width, FND_API.g_miss_num, character_width, p_character_width),
246: decimal_points = DECODE( p_decimal_points, FND_API.g_miss_num, decimal_points, p_decimal_points),
247: no_of_lines = DECODE( p_no_of_lines, FND_API.g_miss_num, no_of_lines, p_no_of_lines),
248: expose_to_partner_flag = DECODE( p_expose_to_partner_flag, FND_API.g_miss_char, expose_to_partner_flag, p_expose_to_partner_flag),
249: value_extn_return_type = DECODE( p_value_extn_return_type, FND_API.g_miss_char, value_extn_return_type, p_value_extn_return_type),
250: enable_matching_flag = DECODE( p_enable_matching_flag, FND_API.g_miss_char, enable_matching_flag, p_enable_matching_flag),
251: performance_flag = DECODE( p_performance_flag, FND_API.g_miss_char, performance_flag, p_performance_flag),

Line 248: expose_to_partner_flag = DECODE( p_expose_to_partner_flag, FND_API.g_miss_char, expose_to_partner_flag, p_expose_to_partner_flag),

244: display_style = DECODE( p_display_style, FND_API.g_miss_char, display_style, p_display_style),
245: character_width = DECODE( p_character_width, FND_API.g_miss_num, character_width, p_character_width),
246: decimal_points = DECODE( p_decimal_points, FND_API.g_miss_num, decimal_points, p_decimal_points),
247: no_of_lines = DECODE( p_no_of_lines, FND_API.g_miss_num, no_of_lines, p_no_of_lines),
248: expose_to_partner_flag = DECODE( p_expose_to_partner_flag, FND_API.g_miss_char, expose_to_partner_flag, p_expose_to_partner_flag),
249: value_extn_return_type = DECODE( p_value_extn_return_type, FND_API.g_miss_char, value_extn_return_type, p_value_extn_return_type),
250: enable_matching_flag = DECODE( p_enable_matching_flag, FND_API.g_miss_char, enable_matching_flag, p_enable_matching_flag),
251: performance_flag = DECODE( p_performance_flag, FND_API.g_miss_char, performance_flag, p_performance_flag),
252: additive_flag = DECODE( p_additive_flag, FND_API.g_miss_char, additive_flag, p_additive_flag),

Line 249: value_extn_return_type = DECODE( p_value_extn_return_type, FND_API.g_miss_char, value_extn_return_type, p_value_extn_return_type),

245: character_width = DECODE( p_character_width, FND_API.g_miss_num, character_width, p_character_width),
246: decimal_points = DECODE( p_decimal_points, FND_API.g_miss_num, decimal_points, p_decimal_points),
247: no_of_lines = DECODE( p_no_of_lines, FND_API.g_miss_num, no_of_lines, p_no_of_lines),
248: expose_to_partner_flag = DECODE( p_expose_to_partner_flag, FND_API.g_miss_char, expose_to_partner_flag, p_expose_to_partner_flag),
249: value_extn_return_type = DECODE( p_value_extn_return_type, FND_API.g_miss_char, value_extn_return_type, p_value_extn_return_type),
250: enable_matching_flag = DECODE( p_enable_matching_flag, FND_API.g_miss_char, enable_matching_flag, p_enable_matching_flag),
251: performance_flag = DECODE( p_performance_flag, FND_API.g_miss_char, performance_flag, p_performance_flag),
252: additive_flag = DECODE( p_additive_flag, FND_API.g_miss_char, additive_flag, p_additive_flag),
253: sequence_number = DECODE( p_sequence_number, FND_API.g_miss_num, sequence_number, p_sequence_number)

Line 250: enable_matching_flag = DECODE( p_enable_matching_flag, FND_API.g_miss_char, enable_matching_flag, p_enable_matching_flag),

246: decimal_points = DECODE( p_decimal_points, FND_API.g_miss_num, decimal_points, p_decimal_points),
247: no_of_lines = DECODE( p_no_of_lines, FND_API.g_miss_num, no_of_lines, p_no_of_lines),
248: expose_to_partner_flag = DECODE( p_expose_to_partner_flag, FND_API.g_miss_char, expose_to_partner_flag, p_expose_to_partner_flag),
249: value_extn_return_type = DECODE( p_value_extn_return_type, FND_API.g_miss_char, value_extn_return_type, p_value_extn_return_type),
250: enable_matching_flag = DECODE( p_enable_matching_flag, FND_API.g_miss_char, enable_matching_flag, p_enable_matching_flag),
251: performance_flag = DECODE( p_performance_flag, FND_API.g_miss_char, performance_flag, p_performance_flag),
252: additive_flag = DECODE( p_additive_flag, FND_API.g_miss_char, additive_flag, p_additive_flag),
253: sequence_number = DECODE( p_sequence_number, FND_API.g_miss_num, sequence_number, p_sequence_number)
254:

Line 251: performance_flag = DECODE( p_performance_flag, FND_API.g_miss_char, performance_flag, p_performance_flag),

247: no_of_lines = DECODE( p_no_of_lines, FND_API.g_miss_num, no_of_lines, p_no_of_lines),
248: expose_to_partner_flag = DECODE( p_expose_to_partner_flag, FND_API.g_miss_char, expose_to_partner_flag, p_expose_to_partner_flag),
249: value_extn_return_type = DECODE( p_value_extn_return_type, FND_API.g_miss_char, value_extn_return_type, p_value_extn_return_type),
250: enable_matching_flag = DECODE( p_enable_matching_flag, FND_API.g_miss_char, enable_matching_flag, p_enable_matching_flag),
251: performance_flag = DECODE( p_performance_flag, FND_API.g_miss_char, performance_flag, p_performance_flag),
252: additive_flag = DECODE( p_additive_flag, FND_API.g_miss_char, additive_flag, p_additive_flag),
253: sequence_number = DECODE( p_sequence_number, FND_API.g_miss_num, sequence_number, p_sequence_number)
254:
255:

Line 252: additive_flag = DECODE( p_additive_flag, FND_API.g_miss_char, additive_flag, p_additive_flag),

248: expose_to_partner_flag = DECODE( p_expose_to_partner_flag, FND_API.g_miss_char, expose_to_partner_flag, p_expose_to_partner_flag),
249: value_extn_return_type = DECODE( p_value_extn_return_type, FND_API.g_miss_char, value_extn_return_type, p_value_extn_return_type),
250: enable_matching_flag = DECODE( p_enable_matching_flag, FND_API.g_miss_char, enable_matching_flag, p_enable_matching_flag),
251: performance_flag = DECODE( p_performance_flag, FND_API.g_miss_char, performance_flag, p_performance_flag),
252: additive_flag = DECODE( p_additive_flag, FND_API.g_miss_char, additive_flag, p_additive_flag),
253: sequence_number = DECODE( p_sequence_number, FND_API.g_miss_num, sequence_number, p_sequence_number)
254:
255:
256: WHERE ATTRIBUTE_ID = p_ATTRIBUTE_ID

Line 253: sequence_number = DECODE( p_sequence_number, FND_API.g_miss_num, sequence_number, p_sequence_number)

249: value_extn_return_type = DECODE( p_value_extn_return_type, FND_API.g_miss_char, value_extn_return_type, p_value_extn_return_type),
250: enable_matching_flag = DECODE( p_enable_matching_flag, FND_API.g_miss_char, enable_matching_flag, p_enable_matching_flag),
251: performance_flag = DECODE( p_performance_flag, FND_API.g_miss_char, performance_flag, p_performance_flag),
252: additive_flag = DECODE( p_additive_flag, FND_API.g_miss_char, additive_flag, p_additive_flag),
253: sequence_number = DECODE( p_sequence_number, FND_API.g_miss_num, sequence_number, p_sequence_number)
254:
255:
256: WHERE ATTRIBUTE_ID = p_ATTRIBUTE_ID
257: AND object_version_number = p_object_version_number;

Line 261: name = decode( p_name, FND_API.G_MISS_CHAR, name, p_name),

257: AND object_version_number = p_object_version_number;
258:
259:
260: update pv_attributes_tl set
261: name = decode( p_name, FND_API.G_MISS_CHAR, name, p_name),
262: description = decode( p_description, FND_API.G_MISS_CHAR, description, p_description),
263: short_name = decode( p_short_name, FND_API.G_MISS_CHAR, short_name, p_short_name),
264: last_update_date = SYSDATE,
265: last_updated_by = FND_GLOBAL.user_id,

Line 262: description = decode( p_description, FND_API.G_MISS_CHAR, description, p_description),

258:
259:
260: update pv_attributes_tl set
261: name = decode( p_name, FND_API.G_MISS_CHAR, name, p_name),
262: description = decode( p_description, FND_API.G_MISS_CHAR, description, p_description),
263: short_name = decode( p_short_name, FND_API.G_MISS_CHAR, short_name, p_short_name),
264: last_update_date = SYSDATE,
265: last_updated_by = FND_GLOBAL.user_id,
266: last_update_login = FND_GLOBAL.conc_login_id,

Line 263: short_name = decode( p_short_name, FND_API.G_MISS_CHAR, short_name, p_short_name),

259:
260: update pv_attributes_tl set
261: name = decode( p_name, FND_API.G_MISS_CHAR, name, p_name),
262: description = decode( p_description, FND_API.G_MISS_CHAR, description, p_description),
263: short_name = decode( p_short_name, FND_API.G_MISS_CHAR, short_name, p_short_name),
264: last_update_date = SYSDATE,
265: last_updated_by = FND_GLOBAL.user_id,
266: last_update_login = FND_GLOBAL.conc_login_id,
267: source_lang = USERENV('LANG')

Line 272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

268: WHERE attribute_id = p_attribute_ID
269: AND USERENV('LANG') IN (language, source_lang);
270:
271: IF (SQL%NOTFOUND) THEN
272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
273: END IF;
274: END Update_Row;
275:
276: PROCEDURE Update_Row_Seed(

Line 298: p_display_style VARCHAR2 := FND_API.G_MISS_CHAR,

294: p_short_name VARCHAR2,
295:
296: --new columns added
297:
298: p_display_style VARCHAR2 := FND_API.G_MISS_CHAR,
299: p_character_width NUMBER := FND_API.G_MISS_NUM,
300: p_decimal_points NUMBER := FND_API.G_MISS_NUM,
301: p_no_of_lines NUMBER := FND_API.G_MISS_NUM,
302: p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,

Line 299: p_character_width NUMBER := FND_API.G_MISS_NUM,

295:
296: --new columns added
297:
298: p_display_style VARCHAR2 := FND_API.G_MISS_CHAR,
299: p_character_width NUMBER := FND_API.G_MISS_NUM,
300: p_decimal_points NUMBER := FND_API.G_MISS_NUM,
301: p_no_of_lines NUMBER := FND_API.G_MISS_NUM,
302: p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,

Line 300: p_decimal_points NUMBER := FND_API.G_MISS_NUM,

296: --new columns added
297:
298: p_display_style VARCHAR2 := FND_API.G_MISS_CHAR,
299: p_character_width NUMBER := FND_API.G_MISS_NUM,
300: p_decimal_points NUMBER := FND_API.G_MISS_NUM,
301: p_no_of_lines NUMBER := FND_API.G_MISS_NUM,
302: p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,

Line 301: p_no_of_lines NUMBER := FND_API.G_MISS_NUM,

297:
298: p_display_style VARCHAR2 := FND_API.G_MISS_CHAR,
299: p_character_width NUMBER := FND_API.G_MISS_NUM,
300: p_decimal_points NUMBER := FND_API.G_MISS_NUM,
301: p_no_of_lines NUMBER := FND_API.G_MISS_NUM,
302: p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,
305: p_performance_flag VARCHAR2 := FND_API.G_MISS_CHAR,

Line 302: p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,

298: p_display_style VARCHAR2 := FND_API.G_MISS_CHAR,
299: p_character_width NUMBER := FND_API.G_MISS_NUM,
300: p_decimal_points NUMBER := FND_API.G_MISS_NUM,
301: p_no_of_lines NUMBER := FND_API.G_MISS_NUM,
302: p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,
305: p_performance_flag VARCHAR2 := FND_API.G_MISS_CHAR,
306: p_additive_flag VARCHAR2 := FND_API.G_MISS_CHAR,

Line 303: p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,

299: p_character_width NUMBER := FND_API.G_MISS_NUM,
300: p_decimal_points NUMBER := FND_API.G_MISS_NUM,
301: p_no_of_lines NUMBER := FND_API.G_MISS_NUM,
302: p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,
305: p_performance_flag VARCHAR2 := FND_API.G_MISS_CHAR,
306: p_additive_flag VARCHAR2 := FND_API.G_MISS_CHAR,
307: p_sequence_number NUMBER := FND_API.G_MISS_NUM

Line 304: p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,

300: p_decimal_points NUMBER := FND_API.G_MISS_NUM,
301: p_no_of_lines NUMBER := FND_API.G_MISS_NUM,
302: p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,
305: p_performance_flag VARCHAR2 := FND_API.G_MISS_CHAR,
306: p_additive_flag VARCHAR2 := FND_API.G_MISS_CHAR,
307: p_sequence_number NUMBER := FND_API.G_MISS_NUM
308: )

Line 305: p_performance_flag VARCHAR2 := FND_API.G_MISS_CHAR,

301: p_no_of_lines NUMBER := FND_API.G_MISS_NUM,
302: p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,
305: p_performance_flag VARCHAR2 := FND_API.G_MISS_CHAR,
306: p_additive_flag VARCHAR2 := FND_API.G_MISS_CHAR,
307: p_sequence_number NUMBER := FND_API.G_MISS_NUM
308: )
309:

Line 306: p_additive_flag VARCHAR2 := FND_API.G_MISS_CHAR,

302: p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,
305: p_performance_flag VARCHAR2 := FND_API.G_MISS_CHAR,
306: p_additive_flag VARCHAR2 := FND_API.G_MISS_CHAR,
307: p_sequence_number NUMBER := FND_API.G_MISS_NUM
308: )
309:
310: IS

Line 307: p_sequence_number NUMBER := FND_API.G_MISS_NUM

303: p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,
305: p_performance_flag VARCHAR2 := FND_API.G_MISS_CHAR,
306: p_additive_flag VARCHAR2 := FND_API.G_MISS_CHAR,
307: p_sequence_number NUMBER := FND_API.G_MISS_NUM
308: )
309:
310: IS
311:

Line 342: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),

338: if( l_last_updated_by = 1) then
339:
340: Update PV_ATTRIBUTES_B
341: SET
342: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),
343: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
344: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
345: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
346: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

Line 343: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

339:
340: Update PV_ATTRIBUTES_B
341: SET
342: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),
343: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
344: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
345: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
346: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
347: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

Line 344: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

340: Update PV_ATTRIBUTES_B
341: SET
342: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),
343: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
344: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
345: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
346: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
347: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
348: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),

Line 345: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),

341: SET
342: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),
343: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
344: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
345: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
346: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
347: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
348: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
349: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),

Line 346: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

342: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),
343: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
344: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
345: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
346: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
347: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
348: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
349: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
350: -- enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),

Line 347: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

343: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
344: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
345: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
346: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
347: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
348: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
349: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
350: -- enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
351: attribute_type = DECODE( p_attribute_type, FND_API.g_miss_char, attribute_type, p_attribute_type),

Line 348: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),

344: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
345: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
346: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
347: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
348: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
349: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
350: -- enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
351: attribute_type = DECODE( p_attribute_type, FND_API.g_miss_char, attribute_type, p_attribute_type),
352: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),

Line 349: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),

345: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
346: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
347: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
348: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
349: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
350: -- enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
351: attribute_type = DECODE( p_attribute_type, FND_API.g_miss_char, attribute_type, p_attribute_type),
352: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
353: seeded_flag = DECODE( p_seeded_flag, FND_API.g_miss_char, seeded_flag, p_seeded_flag),

Line 350: -- enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),

346: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
347: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
348: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
349: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
350: -- enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
351: attribute_type = DECODE( p_attribute_type, FND_API.g_miss_char, attribute_type, p_attribute_type),
352: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
353: seeded_flag = DECODE( p_seeded_flag, FND_API.g_miss_char, seeded_flag, p_seeded_flag),
354: lov_function_name = DECODE( p_lov_function_name, FND_API.g_miss_char, lov_function_name, p_lov_function_name),

Line 351: attribute_type = DECODE( p_attribute_type, FND_API.g_miss_char, attribute_type, p_attribute_type),

347: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
348: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
349: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
350: -- enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
351: attribute_type = DECODE( p_attribute_type, FND_API.g_miss_char, attribute_type, p_attribute_type),
352: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
353: seeded_flag = DECODE( p_seeded_flag, FND_API.g_miss_char, seeded_flag, p_seeded_flag),
354: lov_function_name = DECODE( p_lov_function_name, FND_API.g_miss_char, lov_function_name, p_lov_function_name),
355: return_type = DECODE( p_return_type, FND_API.g_miss_char, return_type, p_return_type),

Line 352: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),

348: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
349: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
350: -- enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
351: attribute_type = DECODE( p_attribute_type, FND_API.g_miss_char, attribute_type, p_attribute_type),
352: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
353: seeded_flag = DECODE( p_seeded_flag, FND_API.g_miss_char, seeded_flag, p_seeded_flag),
354: lov_function_name = DECODE( p_lov_function_name, FND_API.g_miss_char, lov_function_name, p_lov_function_name),
355: return_type = DECODE( p_return_type, FND_API.g_miss_char, return_type, p_return_type),
356: max_value_flag = DECODE( p_max_value_flag, FND_API.g_miss_char, max_value_flag, p_max_value_flag),

Line 353: seeded_flag = DECODE( p_seeded_flag, FND_API.g_miss_char, seeded_flag, p_seeded_flag),

349: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
350: -- enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
351: attribute_type = DECODE( p_attribute_type, FND_API.g_miss_char, attribute_type, p_attribute_type),
352: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
353: seeded_flag = DECODE( p_seeded_flag, FND_API.g_miss_char, seeded_flag, p_seeded_flag),
354: lov_function_name = DECODE( p_lov_function_name, FND_API.g_miss_char, lov_function_name, p_lov_function_name),
355: return_type = DECODE( p_return_type, FND_API.g_miss_char, return_type, p_return_type),
356: max_value_flag = DECODE( p_max_value_flag, FND_API.g_miss_char, max_value_flag, p_max_value_flag),
357: display_style = DECODE( p_display_style, FND_API.g_miss_char, display_style, p_display_style),

Line 354: lov_function_name = DECODE( p_lov_function_name, FND_API.g_miss_char, lov_function_name, p_lov_function_name),

350: -- enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
351: attribute_type = DECODE( p_attribute_type, FND_API.g_miss_char, attribute_type, p_attribute_type),
352: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
353: seeded_flag = DECODE( p_seeded_flag, FND_API.g_miss_char, seeded_flag, p_seeded_flag),
354: lov_function_name = DECODE( p_lov_function_name, FND_API.g_miss_char, lov_function_name, p_lov_function_name),
355: return_type = DECODE( p_return_type, FND_API.g_miss_char, return_type, p_return_type),
356: max_value_flag = DECODE( p_max_value_flag, FND_API.g_miss_char, max_value_flag, p_max_value_flag),
357: display_style = DECODE( p_display_style, FND_API.g_miss_char, display_style, p_display_style),
358: -- character_width = DECODE( p_character_width, FND_API.g_miss_num, character_width, p_character_width),

Line 355: return_type = DECODE( p_return_type, FND_API.g_miss_char, return_type, p_return_type),

351: attribute_type = DECODE( p_attribute_type, FND_API.g_miss_char, attribute_type, p_attribute_type),
352: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
353: seeded_flag = DECODE( p_seeded_flag, FND_API.g_miss_char, seeded_flag, p_seeded_flag),
354: lov_function_name = DECODE( p_lov_function_name, FND_API.g_miss_char, lov_function_name, p_lov_function_name),
355: return_type = DECODE( p_return_type, FND_API.g_miss_char, return_type, p_return_type),
356: max_value_flag = DECODE( p_max_value_flag, FND_API.g_miss_char, max_value_flag, p_max_value_flag),
357: display_style = DECODE( p_display_style, FND_API.g_miss_char, display_style, p_display_style),
358: -- character_width = DECODE( p_character_width, FND_API.g_miss_num, character_width, p_character_width),
359: -- decimal_points = DECODE( p_decimal_points, FND_API.g_miss_num, decimal_points, p_decimal_points),

Line 356: max_value_flag = DECODE( p_max_value_flag, FND_API.g_miss_char, max_value_flag, p_max_value_flag),

352: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
353: seeded_flag = DECODE( p_seeded_flag, FND_API.g_miss_char, seeded_flag, p_seeded_flag),
354: lov_function_name = DECODE( p_lov_function_name, FND_API.g_miss_char, lov_function_name, p_lov_function_name),
355: return_type = DECODE( p_return_type, FND_API.g_miss_char, return_type, p_return_type),
356: max_value_flag = DECODE( p_max_value_flag, FND_API.g_miss_char, max_value_flag, p_max_value_flag),
357: display_style = DECODE( p_display_style, FND_API.g_miss_char, display_style, p_display_style),
358: -- character_width = DECODE( p_character_width, FND_API.g_miss_num, character_width, p_character_width),
359: -- decimal_points = DECODE( p_decimal_points, FND_API.g_miss_num, decimal_points, p_decimal_points),
360: -- no_of_lines = DECODE( p_no_of_lines, FND_API.g_miss_num, no_of_lines, p_no_of_lines),

Line 357: display_style = DECODE( p_display_style, FND_API.g_miss_char, display_style, p_display_style),

353: seeded_flag = DECODE( p_seeded_flag, FND_API.g_miss_char, seeded_flag, p_seeded_flag),
354: lov_function_name = DECODE( p_lov_function_name, FND_API.g_miss_char, lov_function_name, p_lov_function_name),
355: return_type = DECODE( p_return_type, FND_API.g_miss_char, return_type, p_return_type),
356: max_value_flag = DECODE( p_max_value_flag, FND_API.g_miss_char, max_value_flag, p_max_value_flag),
357: display_style = DECODE( p_display_style, FND_API.g_miss_char, display_style, p_display_style),
358: -- character_width = DECODE( p_character_width, FND_API.g_miss_num, character_width, p_character_width),
359: -- decimal_points = DECODE( p_decimal_points, FND_API.g_miss_num, decimal_points, p_decimal_points),
360: -- no_of_lines = DECODE( p_no_of_lines, FND_API.g_miss_num, no_of_lines, p_no_of_lines),
361: expose_to_partner_flag = DECODE( p_expose_to_partner_flag, FND_API.g_miss_char, expose_to_partner_flag, p_expose_to_partner_flag),

Line 358: -- character_width = DECODE( p_character_width, FND_API.g_miss_num, character_width, p_character_width),

354: lov_function_name = DECODE( p_lov_function_name, FND_API.g_miss_char, lov_function_name, p_lov_function_name),
355: return_type = DECODE( p_return_type, FND_API.g_miss_char, return_type, p_return_type),
356: max_value_flag = DECODE( p_max_value_flag, FND_API.g_miss_char, max_value_flag, p_max_value_flag),
357: display_style = DECODE( p_display_style, FND_API.g_miss_char, display_style, p_display_style),
358: -- character_width = DECODE( p_character_width, FND_API.g_miss_num, character_width, p_character_width),
359: -- decimal_points = DECODE( p_decimal_points, FND_API.g_miss_num, decimal_points, p_decimal_points),
360: -- no_of_lines = DECODE( p_no_of_lines, FND_API.g_miss_num, no_of_lines, p_no_of_lines),
361: expose_to_partner_flag = DECODE( p_expose_to_partner_flag, FND_API.g_miss_char, expose_to_partner_flag, p_expose_to_partner_flag),
362: value_extn_return_type = DECODE( p_value_extn_return_type, FND_API.g_miss_char, value_extn_return_type, p_value_extn_return_type),

Line 359: -- decimal_points = DECODE( p_decimal_points, FND_API.g_miss_num, decimal_points, p_decimal_points),

355: return_type = DECODE( p_return_type, FND_API.g_miss_char, return_type, p_return_type),
356: max_value_flag = DECODE( p_max_value_flag, FND_API.g_miss_char, max_value_flag, p_max_value_flag),
357: display_style = DECODE( p_display_style, FND_API.g_miss_char, display_style, p_display_style),
358: -- character_width = DECODE( p_character_width, FND_API.g_miss_num, character_width, p_character_width),
359: -- decimal_points = DECODE( p_decimal_points, FND_API.g_miss_num, decimal_points, p_decimal_points),
360: -- no_of_lines = DECODE( p_no_of_lines, FND_API.g_miss_num, no_of_lines, p_no_of_lines),
361: expose_to_partner_flag = DECODE( p_expose_to_partner_flag, FND_API.g_miss_char, expose_to_partner_flag, p_expose_to_partner_flag),
362: value_extn_return_type = DECODE( p_value_extn_return_type, FND_API.g_miss_char, value_extn_return_type, p_value_extn_return_type),
363: enable_matching_flag = DECODE( p_enable_matching_flag, FND_API.g_miss_char, enable_matching_flag, p_enable_matching_flag),

Line 360: -- no_of_lines = DECODE( p_no_of_lines, FND_API.g_miss_num, no_of_lines, p_no_of_lines),

356: max_value_flag = DECODE( p_max_value_flag, FND_API.g_miss_char, max_value_flag, p_max_value_flag),
357: display_style = DECODE( p_display_style, FND_API.g_miss_char, display_style, p_display_style),
358: -- character_width = DECODE( p_character_width, FND_API.g_miss_num, character_width, p_character_width),
359: -- decimal_points = DECODE( p_decimal_points, FND_API.g_miss_num, decimal_points, p_decimal_points),
360: -- no_of_lines = DECODE( p_no_of_lines, FND_API.g_miss_num, no_of_lines, p_no_of_lines),
361: expose_to_partner_flag = DECODE( p_expose_to_partner_flag, FND_API.g_miss_char, expose_to_partner_flag, p_expose_to_partner_flag),
362: value_extn_return_type = DECODE( p_value_extn_return_type, FND_API.g_miss_char, value_extn_return_type, p_value_extn_return_type),
363: enable_matching_flag = DECODE( p_enable_matching_flag, FND_API.g_miss_char, enable_matching_flag, p_enable_matching_flag),
364: performance_flag = DECODE( p_performance_flag, FND_API.g_miss_char, performance_flag, p_performance_flag),

Line 361: expose_to_partner_flag = DECODE( p_expose_to_partner_flag, FND_API.g_miss_char, expose_to_partner_flag, p_expose_to_partner_flag),

357: display_style = DECODE( p_display_style, FND_API.g_miss_char, display_style, p_display_style),
358: -- character_width = DECODE( p_character_width, FND_API.g_miss_num, character_width, p_character_width),
359: -- decimal_points = DECODE( p_decimal_points, FND_API.g_miss_num, decimal_points, p_decimal_points),
360: -- no_of_lines = DECODE( p_no_of_lines, FND_API.g_miss_num, no_of_lines, p_no_of_lines),
361: expose_to_partner_flag = DECODE( p_expose_to_partner_flag, FND_API.g_miss_char, expose_to_partner_flag, p_expose_to_partner_flag),
362: value_extn_return_type = DECODE( p_value_extn_return_type, FND_API.g_miss_char, value_extn_return_type, p_value_extn_return_type),
363: enable_matching_flag = DECODE( p_enable_matching_flag, FND_API.g_miss_char, enable_matching_flag, p_enable_matching_flag),
364: performance_flag = DECODE( p_performance_flag, FND_API.g_miss_char, performance_flag, p_performance_flag),
365: additive_flag = DECODE( p_additive_flag, FND_API.g_miss_char, additive_flag, p_additive_flag),

Line 362: value_extn_return_type = DECODE( p_value_extn_return_type, FND_API.g_miss_char, value_extn_return_type, p_value_extn_return_type),

358: -- character_width = DECODE( p_character_width, FND_API.g_miss_num, character_width, p_character_width),
359: -- decimal_points = DECODE( p_decimal_points, FND_API.g_miss_num, decimal_points, p_decimal_points),
360: -- no_of_lines = DECODE( p_no_of_lines, FND_API.g_miss_num, no_of_lines, p_no_of_lines),
361: expose_to_partner_flag = DECODE( p_expose_to_partner_flag, FND_API.g_miss_char, expose_to_partner_flag, p_expose_to_partner_flag),
362: value_extn_return_type = DECODE( p_value_extn_return_type, FND_API.g_miss_char, value_extn_return_type, p_value_extn_return_type),
363: enable_matching_flag = DECODE( p_enable_matching_flag, FND_API.g_miss_char, enable_matching_flag, p_enable_matching_flag),
364: performance_flag = DECODE( p_performance_flag, FND_API.g_miss_char, performance_flag, p_performance_flag),
365: additive_flag = DECODE( p_additive_flag, FND_API.g_miss_char, additive_flag, p_additive_flag),
366: sequence_number = DECODE( p_sequence_number, FND_API.g_miss_num, sequence_number, p_sequence_number)

Line 363: enable_matching_flag = DECODE( p_enable_matching_flag, FND_API.g_miss_char, enable_matching_flag, p_enable_matching_flag),

359: -- decimal_points = DECODE( p_decimal_points, FND_API.g_miss_num, decimal_points, p_decimal_points),
360: -- no_of_lines = DECODE( p_no_of_lines, FND_API.g_miss_num, no_of_lines, p_no_of_lines),
361: expose_to_partner_flag = DECODE( p_expose_to_partner_flag, FND_API.g_miss_char, expose_to_partner_flag, p_expose_to_partner_flag),
362: value_extn_return_type = DECODE( p_value_extn_return_type, FND_API.g_miss_char, value_extn_return_type, p_value_extn_return_type),
363: enable_matching_flag = DECODE( p_enable_matching_flag, FND_API.g_miss_char, enable_matching_flag, p_enable_matching_flag),
364: performance_flag = DECODE( p_performance_flag, FND_API.g_miss_char, performance_flag, p_performance_flag),
365: additive_flag = DECODE( p_additive_flag, FND_API.g_miss_char, additive_flag, p_additive_flag),
366: sequence_number = DECODE( p_sequence_number, FND_API.g_miss_num, sequence_number, p_sequence_number)
367:

Line 364: performance_flag = DECODE( p_performance_flag, FND_API.g_miss_char, performance_flag, p_performance_flag),

360: -- no_of_lines = DECODE( p_no_of_lines, FND_API.g_miss_num, no_of_lines, p_no_of_lines),
361: expose_to_partner_flag = DECODE( p_expose_to_partner_flag, FND_API.g_miss_char, expose_to_partner_flag, p_expose_to_partner_flag),
362: value_extn_return_type = DECODE( p_value_extn_return_type, FND_API.g_miss_char, value_extn_return_type, p_value_extn_return_type),
363: enable_matching_flag = DECODE( p_enable_matching_flag, FND_API.g_miss_char, enable_matching_flag, p_enable_matching_flag),
364: performance_flag = DECODE( p_performance_flag, FND_API.g_miss_char, performance_flag, p_performance_flag),
365: additive_flag = DECODE( p_additive_flag, FND_API.g_miss_char, additive_flag, p_additive_flag),
366: sequence_number = DECODE( p_sequence_number, FND_API.g_miss_num, sequence_number, p_sequence_number)
367:
368: WHERE ATTRIBUTE_ID = p_ATTRIBUTE_ID

Line 365: additive_flag = DECODE( p_additive_flag, FND_API.g_miss_char, additive_flag, p_additive_flag),

361: expose_to_partner_flag = DECODE( p_expose_to_partner_flag, FND_API.g_miss_char, expose_to_partner_flag, p_expose_to_partner_flag),
362: value_extn_return_type = DECODE( p_value_extn_return_type, FND_API.g_miss_char, value_extn_return_type, p_value_extn_return_type),
363: enable_matching_flag = DECODE( p_enable_matching_flag, FND_API.g_miss_char, enable_matching_flag, p_enable_matching_flag),
364: performance_flag = DECODE( p_performance_flag, FND_API.g_miss_char, performance_flag, p_performance_flag),
365: additive_flag = DECODE( p_additive_flag, FND_API.g_miss_char, additive_flag, p_additive_flag),
366: sequence_number = DECODE( p_sequence_number, FND_API.g_miss_num, sequence_number, p_sequence_number)
367:
368: WHERE ATTRIBUTE_ID = p_ATTRIBUTE_ID
369: AND object_version_number = p_object_version_number;

Line 366: sequence_number = DECODE( p_sequence_number, FND_API.g_miss_num, sequence_number, p_sequence_number)

362: value_extn_return_type = DECODE( p_value_extn_return_type, FND_API.g_miss_char, value_extn_return_type, p_value_extn_return_type),
363: enable_matching_flag = DECODE( p_enable_matching_flag, FND_API.g_miss_char, enable_matching_flag, p_enable_matching_flag),
364: performance_flag = DECODE( p_performance_flag, FND_API.g_miss_char, performance_flag, p_performance_flag),
365: additive_flag = DECODE( p_additive_flag, FND_API.g_miss_char, additive_flag, p_additive_flag),
366: sequence_number = DECODE( p_sequence_number, FND_API.g_miss_num, sequence_number, p_sequence_number)
367:
368: WHERE ATTRIBUTE_ID = p_ATTRIBUTE_ID
369: AND object_version_number = p_object_version_number;
370:

Line 372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

368: WHERE ATTRIBUTE_ID = p_ATTRIBUTE_ID
369: AND object_version_number = p_object_version_number;
370:
371: IF (SQL%NOTFOUND) THEN
372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
373: END IF;
374:
375: update pv_attributes_tl set
376: name = decode( p_name, FND_API.G_MISS_CHAR, name, p_name),

Line 376: name = decode( p_name, FND_API.G_MISS_CHAR, name, p_name),

372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
373: END IF;
374:
375: update pv_attributes_tl set
376: name = decode( p_name, FND_API.G_MISS_CHAR, name, p_name),
377: description = decode( p_description, FND_API.G_MISS_CHAR, description, p_description),
378: short_name = decode( p_short_name, FND_API.G_MISS_CHAR, short_name, p_short_name),
379: last_update_date = SYSDATE,
380: last_updated_by = FND_GLOBAL.user_id,

Line 377: description = decode( p_description, FND_API.G_MISS_CHAR, description, p_description),

373: END IF;
374:
375: update pv_attributes_tl set
376: name = decode( p_name, FND_API.G_MISS_CHAR, name, p_name),
377: description = decode( p_description, FND_API.G_MISS_CHAR, description, p_description),
378: short_name = decode( p_short_name, FND_API.G_MISS_CHAR, short_name, p_short_name),
379: last_update_date = SYSDATE,
380: last_updated_by = FND_GLOBAL.user_id,
381: last_update_login = FND_GLOBAL.conc_login_id,

Line 378: short_name = decode( p_short_name, FND_API.G_MISS_CHAR, short_name, p_short_name),

374:
375: update pv_attributes_tl set
376: name = decode( p_name, FND_API.G_MISS_CHAR, name, p_name),
377: description = decode( p_description, FND_API.G_MISS_CHAR, description, p_description),
378: short_name = decode( p_short_name, FND_API.G_MISS_CHAR, short_name, p_short_name),
379: last_update_date = SYSDATE,
380: last_updated_by = FND_GLOBAL.user_id,
381: last_update_login = FND_GLOBAL.conc_login_id,
382: source_lang = USERENV('LANG')

Line 387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

383: WHERE attribute_id = p_attribute_ID
384: AND USERENV('LANG') IN (language, source_lang);
385:
386: IF (SQL%NOTFOUND) THEN
387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
388: END IF;
389:
390: else
391:

Line 394: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),

390: else
391:
392: Update PV_ATTRIBUTES_B
393: SET
394: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),
395: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
396: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
397: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
398: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

Line 395: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

391:
392: Update PV_ATTRIBUTES_B
393: SET
394: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),
395: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
396: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
397: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
398: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
399: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

Line 396: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

392: Update PV_ATTRIBUTES_B
393: SET
394: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),
395: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
396: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
397: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
398: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
399: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
400: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),

Line 397: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),

393: SET
394: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),
395: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
396: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
397: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
398: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
399: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
400: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
401: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),

Line 398: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

394: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),
395: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
396: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
397: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
398: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
399: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
400: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
401: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
402: -- enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),

Line 399: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

395: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
396: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
397: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
398: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
399: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
400: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
401: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
402: -- enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
403: attribute_type = DECODE( p_attribute_type, FND_API.g_miss_char, attribute_type, p_attribute_type),

Line 400: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),

396: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
397: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
398: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
399: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
400: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
401: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
402: -- enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
403: attribute_type = DECODE( p_attribute_type, FND_API.g_miss_char, attribute_type, p_attribute_type),
404: -- attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),

Line 401: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),

397: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
398: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
399: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
400: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
401: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
402: -- enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
403: attribute_type = DECODE( p_attribute_type, FND_API.g_miss_char, attribute_type, p_attribute_type),
404: -- attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
405: seeded_flag = DECODE( p_seeded_flag, FND_API.g_miss_char, seeded_flag, p_seeded_flag),

Line 402: -- enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),

398: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
399: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
400: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
401: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
402: -- enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
403: attribute_type = DECODE( p_attribute_type, FND_API.g_miss_char, attribute_type, p_attribute_type),
404: -- attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
405: seeded_flag = DECODE( p_seeded_flag, FND_API.g_miss_char, seeded_flag, p_seeded_flag),
406: lov_function_name = DECODE( p_lov_function_name, FND_API.g_miss_char, lov_function_name, p_lov_function_name),

Line 403: attribute_type = DECODE( p_attribute_type, FND_API.g_miss_char, attribute_type, p_attribute_type),

399: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
400: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
401: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
402: -- enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
403: attribute_type = DECODE( p_attribute_type, FND_API.g_miss_char, attribute_type, p_attribute_type),
404: -- attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
405: seeded_flag = DECODE( p_seeded_flag, FND_API.g_miss_char, seeded_flag, p_seeded_flag),
406: lov_function_name = DECODE( p_lov_function_name, FND_API.g_miss_char, lov_function_name, p_lov_function_name),
407: return_type = DECODE( p_return_type, FND_API.g_miss_char, return_type, p_return_type),

Line 404: -- attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),

400: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
401: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
402: -- enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
403: attribute_type = DECODE( p_attribute_type, FND_API.g_miss_char, attribute_type, p_attribute_type),
404: -- attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
405: seeded_flag = DECODE( p_seeded_flag, FND_API.g_miss_char, seeded_flag, p_seeded_flag),
406: lov_function_name = DECODE( p_lov_function_name, FND_API.g_miss_char, lov_function_name, p_lov_function_name),
407: return_type = DECODE( p_return_type, FND_API.g_miss_char, return_type, p_return_type),
408: --max_value_flag = DECODE( p_max_value_flag, FND_API.g_miss_char, max_value_flag, p_max_value_flag),

Line 405: seeded_flag = DECODE( p_seeded_flag, FND_API.g_miss_char, seeded_flag, p_seeded_flag),

401: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
402: -- enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
403: attribute_type = DECODE( p_attribute_type, FND_API.g_miss_char, attribute_type, p_attribute_type),
404: -- attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
405: seeded_flag = DECODE( p_seeded_flag, FND_API.g_miss_char, seeded_flag, p_seeded_flag),
406: lov_function_name = DECODE( p_lov_function_name, FND_API.g_miss_char, lov_function_name, p_lov_function_name),
407: return_type = DECODE( p_return_type, FND_API.g_miss_char, return_type, p_return_type),
408: --max_value_flag = DECODE( p_max_value_flag, FND_API.g_miss_char, max_value_flag, p_max_value_flag),
409: -- display_style = DECODE( p_display_style, FND_API.g_miss_char, display_style, p_display_style),

Line 406: lov_function_name = DECODE( p_lov_function_name, FND_API.g_miss_char, lov_function_name, p_lov_function_name),

402: -- enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
403: attribute_type = DECODE( p_attribute_type, FND_API.g_miss_char, attribute_type, p_attribute_type),
404: -- attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
405: seeded_flag = DECODE( p_seeded_flag, FND_API.g_miss_char, seeded_flag, p_seeded_flag),
406: lov_function_name = DECODE( p_lov_function_name, FND_API.g_miss_char, lov_function_name, p_lov_function_name),
407: return_type = DECODE( p_return_type, FND_API.g_miss_char, return_type, p_return_type),
408: --max_value_flag = DECODE( p_max_value_flag, FND_API.g_miss_char, max_value_flag, p_max_value_flag),
409: -- display_style = DECODE( p_display_style, FND_API.g_miss_char, display_style, p_display_style),
410: -- character_width = DECODE( p_character_width, FND_API.g_miss_num, character_width, p_character_width),

Line 407: return_type = DECODE( p_return_type, FND_API.g_miss_char, return_type, p_return_type),

403: attribute_type = DECODE( p_attribute_type, FND_API.g_miss_char, attribute_type, p_attribute_type),
404: -- attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
405: seeded_flag = DECODE( p_seeded_flag, FND_API.g_miss_char, seeded_flag, p_seeded_flag),
406: lov_function_name = DECODE( p_lov_function_name, FND_API.g_miss_char, lov_function_name, p_lov_function_name),
407: return_type = DECODE( p_return_type, FND_API.g_miss_char, return_type, p_return_type),
408: --max_value_flag = DECODE( p_max_value_flag, FND_API.g_miss_char, max_value_flag, p_max_value_flag),
409: -- display_style = DECODE( p_display_style, FND_API.g_miss_char, display_style, p_display_style),
410: -- character_width = DECODE( p_character_width, FND_API.g_miss_num, character_width, p_character_width),
411: -- decimal_points = DECODE( p_decimal_points, FND_API.g_miss_num, decimal_points, p_decimal_points),

Line 408: --max_value_flag = DECODE( p_max_value_flag, FND_API.g_miss_char, max_value_flag, p_max_value_flag),

404: -- attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
405: seeded_flag = DECODE( p_seeded_flag, FND_API.g_miss_char, seeded_flag, p_seeded_flag),
406: lov_function_name = DECODE( p_lov_function_name, FND_API.g_miss_char, lov_function_name, p_lov_function_name),
407: return_type = DECODE( p_return_type, FND_API.g_miss_char, return_type, p_return_type),
408: --max_value_flag = DECODE( p_max_value_flag, FND_API.g_miss_char, max_value_flag, p_max_value_flag),
409: -- display_style = DECODE( p_display_style, FND_API.g_miss_char, display_style, p_display_style),
410: -- character_width = DECODE( p_character_width, FND_API.g_miss_num, character_width, p_character_width),
411: -- decimal_points = DECODE( p_decimal_points, FND_API.g_miss_num, decimal_points, p_decimal_points),
412: -- no_of_lines = DECODE( p_no_of_lines, FND_API.g_miss_num, no_of_lines, p_no_of_lines),

Line 409: -- display_style = DECODE( p_display_style, FND_API.g_miss_char, display_style, p_display_style),

405: seeded_flag = DECODE( p_seeded_flag, FND_API.g_miss_char, seeded_flag, p_seeded_flag),
406: lov_function_name = DECODE( p_lov_function_name, FND_API.g_miss_char, lov_function_name, p_lov_function_name),
407: return_type = DECODE( p_return_type, FND_API.g_miss_char, return_type, p_return_type),
408: --max_value_flag = DECODE( p_max_value_flag, FND_API.g_miss_char, max_value_flag, p_max_value_flag),
409: -- display_style = DECODE( p_display_style, FND_API.g_miss_char, display_style, p_display_style),
410: -- character_width = DECODE( p_character_width, FND_API.g_miss_num, character_width, p_character_width),
411: -- decimal_points = DECODE( p_decimal_points, FND_API.g_miss_num, decimal_points, p_decimal_points),
412: -- no_of_lines = DECODE( p_no_of_lines, FND_API.g_miss_num, no_of_lines, p_no_of_lines),
413: --expose_to_partner_flag = DECODE( p_expose_to_partner_flag, FND_API.g_miss_char, expose_to_partner_flag, p_expose_to_partner_flag),

Line 410: -- character_width = DECODE( p_character_width, FND_API.g_miss_num, character_width, p_character_width),

406: lov_function_name = DECODE( p_lov_function_name, FND_API.g_miss_char, lov_function_name, p_lov_function_name),
407: return_type = DECODE( p_return_type, FND_API.g_miss_char, return_type, p_return_type),
408: --max_value_flag = DECODE( p_max_value_flag, FND_API.g_miss_char, max_value_flag, p_max_value_flag),
409: -- display_style = DECODE( p_display_style, FND_API.g_miss_char, display_style, p_display_style),
410: -- character_width = DECODE( p_character_width, FND_API.g_miss_num, character_width, p_character_width),
411: -- decimal_points = DECODE( p_decimal_points, FND_API.g_miss_num, decimal_points, p_decimal_points),
412: -- no_of_lines = DECODE( p_no_of_lines, FND_API.g_miss_num, no_of_lines, p_no_of_lines),
413: --expose_to_partner_flag = DECODE( p_expose_to_partner_flag, FND_API.g_miss_char, expose_to_partner_flag, p_expose_to_partner_flag),
414: value_extn_return_type = DECODE( p_value_extn_return_type, FND_API.g_miss_char, value_extn_return_type, p_value_extn_return_type),

Line 411: -- decimal_points = DECODE( p_decimal_points, FND_API.g_miss_num, decimal_points, p_decimal_points),

407: return_type = DECODE( p_return_type, FND_API.g_miss_char, return_type, p_return_type),
408: --max_value_flag = DECODE( p_max_value_flag, FND_API.g_miss_char, max_value_flag, p_max_value_flag),
409: -- display_style = DECODE( p_display_style, FND_API.g_miss_char, display_style, p_display_style),
410: -- character_width = DECODE( p_character_width, FND_API.g_miss_num, character_width, p_character_width),
411: -- decimal_points = DECODE( p_decimal_points, FND_API.g_miss_num, decimal_points, p_decimal_points),
412: -- no_of_lines = DECODE( p_no_of_lines, FND_API.g_miss_num, no_of_lines, p_no_of_lines),
413: --expose_to_partner_flag = DECODE( p_expose_to_partner_flag, FND_API.g_miss_char, expose_to_partner_flag, p_expose_to_partner_flag),
414: value_extn_return_type = DECODE( p_value_extn_return_type, FND_API.g_miss_char, value_extn_return_type, p_value_extn_return_type),
415: --enable_matching_flag = DECODE( p_enable_matching_flag, FND_API.g_miss_char, enable_matching_flag, p_enable_matching_flag),

Line 412: -- no_of_lines = DECODE( p_no_of_lines, FND_API.g_miss_num, no_of_lines, p_no_of_lines),

408: --max_value_flag = DECODE( p_max_value_flag, FND_API.g_miss_char, max_value_flag, p_max_value_flag),
409: -- display_style = DECODE( p_display_style, FND_API.g_miss_char, display_style, p_display_style),
410: -- character_width = DECODE( p_character_width, FND_API.g_miss_num, character_width, p_character_width),
411: -- decimal_points = DECODE( p_decimal_points, FND_API.g_miss_num, decimal_points, p_decimal_points),
412: -- no_of_lines = DECODE( p_no_of_lines, FND_API.g_miss_num, no_of_lines, p_no_of_lines),
413: --expose_to_partner_flag = DECODE( p_expose_to_partner_flag, FND_API.g_miss_char, expose_to_partner_flag, p_expose_to_partner_flag),
414: value_extn_return_type = DECODE( p_value_extn_return_type, FND_API.g_miss_char, value_extn_return_type, p_value_extn_return_type),
415: --enable_matching_flag = DECODE( p_enable_matching_flag, FND_API.g_miss_char, enable_matching_flag, p_enable_matching_flag),
416: performance_flag = DECODE( p_performance_flag, FND_API.g_miss_char, performance_flag, p_performance_flag),

Line 413: --expose_to_partner_flag = DECODE( p_expose_to_partner_flag, FND_API.g_miss_char, expose_to_partner_flag, p_expose_to_partner_flag),

409: -- display_style = DECODE( p_display_style, FND_API.g_miss_char, display_style, p_display_style),
410: -- character_width = DECODE( p_character_width, FND_API.g_miss_num, character_width, p_character_width),
411: -- decimal_points = DECODE( p_decimal_points, FND_API.g_miss_num, decimal_points, p_decimal_points),
412: -- no_of_lines = DECODE( p_no_of_lines, FND_API.g_miss_num, no_of_lines, p_no_of_lines),
413: --expose_to_partner_flag = DECODE( p_expose_to_partner_flag, FND_API.g_miss_char, expose_to_partner_flag, p_expose_to_partner_flag),
414: value_extn_return_type = DECODE( p_value_extn_return_type, FND_API.g_miss_char, value_extn_return_type, p_value_extn_return_type),
415: --enable_matching_flag = DECODE( p_enable_matching_flag, FND_API.g_miss_char, enable_matching_flag, p_enable_matching_flag),
416: performance_flag = DECODE( p_performance_flag, FND_API.g_miss_char, performance_flag, p_performance_flag),
417: additive_flag = DECODE( p_additive_flag, FND_API.g_miss_char, additive_flag, p_additive_flag) --,

Line 414: value_extn_return_type = DECODE( p_value_extn_return_type, FND_API.g_miss_char, value_extn_return_type, p_value_extn_return_type),

410: -- character_width = DECODE( p_character_width, FND_API.g_miss_num, character_width, p_character_width),
411: -- decimal_points = DECODE( p_decimal_points, FND_API.g_miss_num, decimal_points, p_decimal_points),
412: -- no_of_lines = DECODE( p_no_of_lines, FND_API.g_miss_num, no_of_lines, p_no_of_lines),
413: --expose_to_partner_flag = DECODE( p_expose_to_partner_flag, FND_API.g_miss_char, expose_to_partner_flag, p_expose_to_partner_flag),
414: value_extn_return_type = DECODE( p_value_extn_return_type, FND_API.g_miss_char, value_extn_return_type, p_value_extn_return_type),
415: --enable_matching_flag = DECODE( p_enable_matching_flag, FND_API.g_miss_char, enable_matching_flag, p_enable_matching_flag),
416: performance_flag = DECODE( p_performance_flag, FND_API.g_miss_char, performance_flag, p_performance_flag),
417: additive_flag = DECODE( p_additive_flag, FND_API.g_miss_char, additive_flag, p_additive_flag) --,
418: --sequence_number = DECODE( p_sequence_number, FND_API.g_miss_num, sequence_number, p_sequence_number)

Line 415: --enable_matching_flag = DECODE( p_enable_matching_flag, FND_API.g_miss_char, enable_matching_flag, p_enable_matching_flag),

411: -- decimal_points = DECODE( p_decimal_points, FND_API.g_miss_num, decimal_points, p_decimal_points),
412: -- no_of_lines = DECODE( p_no_of_lines, FND_API.g_miss_num, no_of_lines, p_no_of_lines),
413: --expose_to_partner_flag = DECODE( p_expose_to_partner_flag, FND_API.g_miss_char, expose_to_partner_flag, p_expose_to_partner_flag),
414: value_extn_return_type = DECODE( p_value_extn_return_type, FND_API.g_miss_char, value_extn_return_type, p_value_extn_return_type),
415: --enable_matching_flag = DECODE( p_enable_matching_flag, FND_API.g_miss_char, enable_matching_flag, p_enable_matching_flag),
416: performance_flag = DECODE( p_performance_flag, FND_API.g_miss_char, performance_flag, p_performance_flag),
417: additive_flag = DECODE( p_additive_flag, FND_API.g_miss_char, additive_flag, p_additive_flag) --,
418: --sequence_number = DECODE( p_sequence_number, FND_API.g_miss_num, sequence_number, p_sequence_number)
419:

Line 416: performance_flag = DECODE( p_performance_flag, FND_API.g_miss_char, performance_flag, p_performance_flag),

412: -- no_of_lines = DECODE( p_no_of_lines, FND_API.g_miss_num, no_of_lines, p_no_of_lines),
413: --expose_to_partner_flag = DECODE( p_expose_to_partner_flag, FND_API.g_miss_char, expose_to_partner_flag, p_expose_to_partner_flag),
414: value_extn_return_type = DECODE( p_value_extn_return_type, FND_API.g_miss_char, value_extn_return_type, p_value_extn_return_type),
415: --enable_matching_flag = DECODE( p_enable_matching_flag, FND_API.g_miss_char, enable_matching_flag, p_enable_matching_flag),
416: performance_flag = DECODE( p_performance_flag, FND_API.g_miss_char, performance_flag, p_performance_flag),
417: additive_flag = DECODE( p_additive_flag, FND_API.g_miss_char, additive_flag, p_additive_flag) --,
418: --sequence_number = DECODE( p_sequence_number, FND_API.g_miss_num, sequence_number, p_sequence_number)
419:
420:

Line 417: additive_flag = DECODE( p_additive_flag, FND_API.g_miss_char, additive_flag, p_additive_flag) --,

413: --expose_to_partner_flag = DECODE( p_expose_to_partner_flag, FND_API.g_miss_char, expose_to_partner_flag, p_expose_to_partner_flag),
414: value_extn_return_type = DECODE( p_value_extn_return_type, FND_API.g_miss_char, value_extn_return_type, p_value_extn_return_type),
415: --enable_matching_flag = DECODE( p_enable_matching_flag, FND_API.g_miss_char, enable_matching_flag, p_enable_matching_flag),
416: performance_flag = DECODE( p_performance_flag, FND_API.g_miss_char, performance_flag, p_performance_flag),
417: additive_flag = DECODE( p_additive_flag, FND_API.g_miss_char, additive_flag, p_additive_flag) --,
418: --sequence_number = DECODE( p_sequence_number, FND_API.g_miss_num, sequence_number, p_sequence_number)
419:
420:
421: WHERE ATTRIBUTE_ID = p_ATTRIBUTE_ID

Line 418: --sequence_number = DECODE( p_sequence_number, FND_API.g_miss_num, sequence_number, p_sequence_number)

414: value_extn_return_type = DECODE( p_value_extn_return_type, FND_API.g_miss_char, value_extn_return_type, p_value_extn_return_type),
415: --enable_matching_flag = DECODE( p_enable_matching_flag, FND_API.g_miss_char, enable_matching_flag, p_enable_matching_flag),
416: performance_flag = DECODE( p_performance_flag, FND_API.g_miss_char, performance_flag, p_performance_flag),
417: additive_flag = DECODE( p_additive_flag, FND_API.g_miss_char, additive_flag, p_additive_flag) --,
418: --sequence_number = DECODE( p_sequence_number, FND_API.g_miss_num, sequence_number, p_sequence_number)
419:
420:
421: WHERE ATTRIBUTE_ID = p_ATTRIBUTE_ID
422: AND object_version_number = p_object_version_number;

Line 425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

421: WHERE ATTRIBUTE_ID = p_ATTRIBUTE_ID
422: AND object_version_number = p_object_version_number;
423:
424: IF (SQL%NOTFOUND) THEN
425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
426: END IF;
427:
428: if(l_display_style is null or l_display_style = '') then
429: Update PV_ATTRIBUTES_B

Line 431: display_style = DECODE( p_display_style, FND_API.g_miss_char, display_style, p_display_style)

427:
428: if(l_display_style is null or l_display_style = '') then
429: Update PV_ATTRIBUTES_B
430: SET
431: display_style = DECODE( p_display_style, FND_API.g_miss_char, display_style, p_display_style)
432: WHERE ATTRIBUTE_ID = p_ATTRIBUTE_ID;
433: end if;
434:
435: if(l_attribute_category is null or l_attribute_category = '') then

Line 438: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category)

434:
435: if(l_attribute_category is null or l_attribute_category = '') then
436: Update PV_ATTRIBUTES_B
437: SET
438: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category)
439: WHERE ATTRIBUTE_ID = p_ATTRIBUTE_ID;
440: end if;
441:
442: update pv_attributes_tl set

Line 443: --name = decode( p_name, FND_API.G_MISS_CHAR, name, p_name),

439: WHERE ATTRIBUTE_ID = p_ATTRIBUTE_ID;
440: end if;
441:
442: update pv_attributes_tl set
443: --name = decode( p_name, FND_API.G_MISS_CHAR, name, p_name),
444: --description = decode( p_description, FND_API.G_MISS_CHAR, description, p_description),
445: short_name = decode( p_short_name, FND_API.G_MISS_CHAR, short_name, p_short_name),
446: last_update_date = SYSDATE,
447: last_updated_by = FND_GLOBAL.user_id,

Line 444: --description = decode( p_description, FND_API.G_MISS_CHAR, description, p_description),

440: end if;
441:
442: update pv_attributes_tl set
443: --name = decode( p_name, FND_API.G_MISS_CHAR, name, p_name),
444: --description = decode( p_description, FND_API.G_MISS_CHAR, description, p_description),
445: short_name = decode( p_short_name, FND_API.G_MISS_CHAR, short_name, p_short_name),
446: last_update_date = SYSDATE,
447: last_updated_by = FND_GLOBAL.user_id,
448: last_update_login = FND_GLOBAL.conc_login_id,

Line 445: short_name = decode( p_short_name, FND_API.G_MISS_CHAR, short_name, p_short_name),

441:
442: update pv_attributes_tl set
443: --name = decode( p_name, FND_API.G_MISS_CHAR, name, p_name),
444: --description = decode( p_description, FND_API.G_MISS_CHAR, description, p_description),
445: short_name = decode( p_short_name, FND_API.G_MISS_CHAR, short_name, p_short_name),
446: last_update_date = SYSDATE,
447: last_updated_by = FND_GLOBAL.user_id,
448: last_update_login = FND_GLOBAL.conc_login_id,
449: source_lang = USERENV('LANG')

Line 454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

450: WHERE attribute_id = p_attribute_ID
451: AND USERENV('LANG') IN (language, source_lang);
452:
453: IF (SQL%NOTFOUND) THEN
454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
455: END IF;
456:
457:
458: end if;

Line 500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

496: End If;
497:
498:
499: If (SQL%NOTFOUND) then
500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
501: End If;
502: END Delete_Row ;
503:
504:

Line 541: p_display_style VARCHAR2 := FND_API.G_MISS_CHAR,

537: p_max_value_flag VARCHAR2,
538:
539: --new columns added
540:
541: p_display_style VARCHAR2 := FND_API.G_MISS_CHAR,
542: p_character_width NUMBER := FND_API.G_MISS_NUM,
543: p_decimal_points NUMBER := FND_API.G_MISS_NUM,
544: p_no_of_lines NUMBER := FND_API.G_MISS_NUM,
545: p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,

Line 542: p_character_width NUMBER := FND_API.G_MISS_NUM,

538:
539: --new columns added
540:
541: p_display_style VARCHAR2 := FND_API.G_MISS_CHAR,
542: p_character_width NUMBER := FND_API.G_MISS_NUM,
543: p_decimal_points NUMBER := FND_API.G_MISS_NUM,
544: p_no_of_lines NUMBER := FND_API.G_MISS_NUM,
545: p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,
546: p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,

Line 543: p_decimal_points NUMBER := FND_API.G_MISS_NUM,

539: --new columns added
540:
541: p_display_style VARCHAR2 := FND_API.G_MISS_CHAR,
542: p_character_width NUMBER := FND_API.G_MISS_NUM,
543: p_decimal_points NUMBER := FND_API.G_MISS_NUM,
544: p_no_of_lines NUMBER := FND_API.G_MISS_NUM,
545: p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,
546: p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,
547: p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,

Line 544: p_no_of_lines NUMBER := FND_API.G_MISS_NUM,

540:
541: p_display_style VARCHAR2 := FND_API.G_MISS_CHAR,
542: p_character_width NUMBER := FND_API.G_MISS_NUM,
543: p_decimal_points NUMBER := FND_API.G_MISS_NUM,
544: p_no_of_lines NUMBER := FND_API.G_MISS_NUM,
545: p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,
546: p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,
547: p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,
548: p_performance_flag VARCHAR2 := FND_API.G_MISS_CHAR,

Line 545: p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,

541: p_display_style VARCHAR2 := FND_API.G_MISS_CHAR,
542: p_character_width NUMBER := FND_API.G_MISS_NUM,
543: p_decimal_points NUMBER := FND_API.G_MISS_NUM,
544: p_no_of_lines NUMBER := FND_API.G_MISS_NUM,
545: p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,
546: p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,
547: p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,
548: p_performance_flag VARCHAR2 := FND_API.G_MISS_CHAR,
549: p_additive_flag VARCHAR2 := FND_API.G_MISS_CHAR,

Line 546: p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,

542: p_character_width NUMBER := FND_API.G_MISS_NUM,
543: p_decimal_points NUMBER := FND_API.G_MISS_NUM,
544: p_no_of_lines NUMBER := FND_API.G_MISS_NUM,
545: p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,
546: p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,
547: p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,
548: p_performance_flag VARCHAR2 := FND_API.G_MISS_CHAR,
549: p_additive_flag VARCHAR2 := FND_API.G_MISS_CHAR,
550: p_sequence_number NUMBER := FND_API.G_MISS_NUM

Line 547: p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,

543: p_decimal_points NUMBER := FND_API.G_MISS_NUM,
544: p_no_of_lines NUMBER := FND_API.G_MISS_NUM,
545: p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,
546: p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,
547: p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,
548: p_performance_flag VARCHAR2 := FND_API.G_MISS_CHAR,
549: p_additive_flag VARCHAR2 := FND_API.G_MISS_CHAR,
550: p_sequence_number NUMBER := FND_API.G_MISS_NUM
551:

Line 548: p_performance_flag VARCHAR2 := FND_API.G_MISS_CHAR,

544: p_no_of_lines NUMBER := FND_API.G_MISS_NUM,
545: p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,
546: p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,
547: p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,
548: p_performance_flag VARCHAR2 := FND_API.G_MISS_CHAR,
549: p_additive_flag VARCHAR2 := FND_API.G_MISS_CHAR,
550: p_sequence_number NUMBER := FND_API.G_MISS_NUM
551:
552: )

Line 549: p_additive_flag VARCHAR2 := FND_API.G_MISS_CHAR,

545: p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,
546: p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,
547: p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,
548: p_performance_flag VARCHAR2 := FND_API.G_MISS_CHAR,
549: p_additive_flag VARCHAR2 := FND_API.G_MISS_CHAR,
550: p_sequence_number NUMBER := FND_API.G_MISS_NUM
551:
552: )
553:

Line 550: p_sequence_number NUMBER := FND_API.G_MISS_NUM

546: p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,
547: p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,
548: p_performance_flag VARCHAR2 := FND_API.G_MISS_CHAR,
549: p_additive_flag VARCHAR2 := FND_API.G_MISS_CHAR,
550: p_sequence_number NUMBER := FND_API.G_MISS_NUM
551:
552: )
553:
554: IS

Line 780: p_display_style IN VARCHAR2 := FND_API.G_MISS_CHAR,

776: p_owner IN VARCHAR2,
777:
778: --new columns added
779:
780: p_display_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
781: p_character_width IN NUMBER := FND_API.G_MISS_NUM,
782: p_decimal_points IN NUMBER := FND_API.G_MISS_NUM,
783: p_no_of_lines IN NUMBER := FND_API.G_MISS_NUM,
784: p_expose_to_partner_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 781: p_character_width IN NUMBER := FND_API.G_MISS_NUM,

777:
778: --new columns added
779:
780: p_display_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
781: p_character_width IN NUMBER := FND_API.G_MISS_NUM,
782: p_decimal_points IN NUMBER := FND_API.G_MISS_NUM,
783: p_no_of_lines IN NUMBER := FND_API.G_MISS_NUM,
784: p_expose_to_partner_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
785: p_value_extn_return_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 782: p_decimal_points IN NUMBER := FND_API.G_MISS_NUM,

778: --new columns added
779:
780: p_display_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
781: p_character_width IN NUMBER := FND_API.G_MISS_NUM,
782: p_decimal_points IN NUMBER := FND_API.G_MISS_NUM,
783: p_no_of_lines IN NUMBER := FND_API.G_MISS_NUM,
784: p_expose_to_partner_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
785: p_value_extn_return_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
786: p_enable_matching_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 783: p_no_of_lines IN NUMBER := FND_API.G_MISS_NUM,

779:
780: p_display_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
781: p_character_width IN NUMBER := FND_API.G_MISS_NUM,
782: p_decimal_points IN NUMBER := FND_API.G_MISS_NUM,
783: p_no_of_lines IN NUMBER := FND_API.G_MISS_NUM,
784: p_expose_to_partner_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
785: p_value_extn_return_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
786: p_enable_matching_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
787: p_performance_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 784: p_expose_to_partner_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

780: p_display_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
781: p_character_width IN NUMBER := FND_API.G_MISS_NUM,
782: p_decimal_points IN NUMBER := FND_API.G_MISS_NUM,
783: p_no_of_lines IN NUMBER := FND_API.G_MISS_NUM,
784: p_expose_to_partner_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
785: p_value_extn_return_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
786: p_enable_matching_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
787: p_performance_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
788: p_additive_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 785: p_value_extn_return_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

781: p_character_width IN NUMBER := FND_API.G_MISS_NUM,
782: p_decimal_points IN NUMBER := FND_API.G_MISS_NUM,
783: p_no_of_lines IN NUMBER := FND_API.G_MISS_NUM,
784: p_expose_to_partner_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
785: p_value_extn_return_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
786: p_enable_matching_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
787: p_performance_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
788: p_additive_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
789: p_sequence_number IN NUMBER := FND_API.G_MISS_NUM

Line 786: p_enable_matching_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

782: p_decimal_points IN NUMBER := FND_API.G_MISS_NUM,
783: p_no_of_lines IN NUMBER := FND_API.G_MISS_NUM,
784: p_expose_to_partner_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
785: p_value_extn_return_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
786: p_enable_matching_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
787: p_performance_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
788: p_additive_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
789: p_sequence_number IN NUMBER := FND_API.G_MISS_NUM
790: ) IS

Line 787: p_performance_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

783: p_no_of_lines IN NUMBER := FND_API.G_MISS_NUM,
784: p_expose_to_partner_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
785: p_value_extn_return_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
786: p_enable_matching_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
787: p_performance_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
788: p_additive_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
789: p_sequence_number IN NUMBER := FND_API.G_MISS_NUM
790: ) IS
791:

Line 788: p_additive_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

784: p_expose_to_partner_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
785: p_value_extn_return_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
786: p_enable_matching_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
787: p_performance_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
788: p_additive_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
789: p_sequence_number IN NUMBER := FND_API.G_MISS_NUM
790: ) IS
791:
792: l_user_id number := 0;

Line 789: p_sequence_number IN NUMBER := FND_API.G_MISS_NUM

785: p_value_extn_return_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
786: p_enable_matching_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
787: p_performance_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
788: p_additive_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
789: p_sequence_number IN NUMBER := FND_API.G_MISS_NUM
790: ) IS
791:
792: l_user_id number := 0;
793: l_obj_verno number;

Line 907: p_display_style IN VARCHAR2 := FND_API.G_MISS_CHAR,

903: p_name IN VARCHAR2,
904: p_description IN VARCHAR2,
905: p_short_name IN VARCHAR2,
906: p_owner IN VARCHAR2,
907: p_display_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
908: p_character_width IN NUMBER := FND_API.G_MISS_NUM,
909: p_decimal_points IN NUMBER := FND_API.G_MISS_NUM,
910: p_no_of_lines IN NUMBER := FND_API.G_MISS_NUM,
911: p_expose_to_partner_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 908: p_character_width IN NUMBER := FND_API.G_MISS_NUM,

904: p_description IN VARCHAR2,
905: p_short_name IN VARCHAR2,
906: p_owner IN VARCHAR2,
907: p_display_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
908: p_character_width IN NUMBER := FND_API.G_MISS_NUM,
909: p_decimal_points IN NUMBER := FND_API.G_MISS_NUM,
910: p_no_of_lines IN NUMBER := FND_API.G_MISS_NUM,
911: p_expose_to_partner_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
912: p_value_extn_return_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 909: p_decimal_points IN NUMBER := FND_API.G_MISS_NUM,

905: p_short_name IN VARCHAR2,
906: p_owner IN VARCHAR2,
907: p_display_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
908: p_character_width IN NUMBER := FND_API.G_MISS_NUM,
909: p_decimal_points IN NUMBER := FND_API.G_MISS_NUM,
910: p_no_of_lines IN NUMBER := FND_API.G_MISS_NUM,
911: p_expose_to_partner_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
912: p_value_extn_return_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
913: p_enable_matching_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 910: p_no_of_lines IN NUMBER := FND_API.G_MISS_NUM,

906: p_owner IN VARCHAR2,
907: p_display_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
908: p_character_width IN NUMBER := FND_API.G_MISS_NUM,
909: p_decimal_points IN NUMBER := FND_API.G_MISS_NUM,
910: p_no_of_lines IN NUMBER := FND_API.G_MISS_NUM,
911: p_expose_to_partner_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
912: p_value_extn_return_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
913: p_enable_matching_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
914: p_performance_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 911: p_expose_to_partner_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

907: p_display_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
908: p_character_width IN NUMBER := FND_API.G_MISS_NUM,
909: p_decimal_points IN NUMBER := FND_API.G_MISS_NUM,
910: p_no_of_lines IN NUMBER := FND_API.G_MISS_NUM,
911: p_expose_to_partner_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
912: p_value_extn_return_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
913: p_enable_matching_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
914: p_performance_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
915: p_additive_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 912: p_value_extn_return_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

908: p_character_width IN NUMBER := FND_API.G_MISS_NUM,
909: p_decimal_points IN NUMBER := FND_API.G_MISS_NUM,
910: p_no_of_lines IN NUMBER := FND_API.G_MISS_NUM,
911: p_expose_to_partner_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
912: p_value_extn_return_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
913: p_enable_matching_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
914: p_performance_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
915: p_additive_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
916: p_sequence_number IN NUMBER := FND_API.G_MISS_NUM

Line 913: p_enable_matching_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

909: p_decimal_points IN NUMBER := FND_API.G_MISS_NUM,
910: p_no_of_lines IN NUMBER := FND_API.G_MISS_NUM,
911: p_expose_to_partner_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
912: p_value_extn_return_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
913: p_enable_matching_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
914: p_performance_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
915: p_additive_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
916: p_sequence_number IN NUMBER := FND_API.G_MISS_NUM
917: )

Line 914: p_performance_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

910: p_no_of_lines IN NUMBER := FND_API.G_MISS_NUM,
911: p_expose_to_partner_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
912: p_value_extn_return_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
913: p_enable_matching_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
914: p_performance_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
915: p_additive_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
916: p_sequence_number IN NUMBER := FND_API.G_MISS_NUM
917: )
918: IS

Line 915: p_additive_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

911: p_expose_to_partner_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
912: p_value_extn_return_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
913: p_enable_matching_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
914: p_performance_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
915: p_additive_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
916: p_sequence_number IN NUMBER := FND_API.G_MISS_NUM
917: )
918: IS
919: BEGIN

Line 916: p_sequence_number IN NUMBER := FND_API.G_MISS_NUM

912: p_value_extn_return_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
913: p_enable_matching_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
914: p_performance_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
915: p_additive_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
916: p_sequence_number IN NUMBER := FND_API.G_MISS_NUM
917: )
918: IS
919: BEGIN
920: if (P_UPLOAD_MODE = 'NLS') then