59: p_Cause_Short_Name,
60: p_Effect_Short_Name,
61: p_Cause_Sequence,
62: p_Effect_Sequence,
63: FND_GLOBAL.USER_ID,
64: SYSDATE,
65: FND_GLOBAL.USER_ID,
66: SYSDATE,
67: FND_GLOBAL.LOGIN_ID
61: p_Cause_Sequence,
62: p_Effect_Sequence,
63: FND_GLOBAL.USER_ID,
64: SYSDATE,
65: FND_GLOBAL.USER_ID,
66: SYSDATE,
67: FND_GLOBAL.LOGIN_ID
68: );
69:
63: FND_GLOBAL.USER_ID,
64: SYSDATE,
65: FND_GLOBAL.USER_ID,
66: SYSDATE,
67: FND_GLOBAL.LOGIN_ID
68: );
69:
70: IF (p_commit = FND_API.G_TRUE) THEN
71: COMMIT;
136: UPDATE bis_custom_cause_effect_rels
137: SET
138: cause_sequence = p_Cause_Sequence
139: , effect_sequence = p_Effect_Sequence
140: , last_updated_by = FND_GLOBAL.USER_ID
141: , last_update_date = SYSDATE
142: , last_update_login = FND_GLOBAL.LOGIN_ID
143: WHERE
144: cause_short_name = p_Cause_Short_Name AND
138: cause_sequence = p_Cause_Sequence
139: , effect_sequence = p_Effect_Sequence
140: , last_updated_by = FND_GLOBAL.USER_ID
141: , last_update_date = SYSDATE
142: , last_update_login = FND_GLOBAL.LOGIN_ID
143: WHERE
144: cause_short_name = p_Cause_Short_Name AND
145: effect_short_name = p_Effect_Short_Name;
146: END IF;