APPS.IGS_ST_CITIZENSHP_CD_PKG dependencies on IGS_ST_CITIZENSHP_CD

Line 1: package body IGS_ST_CITIZENSHP_CD_PKG as

1: package body IGS_ST_CITIZENSHP_CD_PKG as
2: /* $Header: IGSVI01B.pls 115.7 2002/12/24 05:45:22 npalanis ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_ST_CITIZENSHP_CD%RowType;

Line 5: old_references IGS_ST_CITIZENSHP_CD%RowType;

1: package body IGS_ST_CITIZENSHP_CD_PKG as
2: /* $Header: IGSVI01B.pls 115.7 2002/12/24 05:45:22 npalanis ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_ST_CITIZENSHP_CD%RowType;
6: new_references IGS_ST_CITIZENSHP_CD%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_ST_CITIZENSHP_CD%RowType;

2: /* $Header: IGSVI01B.pls 115.7 2002/12/24 05:45:22 npalanis ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_ST_CITIZENSHP_CD%RowType;
6: new_references IGS_ST_CITIZENSHP_CD%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 25: FROM IGS_ST_CITIZENSHP_CD

21: ) as
22:
23: CURSOR cur_old_ref_values IS
24: SELECT *
25: FROM IGS_ST_CITIZENSHP_CD
26: WHERE rowid = x_rowid;
27:
28: BEGIN
29:

Line 164: FROM IGS_ST_CITIZENSHP_CD

160: as
161:
162: CURSOR cur_rowid IS
163: SELECT rowid
164: FROM IGS_ST_CITIZENSHP_CD
165: WHERE citizenship_cd = x_citizenship_cd
166: FOR UPDATE NOWAIT;
167:
168: lv_rowid cur_rowid%RowType;

Line 190: FROM IGS_ST_CITIZENSHP_CD

186: ) as
187:
188: CURSOR cur_rowid IS
189: SELECT rowid
190: FROM IGS_ST_CITIZENSHP_CD
191: WHERE govt_citizenship_cd = x_govt_citizenship_cd ;
192:
193: lv_rowid cur_rowid%RowType;
194:

Line 302: cursor C is select ROWID from IGS_ST_CITIZENSHP_CD

298: X_CLOSED_IND in VARCHAR2,
299: X_NOTES in VARCHAR2,
300: X_MODE in VARCHAR2 default 'R'
301: ) as
302: cursor C is select ROWID from IGS_ST_CITIZENSHP_CD
303: where CITIZENSHIP_CD = X_CITIZENSHIP_CD;
304: X_LAST_UPDATE_DATE DATE;
305: X_LAST_UPDATED_BY NUMBER;
306: X_LAST_UPDATE_LOGIN NUMBER;

Line 342: insert into IGS_ST_CITIZENSHP_CD (

338: x_last_updated_by=>X_LAST_UPDATED_BY ,
339: x_last_update_login=> X_LAST_UPDATE_LOGIN
340: );
341:
342: insert into IGS_ST_CITIZENSHP_CD (
343: CITIZENSHIP_CD,
344: GOVT_CITIZENSHIP_CD,
345: DESCRIPTION,
346: CLOSED_IND,

Line 393: from IGS_ST_CITIZENSHP_CD

389: GOVT_CITIZENSHIP_CD,
390: DESCRIPTION,
391: CLOSED_IND,
392: NOTES
393: from IGS_ST_CITIZENSHP_CD
394: where ROWID = X_ROWID for update nowait;
395: tlinfo c1%rowtype;
396:
397: begin

Line 472: update IGS_ST_CITIZENSHP_CD set

468: x_last_updated_by=>X_LAST_UPDATED_BY ,
469: x_last_update_login=> X_LAST_UPDATE_LOGIN
470: );
471:
472: update IGS_ST_CITIZENSHP_CD set
473: GOVT_CITIZENSHIP_CD = NEW_REFERENCES.GOVT_CITIZENSHIP_CD,
474: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
475: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
476: NOTES = NEW_REFERENCES.NOTES,

Line 502: cursor c1 is select rowid from IGS_ST_CITIZENSHP_CD

498: X_CLOSED_IND in VARCHAR2,
499: X_NOTES in VARCHAR2,
500: X_MODE in VARCHAR2 default 'R'
501: ) as
502: cursor c1 is select rowid from IGS_ST_CITIZENSHP_CD
503: where CITIZENSHIP_CD = X_CITIZENSHIP_CD
504: ;
505:
506: begin

Line 542: delete from IGS_ST_CITIZENSHP_CD

538: p_action=>'DELETE',
539: x_rowid=> X_ROWID
540: );
541:
542: delete from IGS_ST_CITIZENSHP_CD
543: where ROWID = X_ROWID;
544: if (sql%notfound) then
545: raise no_data_found;
546: end if;

Line 556: end IGS_ST_CITIZENSHP_CD_PKG;

552:
553:
554: end DELETE_ROW;
555:
556: end IGS_ST_CITIZENSHP_CD_PKG;