APPS.IGS_TR_STEP_PKG dependencies on IGS_TR_STEP

Line 1: PACKAGE BODY igs_tr_step_pkg AS

1: PACKAGE BODY igs_tr_step_pkg AS
2: /* $Header: IGSTI03B.pls 115.10 2003/02/19 12:44:07 kpadiyar ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_tr_step%ROWTYPE;
5: new_references igs_tr_step%ROWTYPE;

Line 4: old_references igs_tr_step%ROWTYPE;

1: PACKAGE BODY igs_tr_step_pkg AS
2: /* $Header: IGSTI03B.pls 115.10 2003/02/19 12:44:07 kpadiyar ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_tr_step%ROWTYPE;
5: new_references igs_tr_step%ROWTYPE;
6:
7: PROCEDURE set_column_values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_tr_step%ROWTYPE;

1: PACKAGE BODY igs_tr_step_pkg AS
2: /* $Header: IGSTI03B.pls 115.10 2003/02/19 12:44:07 kpadiyar ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_tr_step%ROWTYPE;
5: new_references igs_tr_step%ROWTYPE;
6:
7: PROCEDURE set_column_values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 32: FROM igs_tr_step

28: ) AS
29:
30: CURSOR cur_old_ref_values IS
31: SELECT *
32: FROM igs_tr_step
33: WHERE ROWID = x_rowid;
34:
35: BEGIN
36:

Line 105: v_tracking_id igs_tr_step.tracking_id%TYPE;

101: p_deleting IN BOOLEAN DEFAULT FALSE
102: ) AS
103:
104: v_message_name VARCHAR2(30);
105: v_tracking_id igs_tr_step.tracking_id%TYPE;
106: v_tracking_type igs_tr_item.tracking_type%TYPE;
107:
108: CURSOR c_tri (cp_tracking_id igs_tr_item.tracking_id%TYPE) IS
109: SELECT tracking_type

Line 198: IF NOT igs_tr_step_ctlg_pkg.get_uk_for_validation ( new_references.step_catalog_cd )THEN

194:
195: IF (((old_references.step_catalog_cd = new_references.step_catalog_cd)) OR ((new_references.step_catalog_cd IS NULL))) THEN
196: NULL;
197: ELSE
198: IF NOT igs_tr_step_ctlg_pkg.get_uk_for_validation ( new_references.step_catalog_cd )THEN
199: fnd_message.set_name('FND','FORM_RECORD_DELETED');
200: igs_ge_msg_stack.add;
201: app_exception.raise_exception;
202: END IF;

Line 209: igs_tr_step_note_pkg.get_fk_igs_tr_step (

205:
206: PROCEDURE check_child_existance AS
207: BEGIN
208:
209: igs_tr_step_note_pkg.get_fk_igs_tr_step (
210: old_references.tracking_id,
211: old_references.tracking_step_id
212: );
213:

Line 223: FROM igs_tr_step

219: RETURN BOOLEAN AS
220:
221: CURSOR cur_rowid IS
222: SELECT ROWID
223: FROM igs_tr_step
224: WHERE tracking_id = x_tracking_id
225: AND tracking_step_id = x_tracking_step_id
226: FOR UPDATE NOWAIT;
227:

Line 250: FROM igs_tr_step

246: ) AS
247:
248: CURSOR cur_rowid IS
249: SELECT ROWID
250: FROM igs_tr_step
251: WHERE recipient_id = x_person_id ;
252:
253: lv_rowid cur_rowid%ROWTYPE;
254:

Line 276: FROM igs_tr_step

272: ) AS
273:
274: CURSOR cur_rowid IS
275: SELECT ROWID
276: FROM igs_tr_step
277: WHERE tracking_id = x_tracking_id ;
278:
279: lv_rowid cur_rowid%ROWTYPE;
280:

Line 303: FROM igs_tr_step

299: ) AS
300:
301: CURSOR cur_rowid IS
302: SELECT ROWID
303: FROM igs_tr_step
304: WHERE s_tracking_step_type = x_s_tracking_step_type ;
305:
306: lv_rowid cur_rowid%ROWTYPE;
307:

Line 543: FROM igs_tr_step

539: ) AS
540:
541: CURSOR c IS
542: SELECT ROWID
543: FROM igs_tr_step
544: WHERE tracking_id = x_tracking_id AND tracking_step_id = x_tracking_step_id;
545:
546: x_last_update_date DATE;
547: x_last_updated_by NUMBER;

Line 613: INSERT INTO igs_tr_step (

609: x_last_updated_by =>x_last_updated_by,
610: x_last_update_login =>x_last_update_login
611: );
612:
613: INSERT INTO igs_tr_step (
614: tracking_id,
615: tracking_step_id,
616: tracking_step_number,
617: description,

Line 693: FROM igs_tr_step

689: SELECT tracking_step_number, description,
690: s_tracking_step_type, completion_dt,
691: action_days, step_completion_ind,by_pass_ind, recipient_id,
692: step_group_id, publish_ind, step_catalog_cd
693: FROM igs_tr_step
694: WHERE ROWID = x_rowid
695: FOR UPDATE NOWAIT;
696: tlinfo c1%ROWTYPE;
697:

Line 829: UPDATE igs_tr_step SET

825: END IF;
826:
827: END IF;
828:
829: UPDATE igs_tr_step SET
830: tracking_step_number = new_references.tracking_step_number,
831: description = new_references.description,
832: s_tracking_step_type = new_references.s_tracking_step_type,
833: completion_dt = new_references.completion_dt,

Line 875: FROM igs_tr_step

871: x_mode IN VARCHAR2 DEFAULT 'R'
872: ) AS
873: CURSOR c1 IS
874: SELECT ROWID
875: FROM igs_tr_step
876: WHERE tracking_id = x_tracking_id
877: AND tracking_step_id = x_tracking_step_id;
878:
879: BEGIN

Line 935: DELETE FROM igs_tr_step

931: before_dml(p_action =>'DELETE',
932: x_rowid =>x_rowid
933: );
934:
935: DELETE FROM igs_tr_step
936: WHERE ROWID = x_rowid;
937: IF (SQL%NOTFOUND) THEN
938: RAISE no_data_found;
939: END IF;

Line 943: END igs_tr_step_pkg;

939: END IF;
940:
941: END delete_row;
942:
943: END igs_tr_step_pkg;