APPS.PV_ATTRIBUTE_USAGES_PKG dependencies on FND_API

Line 84: DECODE( px_attribute_usage_id, FND_API.g_miss_num, NULL, px_attribute_usage_id),

80: attribute_id,
81: enabled_flag
82: --security_group_id
83: ) VALUES (
84: DECODE( px_attribute_usage_id, FND_API.g_miss_num, NULL, px_attribute_usage_id),
85: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
86: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
87: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
88: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

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

81: enabled_flag
82: --security_group_id
83: ) VALUES (
84: DECODE( px_attribute_usage_id, FND_API.g_miss_num, NULL, px_attribute_usage_id),
85: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
86: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
87: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
88: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
89: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

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

82: --security_group_id
83: ) VALUES (
84: DECODE( px_attribute_usage_id, FND_API.g_miss_num, NULL, px_attribute_usage_id),
85: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
86: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
87: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
88: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
89: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
90: DECODE( p_request_id, FND_API.g_miss_num, NULL, p_request_id),

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

83: ) VALUES (
84: DECODE( px_attribute_usage_id, FND_API.g_miss_num, NULL, px_attribute_usage_id),
85: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
86: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
87: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
88: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
89: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
90: DECODE( p_request_id, FND_API.g_miss_num, NULL, p_request_id),
91: DECODE( p_program_application_id, FND_API.g_miss_num, NULL, p_program_application_id),

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

84: DECODE( px_attribute_usage_id, FND_API.g_miss_num, NULL, px_attribute_usage_id),
85: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
86: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
87: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
88: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
89: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
90: DECODE( p_request_id, FND_API.g_miss_num, NULL, p_request_id),
91: DECODE( p_program_application_id, FND_API.g_miss_num, NULL, p_program_application_id),
92: DECODE( p_program_id, FND_API.g_miss_num, NULL, p_program_id),

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

85: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
86: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
87: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
88: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
89: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
90: DECODE( p_request_id, FND_API.g_miss_num, NULL, p_request_id),
91: DECODE( p_program_application_id, FND_API.g_miss_num, NULL, p_program_application_id),
92: DECODE( p_program_id, FND_API.g_miss_num, NULL, p_program_id),
93: DECODE( p_program_update_date, FND_API.g_miss_date, NULL, p_program_update_date),

Line 90: DECODE( p_request_id, FND_API.g_miss_num, NULL, p_request_id),

86: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
87: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
88: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
89: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
90: DECODE( p_request_id, FND_API.g_miss_num, NULL, p_request_id),
91: DECODE( p_program_application_id, FND_API.g_miss_num, NULL, p_program_application_id),
92: DECODE( p_program_id, FND_API.g_miss_num, NULL, p_program_id),
93: DECODE( p_program_update_date, FND_API.g_miss_date, NULL, p_program_update_date),
94: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

Line 91: DECODE( p_program_application_id, FND_API.g_miss_num, NULL, p_program_application_id),

87: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
88: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
89: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
90: DECODE( p_request_id, FND_API.g_miss_num, NULL, p_request_id),
91: DECODE( p_program_application_id, FND_API.g_miss_num, NULL, p_program_application_id),
92: DECODE( p_program_id, FND_API.g_miss_num, NULL, p_program_id),
93: DECODE( p_program_update_date, FND_API.g_miss_date, NULL, p_program_update_date),
94: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
95: DECODE( p_attribute_usage_type, FND_API.g_miss_char, NULL, p_attribute_usage_type),

Line 92: DECODE( p_program_id, FND_API.g_miss_num, NULL, p_program_id),

88: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
89: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
90: DECODE( p_request_id, FND_API.g_miss_num, NULL, p_request_id),
91: DECODE( p_program_application_id, FND_API.g_miss_num, NULL, p_program_application_id),
92: DECODE( p_program_id, FND_API.g_miss_num, NULL, p_program_id),
93: DECODE( p_program_update_date, FND_API.g_miss_date, NULL, p_program_update_date),
94: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
95: DECODE( p_attribute_usage_type, FND_API.g_miss_char, NULL, p_attribute_usage_type),
96: DECODE( p_attribute_usage_code, FND_API.g_miss_char, NULL, p_attribute_usage_code),

Line 93: DECODE( p_program_update_date, FND_API.g_miss_date, NULL, p_program_update_date),

89: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
90: DECODE( p_request_id, FND_API.g_miss_num, NULL, p_request_id),
91: DECODE( p_program_application_id, FND_API.g_miss_num, NULL, p_program_application_id),
92: DECODE( p_program_id, FND_API.g_miss_num, NULL, p_program_id),
93: DECODE( p_program_update_date, FND_API.g_miss_date, NULL, p_program_update_date),
94: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
95: DECODE( p_attribute_usage_type, FND_API.g_miss_char, NULL, p_attribute_usage_type),
96: DECODE( p_attribute_usage_code, FND_API.g_miss_char, NULL, p_attribute_usage_code),
97: DECODE( p_attribute_id, FND_API.g_miss_num, NULL, p_attribute_id),

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

90: DECODE( p_request_id, FND_API.g_miss_num, NULL, p_request_id),
91: DECODE( p_program_application_id, FND_API.g_miss_num, NULL, p_program_application_id),
92: DECODE( p_program_id, FND_API.g_miss_num, NULL, p_program_id),
93: DECODE( p_program_update_date, FND_API.g_miss_date, NULL, p_program_update_date),
94: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
95: DECODE( p_attribute_usage_type, FND_API.g_miss_char, NULL, p_attribute_usage_type),
96: DECODE( p_attribute_usage_code, FND_API.g_miss_char, NULL, p_attribute_usage_code),
97: DECODE( p_attribute_id, FND_API.g_miss_num, NULL, p_attribute_id),
98: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag)

Line 95: DECODE( p_attribute_usage_type, FND_API.g_miss_char, NULL, p_attribute_usage_type),

91: DECODE( p_program_application_id, FND_API.g_miss_num, NULL, p_program_application_id),
92: DECODE( p_program_id, FND_API.g_miss_num, NULL, p_program_id),
93: DECODE( p_program_update_date, FND_API.g_miss_date, NULL, p_program_update_date),
94: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
95: DECODE( p_attribute_usage_type, FND_API.g_miss_char, NULL, p_attribute_usage_type),
96: DECODE( p_attribute_usage_code, FND_API.g_miss_char, NULL, p_attribute_usage_code),
97: DECODE( p_attribute_id, FND_API.g_miss_num, NULL, p_attribute_id),
98: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag)
99: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)

Line 96: DECODE( p_attribute_usage_code, FND_API.g_miss_char, NULL, p_attribute_usage_code),

92: DECODE( p_program_id, FND_API.g_miss_num, NULL, p_program_id),
93: DECODE( p_program_update_date, FND_API.g_miss_date, NULL, p_program_update_date),
94: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
95: DECODE( p_attribute_usage_type, FND_API.g_miss_char, NULL, p_attribute_usage_type),
96: DECODE( p_attribute_usage_code, FND_API.g_miss_char, NULL, p_attribute_usage_code),
97: DECODE( p_attribute_id, FND_API.g_miss_num, NULL, p_attribute_id),
98: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag)
99: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)
100: );

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

93: DECODE( p_program_update_date, FND_API.g_miss_date, NULL, p_program_update_date),
94: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
95: DECODE( p_attribute_usage_type, FND_API.g_miss_char, NULL, p_attribute_usage_type),
96: DECODE( p_attribute_usage_code, FND_API.g_miss_char, NULL, p_attribute_usage_code),
97: DECODE( p_attribute_id, FND_API.g_miss_num, NULL, p_attribute_id),
98: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag)
99: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)
100: );
101: END Insert_Row;

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

94: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
95: DECODE( p_attribute_usage_type, FND_API.g_miss_char, NULL, p_attribute_usage_type),
96: DECODE( p_attribute_usage_code, FND_API.g_miss_char, NULL, p_attribute_usage_code),
97: DECODE( p_attribute_id, FND_API.g_miss_num, NULL, p_attribute_id),
98: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag)
99: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)
100: );
101: END Insert_Row;
102:

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

95: DECODE( p_attribute_usage_type, FND_API.g_miss_char, NULL, p_attribute_usage_type),
96: DECODE( p_attribute_usage_code, FND_API.g_miss_char, NULL, p_attribute_usage_code),
97: DECODE( p_attribute_id, FND_API.g_miss_num, NULL, p_attribute_id),
98: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag)
99: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)
100: );
101: END Insert_Row;
102:
103:

Line 124: p_creation_date DATE := FND_API.g_miss_date ,

120: PROCEDURE Update_Row(
121: p_attribute_usage_id NUMBER,
122: p_last_update_date DATE,
123: p_last_updated_by NUMBER,
124: p_creation_date DATE := FND_API.g_miss_date ,
125: p_created_by NUMBER := FND_API.g_miss_num ,
126: p_last_update_login NUMBER,
127: p_request_id NUMBER,
128: p_program_application_id NUMBER,

Line 125: p_created_by NUMBER := FND_API.g_miss_num ,

121: p_attribute_usage_id NUMBER,
122: p_last_update_date DATE,
123: p_last_updated_by NUMBER,
124: p_creation_date DATE := FND_API.g_miss_date ,
125: p_created_by NUMBER := FND_API.g_miss_num ,
126: p_last_update_login NUMBER,
127: p_request_id NUMBER,
128: p_program_application_id NUMBER,
129: p_program_id NUMBER,

Line 143: attribute_usage_id = DECODE( p_attribute_usage_id, FND_API.g_miss_num, attribute_usage_id, p_attribute_usage_id),

139: IS
140: BEGIN
141: Update PV_ATTRIBUTE_USAGES
142: SET
143: attribute_usage_id = DECODE( p_attribute_usage_id, FND_API.g_miss_num, attribute_usage_id, p_attribute_usage_id),
144: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
145: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
146: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
147: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

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

140: BEGIN
141: Update PV_ATTRIBUTE_USAGES
142: SET
143: attribute_usage_id = DECODE( p_attribute_usage_id, FND_API.g_miss_num, attribute_usage_id, p_attribute_usage_id),
144: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
145: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
146: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
147: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
148: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

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

141: Update PV_ATTRIBUTE_USAGES
142: SET
143: attribute_usage_id = DECODE( p_attribute_usage_id, FND_API.g_miss_num, attribute_usage_id, p_attribute_usage_id),
144: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
145: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
146: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
147: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
148: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
149: request_id = DECODE( p_request_id, FND_API.g_miss_num, request_id, p_request_id),

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

142: SET
143: attribute_usage_id = DECODE( p_attribute_usage_id, FND_API.g_miss_num, attribute_usage_id, p_attribute_usage_id),
144: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
145: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
146: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
147: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
148: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
149: request_id = DECODE( p_request_id, FND_API.g_miss_num, request_id, p_request_id),
150: program_application_id = DECODE( p_program_application_id, FND_API.g_miss_num, program_application_id, p_program_application_id),

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

143: attribute_usage_id = DECODE( p_attribute_usage_id, FND_API.g_miss_num, attribute_usage_id, p_attribute_usage_id),
144: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
145: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
146: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
147: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
148: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
149: request_id = DECODE( p_request_id, FND_API.g_miss_num, request_id, p_request_id),
150: program_application_id = DECODE( p_program_application_id, FND_API.g_miss_num, program_application_id, p_program_application_id),
151: program_id = DECODE( p_program_id, FND_API.g_miss_num, program_id, p_program_id),

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

144: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
145: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
146: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
147: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
148: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
149: request_id = DECODE( p_request_id, FND_API.g_miss_num, request_id, p_request_id),
150: program_application_id = DECODE( p_program_application_id, FND_API.g_miss_num, program_application_id, p_program_application_id),
151: program_id = DECODE( p_program_id, FND_API.g_miss_num, program_id, p_program_id),
152: program_update_date = DECODE( p_program_update_date, FND_API.g_miss_date, program_update_date, p_program_update_date),

Line 149: request_id = DECODE( p_request_id, FND_API.g_miss_num, request_id, p_request_id),

145: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
146: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
147: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
148: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
149: request_id = DECODE( p_request_id, FND_API.g_miss_num, request_id, p_request_id),
150: program_application_id = DECODE( p_program_application_id, FND_API.g_miss_num, program_application_id, p_program_application_id),
151: program_id = DECODE( p_program_id, FND_API.g_miss_num, program_id, p_program_id),
152: program_update_date = DECODE( p_program_update_date, FND_API.g_miss_date, program_update_date, p_program_update_date),
153: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),

Line 150: program_application_id = DECODE( p_program_application_id, FND_API.g_miss_num, program_application_id, p_program_application_id),

146: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
147: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
148: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
149: request_id = DECODE( p_request_id, FND_API.g_miss_num, request_id, p_request_id),
150: program_application_id = DECODE( p_program_application_id, FND_API.g_miss_num, program_application_id, p_program_application_id),
151: program_id = DECODE( p_program_id, FND_API.g_miss_num, program_id, p_program_id),
152: program_update_date = DECODE( p_program_update_date, FND_API.g_miss_date, program_update_date, p_program_update_date),
153: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
154: attribute_usage_type = DECODE( p_attribute_usage_type, FND_API.g_miss_char, attribute_usage_type, p_attribute_usage_type),

Line 151: program_id = DECODE( p_program_id, FND_API.g_miss_num, program_id, p_program_id),

147: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
148: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
149: request_id = DECODE( p_request_id, FND_API.g_miss_num, request_id, p_request_id),
150: program_application_id = DECODE( p_program_application_id, FND_API.g_miss_num, program_application_id, p_program_application_id),
151: program_id = DECODE( p_program_id, FND_API.g_miss_num, program_id, p_program_id),
152: program_update_date = DECODE( p_program_update_date, FND_API.g_miss_date, program_update_date, p_program_update_date),
153: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
154: attribute_usage_type = DECODE( p_attribute_usage_type, FND_API.g_miss_char, attribute_usage_type, p_attribute_usage_type),
155: attribute_usage_code = DECODE( p_attribute_usage_code, FND_API.g_miss_char, attribute_usage_code, p_attribute_usage_code),

Line 152: program_update_date = DECODE( p_program_update_date, FND_API.g_miss_date, program_update_date, p_program_update_date),

148: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
149: request_id = DECODE( p_request_id, FND_API.g_miss_num, request_id, p_request_id),
150: program_application_id = DECODE( p_program_application_id, FND_API.g_miss_num, program_application_id, p_program_application_id),
151: program_id = DECODE( p_program_id, FND_API.g_miss_num, program_id, p_program_id),
152: program_update_date = DECODE( p_program_update_date, FND_API.g_miss_date, program_update_date, p_program_update_date),
153: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
154: attribute_usage_type = DECODE( p_attribute_usage_type, FND_API.g_miss_char, attribute_usage_type, p_attribute_usage_type),
155: attribute_usage_code = DECODE( p_attribute_usage_code, FND_API.g_miss_char, attribute_usage_code, p_attribute_usage_code),
156: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),

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

149: request_id = DECODE( p_request_id, FND_API.g_miss_num, request_id, p_request_id),
150: program_application_id = DECODE( p_program_application_id, FND_API.g_miss_num, program_application_id, p_program_application_id),
151: program_id = DECODE( p_program_id, FND_API.g_miss_num, program_id, p_program_id),
152: program_update_date = DECODE( p_program_update_date, FND_API.g_miss_date, program_update_date, p_program_update_date),
153: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
154: attribute_usage_type = DECODE( p_attribute_usage_type, FND_API.g_miss_char, attribute_usage_type, p_attribute_usage_type),
155: attribute_usage_code = DECODE( p_attribute_usage_code, FND_API.g_miss_char, attribute_usage_code, p_attribute_usage_code),
156: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),
157: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)

Line 154: attribute_usage_type = DECODE( p_attribute_usage_type, FND_API.g_miss_char, attribute_usage_type, p_attribute_usage_type),

150: program_application_id = DECODE( p_program_application_id, FND_API.g_miss_num, program_application_id, p_program_application_id),
151: program_id = DECODE( p_program_id, FND_API.g_miss_num, program_id, p_program_id),
152: program_update_date = DECODE( p_program_update_date, FND_API.g_miss_date, program_update_date, p_program_update_date),
153: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
154: attribute_usage_type = DECODE( p_attribute_usage_type, FND_API.g_miss_char, attribute_usage_type, p_attribute_usage_type),
155: attribute_usage_code = DECODE( p_attribute_usage_code, FND_API.g_miss_char, attribute_usage_code, p_attribute_usage_code),
156: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),
157: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)
158: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)

Line 155: attribute_usage_code = DECODE( p_attribute_usage_code, FND_API.g_miss_char, attribute_usage_code, p_attribute_usage_code),

151: program_id = DECODE( p_program_id, FND_API.g_miss_num, program_id, p_program_id),
152: program_update_date = DECODE( p_program_update_date, FND_API.g_miss_date, program_update_date, p_program_update_date),
153: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
154: attribute_usage_type = DECODE( p_attribute_usage_type, FND_API.g_miss_char, attribute_usage_type, p_attribute_usage_type),
155: attribute_usage_code = DECODE( p_attribute_usage_code, FND_API.g_miss_char, attribute_usage_code, p_attribute_usage_code),
156: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),
157: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)
158: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
159: WHERE ATTRIBUTE_USAGE_ID = p_ATTRIBUTE_USAGE_ID

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

152: program_update_date = DECODE( p_program_update_date, FND_API.g_miss_date, program_update_date, p_program_update_date),
153: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
154: attribute_usage_type = DECODE( p_attribute_usage_type, FND_API.g_miss_char, attribute_usage_type, p_attribute_usage_type),
155: attribute_usage_code = DECODE( p_attribute_usage_code, FND_API.g_miss_char, attribute_usage_code, p_attribute_usage_code),
156: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),
157: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)
158: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
159: WHERE ATTRIBUTE_USAGE_ID = p_ATTRIBUTE_USAGE_ID
160: AND object_version_number = p_object_version_number;

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

153: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
154: attribute_usage_type = DECODE( p_attribute_usage_type, FND_API.g_miss_char, attribute_usage_type, p_attribute_usage_type),
155: attribute_usage_code = DECODE( p_attribute_usage_code, FND_API.g_miss_char, attribute_usage_code, p_attribute_usage_code),
156: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),
157: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)
158: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
159: WHERE ATTRIBUTE_USAGE_ID = p_ATTRIBUTE_USAGE_ID
160: AND object_version_number = p_object_version_number;
161:

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

154: attribute_usage_type = DECODE( p_attribute_usage_type, FND_API.g_miss_char, attribute_usage_type, p_attribute_usage_type),
155: attribute_usage_code = DECODE( p_attribute_usage_code, FND_API.g_miss_char, attribute_usage_code, p_attribute_usage_code),
156: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),
157: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)
158: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
159: WHERE ATTRIBUTE_USAGE_ID = p_ATTRIBUTE_USAGE_ID
160: AND object_version_number = p_object_version_number;
161:
162: IF (SQL%NOTFOUND) THEN

Line 163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

159: WHERE ATTRIBUTE_USAGE_ID = p_ATTRIBUTE_USAGE_ID
160: AND object_version_number = p_object_version_number;
161:
162: IF (SQL%NOTFOUND) THEN
163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
164: END IF;
165: END Update_Row;
166:
167:

Line 191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

187: BEGIN
188: DELETE FROM PV_ATTRIBUTE_USAGES
189: WHERE ATTRIBUTE_USAGE_ID = p_ATTRIBUTE_USAGE_ID;
190: If (SQL%NOTFOUND) then
191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
192: End If;
193: END Delete_Row ;
194:
195: