APPS.IGF_AP_FA_BASE_REC_PKG dependencies on IGF_AP_FA_BASE_REC_ALL

Line 5: old_references igf_ap_fa_base_rec_all%ROWTYPE;

1: PACKAGE BODY igf_ap_fa_base_rec_pkg AS
2: /* $Header: IGFAI03B.pls 120.0 2005/06/02 15:52:58 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_ap_fa_base_rec_all%ROWTYPE;
6: new_references igf_ap_fa_base_rec_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_ap_fa_base_rec_all%ROWTYPE;

2: /* $Header: IGFAI03B.pls 120.0 2005/06/02 15:52:58 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_ap_fa_base_rec_all%ROWTYPE;
6: new_references igf_ap_fa_base_rec_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 146: FROM igf_ap_fa_base_rec_all

142: */
143:
144: CURSOR cur_old_ref_values IS
145: SELECT *
146: FROM igf_ap_fa_base_rec_all
147: WHERE rowid = x_rowid;
148:
149: BEGIN
150:

Line 393: FROM igf_ap_fa_base_rec_all

389: || (reverse chronological order - newest change first)
390: */
391: CURSOR cur_rowid IS
392: SELECT rowid
393: FROM igf_ap_fa_base_rec_all
394: WHERE base_id = x_base_id
395: FOR UPDATE NOWAIT;
396:
397: lv_rowid cur_rowid%RowType;

Line 430: FROM igf_ap_fa_base_rec_all

426: || (reverse chronological order - newest change first)
427: */
428: CURSOR cur_rowid IS
429: SELECT rowid
430: FROM igf_ap_fa_base_rec_all
431: WHERE ci_cal_type = x_ci_cal_type
432: AND person_id = x_person_id
433: AND ci_sequence_number = x_ci_sequence_number
434: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 467: FROM igf_ap_fa_base_rec_all

463: || (reverse chronological order - newest change first)
464: */
465: CURSOR cur_rowid IS
466: SELECT rowid
467: FROM igf_ap_fa_base_rec_all
468: WHERE ((ci_cal_type = x_cal_type) AND
469: (ci_sequence_number = x_sequence_number));
470:
471: lv_rowid cur_rowid%RowType;

Line 923: FROM igf_ap_fa_base_rec_all

919: || (reverse chronological order - newest change first)
920: */
921: CURSOR c IS
922: SELECT rowid
923: FROM igf_ap_fa_base_rec_all
924: WHERE base_id = x_base_id;
925:
926: x_last_update_date DATE;
927: x_last_updated_by NUMBER;

Line 1097: INSERT INTO igf_ap_fa_base_rec_all (

1093: -- Bug 3700586 : Person data missing in OSS if peson is created thru HRMS
1094: -- Added the call to check whether HZ information is present in the IGS_PE_HZ_PARTIES table, if not it will add
1095: l_return_val_pe_hz := igs_pe_person_pkg.get_pk_for_validation(new_references.person_id);
1096:
1097: INSERT INTO igf_ap_fa_base_rec_all (
1098: base_id,
1099: ci_cal_type,
1100: person_id,
1101: ci_sequence_number,

Line 1593: FROM igf_ap_fa_base_rec_all

1589: isir_locked_by,
1590: adnl_unsub_loan_elig_flag,
1591: lock_awd_flag,
1592: lock_coa_flag
1593: FROM igf_ap_fa_base_rec_all
1594: WHERE rowid = x_rowid
1595: FOR UPDATE NOWAIT;
1596:
1597: tlinfo c1%ROWTYPE;

Line 2042: UPDATE igf_ap_fa_base_rec_all

2038: x_program_update_date := SYSDATE;
2039: END IF;
2040: END IF;
2041:
2042: UPDATE igf_ap_fa_base_rec_all
2043: SET
2044: ci_cal_type = new_references.ci_cal_type,
2045: person_id = new_references.person_id,
2046: ci_sequence_number = new_references.ci_sequence_number,

Line 2302: FROM igf_ap_fa_base_rec_all

2298: || (reverse chronological order - newest change first)
2299: */
2300: CURSOR c1 IS
2301: SELECT rowid
2302: FROM igf_ap_fa_base_rec_all
2303: WHERE base_id = x_base_id;
2304:
2305: BEGIN
2306:

Line 2573: DELETE FROM igf_ap_fa_base_rec_all

2569: p_action => 'DELETE',
2570: x_rowid => x_rowid
2571: );
2572:
2573: DELETE FROM igf_ap_fa_base_rec_all
2574: WHERE rowid = x_rowid;
2575:
2576: IF (SQL%NOTFOUND) THEN
2577: RAISE NO_DATA_FOUND;