APPS.IGS_PE_SRC_TYPES_PKG dependencies on IGS_PE_SRC_TYPES_ALL

Line 4: old_references igs_pe_src_types_all%RowType;

1: PACKAGE BODY igs_pe_src_types_pkg AS
2: /* $Header: IGSNI65B.pls 120.0 2005/06/01 12:36:23 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_pe_src_types_all%RowType;
5: new_references igs_pe_src_types_all%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_pe_src_types_all%RowType;

1: PACKAGE BODY igs_pe_src_types_pkg AS
2: /* $Header: IGSNI65B.pls 120.0 2005/06/01 12:36:23 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_pe_src_types_all%RowType;
5: new_references igs_pe_src_types_all%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 42: FROM igs_pe_src_types_all

38: ***************************************************************/
39:
40: CURSOR cur_old_ref_values IS
41: SELECT *
42: FROM igs_pe_src_types_all
43: WHERE rowid = x_rowid;
44:
45: BEGIN
46:

Line 139: FROM igs_pe_src_types_all

135: ***************************************************************/
136:
137: CURSOR cur_rowid IS
138: SELECT rowid
139: FROM igs_pe_src_types_all
140: WHERE source_type_id = x_source_type_id
141: FOR UPDATE NOWAIT;
142:
143: lv_rowid cur_rowid%RowType;

Line 273: FROM igs_pe_src_types_all

269: (reverse chronological order - newest change first)
270: ***************************************************************/
271: CURSOR cur_rowid IS
272: SELECT rowid
273: FROM igs_pe_src_types_all
274: WHERE source_type = x_source_type
275: and ((l_rowid is null) or (rowid <> l_rowid));
276:
277: lv_rowid cur_rowid%RowType;

Line 592: from igs_pe_src_types_all

588: pbondugu 26-Feb-2003 admission_Cat is assigned with Null
589: ***************************************************************/
590: cursor C is
591: select ROWID
592: from igs_pe_src_types_all
593: where SOURCE_TYPE_ID= X_SOURCE_TYPE_ID;
594:
595: X_LAST_UPDATE_DATE DATE ;
596: X_LAST_UPDATED_BY NUMBER ;

Line 644: INSERT INTO igs_pe_src_types_all (

640: x_org_id=>igs_ge_gen_003.get_org_id,
641: x_inquiry_type_id => X_INQUIRY_TYPE_ID
642: );
643:
644: INSERT INTO igs_pe_src_types_all (
645: SOURCE_TYPE_ID
646: ,SOURCE_TYPE
647: ,DESCRIPTION
648: ,SYSTEM_SOURCE_TYPE

Line 731: FROM igs_pe_src_types_all

727: ,ENQUIRY_SOURCE_TYPE
728: ,FUNNEL_STATUS
729: ,INQ_ENTRY_STAT_ID
730: ,INQUIRY_TYPE_ID
731: FROM igs_pe_src_types_all
732: WHERE ROWID = X_ROWID
733: for update nowait;
734:
735: tlinfo c1%rowtype;

Line 849: UPDATE igs_pe_src_types_all SET

845: x_last_update_login=>X_LAST_UPDATE_LOGIN,
846: x_inquiry_type_id => X_INQUIRY_TYPE_ID
847: );
848:
849: UPDATE igs_pe_src_types_all SET
850: SOURCE_TYPE = NEW_REFERENCES.SOURCE_TYPE,
851: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
852: SYSTEM_SOURCE_TYPE = NEW_REFERENCES.SYSTEM_SOURCE_TYPE,
853: ADMISSION_CAT = NULL, --NEW_REFERENCES.ADMISSION_CAT,

Line 904: FROM igs_pe_src_types_all

900: (reverse chronological order - newest change first)
901: ***************************************************************/
902: CURSOR c1 is
903: SELECT ROWID
904: FROM igs_pe_src_types_all
905: WHERE SOURCE_TYPE_ID= X_SOURCE_TYPE_ID;
906:
907: begin
908: open c1;

Line 969: delete from igs_pe_src_types_all

965: p_action => 'DELETE',
966: x_rowid => X_ROWID
967: );
968:
969: delete from igs_pe_src_types_all
970: where ROWID = X_ROWID;
971: if (sql%notfound) then
972: raise no_data_found;
973: end if;