APPS.IGS_TR_TYPE_PKG dependencies on IGS_TR_TYPE_ALL

Line 5: old_references igs_tr_type_all%ROWTYPE;

1: PACKAGE BODY igs_tr_type_pkg AS
2: /* $Header: IGSTI05B.pls 115.10 2003/02/19 10:29:45 kpadiyar ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_tr_type_all%ROWTYPE;
6: new_references igs_tr_type_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_tr_type_all%ROWTYPE;

2: /* $Header: IGSTI05B.pls 115.10 2003/02/19 10:29:45 kpadiyar ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_tr_type_all%ROWTYPE;
6: new_references igs_tr_type_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 29: FROM igs_tr_type_all

25: ) AS
26:
27: CURSOR cur_old_ref_values IS
28: SELECT *
29: FROM igs_tr_type_all
30: WHERE ROWID = x_rowid;
31:
32: BEGIN
33:

Line 97: FROM igs_tr_type_all

93: ) RETURN BOOLEAN AS
94:
95: CURSOR cur_rowid IS
96: SELECT ROWID
97: FROM igs_tr_type_all
98: WHERE tracking_type = x_tracking_type;
99:
100: lv_rowid cur_rowid%ROWTYPE;
101:

Line 122: FROM igs_tr_type_all

118: ) AS
119:
120: CURSOR cur_rowid IS
121: SELECT ROWID
122: FROM igs_tr_type_all
123: WHERE s_tracking_type = x_s_tracking_type ;
124:
125: lv_rowid cur_rowid%ROWTYPE;
126:

Line 357: FROM igs_tr_type_all

353: ) AS
354:
355: CURSOR c IS
356: SELECT ROWID
357: FROM igs_tr_type_all
358: WHERE tracking_type = x_tracking_type;
359:
360: x_last_update_date DATE;
361: x_last_updated_by NUMBER;

Line 408: INSERT INTO igs_tr_type_all (

404: x_last_update_login =>x_last_update_login,
405: x_org_id => igs_ge_gen_003.get_org_id
406: );
407:
408: INSERT INTO igs_tr_type_all (
409: tracking_type,
410: description,
411: s_tracking_type,
412: target_days,

Line 470: FROM igs_tr_type_all

466:
467: CURSOR c1 IS
468: SELECT description,s_tracking_type,target_days,sequence_ind,business_days_ind,
469: closed_ind, publish_ind
470: FROM igs_tr_type_all
471: WHERE ROWID = x_rowid
472: FOR UPDATE NOWAIT;
473: tlinfo c1%ROWTYPE;
474:

Line 561: UPDATE igs_tr_type_all SET

557: x_last_updated_by =>x_last_updated_by,
558: x_last_update_login =>x_last_update_login
559: );
560:
561: UPDATE igs_tr_type_all SET
562: description = new_references.description,
563: s_tracking_type = new_references.s_tracking_type,
564: target_days = new_references.target_days,
565: sequence_ind = new_references.sequence_ind,

Line 601: FROM igs_tr_type_all

597: ) AS
598:
599: CURSOR c1 IS
600: SELECT ROWID
601: FROM igs_tr_type_all
602: WHERE tracking_type = x_tracking_type;
603:
604: BEGIN
605: