APPS.IGS_PE_STAT_DETAILS_PKG dependencies on IGS_PE_STAT_DETAILS

Line 1: PACKAGE BODY Igs_Pe_Stat_Details_Pkg AS

1: PACKAGE BODY Igs_Pe_Stat_Details_Pkg AS
2: /* $Header: IGSNI72B.pls 120.2 2006/02/17 06:52:23 gmaheswa ship $ */
3:
4: ------------------------------------------------------------------
5: -- Change History

Line 26: old_references igs_pe_stat_details%ROWTYPE;

22: -- added person_id mandatory FK with HZ_PARTIES. removed person_profile_id and all the obsoleted columns
23: ------------------------------------------------------------------
24:
25: l_rowid VARCHAR2(25);
26: old_references igs_pe_stat_details%ROWTYPE;
27: new_references igs_pe_stat_details%ROWTYPE;
28:
29: PROCEDURE set_column_values (
30: p_action IN VARCHAR2,

Line 27: new_references igs_pe_stat_details%ROWTYPE;

23: ------------------------------------------------------------------
24:
25: l_rowid VARCHAR2(25);
26: old_references igs_pe_stat_details%ROWTYPE;
27: new_references igs_pe_stat_details%ROWTYPE;
28:
29: PROCEDURE set_column_values (
30: p_action IN VARCHAR2,
31: x_rowid IN VARCHAR2 ,-- DEFAULT NULL,

Line 97: FROM IGS_PE_STAT_DETAILS

93: */
94:
95: CURSOR cur_old_ref_values IS
96: SELECT *
97: FROM IGS_PE_STAT_DETAILS
98: WHERE ROWID = x_rowid;
99:
100: BEGIN
101:

Line 197: FROM igs_pe_stat_details

193: || (reverse chronological order - newest change first)
194: */
195: CURSOR cur_rowid IS
196: SELECT ROWID
197: FROM igs_pe_stat_details
198: -- WHERE person_profile_id = x_person_profile_id
199: WHERE person_id = x_person_id
200: FOR UPDATE NOWAIT;
201:

Line 224: FROM IGS_PE_STAT_DETAILS

220: x_ci_sequence_number IN NUMBER
221: ) AS
222: CURSOR cur_rowid IS
223: SELECT rowid
224: FROM IGS_PE_STAT_DETAILS
225: WHERE (
226: ( MATR_CAL_TYPE = X_CAL_TYPE AND MATR_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER ) OR
227: ( INIT_CAL_TYPE = X_CAL_TYPE AND INIT_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER ) OR
228: ( RECENT_CAL_TYPE = X_CAL_TYPE AND RECENT_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER ) OR

Line 561: FROM igs_pe_stat_details

557: || ssawhney 2203778 person_id replaces person_profile_id
558: */
559: CURSOR c IS
560: SELECT ROWID
561: FROM igs_pe_stat_details
562: WHERE person_id = x_person_id;
563:
564: x_last_update_date DATE;
565: x_last_updated_by NUMBER;

Line 665: INSERT INTO igs_pe_stat_details (

661:
662: IF (x_mode = 'S') THEN
663: igs_sc_gen_001.set_ctx('R');
664: END IF;
665: INSERT INTO igs_pe_stat_details (
666: -- person_profile_id,
667: person_id,
668: effective_start_date,
669: effective_end_date,

Line 918: FROM igs_pe_stat_details

914: ATTRIBUTE18,
915: ATTRIBUTE19,
916: ATTRIBUTE20,
917: BIRTH_CNTRY_RESN_CODE
918: FROM igs_pe_stat_details
919: WHERE ROWID = x_rowid
920: FOR UPDATE NOWAIT;
921:
922: tlinfo c1%ROWTYPE;

Line 1202: UPDATE igs_pe_stat_details

1198:
1199: IF (x_mode = 'S') THEN
1200: igs_sc_gen_001.set_ctx('R');
1201: END IF;
1202: UPDATE igs_pe_stat_details
1203: SET
1204: effective_start_date = new_references.effective_start_date,
1205: effective_end_date = new_references.effective_end_date,
1206: religion_cd = new_references.religion_cd,

Line 1349: FROM igs_pe_stat_details

1345: || ssawhney 2203778 : person_id replaces person_profile_id
1346: */
1347: CURSOR c1 IS
1348: SELECT ROWID
1349: FROM igs_pe_stat_details
1350: WHERE person_id = x_person_id;
1351:
1352: BEGIN
1353:

Line 1492: DELETE FROM igs_pe_stat_details

1488:
1489: IF (x_mode = 'S') THEN
1490: igs_sc_gen_001.set_ctx('R');
1491: END IF;
1492: DELETE FROM igs_pe_stat_details
1493: WHERE ROWID = x_rowid;
1494:
1495: IF (SQL%NOTFOUND) THEN
1496: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 1509: END Igs_Pe_Stat_Details_Pkg;

1505:
1506: END delete_row;
1507:
1508:
1509: END Igs_Pe_Stat_Details_Pkg;