[Home] [Help]
1: PACKAGE BODY GR_PHRASE_CONFLICTS_PKG AS
2: /*$Header: GRHIPCB.pls 115.4 2002/10/28 20:03:16 methomas ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,
69: IF FND_API.To_Boolean(l_key_exists) THEN
70: RAISE Label_Exists_Error;
71: END IF;
72:
73: INSERT INTO gr_phrase_conflicts
74: (phrase_code,
75: phrase_code_also_involved,
76: phrase_code_solution,
77: created_by,
227:
228: IF l_return_status <> 'S' THEN
229: RAISE Foreign_Key_Error;
230: ELSE
231: UPDATE gr_phrase_conflicts
232: SET phrase_code = p_phrase_code,
233: phrase_code_also_involved = p_phrase_code_also_involved,
234: phrase_code_solution = p_phrase_code_solution,
235: created_by = p_created_by,
335:
336: CURSOR c_lock_conflicts
337: IS
338: SELECT *
339: FROM gr_phrase_conflicts
340: WHERE rowid = p_rowid
341: FOR UPDATE NOWAIT;
342: LockConflictRcd c_lock_conflicts%ROWTYPE;
343:
467: IF l_return_status <> 'S' THEN
468: RAISE Check_Integrity_Error;
469: END IF;
470:
471: DELETE FROM gr_phrase_conflicts
472: WHERE rowid = p_rowid;
473:
474: /* Check the commit flag and if set, then commit the work. */
475:
553: x_oracle_error := 0;
554: x_msg_data := NULL;
555: l_msg_token := p_phrase_code;
556:
557: DELETE FROM gr_phrase_conflicts
558: WHERE phrase_code = p_phrase_code;
559:
560: IF FND_API.To_Boolean(p_commit) THEN
561: COMMIT WORK;
774:
775: CURSOR c_get_conflict_rowid
776: IS
777: SELECT pc.rowid
778: FROM gr_phrase_conflicts pc
779: WHERE pc.phrase_code = p_phrase_code
780: AND pc.phrase_code_also_involved = p_phrase_code_also_involved;
781: ConflictRecord c_get_conflict_rowid%ROWTYPE;
782:
808: END IF;
809:
810: END Check_Primary_Key;
811:
812: END GR_PHRASE_CONFLICTS_PKG;