[Home] [Help]
219: p_operation_code => 'UPDATE',
220: p_db_object_name => 'HZ_RELATIONSHIPS',
221: p_instance_pk1_value => l_relationship_id(i),
222: p_instance_pk2_value => 'F',
223: p_user_name => fnd_global.user_name,
224: x_return_status => dss_return_status,
225: x_msg_count => dss_msg_count,
226: x_msg_data => dss_msg_data);
227:
336: nvl2(l_object_id(j), 'Y', null), --HZ_IMP_REL_SUBJ_OBJ_ERROR,SUB_OR_OBJ,OBJECT
337: decode(l_subject_id(j), null, 'Y',
338: decode(l_object_id(j), null, 'Y', nvl2(l_relationship_type(j), 'Y', null))), --HZ_IMP_REL_TYPE_ERROR
339: decode(l_flex_val_errors(j), 1, null, 'Y'), --AR_RAPI_DESC_FLEX_INVALID,DFF_NAME,HZ_RELATIONSHIPS
340: decode(l_dss_security_errors(j), FND_API.G_TRUE,'Y',null), --HZ_DSS_SECURITY_FAIL,USER_NAME,FND_GLOBAL.user_name,OPER_NAME,UPDATE,OBJECT_NAME,HZ_RELATIONSHIPS
341: 'Y',
342: nvl2(l_action_mismatch_errors(j), 'Y', null), --HZ_IMP_ACTION_MISMATCH
343: l_exception_exists(j)
344: from dual
1105: and party_rel_type_l.lookup_type (+) = ''PARTY_RELATIONS_TYPE''
1106: and party_rel_type_l.language (+) = userenv(''LANG'')
1107: and party_rel_type_l.view_application_id (+) = 222
1108: and party_rel_type_l.security_group_id (+) =
1109: fnd_global.lookup_security_group(''PARTY_RELATIONS_TYPE'', 222)
1110: and createdby_l.lookup_code (+) = rs.created_by_module
1111: and createdby_l.lookup_type (+) = ''HZ_CREATED_BY_MODULES''
1112: and createdby_l.language (+) = userenv(''LANG'')
1113: and createdby_l.view_application_id (+) = 222
1111: and createdby_l.lookup_type (+) = ''HZ_CREATED_BY_MODULES''
1112: and createdby_l.language (+) = userenv(''LANG'')
1113: and createdby_l.view_application_id (+) = 222
1114: and createdby_l.security_group_id (+) =
1115: fnd_global.lookup_security_group(''HZ_CREATED_BY_MODULES'', 222)
1116: and rs.relationship_type = rt.relationship_type (+)
1117: and rs.relationship_code = rt.forward_rel_code (+)
1118: and rs.sp_type = rt.subject_type (+)
1119: and rs.op_type = rt.object_type (+)';