eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PR_GEN_006 dependencies on IGS_PE_PERS_ENCUMB

Line 15: || in the call to IGS_PE_PERS_ENCUMB_PKG.UPDATE_ROW

11: || (reverse chronological order - newest change first) ||
12: ||==============================================================================||
13: || sarakshi 16-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG in function IGS_PR_UPD_SCA_STATUS
14: || ssawhney 17-feb-2003 Bug : 2758856 : Added the parameter x_external_reference
15: || in the call to IGS_PE_PERS_ENCUMB_PKG.UPDATE_ROW
16: ||
17: || NALKUMAR 19-NOV-2002 Bug NO: 2658550 ||
18: || Modified this object as per the FA110 PR Enh. ||
19: ||==============================================================================||

Line 21: || Added the parameter auth_resp_id in the call to THB igs_pe_pers_encumb_pkg

17: || NALKUMAR 19-NOV-2002 Bug NO: 2658550 ||
18: || Modified this object as per the FA110 PR Enh. ||
19: ||==============================================================================||
20: || pkpatel 07-OCT-2002 Bug No: 2600842 ||
21: || Added the parameter auth_resp_id in the call to THB igs_pe_pers_encumb_pkg
22: | nmankodi 11-Apr-2005 fnd_user.customer_id column has been changed to
23: | fnd_user.person_party_id as an ebizsuite wide TCA mandate.
24: ||==============================================================================||
25: */

Line 1643: IGS_PE_PERS_ENCUMB pen

1639: CURSOR c_pee (
1640: cp_encumbrance_type igs_pr_ou_type.encumbrance_type%TYPE) IS
1641: SELECT 'X'
1642: FROM IGS_PE_PERSENC_EFFCT pee,
1643: IGS_PE_PERS_ENCUMB pen
1644: WHERE pen.person_id = p_person_id AND
1645: pen.spo_course_cd IS NULL AND
1646: (pen.expiry_dt IS NULL OR
1647: pen.expiry_dt > TRUNC(SYSDATE)) AND

Line 1687: FROM IGS_PE_PERS_ENCUMB pen,

1683: CURSOR c_pen_pee (
1684: cp_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE,
1685: cp_spo_expiry_dt IGS_PR_STDNT_PR_OU.expiry_dt%TYPE) IS
1686: SELECT pee.s_encmb_effect_type
1687: FROM IGS_PE_PERS_ENCUMB pen,
1688: IGS_PE_PERSENC_EFFCT pee
1689: WHERE pen.person_id = p_person_id AND
1690: pen.spo_course_cd = p_course_cd AND
1691: pen.spo_sequence_number = cp_spo_sequence_number AND

Line 2485: || ssawhney 17-feb-2003 Bug : 2758856 : Added the parameter x_external_reference in the call to IGS_PE_PERS_ENCUMB_PKG.UPDATE_ROW

2481: || Purpose : Validates the Foreign Keys for the table.
2482: || Known limitations, enhancements or remarks :
2483: || Change History :
2484: || Who When What
2485: || ssawhney 17-feb-2003 Bug : 2758856 : Added the parameter x_external_reference in the call to IGS_PE_PERS_ENCUMB_PKG.UPDATE_ROW
2486: || kdande 17-Dec-2002 Bug# 2543601. Changed the query for c_pe
2487: || cursor to use hz_parties instead of igs_pe_person
2488: || nalkumar 19-NOV-2002 Bug NO: 2658550. Modified this function as per the FA110 PR Enh.
2489: || pkpatel 7-OCT-2002 Bug No: 2600842

Line 2490: || Added the parameter x_auth_resp_id in the call to igs_pe_pers_encumb_pkg

2486: || kdande 17-Dec-2002 Bug# 2543601. Changed the query for c_pe
2487: || cursor to use hz_parties instead of igs_pe_person
2488: || nalkumar 19-NOV-2002 Bug NO: 2658550. Modified this function as per the FA110 PR Enh.
2489: || pkpatel 7-OCT-2002 Bug No: 2600842
2490: || Added the parameter x_auth_resp_id in the call to igs_pe_pers_encumb_pkg
2491: || (reverse chronological order - newest change first)
2492: */
2493: gv_other_detail VARCHAR2(255);
2494: gcst_sysdate CONSTANT DATE := TRUNC(SYSDATE);

Line 2502: -- A database relationship exists between the IGS_PE_PERS_ENCUMB and

2498: -- IGS_PR_STDNT_PR_OU that has been approved. The encumbrance details
2499: -- resulting from spo detail are only maintainable through this routine, via
2500: -- changes through the progression screens. The routine also handles the
2501: -- removal of encumbrances if the outcome has been Cancelled/Removed.
2502: -- A database relationship exists between the IGS_PE_PERS_ENCUMB and
2503: -- IGS_PR_STDNT_PR_OU from which it has resulted.
2504: -- Note: If a student has multiple IGS_PR_STDNT_PR_OUs then they
2505: -- will result in separate IGS_PE_PERS_ENCUMB entries related accordingly.
2506: -- Overlap between encumbrance effects is possible and is resolved where

Line 2505: -- will result in separate IGS_PE_PERS_ENCUMB entries related accordingly.

2501: -- removal of encumbrances if the outcome has been Cancelled/Removed.
2502: -- A database relationship exists between the IGS_PE_PERS_ENCUMB and
2503: -- IGS_PR_STDNT_PR_OU from which it has resulted.
2504: -- Note: If a student has multiple IGS_PR_STDNT_PR_OUs then they
2505: -- will result in separate IGS_PE_PERS_ENCUMB entries related accordingly.
2506: -- Overlap between encumbrance effects is possible and is resolved where
2507: -- required.
2508: -- Note: the authorising person ID parameter is designed to be passed from
2509: -- calling routines and will be recorded against the person encumbrance

Line 2538: lv_spo_sequence_number IGS_PE_PERS_ENCUMB.SPO_SEQUENCE_NUMBER%TYPE;

2534: cst_required CONSTANT VARCHAR2(10) := 'REQUIRED';
2535: e_record_locked EXCEPTION;
2536: v_decode_val1 NUMBER(6,3);
2537: v_decode_val2 VARCHAR2(2);
2538: lv_spo_sequence_number IGS_PE_PERS_ENCUMB.SPO_SEQUENCE_NUMBER%TYPE;
2539: PRAGMA EXCEPTION_INIT (e_record_locked, -54);
2540: v_authorising_person_id IGS_PE_PERSON.person_id%TYPE;
2541: v_message_text VARCHAR2(2000) DEFAULT NULL;
2542: v_message_level VARCHAR2(10) DEFAULT NULL;

Line 2543: v_action_expiry_dt IGS_PE_PERS_ENCUMB.expiry_dt%TYPE;

2539: PRAGMA EXCEPTION_INIT (e_record_locked, -54);
2540: v_authorising_person_id IGS_PE_PERSON.person_id%TYPE;
2541: v_message_text VARCHAR2(2000) DEFAULT NULL;
2542: v_message_level VARCHAR2(10) DEFAULT NULL;
2543: v_action_expiry_dt IGS_PE_PERS_ENCUMB.expiry_dt%TYPE;
2544: v_pen_expiry_dt IGS_PE_PERS_ENCUMB.expiry_dt%TYPE;
2545: v_pen_exists BOOLEAN;
2546: v_expiry_status VARCHAR2(10);
2547: v_expiry_dt DATE;

Line 2544: v_pen_expiry_dt IGS_PE_PERS_ENCUMB.expiry_dt%TYPE;

2540: v_authorising_person_id IGS_PE_PERSON.person_id%TYPE;
2541: v_message_text VARCHAR2(2000) DEFAULT NULL;
2542: v_message_level VARCHAR2(10) DEFAULT NULL;
2543: v_action_expiry_dt IGS_PE_PERS_ENCUMB.expiry_dt%TYPE;
2544: v_pen_expiry_dt IGS_PE_PERS_ENCUMB.expiry_dt%TYPE;
2545: v_pen_exists BOOLEAN;
2546: v_expiry_status VARCHAR2(10);
2547: v_expiry_dt DATE;
2548: v_course_cd_found BOOLEAN;

Line 2581: FROM IGS_PE_PERS_ENCUMB pen

2577: AND u.person_party_id = p.party_id
2578: AND SUBSTR (igs_en_gen_003.get_staff_ind (p.party_id), 1, 1) = 'Y';
2579: CURSOR c_pen IS
2580: SELECT pen.expiry_dt
2581: FROM IGS_PE_PERS_ENCUMB pen
2582: WHERE pen.person_id = p_person_id AND
2583: pen.spo_course_cd = p_course_cd AND
2584: pen.spo_sequence_number = p_spo_sequence_number;
2585: CURSOR c_etde (

Line 2594: FROM IGS_PE_PERS_ENCUMB pen,

2590:
2591: CURSOR c_pee IS
2592: SELECT pee.*,
2593: pee.ROWID
2594: FROM IGS_PE_PERS_ENCUMB pen,
2595: IGS_PE_PERSENC_EFFCT pee,
2596: igs_fi_enc_dflt_eft etde
2597: WHERE pen.person_id = p_person_id AND
2598: pen.spo_course_cd = p_course_cd AND

Line 2981: p_expiry_dt IGS_PE_PERS_ENCUMB.expiry_dt%TYPE,

2977: --
2978: -- End of new code added as per the FA110 PR Enh. Bug# 2658550.
2979: --
2980: FUNCTION prgpl_upd_expiry_dt1 (
2981: p_expiry_dt IGS_PE_PERS_ENCUMB.expiry_dt%TYPE,
2982: p_local_message_level OUT NOCOPY VARCHAR2,
2983: p_local_message_text OUT NOCOPY VARCHAR2)
2984: RETURN BOOLEAN
2985: IS

Line 2993: || ssawhney 17-feb-2003 Bug : 2758856 : Added the parameter x_external_reference in the call to IGS_PE_PERS_ENCUMB_PKG.UPDATE_ROW

2989: || Purpose : Validates the Foreign Keys for the table.
2990: || Known limitations, enhancements or remarks :
2991: || Change History :
2992: || Who When What
2993: || ssawhney 17-feb-2003 Bug : 2758856 : Added the parameter x_external_reference in the call to IGS_PE_PERS_ENCUMB_PKG.UPDATE_ROW
2994: || pkpatel 7-OCT-2002 Bug No: 2600842
2995: || Added the parameter x_auth_resp_id in the call to igs_pe_pers_encumb_pkg
2996: || (reverse chronological order - newest change first)
2997: */

Line 2995: || Added the parameter x_auth_resp_id in the call to igs_pe_pers_encumb_pkg

2991: || Change History :
2992: || Who When What
2993: || ssawhney 17-feb-2003 Bug : 2758856 : Added the parameter x_external_reference in the call to IGS_PE_PERS_ENCUMB_PKG.UPDATE_ROW
2994: || pkpatel 7-OCT-2002 Bug No: 2600842
2995: || Added the parameter x_auth_resp_id in the call to igs_pe_pers_encumb_pkg
2996: || (reverse chronological order - newest change first)
2997: */
2998: gvl_other_detail VARCHAR2(255);
2999:

Line 3005: cp_expiry_dt IGS_PE_PERS_ENCUMB.expiry_dt%TYPE) IS

3001:
3002: DECLARE
3003:
3004: CURSOR c_pen (
3005: cp_expiry_dt IGS_PE_PERS_ENCUMB.expiry_dt%TYPE) IS
3006: SELECT pen.*,
3007: pen.ROWID
3008: FROM IGS_PE_PERS_ENCUMB pen
3009: WHERE pen.person_id = p_person_id AND

Line 3008: FROM IGS_PE_PERS_ENCUMB pen

3004: CURSOR c_pen (
3005: cp_expiry_dt IGS_PE_PERS_ENCUMB.expiry_dt%TYPE) IS
3006: SELECT pen.*,
3007: pen.ROWID
3008: FROM IGS_PE_PERS_ENCUMB pen
3009: WHERE pen.person_id = p_person_id AND
3010: pen.spo_course_cd = p_course_cd AND
3011: pen.spo_sequence_number = p_spo_sequence_number AND
3012: ((cp_expiry_dt IS NULL OR

Line 3019: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,

3015: pen.expiry_dt > gcst_sysdate))
3016: FOR UPDATE NOWAIT;
3017:
3018: CURSOR c_pee (
3019: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3020: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3021: cp_expiry_dt IGS_PE_PERSENC_EFFCT.expiry_dt%TYPE) IS
3022: SELECT pee.*,
3023: pee.ROWID

Line 3020: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,

3016: FOR UPDATE NOWAIT;
3017:
3018: CURSOR c_pee (
3019: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3020: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3021: cp_expiry_dt IGS_PE_PERSENC_EFFCT.expiry_dt%TYPE) IS
3022: SELECT pee.*,
3023: pee.ROWID
3024: FROM IGS_PE_PERSENC_EFFCT pee

Line 3035: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,

3031: pee.expiry_dt > gcst_sysdate))
3032: FOR UPDATE NOWAIT;
3033:
3034: CURSOR c_pce (
3035: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3036: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3037: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3038: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3039: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

Line 3036: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,

3032: FOR UPDATE NOWAIT;
3033:
3034: CURSOR c_pce (
3035: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3036: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3037: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3038: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3039: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3040: SELECT pce.*,pce.ROWID

Line 3053: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,

3049: pce.expiry_dt > gcst_sysdate)
3050: FOR UPDATE NOWAIT;
3051:
3052: CURSOR c_pcge (
3053: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3054: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3055: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3056: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3057: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

Line 3054: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,

3050: FOR UPDATE NOWAIT;
3051:
3052: CURSOR c_pcge (
3053: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3054: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3055: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3056: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3057: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3058: SELECT pcge.*, pcge.ROWID

Line 3071: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,

3067: pcge.expiry_dt > gcst_sysdate)
3068: FOR UPDATE NOWAIT;
3069:
3070: CURSOR c_puse (
3071: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3072: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3073: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3074: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3075: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

Line 3072: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,

3068: FOR UPDATE NOWAIT;
3069:
3070: CURSOR c_puse (
3071: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3072: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3073: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3074: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3075: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3076: SELECT puse.*,puse.ROWID

Line 3089: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,

3085: puse.expiry_dt > gcst_sysdate)
3086: FOR UPDATE NOWAIT;
3087:
3088: CURSOR c_pue (
3089: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3090: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3091: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3092: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3093: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

Line 3090: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,

3086: FOR UPDATE NOWAIT;
3087:
3088: CURSOR c_pue (
3089: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3090: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3091: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3092: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3093: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3094: SELECT pue.*, pue.ROWID

Line 3107: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,

3103: pue.expiry_dt > gcst_sysdate)
3104: FOR UPDATE NOWAIT;
3105:
3106: CURSOR c_pur (
3107: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3108: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3109: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3110: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3111: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

Line 3108: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,

3104: FOR UPDATE NOWAIT;
3105:
3106: CURSOR c_pur (
3107: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3108: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3109: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3110: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3111: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3112: SELECT pur.*, pur.ROWID

Line 3128: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,

3124: --
3125: -- Start of new code added as per the FA110 PR Enh. Bug# 2658550.
3126: --
3127: CURSOR c_pfe (
3128: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3129: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3130: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3131: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3132: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

Line 3129: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,

3125: -- Start of new code added as per the FA110 PR Enh. Bug# 2658550.
3126: --
3127: CURSOR c_pfe (
3128: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3129: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3130: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3131: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3132: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3133: SELECT pfe.*, pfe.ROWID

Line 3322: IGS_PE_PERS_ENCUMB_PKG.UPDATE_ROW(

3318: X_RESTRICTED_ATTENDANCE_TYPE => v_pee_rec.RESTRICTED_ATTENDANCE_TYPE,
3319: X_MODE => 'R'
3320: );
3321: END LOOP; -- c_pee
3322: IGS_PE_PERS_ENCUMB_PKG.UPDATE_ROW(
3323: X_ROWID => v_pen_rec.ROWID,
3324: X_PERSON_ID => v_pen_rec.PERSON_ID,
3325: X_ENCUMBRANCE_TYPE => v_pen_rec.ENCUMBRANCE_TYPE,
3326: X_START_DT => v_pen_rec.START_DT,

Line 3421: FROM IGS_PE_PERS_ENCUMB pen,

3417: DECLARE
3418: CURSOR c_pee IS
3419: SELECT pee.*,
3420: pee.ROWID
3421: FROM IGS_PE_PERS_ENCUMB pen,
3422: IGS_PE_PERSENC_EFFCT pee,
3423: igs_fi_enc_dflt_eft etde
3424: WHERE pen.person_id = p_person_id AND
3425: pen.spo_course_cd = p_course_cd AND

Line 3437: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,

3433: pee.expiry_dt >= gcst_sysdate)
3434: FOR UPDATE NOWAIT;
3435:
3436: CURSOR c_pce (
3437: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3438: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3439: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3440: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3441: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

Line 3438: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,

3434: FOR UPDATE NOWAIT;
3435:
3436: CURSOR c_pce (
3437: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3438: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3439: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3440: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3441: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3442: SELECT pce.*, pce.ROWID

Line 3453: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,

3449: pce.pee_sequence_number = cp_pee_sequence_number
3450: FOR UPDATE NOWAIT;
3451:
3452: CURSOR c_pcge (
3453: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3454: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3455: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3456: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3457: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

Line 3454: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,

3450: FOR UPDATE NOWAIT;
3451:
3452: CURSOR c_pcge (
3453: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3454: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3455: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3456: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3457: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3458: SELECT pcge.*, pcge.ROWID

Line 3469: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,

3465: pcge.pee_sequence_number = cp_pee_sequence_number
3466: FOR UPDATE NOWAIT;
3467:
3468: CURSOR c_puse (
3469: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3470: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3471: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3472: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3473: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

Line 3470: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,

3466: FOR UPDATE NOWAIT;
3467:
3468: CURSOR c_puse (
3469: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3470: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3471: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3472: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3473: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3474: SELECT puse.*, puse.ROWID

Line 3485: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,

3481: puse.pee_sequence_number = cp_pee_sequence_number
3482: FOR UPDATE NOWAIT;
3483:
3484: CURSOR c_pue (
3485: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3486: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3487: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3488: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3489: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

Line 3486: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,

3482: FOR UPDATE NOWAIT;
3483:
3484: CURSOR c_pue (
3485: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3486: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3487: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3488: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3489: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3490: SELECT pue.*, pue.ROWID

Line 3501: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,

3497: pue.pee_sequence_number = cp_pee_sequence_number
3498: FOR UPDATE NOWAIT;
3499:
3500: CURSOR c_pur (
3501: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3502: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3503: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3504: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3505: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

Line 3502: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,

3498: FOR UPDATE NOWAIT;
3499:
3500: CURSOR c_pur (
3501: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3502: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3503: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3504: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3505: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3506: SELECT pur.*, pur.ROWID

Line 3520: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,

3516: --
3517: -- Start of new code added as per the FA110 PR Enh. Bug# 2658550.
3518: --
3519: CURSOR c_pfe (
3520: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3521: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3522: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3523: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3524: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

Line 3521: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,

3517: -- Start of new code added as per the FA110 PR Enh. Bug# 2658550.
3518: --
3519: CURSOR c_pfe (
3520: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3521: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3522: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3523: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3524: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3525: SELECT pfe.*, pfe.ROWID

Line 4624: IGS_PE_PERS_ENCUMB_pkg.INSERT_ROW (

4620: DECLARE
4621: lv_rowid VARCHAR2(25);
4622: BEGIN
4623:
4624: IGS_PE_PERS_ENCUMB_pkg.INSERT_ROW (
4625: X_ROWID =>lv_rowid,
4626: X_PERSON_ID =>p_person_id,
4627: X_ENCUMBRANCE_TYPE =>v_spo_rec.encumbrance_type,
4628: X_START_DT=> gcst_sysdatetime, --gjha Chaged from gcst_sysdatetime -- Modified by Prajeesh to sysdatetime