APPS.IGF_AP_BATCH_AW_MAP_PKG dependencies on IGF_AP_BATCH_AW_MAP_ALL

Line 53: old_references igf_ap_batch_aw_map_all%ROWTYPE;

49: | |
50: *=======================================================================*/
51:
52: l_rowid VARCHAR2(25);
53: old_references igf_ap_batch_aw_map_all%ROWTYPE;
54: new_references igf_ap_batch_aw_map_all%ROWTYPE;
55:
56: PROCEDURE set_column_values (
57: p_action IN VARCHAR2 ,

Line 54: new_references igf_ap_batch_aw_map_all%ROWTYPE;

50: *=======================================================================*/
51:
52: l_rowid VARCHAR2(25);
53: old_references igf_ap_batch_aw_map_all%ROWTYPE;
54: new_references igf_ap_batch_aw_map_all%ROWTYPE;
55:
56: PROCEDURE set_column_values (
57: p_action IN VARCHAR2 ,
58: x_rowid IN VARCHAR2 ,

Line 101: FROM igf_ap_batch_aw_map_all

97: */
98:
99: CURSOR cur_old_ref_values IS
100: SELECT *
101: FROM igf_ap_batch_aw_map_all
102: WHERE rowid = x_rowid;
103:
104: BEGIN
105:

Line 232: FROM igf_ap_batch_aw_map_all

228: || (reverse chronological order - newest change first)
229: */
230: CURSOR cur_rowid IS
231: SELECT rowid
232: FROM igf_ap_batch_aw_map_all
233: WHERE bam_id = x_bam_id
234: FOR UPDATE NOWAIT;
235:
236: lv_rowid cur_rowid%ROWTYPE;

Line 267: FROM igf_ap_batch_aw_map_all

263: || (reverse chronological order - newest change first)
264: */
265: CURSOR cur_rowid IS
266: SELECT rowid
267: FROM igf_ap_batch_aw_map_all
268: WHERE ci_cal_type = x_ci_cal_type
269: AND ci_sequence_number = x_ci_sequence_number
270: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
271:

Line 302: FROM igf_ap_batch_aw_map_all

298: || (reverse chronological order - newest change first)
299: */
300: CURSOR cur_rowid IS
301: SELECT rowid
302: FROM igf_ap_batch_aw_map_all
303: WHERE sys_award_year = x_sys_award_year
304: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
305:
306: lv_rowid cur_rowid%ROWTYPE;

Line 338: FROM igf_ap_batch_aw_map_all

334: || (reverse chronological order - newest change first)
335: */
336: CURSOR cur_rowid IS
337: SELECT rowid
338: FROM igf_ap_batch_aw_map_all
339: WHERE ((ci_cal_type = x_cal_type) AND
340: (ci_sequence_number = x_sequence_number))
341: OR ((ci_cal_type_acad = x_cal_type) AND
342: (ci_sequence_number_acad = x_sequence_number)) ;

Line 509: FROM igf_ap_batch_aw_map_all

505: || (reverse chronological order - newest change first)
506: */
507: CURSOR c IS
508: SELECT rowid
509: FROM igf_ap_batch_aw_map_all
510: WHERE bam_id = x_bam_id;
511:
512: x_last_update_date DATE;
513: x_last_updated_by NUMBER;

Line 516: l_org_id igf_ap_batch_aw_map_all.org_id%TYPE := igf_aw_gen.get_org_id;

512: x_last_update_date DATE;
513: x_last_updated_by NUMBER;
514: x_last_update_login NUMBER;
515:
516: l_org_id igf_ap_batch_aw_map_all.org_id%TYPE := igf_aw_gen.get_org_id;
517:
518: BEGIN
519:
520: x_last_update_date := SYSDATE;

Line 541: SELECT igf_ap_batch_aw_map_all_s.NEXTVAL INTO x_bam_id FROM dual;

537: IGS_GE_MSG_STACK.ADD;
538: APP_EXCEPTION.RAISE_EXCEPTION;
539: END IF;
540:
541: SELECT igf_ap_batch_aw_map_all_s.NEXTVAL INTO x_bam_id FROM dual;
542:
543: before_dml(
544: p_action => 'INSERT',
545: x_rowid => x_rowid,

Line 577: INSERT INTO igf_ap_batch_aw_map_all (

573: x_last_update_login => x_last_update_login,
574: x_publish_in_ss_flag => x_publish_in_ss_flag
575: );
576:
577: INSERT INTO igf_ap_batch_aw_map_all (
578: batch_year,
579: ci_sequence_number,
580: ci_cal_type,
581: ci_sequence_number_acad,

Line 709: FROM igf_ap_batch_aw_map_all

705: award_year_status_code,
706: pell_participant_code,
707: dl_participant_code,
708: publish_in_ss_flag
709: FROM igf_ap_batch_aw_map_all
710: WHERE rowid = x_rowid
711: FOR UPDATE NOWAIT;
712:
713: tlinfo c1%ROWTYPE;

Line 859: UPDATE igf_ap_batch_aw_map_all

855: x_last_update_login => x_last_update_login,
856: x_publish_in_ss_flag => x_publish_in_ss_flag
857: );
858:
859: UPDATE igf_ap_batch_aw_map_all
860: SET
861: batch_year = new_references.batch_year,
862: ci_sequence_number = new_references.ci_sequence_number,
863: ci_cal_type = new_references.ci_cal_type,

Line 931: FROM igf_ap_batch_aw_map_all

927: || (reverse chronological order - newest change first)
928: */
929: CURSOR c1 IS
930: SELECT rowid
931: FROM igf_ap_batch_aw_map_all
932: WHERE bam_id = x_bam_id;
933:
934: BEGIN
935:

Line 1023: DELETE FROM igf_ap_batch_aw_map_all

1019: p_action => 'DELETE',
1020: x_rowid => x_rowid
1021: );
1022:
1023: DELETE FROM igf_ap_batch_aw_map_all
1024: WHERE rowid = x_rowid;
1025:
1026: IF (SQL%NOTFOUND) THEN
1027: RAISE NO_DATA_FOUND;