eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_ENTITY_ATTRS_PKG dependencies on FND_API

Line 55: DECODE ( px_entity_attr_id,FND_API.g_miss_num,NULL,px_entity_attr_id),

51: last_update_date,
52: last_updated_by,
53: last_update_login
54: ) VALUES (
55: DECODE ( px_entity_attr_id,FND_API.g_miss_num,NULL,px_entity_attr_id),
56: DECODE ( p_batch_sql_text,FND_API.g_miss_char,NULL,p_batch_sql_text ),
57: DECODE ( p_refresh_frequency,FND_API.g_miss_char,NULL,p_refresh_frequency ),
58: DECODE ( p_refresh_frequency_uom,FND_API.g_miss_char,NULL,p_refresh_frequency_uom ),
59: DECODE ( p_last_refresh_date,FND_API.g_miss_date,NULL,p_last_refresh_date ),

Line 56: DECODE ( p_batch_sql_text,FND_API.g_miss_char,NULL,p_batch_sql_text ),

52: last_updated_by,
53: last_update_login
54: ) VALUES (
55: DECODE ( px_entity_attr_id,FND_API.g_miss_num,NULL,px_entity_attr_id),
56: DECODE ( p_batch_sql_text,FND_API.g_miss_char,NULL,p_batch_sql_text ),
57: DECODE ( p_refresh_frequency,FND_API.g_miss_char,NULL,p_refresh_frequency ),
58: DECODE ( p_refresh_frequency_uom,FND_API.g_miss_char,NULL,p_refresh_frequency_uom ),
59: DECODE ( p_last_refresh_date,FND_API.g_miss_date,NULL,p_last_refresh_date ),
60: DECODE ( p_display_external_value_flag,FND_API.g_miss_char,NULL,p_display_external_value_flag ),

Line 57: DECODE ( p_refresh_frequency,FND_API.g_miss_char,NULL,p_refresh_frequency ),

53: last_update_login
54: ) VALUES (
55: DECODE ( px_entity_attr_id,FND_API.g_miss_num,NULL,px_entity_attr_id),
56: DECODE ( p_batch_sql_text,FND_API.g_miss_char,NULL,p_batch_sql_text ),
57: DECODE ( p_refresh_frequency,FND_API.g_miss_char,NULL,p_refresh_frequency ),
58: DECODE ( p_refresh_frequency_uom,FND_API.g_miss_char,NULL,p_refresh_frequency_uom ),
59: DECODE ( p_last_refresh_date,FND_API.g_miss_date,NULL,p_last_refresh_date ),
60: DECODE ( p_display_external_value_flag,FND_API.g_miss_char,NULL,p_display_external_value_flag ),
61: DECODE ( p_lov_string,FND_API.g_miss_char,NULL,p_lov_string ),

Line 58: DECODE ( p_refresh_frequency_uom,FND_API.g_miss_char,NULL,p_refresh_frequency_uom ),

54: ) VALUES (
55: DECODE ( px_entity_attr_id,FND_API.g_miss_num,NULL,px_entity_attr_id),
56: DECODE ( p_batch_sql_text,FND_API.g_miss_char,NULL,p_batch_sql_text ),
57: DECODE ( p_refresh_frequency,FND_API.g_miss_char,NULL,p_refresh_frequency ),
58: DECODE ( p_refresh_frequency_uom,FND_API.g_miss_char,NULL,p_refresh_frequency_uom ),
59: DECODE ( p_last_refresh_date,FND_API.g_miss_date,NULL,p_last_refresh_date ),
60: DECODE ( p_display_external_value_flag,FND_API.g_miss_char,NULL,p_display_external_value_flag ),
61: DECODE ( p_lov_string,FND_API.g_miss_char,NULL,p_lov_string ),
62: DECODE ( p_enabled_flag,FND_API.g_miss_char,NULL,p_enabled_flag ),

Line 59: DECODE ( p_last_refresh_date,FND_API.g_miss_date,NULL,p_last_refresh_date ),

55: DECODE ( px_entity_attr_id,FND_API.g_miss_num,NULL,px_entity_attr_id),
56: DECODE ( p_batch_sql_text,FND_API.g_miss_char,NULL,p_batch_sql_text ),
57: DECODE ( p_refresh_frequency,FND_API.g_miss_char,NULL,p_refresh_frequency ),
58: DECODE ( p_refresh_frequency_uom,FND_API.g_miss_char,NULL,p_refresh_frequency_uom ),
59: DECODE ( p_last_refresh_date,FND_API.g_miss_date,NULL,p_last_refresh_date ),
60: DECODE ( p_display_external_value_flag,FND_API.g_miss_char,NULL,p_display_external_value_flag ),
61: DECODE ( p_lov_string,FND_API.g_miss_char,NULL,p_lov_string ),
62: DECODE ( p_enabled_flag,FND_API.g_miss_char,NULL,p_enabled_flag ),
63: DECODE ( p_display_flag,FND_API.g_miss_char,NULL,p_display_flag ),

Line 60: DECODE ( p_display_external_value_flag,FND_API.g_miss_char,NULL,p_display_external_value_flag ),

56: DECODE ( p_batch_sql_text,FND_API.g_miss_char,NULL,p_batch_sql_text ),
57: DECODE ( p_refresh_frequency,FND_API.g_miss_char,NULL,p_refresh_frequency ),
58: DECODE ( p_refresh_frequency_uom,FND_API.g_miss_char,NULL,p_refresh_frequency_uom ),
59: DECODE ( p_last_refresh_date,FND_API.g_miss_date,NULL,p_last_refresh_date ),
60: DECODE ( p_display_external_value_flag,FND_API.g_miss_char,NULL,p_display_external_value_flag ),
61: DECODE ( p_lov_string,FND_API.g_miss_char,NULL,p_lov_string ),
62: DECODE ( p_enabled_flag,FND_API.g_miss_char,NULL,p_enabled_flag ),
63: DECODE ( p_display_flag,FND_API.g_miss_char,NULL,p_display_flag ),
64: DECODE ( p_locator_flag,FND_API.g_miss_char,NULL,p_locator_flag ),

Line 61: DECODE ( p_lov_string,FND_API.g_miss_char,NULL,p_lov_string ),

57: DECODE ( p_refresh_frequency,FND_API.g_miss_char,NULL,p_refresh_frequency ),
58: DECODE ( p_refresh_frequency_uom,FND_API.g_miss_char,NULL,p_refresh_frequency_uom ),
59: DECODE ( p_last_refresh_date,FND_API.g_miss_date,NULL,p_last_refresh_date ),
60: DECODE ( p_display_external_value_flag,FND_API.g_miss_char,NULL,p_display_external_value_flag ),
61: DECODE ( p_lov_string,FND_API.g_miss_char,NULL,p_lov_string ),
62: DECODE ( p_enabled_flag,FND_API.g_miss_char,NULL,p_enabled_flag ),
63: DECODE ( p_display_flag,FND_API.g_miss_char,NULL,p_display_flag ),
64: DECODE ( p_locator_flag,FND_API.g_miss_char,NULL,p_locator_flag ),
65: DECODE ( p_entity_type,FND_API.g_miss_char,NULL,p_entity_type ),

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

58: DECODE ( p_refresh_frequency_uom,FND_API.g_miss_char,NULL,p_refresh_frequency_uom ),
59: DECODE ( p_last_refresh_date,FND_API.g_miss_date,NULL,p_last_refresh_date ),
60: DECODE ( p_display_external_value_flag,FND_API.g_miss_char,NULL,p_display_external_value_flag ),
61: DECODE ( p_lov_string,FND_API.g_miss_char,NULL,p_lov_string ),
62: DECODE ( p_enabled_flag,FND_API.g_miss_char,NULL,p_enabled_flag ),
63: DECODE ( p_display_flag,FND_API.g_miss_char,NULL,p_display_flag ),
64: DECODE ( p_locator_flag,FND_API.g_miss_char,NULL,p_locator_flag ),
65: DECODE ( p_entity_type,FND_API.g_miss_char,NULL,p_entity_type ),
66: DECODE ( p_require_validation_flag,FND_API.g_miss_char,NULL,p_require_validation_flag ),

Line 63: DECODE ( p_display_flag,FND_API.g_miss_char,NULL,p_display_flag ),

59: DECODE ( p_last_refresh_date,FND_API.g_miss_date,NULL,p_last_refresh_date ),
60: DECODE ( p_display_external_value_flag,FND_API.g_miss_char,NULL,p_display_external_value_flag ),
61: DECODE ( p_lov_string,FND_API.g_miss_char,NULL,p_lov_string ),
62: DECODE ( p_enabled_flag,FND_API.g_miss_char,NULL,p_enabled_flag ),
63: DECODE ( p_display_flag,FND_API.g_miss_char,NULL,p_display_flag ),
64: DECODE ( p_locator_flag,FND_API.g_miss_char,NULL,p_locator_flag ),
65: DECODE ( p_entity_type,FND_API.g_miss_char,NULL,p_entity_type ),
66: DECODE ( p_require_validation_flag,FND_API.g_miss_char,NULL,p_require_validation_flag ),
67: DECODE ( p_external_update_text,FND_API.g_miss_char,NULL,p_external_update_text ),

Line 64: DECODE ( p_locator_flag,FND_API.g_miss_char,NULL,p_locator_flag ),

60: DECODE ( p_display_external_value_flag,FND_API.g_miss_char,NULL,p_display_external_value_flag ),
61: DECODE ( p_lov_string,FND_API.g_miss_char,NULL,p_lov_string ),
62: DECODE ( p_enabled_flag,FND_API.g_miss_char,NULL,p_enabled_flag ),
63: DECODE ( p_display_flag,FND_API.g_miss_char,NULL,p_display_flag ),
64: DECODE ( p_locator_flag,FND_API.g_miss_char,NULL,p_locator_flag ),
65: DECODE ( p_entity_type,FND_API.g_miss_char,NULL,p_entity_type ),
66: DECODE ( p_require_validation_flag,FND_API.g_miss_char,NULL,p_require_validation_flag ),
67: DECODE ( p_external_update_text,FND_API.g_miss_char,NULL,p_external_update_text ),
68: DECODE ( px_object_version_number,FND_API.g_miss_num,NULL,px_object_version_number ),

Line 65: DECODE ( p_entity_type,FND_API.g_miss_char,NULL,p_entity_type ),

61: DECODE ( p_lov_string,FND_API.g_miss_char,NULL,p_lov_string ),
62: DECODE ( p_enabled_flag,FND_API.g_miss_char,NULL,p_enabled_flag ),
63: DECODE ( p_display_flag,FND_API.g_miss_char,NULL,p_display_flag ),
64: DECODE ( p_locator_flag,FND_API.g_miss_char,NULL,p_locator_flag ),
65: DECODE ( p_entity_type,FND_API.g_miss_char,NULL,p_entity_type ),
66: DECODE ( p_require_validation_flag,FND_API.g_miss_char,NULL,p_require_validation_flag ),
67: DECODE ( p_external_update_text,FND_API.g_miss_char,NULL,p_external_update_text ),
68: DECODE ( px_object_version_number,FND_API.g_miss_num,NULL,px_object_version_number ),
69: DECODE ( p_attribute_id,FND_API.g_miss_num,NULL,p_attribute_id ),

Line 66: DECODE ( p_require_validation_flag,FND_API.g_miss_char,NULL,p_require_validation_flag ),

62: DECODE ( p_enabled_flag,FND_API.g_miss_char,NULL,p_enabled_flag ),
63: DECODE ( p_display_flag,FND_API.g_miss_char,NULL,p_display_flag ),
64: DECODE ( p_locator_flag,FND_API.g_miss_char,NULL,p_locator_flag ),
65: DECODE ( p_entity_type,FND_API.g_miss_char,NULL,p_entity_type ),
66: DECODE ( p_require_validation_flag,FND_API.g_miss_char,NULL,p_require_validation_flag ),
67: DECODE ( p_external_update_text,FND_API.g_miss_char,NULL,p_external_update_text ),
68: DECODE ( px_object_version_number,FND_API.g_miss_num,NULL,px_object_version_number ),
69: DECODE ( p_attribute_id,FND_API.g_miss_num,NULL,p_attribute_id ),
70: DECODE ( p_entity,FND_API.g_miss_char,NULL,p_entity ),

Line 67: DECODE ( p_external_update_text,FND_API.g_miss_char,NULL,p_external_update_text ),

63: DECODE ( p_display_flag,FND_API.g_miss_char,NULL,p_display_flag ),
64: DECODE ( p_locator_flag,FND_API.g_miss_char,NULL,p_locator_flag ),
65: DECODE ( p_entity_type,FND_API.g_miss_char,NULL,p_entity_type ),
66: DECODE ( p_require_validation_flag,FND_API.g_miss_char,NULL,p_require_validation_flag ),
67: DECODE ( p_external_update_text,FND_API.g_miss_char,NULL,p_external_update_text ),
68: DECODE ( px_object_version_number,FND_API.g_miss_num,NULL,px_object_version_number ),
69: DECODE ( p_attribute_id,FND_API.g_miss_num,NULL,p_attribute_id ),
70: DECODE ( p_entity,FND_API.g_miss_char,NULL,p_entity ),
71: DECODE ( p_sql_text,FND_API.g_miss_char,NULL,p_sql_text ),

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

64: DECODE ( p_locator_flag,FND_API.g_miss_char,NULL,p_locator_flag ),
65: DECODE ( p_entity_type,FND_API.g_miss_char,NULL,p_entity_type ),
66: DECODE ( p_require_validation_flag,FND_API.g_miss_char,NULL,p_require_validation_flag ),
67: DECODE ( p_external_update_text,FND_API.g_miss_char,NULL,p_external_update_text ),
68: DECODE ( px_object_version_number,FND_API.g_miss_num,NULL,px_object_version_number ),
69: DECODE ( p_attribute_id,FND_API.g_miss_num,NULL,p_attribute_id ),
70: DECODE ( p_entity,FND_API.g_miss_char,NULL,p_entity ),
71: DECODE ( p_sql_text,FND_API.g_miss_char,NULL,p_sql_text ),
72: DECODE ( p_attr_data_type,FND_API.g_miss_char,NULL,p_attr_data_type ),

Line 69: DECODE ( p_attribute_id,FND_API.g_miss_num,NULL,p_attribute_id ),

65: DECODE ( p_entity_type,FND_API.g_miss_char,NULL,p_entity_type ),
66: DECODE ( p_require_validation_flag,FND_API.g_miss_char,NULL,p_require_validation_flag ),
67: DECODE ( p_external_update_text,FND_API.g_miss_char,NULL,p_external_update_text ),
68: DECODE ( px_object_version_number,FND_API.g_miss_num,NULL,px_object_version_number ),
69: DECODE ( p_attribute_id,FND_API.g_miss_num,NULL,p_attribute_id ),
70: DECODE ( p_entity,FND_API.g_miss_char,NULL,p_entity ),
71: DECODE ( p_sql_text,FND_API.g_miss_char,NULL,p_sql_text ),
72: DECODE ( p_attr_data_type,FND_API.g_miss_char,NULL,p_attr_data_type ),
73: DECODE ( p_creation_date,FND_API.g_miss_date,NULL,p_creation_date ),

Line 70: DECODE ( p_entity,FND_API.g_miss_char,NULL,p_entity ),

66: DECODE ( p_require_validation_flag,FND_API.g_miss_char,NULL,p_require_validation_flag ),
67: DECODE ( p_external_update_text,FND_API.g_miss_char,NULL,p_external_update_text ),
68: DECODE ( px_object_version_number,FND_API.g_miss_num,NULL,px_object_version_number ),
69: DECODE ( p_attribute_id,FND_API.g_miss_num,NULL,p_attribute_id ),
70: DECODE ( p_entity,FND_API.g_miss_char,NULL,p_entity ),
71: DECODE ( p_sql_text,FND_API.g_miss_char,NULL,p_sql_text ),
72: DECODE ( p_attr_data_type,FND_API.g_miss_char,NULL,p_attr_data_type ),
73: DECODE ( p_creation_date,FND_API.g_miss_date,NULL,p_creation_date ),
74: DECODE ( p_created_by,FND_API.g_miss_num,NULL,p_created_by ),

Line 71: DECODE ( p_sql_text,FND_API.g_miss_char,NULL,p_sql_text ),

67: DECODE ( p_external_update_text,FND_API.g_miss_char,NULL,p_external_update_text ),
68: DECODE ( px_object_version_number,FND_API.g_miss_num,NULL,px_object_version_number ),
69: DECODE ( p_attribute_id,FND_API.g_miss_num,NULL,p_attribute_id ),
70: DECODE ( p_entity,FND_API.g_miss_char,NULL,p_entity ),
71: DECODE ( p_sql_text,FND_API.g_miss_char,NULL,p_sql_text ),
72: DECODE ( p_attr_data_type,FND_API.g_miss_char,NULL,p_attr_data_type ),
73: DECODE ( p_creation_date,FND_API.g_miss_date,NULL,p_creation_date ),
74: DECODE ( p_created_by,FND_API.g_miss_num,NULL,p_created_by ),
75: DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date ),

Line 72: DECODE ( p_attr_data_type,FND_API.g_miss_char,NULL,p_attr_data_type ),

68: DECODE ( px_object_version_number,FND_API.g_miss_num,NULL,px_object_version_number ),
69: DECODE ( p_attribute_id,FND_API.g_miss_num,NULL,p_attribute_id ),
70: DECODE ( p_entity,FND_API.g_miss_char,NULL,p_entity ),
71: DECODE ( p_sql_text,FND_API.g_miss_char,NULL,p_sql_text ),
72: DECODE ( p_attr_data_type,FND_API.g_miss_char,NULL,p_attr_data_type ),
73: DECODE ( p_creation_date,FND_API.g_miss_date,NULL,p_creation_date ),
74: DECODE ( p_created_by,FND_API.g_miss_num,NULL,p_created_by ),
75: DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date ),
76: DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),

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

69: DECODE ( p_attribute_id,FND_API.g_miss_num,NULL,p_attribute_id ),
70: DECODE ( p_entity,FND_API.g_miss_char,NULL,p_entity ),
71: DECODE ( p_sql_text,FND_API.g_miss_char,NULL,p_sql_text ),
72: DECODE ( p_attr_data_type,FND_API.g_miss_char,NULL,p_attr_data_type ),
73: DECODE ( p_creation_date,FND_API.g_miss_date,NULL,p_creation_date ),
74: DECODE ( p_created_by,FND_API.g_miss_num,NULL,p_created_by ),
75: DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date ),
76: DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),
77: DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login));

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

70: DECODE ( p_entity,FND_API.g_miss_char,NULL,p_entity ),
71: DECODE ( p_sql_text,FND_API.g_miss_char,NULL,p_sql_text ),
72: DECODE ( p_attr_data_type,FND_API.g_miss_char,NULL,p_attr_data_type ),
73: DECODE ( p_creation_date,FND_API.g_miss_date,NULL,p_creation_date ),
74: DECODE ( p_created_by,FND_API.g_miss_num,NULL,p_created_by ),
75: DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date ),
76: DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),
77: DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login));
78:

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

71: DECODE ( p_sql_text,FND_API.g_miss_char,NULL,p_sql_text ),
72: DECODE ( p_attr_data_type,FND_API.g_miss_char,NULL,p_attr_data_type ),
73: DECODE ( p_creation_date,FND_API.g_miss_date,NULL,p_creation_date ),
74: DECODE ( p_created_by,FND_API.g_miss_num,NULL,p_created_by ),
75: DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date ),
76: DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),
77: DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login));
78:
79:

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

72: DECODE ( p_attr_data_type,FND_API.g_miss_char,NULL,p_attr_data_type ),
73: DECODE ( p_creation_date,FND_API.g_miss_date,NULL,p_creation_date ),
74: DECODE ( p_created_by,FND_API.g_miss_num,NULL,p_created_by ),
75: DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date ),
76: DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),
77: DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login));
78:
79:
80:

Line 77: DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login));

73: DECODE ( p_creation_date,FND_API.g_miss_date,NULL,p_creation_date ),
74: DECODE ( p_created_by,FND_API.g_miss_num,NULL,p_created_by ),
75: DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date ),
76: DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),
77: DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login));
78:
79:
80:
81: end INSERT_ROW;

Line 200: batch_sql_text = DECODE ( p_batch_sql_text,FND_API.g_miss_char,NULL,p_batch_sql_text ),

196: p_last_update_login IN NUMBER
197: ) IS
198: begin
199: update PV_ENTITY_ATTRS set
200: batch_sql_text = DECODE ( p_batch_sql_text,FND_API.g_miss_char,NULL,p_batch_sql_text ),
201: refresh_frequency = DECODE ( p_refresh_frequency,FND_API.g_miss_char,NULL,p_refresh_frequency ),
202: refresh_frequency_uom = DECODE ( p_refresh_frequency_uom,FND_API.g_miss_char,NULL,p_refresh_frequency_uom ),
203: last_refresh_date = DECODE ( p_last_refresh_date,FND_API.g_miss_date,NULL,p_last_refresh_date ),
204: display_external_value_flag = DECODE ( p_display_external_value_flag,FND_API.g_miss_char,NULL,p_display_external_value_flag ),

Line 201: refresh_frequency = DECODE ( p_refresh_frequency,FND_API.g_miss_char,NULL,p_refresh_frequency ),

197: ) IS
198: begin
199: update PV_ENTITY_ATTRS set
200: batch_sql_text = DECODE ( p_batch_sql_text,FND_API.g_miss_char,NULL,p_batch_sql_text ),
201: refresh_frequency = DECODE ( p_refresh_frequency,FND_API.g_miss_char,NULL,p_refresh_frequency ),
202: refresh_frequency_uom = DECODE ( p_refresh_frequency_uom,FND_API.g_miss_char,NULL,p_refresh_frequency_uom ),
203: last_refresh_date = DECODE ( p_last_refresh_date,FND_API.g_miss_date,NULL,p_last_refresh_date ),
204: display_external_value_flag = DECODE ( p_display_external_value_flag,FND_API.g_miss_char,NULL,p_display_external_value_flag ),
205: lov_string = DECODE ( p_lov_string,FND_API.g_miss_char,NULL,p_lov_string ),

Line 202: refresh_frequency_uom = DECODE ( p_refresh_frequency_uom,FND_API.g_miss_char,NULL,p_refresh_frequency_uom ),

198: begin
199: update PV_ENTITY_ATTRS set
200: batch_sql_text = DECODE ( p_batch_sql_text,FND_API.g_miss_char,NULL,p_batch_sql_text ),
201: refresh_frequency = DECODE ( p_refresh_frequency,FND_API.g_miss_char,NULL,p_refresh_frequency ),
202: refresh_frequency_uom = DECODE ( p_refresh_frequency_uom,FND_API.g_miss_char,NULL,p_refresh_frequency_uom ),
203: last_refresh_date = DECODE ( p_last_refresh_date,FND_API.g_miss_date,NULL,p_last_refresh_date ),
204: display_external_value_flag = DECODE ( p_display_external_value_flag,FND_API.g_miss_char,NULL,p_display_external_value_flag ),
205: lov_string = DECODE ( p_lov_string,FND_API.g_miss_char,NULL,p_lov_string ),
206: enabled_flag = DECODE ( p_enabled_flag,FND_API.g_miss_char,NULL,p_enabled_flag ),

Line 203: last_refresh_date = DECODE ( p_last_refresh_date,FND_API.g_miss_date,NULL,p_last_refresh_date ),

199: update PV_ENTITY_ATTRS set
200: batch_sql_text = DECODE ( p_batch_sql_text,FND_API.g_miss_char,NULL,p_batch_sql_text ),
201: refresh_frequency = DECODE ( p_refresh_frequency,FND_API.g_miss_char,NULL,p_refresh_frequency ),
202: refresh_frequency_uom = DECODE ( p_refresh_frequency_uom,FND_API.g_miss_char,NULL,p_refresh_frequency_uom ),
203: last_refresh_date = DECODE ( p_last_refresh_date,FND_API.g_miss_date,NULL,p_last_refresh_date ),
204: display_external_value_flag = DECODE ( p_display_external_value_flag,FND_API.g_miss_char,NULL,p_display_external_value_flag ),
205: lov_string = DECODE ( p_lov_string,FND_API.g_miss_char,NULL,p_lov_string ),
206: enabled_flag = DECODE ( p_enabled_flag,FND_API.g_miss_char,NULL,p_enabled_flag ),
207: display_flag = DECODE ( p_display_flag,FND_API.g_miss_char,NULL,p_display_flag ),

Line 204: display_external_value_flag = DECODE ( p_display_external_value_flag,FND_API.g_miss_char,NULL,p_display_external_value_flag ),

200: batch_sql_text = DECODE ( p_batch_sql_text,FND_API.g_miss_char,NULL,p_batch_sql_text ),
201: refresh_frequency = DECODE ( p_refresh_frequency,FND_API.g_miss_char,NULL,p_refresh_frequency ),
202: refresh_frequency_uom = DECODE ( p_refresh_frequency_uom,FND_API.g_miss_char,NULL,p_refresh_frequency_uom ),
203: last_refresh_date = DECODE ( p_last_refresh_date,FND_API.g_miss_date,NULL,p_last_refresh_date ),
204: display_external_value_flag = DECODE ( p_display_external_value_flag,FND_API.g_miss_char,NULL,p_display_external_value_flag ),
205: lov_string = DECODE ( p_lov_string,FND_API.g_miss_char,NULL,p_lov_string ),
206: enabled_flag = DECODE ( p_enabled_flag,FND_API.g_miss_char,NULL,p_enabled_flag ),
207: display_flag = DECODE ( p_display_flag,FND_API.g_miss_char,NULL,p_display_flag ),
208: locator_flag = DECODE ( p_locator_flag,FND_API.g_miss_char,NULL,p_locator_flag ),

Line 205: lov_string = DECODE ( p_lov_string,FND_API.g_miss_char,NULL,p_lov_string ),

201: refresh_frequency = DECODE ( p_refresh_frequency,FND_API.g_miss_char,NULL,p_refresh_frequency ),
202: refresh_frequency_uom = DECODE ( p_refresh_frequency_uom,FND_API.g_miss_char,NULL,p_refresh_frequency_uom ),
203: last_refresh_date = DECODE ( p_last_refresh_date,FND_API.g_miss_date,NULL,p_last_refresh_date ),
204: display_external_value_flag = DECODE ( p_display_external_value_flag,FND_API.g_miss_char,NULL,p_display_external_value_flag ),
205: lov_string = DECODE ( p_lov_string,FND_API.g_miss_char,NULL,p_lov_string ),
206: enabled_flag = DECODE ( p_enabled_flag,FND_API.g_miss_char,NULL,p_enabled_flag ),
207: display_flag = DECODE ( p_display_flag,FND_API.g_miss_char,NULL,p_display_flag ),
208: locator_flag = DECODE ( p_locator_flag,FND_API.g_miss_char,NULL,p_locator_flag ),
209: entity_type = DECODE ( p_entity_type,FND_API.g_miss_char,NULL,p_entity_type ),

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

202: refresh_frequency_uom = DECODE ( p_refresh_frequency_uom,FND_API.g_miss_char,NULL,p_refresh_frequency_uom ),
203: last_refresh_date = DECODE ( p_last_refresh_date,FND_API.g_miss_date,NULL,p_last_refresh_date ),
204: display_external_value_flag = DECODE ( p_display_external_value_flag,FND_API.g_miss_char,NULL,p_display_external_value_flag ),
205: lov_string = DECODE ( p_lov_string,FND_API.g_miss_char,NULL,p_lov_string ),
206: enabled_flag = DECODE ( p_enabled_flag,FND_API.g_miss_char,NULL,p_enabled_flag ),
207: display_flag = DECODE ( p_display_flag,FND_API.g_miss_char,NULL,p_display_flag ),
208: locator_flag = DECODE ( p_locator_flag,FND_API.g_miss_char,NULL,p_locator_flag ),
209: entity_type = DECODE ( p_entity_type,FND_API.g_miss_char,NULL,p_entity_type ),
210: require_validation_flag = DECODE ( p_require_validation_flag,FND_API.g_miss_char,NULL,p_require_validation_flag ),

Line 207: display_flag = DECODE ( p_display_flag,FND_API.g_miss_char,NULL,p_display_flag ),

203: last_refresh_date = DECODE ( p_last_refresh_date,FND_API.g_miss_date,NULL,p_last_refresh_date ),
204: display_external_value_flag = DECODE ( p_display_external_value_flag,FND_API.g_miss_char,NULL,p_display_external_value_flag ),
205: lov_string = DECODE ( p_lov_string,FND_API.g_miss_char,NULL,p_lov_string ),
206: enabled_flag = DECODE ( p_enabled_flag,FND_API.g_miss_char,NULL,p_enabled_flag ),
207: display_flag = DECODE ( p_display_flag,FND_API.g_miss_char,NULL,p_display_flag ),
208: locator_flag = DECODE ( p_locator_flag,FND_API.g_miss_char,NULL,p_locator_flag ),
209: entity_type = DECODE ( p_entity_type,FND_API.g_miss_char,NULL,p_entity_type ),
210: require_validation_flag = DECODE ( p_require_validation_flag,FND_API.g_miss_char,NULL,p_require_validation_flag ),
211: external_update_text = DECODE ( p_external_update_text,FND_API.g_miss_char,NULL,p_external_update_text ),

Line 208: locator_flag = DECODE ( p_locator_flag,FND_API.g_miss_char,NULL,p_locator_flag ),

204: display_external_value_flag = DECODE ( p_display_external_value_flag,FND_API.g_miss_char,NULL,p_display_external_value_flag ),
205: lov_string = DECODE ( p_lov_string,FND_API.g_miss_char,NULL,p_lov_string ),
206: enabled_flag = DECODE ( p_enabled_flag,FND_API.g_miss_char,NULL,p_enabled_flag ),
207: display_flag = DECODE ( p_display_flag,FND_API.g_miss_char,NULL,p_display_flag ),
208: locator_flag = DECODE ( p_locator_flag,FND_API.g_miss_char,NULL,p_locator_flag ),
209: entity_type = DECODE ( p_entity_type,FND_API.g_miss_char,NULL,p_entity_type ),
210: require_validation_flag = DECODE ( p_require_validation_flag,FND_API.g_miss_char,NULL,p_require_validation_flag ),
211: external_update_text = DECODE ( p_external_update_text,FND_API.g_miss_char,NULL,p_external_update_text ),
212: object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1 ),

Line 209: entity_type = DECODE ( p_entity_type,FND_API.g_miss_char,NULL,p_entity_type ),

205: lov_string = DECODE ( p_lov_string,FND_API.g_miss_char,NULL,p_lov_string ),
206: enabled_flag = DECODE ( p_enabled_flag,FND_API.g_miss_char,NULL,p_enabled_flag ),
207: display_flag = DECODE ( p_display_flag,FND_API.g_miss_char,NULL,p_display_flag ),
208: locator_flag = DECODE ( p_locator_flag,FND_API.g_miss_char,NULL,p_locator_flag ),
209: entity_type = DECODE ( p_entity_type,FND_API.g_miss_char,NULL,p_entity_type ),
210: require_validation_flag = DECODE ( p_require_validation_flag,FND_API.g_miss_char,NULL,p_require_validation_flag ),
211: external_update_text = DECODE ( p_external_update_text,FND_API.g_miss_char,NULL,p_external_update_text ),
212: object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1 ),
213: attribute_id = DECODE ( p_attribute_id,FND_API.g_miss_num,NULL,p_attribute_id ),

Line 210: require_validation_flag = DECODE ( p_require_validation_flag,FND_API.g_miss_char,NULL,p_require_validation_flag ),

206: enabled_flag = DECODE ( p_enabled_flag,FND_API.g_miss_char,NULL,p_enabled_flag ),
207: display_flag = DECODE ( p_display_flag,FND_API.g_miss_char,NULL,p_display_flag ),
208: locator_flag = DECODE ( p_locator_flag,FND_API.g_miss_char,NULL,p_locator_flag ),
209: entity_type = DECODE ( p_entity_type,FND_API.g_miss_char,NULL,p_entity_type ),
210: require_validation_flag = DECODE ( p_require_validation_flag,FND_API.g_miss_char,NULL,p_require_validation_flag ),
211: external_update_text = DECODE ( p_external_update_text,FND_API.g_miss_char,NULL,p_external_update_text ),
212: object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1 ),
213: attribute_id = DECODE ( p_attribute_id,FND_API.g_miss_num,NULL,p_attribute_id ),
214: entity = DECODE ( p_entity,FND_API.g_miss_char,NULL,p_entity ),

Line 211: external_update_text = DECODE ( p_external_update_text,FND_API.g_miss_char,NULL,p_external_update_text ),

207: display_flag = DECODE ( p_display_flag,FND_API.g_miss_char,NULL,p_display_flag ),
208: locator_flag = DECODE ( p_locator_flag,FND_API.g_miss_char,NULL,p_locator_flag ),
209: entity_type = DECODE ( p_entity_type,FND_API.g_miss_char,NULL,p_entity_type ),
210: require_validation_flag = DECODE ( p_require_validation_flag,FND_API.g_miss_char,NULL,p_require_validation_flag ),
211: external_update_text = DECODE ( p_external_update_text,FND_API.g_miss_char,NULL,p_external_update_text ),
212: object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1 ),
213: attribute_id = DECODE ( p_attribute_id,FND_API.g_miss_num,NULL,p_attribute_id ),
214: entity = DECODE ( p_entity,FND_API.g_miss_char,NULL,p_entity ),
215: sql_text = DECODE ( p_sql_text,FND_API.g_miss_char,NULL,p_sql_text ),

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

208: locator_flag = DECODE ( p_locator_flag,FND_API.g_miss_char,NULL,p_locator_flag ),
209: entity_type = DECODE ( p_entity_type,FND_API.g_miss_char,NULL,p_entity_type ),
210: require_validation_flag = DECODE ( p_require_validation_flag,FND_API.g_miss_char,NULL,p_require_validation_flag ),
211: external_update_text = DECODE ( p_external_update_text,FND_API.g_miss_char,NULL,p_external_update_text ),
212: object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1 ),
213: attribute_id = DECODE ( p_attribute_id,FND_API.g_miss_num,NULL,p_attribute_id ),
214: entity = DECODE ( p_entity,FND_API.g_miss_char,NULL,p_entity ),
215: sql_text = DECODE ( p_sql_text,FND_API.g_miss_char,NULL,p_sql_text ),
216: attr_data_type = DECODE ( p_attr_data_type,FND_API.g_miss_char,NULL,p_attr_data_type ),

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

209: entity_type = DECODE ( p_entity_type,FND_API.g_miss_char,NULL,p_entity_type ),
210: require_validation_flag = DECODE ( p_require_validation_flag,FND_API.g_miss_char,NULL,p_require_validation_flag ),
211: external_update_text = DECODE ( p_external_update_text,FND_API.g_miss_char,NULL,p_external_update_text ),
212: object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1 ),
213: attribute_id = DECODE ( p_attribute_id,FND_API.g_miss_num,NULL,p_attribute_id ),
214: entity = DECODE ( p_entity,FND_API.g_miss_char,NULL,p_entity ),
215: sql_text = DECODE ( p_sql_text,FND_API.g_miss_char,NULL,p_sql_text ),
216: attr_data_type = DECODE ( p_attr_data_type,FND_API.g_miss_char,NULL,p_attr_data_type ),
217: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date ),

Line 214: entity = DECODE ( p_entity,FND_API.g_miss_char,NULL,p_entity ),

210: require_validation_flag = DECODE ( p_require_validation_flag,FND_API.g_miss_char,NULL,p_require_validation_flag ),
211: external_update_text = DECODE ( p_external_update_text,FND_API.g_miss_char,NULL,p_external_update_text ),
212: object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1 ),
213: attribute_id = DECODE ( p_attribute_id,FND_API.g_miss_num,NULL,p_attribute_id ),
214: entity = DECODE ( p_entity,FND_API.g_miss_char,NULL,p_entity ),
215: sql_text = DECODE ( p_sql_text,FND_API.g_miss_char,NULL,p_sql_text ),
216: attr_data_type = DECODE ( p_attr_data_type,FND_API.g_miss_char,NULL,p_attr_data_type ),
217: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date ),
218: last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),

Line 215: sql_text = DECODE ( p_sql_text,FND_API.g_miss_char,NULL,p_sql_text ),

211: external_update_text = DECODE ( p_external_update_text,FND_API.g_miss_char,NULL,p_external_update_text ),
212: object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1 ),
213: attribute_id = DECODE ( p_attribute_id,FND_API.g_miss_num,NULL,p_attribute_id ),
214: entity = DECODE ( p_entity,FND_API.g_miss_char,NULL,p_entity ),
215: sql_text = DECODE ( p_sql_text,FND_API.g_miss_char,NULL,p_sql_text ),
216: attr_data_type = DECODE ( p_attr_data_type,FND_API.g_miss_char,NULL,p_attr_data_type ),
217: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date ),
218: last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),
219: last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login)

Line 216: attr_data_type = DECODE ( p_attr_data_type,FND_API.g_miss_char,NULL,p_attr_data_type ),

212: object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1 ),
213: attribute_id = DECODE ( p_attribute_id,FND_API.g_miss_num,NULL,p_attribute_id ),
214: entity = DECODE ( p_entity,FND_API.g_miss_char,NULL,p_entity ),
215: sql_text = DECODE ( p_sql_text,FND_API.g_miss_char,NULL,p_sql_text ),
216: attr_data_type = DECODE ( p_attr_data_type,FND_API.g_miss_char,NULL,p_attr_data_type ),
217: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date ),
218: last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),
219: last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login)
220: WHERE entity_attr_id = p_entity_attr_id;

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

213: attribute_id = DECODE ( p_attribute_id,FND_API.g_miss_num,NULL,p_attribute_id ),
214: entity = DECODE ( p_entity,FND_API.g_miss_char,NULL,p_entity ),
215: sql_text = DECODE ( p_sql_text,FND_API.g_miss_char,NULL,p_sql_text ),
216: attr_data_type = DECODE ( p_attr_data_type,FND_API.g_miss_char,NULL,p_attr_data_type ),
217: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date ),
218: last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),
219: last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login)
220: WHERE entity_attr_id = p_entity_attr_id;
221:

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

214: entity = DECODE ( p_entity,FND_API.g_miss_char,NULL,p_entity ),
215: sql_text = DECODE ( p_sql_text,FND_API.g_miss_char,NULL,p_sql_text ),
216: attr_data_type = DECODE ( p_attr_data_type,FND_API.g_miss_char,NULL,p_attr_data_type ),
217: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date ),
218: last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),
219: last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login)
220: WHERE entity_attr_id = p_entity_attr_id;
221:
222: IF (SQL%NOTFOUND) THEN

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

215: sql_text = DECODE ( p_sql_text,FND_API.g_miss_char,NULL,p_sql_text ),
216: attr_data_type = DECODE ( p_attr_data_type,FND_API.g_miss_char,NULL,p_attr_data_type ),
217: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date ),
218: last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),
219: last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login)
220: WHERE entity_attr_id = p_entity_attr_id;
221:
222: IF (SQL%NOTFOUND) THEN
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

219: last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login)
220: WHERE entity_attr_id = p_entity_attr_id;
221:
222: IF (SQL%NOTFOUND) THEN
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224: END IF;
225:
226: end UPDATE_ROW;
227:

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

330: )
331: IS
332: BEGIN
333: update PV_ENTITY_ATTRS set
334: attribute_id = DECODE ( p_attribute_id,FND_API.g_miss_num,NULL,p_attribute_id ),
335: entity = DECODE ( p_entity,FND_API.g_miss_char,NULL,p_entity ),
336: sql_text = DECODE ( p_sql_text,FND_API.g_miss_char,NULL,p_sql_text ),
337: attr_data_type = DECODE ( p_attr_data_type,FND_API.g_miss_char,NULL,p_attr_data_type ),
338: lov_string = DECODE ( p_lov_string,FND_API.g_miss_char,NULL,p_lov_string ),

Line 335: entity = DECODE ( p_entity,FND_API.g_miss_char,NULL,p_entity ),

331: IS
332: BEGIN
333: update PV_ENTITY_ATTRS set
334: attribute_id = DECODE ( p_attribute_id,FND_API.g_miss_num,NULL,p_attribute_id ),
335: entity = DECODE ( p_entity,FND_API.g_miss_char,NULL,p_entity ),
336: sql_text = DECODE ( p_sql_text,FND_API.g_miss_char,NULL,p_sql_text ),
337: attr_data_type = DECODE ( p_attr_data_type,FND_API.g_miss_char,NULL,p_attr_data_type ),
338: lov_string = DECODE ( p_lov_string,FND_API.g_miss_char,NULL,p_lov_string ),
339: entity_type = DECODE ( p_entity_type,FND_API.g_miss_char,NULL,p_entity_type ),

Line 336: sql_text = DECODE ( p_sql_text,FND_API.g_miss_char,NULL,p_sql_text ),

332: BEGIN
333: update PV_ENTITY_ATTRS set
334: attribute_id = DECODE ( p_attribute_id,FND_API.g_miss_num,NULL,p_attribute_id ),
335: entity = DECODE ( p_entity,FND_API.g_miss_char,NULL,p_entity ),
336: sql_text = DECODE ( p_sql_text,FND_API.g_miss_char,NULL,p_sql_text ),
337: attr_data_type = DECODE ( p_attr_data_type,FND_API.g_miss_char,NULL,p_attr_data_type ),
338: lov_string = DECODE ( p_lov_string,FND_API.g_miss_char,NULL,p_lov_string ),
339: entity_type = DECODE ( p_entity_type,FND_API.g_miss_char,NULL,p_entity_type ),
340: enabled_flag = DECODE ( p_enabled_flag,FND_API.g_miss_char,NULL,p_enabled_flag ),

Line 337: attr_data_type = DECODE ( p_attr_data_type,FND_API.g_miss_char,NULL,p_attr_data_type ),

333: update PV_ENTITY_ATTRS set
334: attribute_id = DECODE ( p_attribute_id,FND_API.g_miss_num,NULL,p_attribute_id ),
335: entity = DECODE ( p_entity,FND_API.g_miss_char,NULL,p_entity ),
336: sql_text = DECODE ( p_sql_text,FND_API.g_miss_char,NULL,p_sql_text ),
337: attr_data_type = DECODE ( p_attr_data_type,FND_API.g_miss_char,NULL,p_attr_data_type ),
338: lov_string = DECODE ( p_lov_string,FND_API.g_miss_char,NULL,p_lov_string ),
339: entity_type = DECODE ( p_entity_type,FND_API.g_miss_char,NULL,p_entity_type ),
340: enabled_flag = DECODE ( p_enabled_flag,FND_API.g_miss_char,NULL,p_enabled_flag ),
341: display_flag = DECODE ( p_display_flag,FND_API.g_miss_char,NULL,p_display_flag ),

Line 338: lov_string = DECODE ( p_lov_string,FND_API.g_miss_char,NULL,p_lov_string ),

334: attribute_id = DECODE ( p_attribute_id,FND_API.g_miss_num,NULL,p_attribute_id ),
335: entity = DECODE ( p_entity,FND_API.g_miss_char,NULL,p_entity ),
336: sql_text = DECODE ( p_sql_text,FND_API.g_miss_char,NULL,p_sql_text ),
337: attr_data_type = DECODE ( p_attr_data_type,FND_API.g_miss_char,NULL,p_attr_data_type ),
338: lov_string = DECODE ( p_lov_string,FND_API.g_miss_char,NULL,p_lov_string ),
339: entity_type = DECODE ( p_entity_type,FND_API.g_miss_char,NULL,p_entity_type ),
340: enabled_flag = DECODE ( p_enabled_flag,FND_API.g_miss_char,NULL,p_enabled_flag ),
341: display_flag = DECODE ( p_display_flag,FND_API.g_miss_char,NULL,p_display_flag ),
342: external_update_text = DECODE ( p_external_update_text,FND_API.g_miss_char,NULL,p_external_update_text ),

Line 339: entity_type = DECODE ( p_entity_type,FND_API.g_miss_char,NULL,p_entity_type ),

335: entity = DECODE ( p_entity,FND_API.g_miss_char,NULL,p_entity ),
336: sql_text = DECODE ( p_sql_text,FND_API.g_miss_char,NULL,p_sql_text ),
337: attr_data_type = DECODE ( p_attr_data_type,FND_API.g_miss_char,NULL,p_attr_data_type ),
338: lov_string = DECODE ( p_lov_string,FND_API.g_miss_char,NULL,p_lov_string ),
339: entity_type = DECODE ( p_entity_type,FND_API.g_miss_char,NULL,p_entity_type ),
340: enabled_flag = DECODE ( p_enabled_flag,FND_API.g_miss_char,NULL,p_enabled_flag ),
341: display_flag = DECODE ( p_display_flag,FND_API.g_miss_char,NULL,p_display_flag ),
342: external_update_text = DECODE ( p_external_update_text,FND_API.g_miss_char,NULL,p_external_update_text ),
343: batch_sql_text = DECODE ( p_batch_sql_text,FND_API.g_miss_char,NULL,p_batch_sql_text ),

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

336: sql_text = DECODE ( p_sql_text,FND_API.g_miss_char,NULL,p_sql_text ),
337: attr_data_type = DECODE ( p_attr_data_type,FND_API.g_miss_char,NULL,p_attr_data_type ),
338: lov_string = DECODE ( p_lov_string,FND_API.g_miss_char,NULL,p_lov_string ),
339: entity_type = DECODE ( p_entity_type,FND_API.g_miss_char,NULL,p_entity_type ),
340: enabled_flag = DECODE ( p_enabled_flag,FND_API.g_miss_char,NULL,p_enabled_flag ),
341: display_flag = DECODE ( p_display_flag,FND_API.g_miss_char,NULL,p_display_flag ),
342: external_update_text = DECODE ( p_external_update_text,FND_API.g_miss_char,NULL,p_external_update_text ),
343: batch_sql_text = DECODE ( p_batch_sql_text,FND_API.g_miss_char,NULL,p_batch_sql_text ),
344: display_external_value_flag = DECODE ( p_display_external_value_flag,FND_API.g_miss_char,NULL,p_display_external_value_flag ),

Line 341: display_flag = DECODE ( p_display_flag,FND_API.g_miss_char,NULL,p_display_flag ),

337: attr_data_type = DECODE ( p_attr_data_type,FND_API.g_miss_char,NULL,p_attr_data_type ),
338: lov_string = DECODE ( p_lov_string,FND_API.g_miss_char,NULL,p_lov_string ),
339: entity_type = DECODE ( p_entity_type,FND_API.g_miss_char,NULL,p_entity_type ),
340: enabled_flag = DECODE ( p_enabled_flag,FND_API.g_miss_char,NULL,p_enabled_flag ),
341: display_flag = DECODE ( p_display_flag,FND_API.g_miss_char,NULL,p_display_flag ),
342: external_update_text = DECODE ( p_external_update_text,FND_API.g_miss_char,NULL,p_external_update_text ),
343: batch_sql_text = DECODE ( p_batch_sql_text,FND_API.g_miss_char,NULL,p_batch_sql_text ),
344: display_external_value_flag = DECODE ( p_display_external_value_flag,FND_API.g_miss_char,NULL,p_display_external_value_flag ),
345: object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1 ),

Line 342: external_update_text = DECODE ( p_external_update_text,FND_API.g_miss_char,NULL,p_external_update_text ),

338: lov_string = DECODE ( p_lov_string,FND_API.g_miss_char,NULL,p_lov_string ),
339: entity_type = DECODE ( p_entity_type,FND_API.g_miss_char,NULL,p_entity_type ),
340: enabled_flag = DECODE ( p_enabled_flag,FND_API.g_miss_char,NULL,p_enabled_flag ),
341: display_flag = DECODE ( p_display_flag,FND_API.g_miss_char,NULL,p_display_flag ),
342: external_update_text = DECODE ( p_external_update_text,FND_API.g_miss_char,NULL,p_external_update_text ),
343: batch_sql_text = DECODE ( p_batch_sql_text,FND_API.g_miss_char,NULL,p_batch_sql_text ),
344: display_external_value_flag = DECODE ( p_display_external_value_flag,FND_API.g_miss_char,NULL,p_display_external_value_flag ),
345: object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1 ),
346: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date ),

Line 343: batch_sql_text = DECODE ( p_batch_sql_text,FND_API.g_miss_char,NULL,p_batch_sql_text ),

339: entity_type = DECODE ( p_entity_type,FND_API.g_miss_char,NULL,p_entity_type ),
340: enabled_flag = DECODE ( p_enabled_flag,FND_API.g_miss_char,NULL,p_enabled_flag ),
341: display_flag = DECODE ( p_display_flag,FND_API.g_miss_char,NULL,p_display_flag ),
342: external_update_text = DECODE ( p_external_update_text,FND_API.g_miss_char,NULL,p_external_update_text ),
343: batch_sql_text = DECODE ( p_batch_sql_text,FND_API.g_miss_char,NULL,p_batch_sql_text ),
344: display_external_value_flag = DECODE ( p_display_external_value_flag,FND_API.g_miss_char,NULL,p_display_external_value_flag ),
345: object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1 ),
346: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date ),
347: last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),

Line 344: display_external_value_flag = DECODE ( p_display_external_value_flag,FND_API.g_miss_char,NULL,p_display_external_value_flag ),

340: enabled_flag = DECODE ( p_enabled_flag,FND_API.g_miss_char,NULL,p_enabled_flag ),
341: display_flag = DECODE ( p_display_flag,FND_API.g_miss_char,NULL,p_display_flag ),
342: external_update_text = DECODE ( p_external_update_text,FND_API.g_miss_char,NULL,p_external_update_text ),
343: batch_sql_text = DECODE ( p_batch_sql_text,FND_API.g_miss_char,NULL,p_batch_sql_text ),
344: display_external_value_flag = DECODE ( p_display_external_value_flag,FND_API.g_miss_char,NULL,p_display_external_value_flag ),
345: object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1 ),
346: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date ),
347: last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),
348: last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login)

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

341: display_flag = DECODE ( p_display_flag,FND_API.g_miss_char,NULL,p_display_flag ),
342: external_update_text = DECODE ( p_external_update_text,FND_API.g_miss_char,NULL,p_external_update_text ),
343: batch_sql_text = DECODE ( p_batch_sql_text,FND_API.g_miss_char,NULL,p_batch_sql_text ),
344: display_external_value_flag = DECODE ( p_display_external_value_flag,FND_API.g_miss_char,NULL,p_display_external_value_flag ),
345: object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1 ),
346: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date ),
347: last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),
348: last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login)
349: WHERE entity_attr_id = p_entity_attr_id;

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

342: external_update_text = DECODE ( p_external_update_text,FND_API.g_miss_char,NULL,p_external_update_text ),
343: batch_sql_text = DECODE ( p_batch_sql_text,FND_API.g_miss_char,NULL,p_batch_sql_text ),
344: display_external_value_flag = DECODE ( p_display_external_value_flag,FND_API.g_miss_char,NULL,p_display_external_value_flag ),
345: object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1 ),
346: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date ),
347: last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),
348: last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login)
349: WHERE entity_attr_id = p_entity_attr_id;
350:

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

343: batch_sql_text = DECODE ( p_batch_sql_text,FND_API.g_miss_char,NULL,p_batch_sql_text ),
344: display_external_value_flag = DECODE ( p_display_external_value_flag,FND_API.g_miss_char,NULL,p_display_external_value_flag ),
345: object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1 ),
346: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date ),
347: last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),
348: last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login)
349: WHERE entity_attr_id = p_entity_attr_id;
350:
351: IF (SQL%NOTFOUND) THEN

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

344: display_external_value_flag = DECODE ( p_display_external_value_flag,FND_API.g_miss_char,NULL,p_display_external_value_flag ),
345: object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1 ),
346: last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date ),
347: last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),
348: last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login)
349: WHERE entity_attr_id = p_entity_attr_id;
350:
351: IF (SQL%NOTFOUND) THEN
352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

348: last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login)
349: WHERE entity_attr_id = p_entity_attr_id;
350:
351: IF (SQL%NOTFOUND) THEN
352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
353: END IF;
354:
355: END seed_update_row;
356:

Line 478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

474: delete from PV_ENTITY_ATTRS
475: where ENTITY_ATTR_ID = p_ENTITY_ATTR_ID;
476:
477: IF (SQL%NOTFOUND) THEN
478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
479: END IF;
480: end DELETE_ROW;
481:
482: