APPS.IGS_PE_HLTH_INS_PKG dependencies on IGS_PE_HLTH_INS_ALL

Line 5: old_references IGS_PE_HLTH_INS_ALL%RowType;

1: PACKAGE BODY igs_pe_hlth_ins_pkg AS
2: /* $Header: IGSNI57B.pls 120.3 2005/10/17 02:21:48 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PE_HLTH_INS_ALL%RowType;
6: new_references IGS_PE_HLTH_INS_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PE_HLTH_INS_ALL%RowType;

2: /* $Header: IGSNI57B.pls 120.3 2005/10/17 02:21:48 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PE_HLTH_INS_ALL%RowType;
6: new_references IGS_PE_HLTH_INS_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 64: FROM IGS_PE_HLTH_INS_ALL

60: ****************************************************************/
61:
62: CURSOR cur_old_ref_values IS
63: SELECT *
64: FROM IGS_PE_HLTH_INS_ALL
65: WHERE rowid = x_rowid;
66:
67: BEGIN
68:

Line 293: FROM IGS_PE_HLTH_INS_ALL

289: ****************************************************************/
290:
291: CURSOR cur_rowid IS
292: SELECT rowid
293: FROM IGS_PE_HLTH_INS_ALL
294: WHERE health_ins_id = x_health_ins_id
295: FOR UPDATE NOWAIT;
296:
297: lv_rowid cur_rowid%RowType;

Line 334: FROM IGS_PE_HLTH_INS_ALL

330:
331: ****************************************************************/
332: CURSOR cur_rowid IS
333: SELECT rowid
334: FROM IGS_PE_HLTH_INS_ALL
335: WHERE insurance_cd = x_insurance_cd
336: AND start_date = x_start_date and person_id = x_person_id and ((l_rowid is null) or (rowid <> l_rowid))
337:
338: ;

Line 377: FROM IGS_PE_HLTH_INS_ALL

373: ****************************************************************/
374:
375: CURSOR cur_rowid IS
376: SELECT rowid
377: FROM IGS_PE_HLTH_INS_ALL
378: WHERE person_id = x_person_id ;
379:
380: lv_rowid cur_rowid%RowType;
381:

Line 418: FROM IGS_PE_HLTH_INS_ALL

414:
415:
416: CURSOR cur_rowid IS
417: SELECT rowid
418: FROM IGS_PE_HLTH_INS_ALL
419: WHERE insurance_id = x_code_classes_id ;
420:
421: lv_rowid cur_rowid%RowType;
422:

Line 658: cursor C is select ROWID from IGS_PE_HLTH_INS_ALL

654:
655: Who When What
656:
657: ****************************************************************/
658: cursor C is select ROWID from IGS_PE_HLTH_INS_ALL
659: where HEALTH_INS_ID= X_HEALTH_INS_ID
660: ;
661: X_LAST_UPDATE_DATE DATE ;
662: X_LAST_UPDATED_BY NUMBER ;

Line 726: insert into IGS_PE_HLTH_INS_ALL (

722: x_insurance_cd => X_INSURANCE_CD);
723: IF (x_mode = 'S') THEN
724: igs_sc_gen_001.set_ctx('R');
725: END IF;
726: insert into IGS_PE_HLTH_INS_ALL (
727: HEALTH_INS_ID
728: ,PERSON_ID
729: ,INSURANCE_PROVIDER
730: ,POLICY_NUMBER

Line 900: from IGS_PE_HLTH_INS_ALL

896: , ATTRIBUTE18
897: , ATTRIBUTE19
898: , ATTRIBUTE20
899: , INSURANCE_CD
900: from IGS_PE_HLTH_INS_ALL
901: where ROWID = X_ROWID
902: for update nowait;
903: tlinfo c1%rowtype;
904: begin

Line 1106: update IGS_PE_HLTH_INS_ALL set

1102: x_insurance_cd=>X_INSURANCE_CD );
1103: IF (x_mode = 'S') THEN
1104: igs_sc_gen_001.set_ctx('R');
1105: END IF;
1106: update IGS_PE_HLTH_INS_ALL set
1107: PERSON_ID = NEW_REFERENCES.PERSON_ID,
1108: INSURANCE_PROVIDER = NEW_REFERENCES.INSURANCE_PROVIDER,
1109: POLICY_NUMBER = NEW_REFERENCES.POLICY_NUMBER,
1110: START_DATE = NEW_REFERENCES.START_DATE,

Line 1216: cursor c1 is select ROWID from IGS_PE_HLTH_INS_ALL

1212:
1213: Who When What
1214:
1215: ****************************************************************/
1216: cursor c1 is select ROWID from IGS_PE_HLTH_INS_ALL
1217: where HEALTH_INS_ID= X_HEALTH_INS_ID
1218: ;
1219: begin
1220: open c1;

Line 1319: delete from IGS_PE_HLTH_INS_ALL

1315: );
1316: IF (x_mode = 'S') THEN
1317: igs_sc_gen_001.set_ctx('R');
1318: END IF;
1319: delete from IGS_PE_HLTH_INS_ALL
1320: where ROWID = X_ROWID;
1321: if (sql%notfound) then
1322: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1323: igs_ge_msg_stack.add;