APPS.IGI_EXP_POS_ACTIONS_PKG dependencies on IGI_EXP_POS_ACTIONS_ALL

Line 5: old_references igi_exp_pos_actions_all%ROWTYPE;

1: PACKAGE BODY igi_exp_pos_actions_pkg AS
2: /* $Header: igiexdb.pls 120.4.12000000.1 2007/09/13 04:24:12 mbremkum ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igi_exp_pos_actions_all%ROWTYPE;
6: new_references igi_exp_pos_actions_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igi_exp_pos_actions_all%ROWTYPE;

2: /* $Header: igiexdb.pls 120.4.12000000.1 2007/09/13 04:24:12 mbremkum ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igi_exp_pos_actions_all%ROWTYPE;
6: new_references igi_exp_pos_actions_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 37: FROM IGI_EXP_POS_ACTIONS_ALL

33: */
34:
35: CURSOR cur_old_ref_values IS
36: SELECT *
37: FROM IGI_EXP_POS_ACTIONS_ALL
38: WHERE rowid = x_rowid;
39:
40: BEGIN
41:

Line 121: FROM igi_exp_pos_actions_all

117: */
118: CURSOR cur_rowid IS
119: SELECT rowid
120:
121: FROM igi_exp_pos_actions_all
122: WHERE pos_action_id = x_pos_action_id
123: FOR UPDATE NOWAIT;
124:
125: lv_rowid cur_rowid%RowType;

Line 157: FROM igi_exp_pos_actions_all

153: || (reverse chronological order - newest change first)
154: */
155: CURSOR cur_rowid IS
156: SELECT rowid
157: FROM igi_exp_pos_actions_all
158: WHERE position_id = x_position_id
159: AND org_id = new_references.org_id
160: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
161:

Line 284: FROM igi_exp_pos_actions_all

280: || (reverse chronological order - newest change first)
281: */
282: CURSOR c IS
283: SELECT rowid
284: FROM igi_exp_pos_actions_all
285: WHERE pos_action_id = x_pos_action_id;
286:
287: x_last_update_date DATE;
288: x_last_updated_by NUMBER;

Line 336: INSERT INTO igi_exp_pos_actions_all (

332: x_last_updated_by => x_last_updated_by,
333: x_last_update_login => x_last_update_login
334: );
335:
336: INSERT INTO igi_exp_pos_actions_all (
337:
338: pos_action_id,
339: position_id,
340: approve,

Line 405: FROM igi_exp_pos_actions_all

401: reject,
402: hold,
403: return,
404: org_id
405: FROM igi_exp_pos_actions_all
406: WHERE rowid = x_rowid
407: FOR UPDATE NOWAIT;
408:
409:

Line 511: UPDATE igi_exp_pos_actions_all

507: x_last_updated_by => x_last_updated_by,
508: x_last_update_login => x_last_update_login
509: );
510:
511: UPDATE igi_exp_pos_actions_all
512: SET
513: position_id = new_references.position_id,
514: approve = new_references.approve,
515: reject = new_references.reject,

Line 557: FROM igi_exp_pos_actions_all

553:
554: */
555: CURSOR c1 IS
556: SELECT rowid
557: FROM igi_exp_pos_actions_all
558: WHERE pos_action_id = x_pos_action_id;
559:
560: BEGIN
561:

Line 618: DELETE FROM igi_exp_pos_actions_all

614: p_action => 'DELETE',
615: x_rowid => x_rowid
616: );
617:
618: DELETE FROM igi_exp_pos_actions_all
619: WHERE rowid = x_rowid;
620:
621: IF (SQL%NOTFOUND) THEN
622: RAISE NO_DATA_FOUND;