APPS.IGS_PE_MIL_SERVICES_PKG dependencies on IGS_PE_MIL_SERVICES_ALL

Line 5: old_references IGS_PE_MIL_SERVICES_ALL%RowType;

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

Line 6: new_references IGS_PE_MIL_SERVICES_ALL%RowType;

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

Line 65: FROM IGS_PE_MIL_SERVICES_ALL

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

Line 212: FROM IGS_PE_MIL_SERVICES_ALL

208: )RETURN BOOLEAN AS
209:
210: CURSOR cur_rowid IS
211: SELECT rowid
212: FROM IGS_PE_MIL_SERVICES_ALL
213: WHERE military_type_cd = x_military_type_cd
214: AND person_id = x_person_id
215: AND start_date = x_start_date
216: AND ((l_rowid IS NULL) OR (rowid <> l_rowid))

Line 347: FROM IGS_PE_MIL_SERVICES_ALL

343: ****************************************************************/
344:
345: CURSOR cur_rowid IS
346: SELECT rowid
347: FROM IGS_PE_MIL_SERVICES_ALL
348: WHERE milit_service_id = x_milit_service_id
349: FOR UPDATE NOWAIT;
350:
351: lv_rowid cur_rowid%RowType;

Line 387: FROM IGS_PE_MIL_SERVICES_ALL

383: ****************************************************************/
384:
385: CURSOR cur_rowid IS
386: SELECT rowid
387: FROM IGS_PE_MIL_SERVICES_ALL
388: WHERE person_id = x_person_id ;
389:
390: lv_rowid cur_rowid%RowType;
391:

Line 631: cursor C is select ROWID from IGS_PE_MIL_SERVICES_ALL

627:
628: Who When What
629:
630: ****************************************************************/
631: cursor C is select ROWID from IGS_PE_MIL_SERVICES_ALL
632: where MILIT_SERVICE_ID= X_MILIT_SERVICE_ID
633: ;
634: X_LAST_UPDATE_DATE DATE ;
635: X_LAST_UPDATED_BY NUMBER ;

Line 699: insert into IGS_PE_MIL_SERVICES_ALL (

695: x_last_update_login=>X_LAST_UPDATE_LOGIN);
696: IF (x_mode = 'S') THEN
697: igs_sc_gen_001.set_ctx('R');
698: END IF;
699: insert into IGS_PE_MIL_SERVICES_ALL (
700: MILIT_SERVICE_ID
701: ,PERSON_ID
702: ,START_DATE
703: ,END_DATE

Line 877: from IGS_PE_MIL_SERVICES_ALL

873: , MILITARY_TYPE_CD
874: , SEPARATION_TYPE_CD
875: , ASSISTANCE_TYPE_CD
876: , ASSISTANCE_STATUS_CD
877: from IGS_PE_MIL_SERVICES_ALL
878: where ROWID = X_ROWID
879: for update nowait;
880: tlinfo c1%rowtype;
881: begin

Line 1093: update IGS_PE_MIL_SERVICES_ALL set

1089: x_last_update_login=>X_LAST_UPDATE_LOGIN);
1090: IF (x_mode = 'S') THEN
1091: igs_sc_gen_001.set_ctx('R');
1092: END IF;
1093: update IGS_PE_MIL_SERVICES_ALL set
1094: PERSON_ID = NEW_REFERENCES.PERSON_ID,
1095: -- MILITARY_TYPE_ID = NEW_REFERENCES.MILITARY_TYPE_ID,
1096: START_DATE = NEW_REFERENCES.START_DATE,
1097: END_DATE = NEW_REFERENCES.END_DATE,

Line 1209: cursor c1 is select ROWID from IGS_PE_MIL_SERVICES_ALL

1205:
1206: Who When What
1207:
1208: ****************************************************************/
1209: cursor c1 is select ROWID from IGS_PE_MIL_SERVICES_ALL
1210: where MILIT_SERVICE_ID= X_MILIT_SERVICE_ID
1211: ;
1212: begin
1213: open c1;

Line 1314: delete from IGS_PE_MIL_SERVICES_ALL

1310: );
1311: IF (x_mode = 'S') THEN
1312: igs_sc_gen_001.set_ctx('R');
1313: END IF;
1314: delete from IGS_PE_MIL_SERVICES_ALL
1315: where ROWID = X_ROWID;
1316: if (sql%notfound) then
1317: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1318: igs_ge_msg_stack.add;