APPS.IGS_TR_TYPE_STEP_PKG dependencies on IGS_TR_TYPE_STEP_ALL

Line 5: old_references igs_tr_type_step_all%ROWTYPE;

1: PACKAGE BODY igs_tr_type_step_pkg AS
2: /* $Header: IGSTI06B.pls 115.14 2003/02/19 12:31:44 kpadiyar ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_tr_type_step_all%ROWTYPE;
6: new_references igs_tr_type_step_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_tr_type_step_all%ROWTYPE;

2: /* $Header: IGSTI06B.pls 115.14 2003/02/19 12:31:44 kpadiyar ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_tr_type_step_all%ROWTYPE;
6: new_references igs_tr_type_step_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 31: FROM igs_tr_type_step_all

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

Line 209: FROM igs_tr_type_step_all

205: ) RETURN BOOLEAN AS
206:
207: CURSOR cur_rowid IS
208: SELECT ROWID
209: FROM igs_tr_type_step_all
210: WHERE tracking_type = x_tracking_type
211: AND tracking_type_step_id = x_tracking_type_step_id
212: FOR UPDATE NOWAIT;
213:

Line 236: FROM igs_tr_type_step_all

232: ) AS
233:
234: CURSOR cur_rowid IS
235: SELECT ROWID
236: FROM igs_tr_type_step_all
237: WHERE recipient_id = x_person_id ;
238:
239: lv_rowid cur_rowid%ROWTYPE;
240:

Line 262: FROM igs_tr_type_step_all

258: ) AS
259:
260: CURSOR cur_rowid IS
261: SELECT ROWID
262: FROM igs_tr_type_step_all
263: WHERE s_tracking_step_type = x_s_tracking_step_type ;
264:
265: lv_rowid cur_rowid%ROWTYPE;
266:

Line 476: FROM igs_tr_type_step_all

472: ) AS
473:
474: CURSOR c IS
475: SELECT ROWID
476: FROM igs_tr_type_step_all
477: WHERE tracking_type = x_tracking_type
478: AND tracking_type_step_id = x_tracking_type_step_id;
479:
480: x_last_update_date DATE;

Line 527: INSERT INTO igs_tr_type_step_all (

523: x_last_update_login =>x_last_update_login,
524: x_org_id => igs_ge_gen_003.get_org_id
525: );
526:
527: INSERT INTO igs_tr_type_step_all (
528: tracking_type,
529: tracking_type_step_id,
530: tracking_type_step_number,
531: description,

Line 595: FROM igs_tr_type_step_all

591:
592: CURSOR c1 IS
593: SELECT tracking_type_step_number, description, s_tracking_step_type, action_days,
594: recipient_id, step_group_id, publish_ind, step_catalog_cd
595: FROM igs_tr_type_step_all
596: WHERE ROWID = x_rowid
597: FOR UPDATE NOWAIT;
598:
599: tlinfo c1%ROWTYPE;

Line 706: UPDATE igs_tr_type_step_all SET

702: x_last_updated_by =>x_last_updated_by,
703: x_last_update_login =>x_last_update_login
704: );
705:
706: UPDATE igs_tr_type_step_all SET
707: tracking_type_step_number = new_references.tracking_type_step_number,
708: description = new_references.description,
709: s_tracking_step_type = new_references.s_tracking_step_type,
710: action_days = new_references.action_days,

Line 749: FROM igs_tr_type_step_all

745: ) AS
746:
747: CURSOR c1 IS
748: SELECT ROWID
749: FROM igs_tr_type_step_all
750: WHERE tracking_type = x_tracking_type
751: AND tracking_type_step_id = x_tracking_type_step_id;
752:
753: BEGIN

Line 803: DELETE FROM igs_tr_type_step_all WHERE ROWID = x_rowid;

799: before_dml(p_action =>'DELETE',
800: x_rowid =>x_rowid
801: );
802:
803: DELETE FROM igs_tr_type_step_all WHERE ROWID = x_rowid;
804: IF (SQL%NOTFOUND) THEN
805: RAISE no_data_found;
806: END IF;
807: