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_AD_RECRUITMENTS_PKG dependencies on IGS_AD_RECRUITMENTS

Line 1: PACKAGE BODY igs_ad_recruitments_pkg AS

1: PACKAGE BODY igs_ad_recruitments_pkg AS
2: /* $Header: IGSAI87B.pls 115.15 2003/12/09 11:07:12 akadam ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_recruitments%RowType;
5: new_references igs_ad_recruitments%RowType;

Line 4: old_references igs_ad_recruitments%RowType;

1: PACKAGE BODY igs_ad_recruitments_pkg AS
2: /* $Header: IGSAI87B.pls 115.15 2003/12/09 11:07:12 akadam ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_recruitments%RowType;
5: new_references igs_ad_recruitments%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ad_recruitments%RowType;

1: PACKAGE BODY igs_ad_recruitments_pkg AS
2: /* $Header: IGSAI87B.pls 115.15 2003/12/09 11:07:12 akadam ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_recruitments%RowType;
5: new_references igs_ad_recruitments%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 ,--DEFAULT NULL,

Line 54: FROM IGS_AD_RECRUITMENTS

50: ***************************************************************/
51:
52: CURSOR cur_old_ref_values IS
53: SELECT *
54: FROM IGS_AD_RECRUITMENTS
55: WHERE rowid = x_rowid;
56:
57: BEGIN
58:

Line 471: FROM igs_ad_recruitments

467: ***************************************************************/
468:
469: CURSOR cur_rowid IS
470: SELECT rowid
471: FROM igs_ad_recruitments
472: WHERE recruitment_id = x_recruitment_id
473: FOR UPDATE NOWAIT;
474:
475: lv_rowid cur_rowid%RowType;

Line 507: FROM igs_ad_recruitments

503: ***************************************************************/
504:
505: CURSOR cur_rowid IS
506: SELECT rowid
507: FROM igs_ad_recruitments
508: WHERE person_id = x_person_id
509: and ((l_rowid is null) or (rowid <> l_rowid));
510: lv_rowid cur_rowid%RowType;
511:

Line 542: FROM igs_ad_recruitments

538: ***************************************************************/
539:
540: CURSOR cur_rowid1 IS
541: SELECT rowid
542: FROM igs_ad_recruitments
543: WHERE institution_location_id = x_code_id ;
544:
545: CURSOR cur_rowid2 IS
546: SELECT rowid

Line 547: FROM igs_ad_recruitments

543: WHERE institution_location_id = x_code_id ;
544:
545: CURSOR cur_rowid2 IS
546: SELECT rowid
547: FROM igs_ad_recruitments
548: WHERE degree_goal_id = x_code_id ;
549:
550: CURSOR cur_rowid3 IS
551: SELECT rowid

Line 552: FROM igs_ad_recruitments

548: WHERE degree_goal_id = x_code_id ;
549:
550: CURSOR cur_rowid3 IS
551: SELECT rowid
552: FROM igs_ad_recruitments
553: WHERE unit_set_id = x_code_id ;
554:
555: CURSOR cur_rowid4 IS
556: SELECT rowid

Line 557: FROM igs_ad_recruitments

553: WHERE unit_set_id = x_code_id ;
554:
555: CURSOR cur_rowid4 IS
556: SELECT rowid
557: FROM igs_ad_recruitments
558: WHERE institution_setting_id = x_code_id ;
559:
560: CURSOR cur_rowid5 IS
561: SELECT rowid

Line 562: FROM igs_ad_recruitments

558: WHERE institution_setting_id = x_code_id ;
559:
560: CURSOR cur_rowid5 IS
561: SELECT rowid
562: FROM igs_ad_recruitments
563: WHERE program_interest_id = x_code_id ;
564:
565: CURSOR cur_rowid6 IS
566: SELECT rowid

Line 567: FROM igs_ad_recruitments

563: WHERE program_interest_id = x_code_id ;
564:
565: CURSOR cur_rowid6 IS
566: SELECT rowid
567: FROM igs_ad_recruitments
568: WHERE certainty_of_choice_id = x_code_id ;
569:
570: CURSOR cur_rowid7 IS
571: SELECT rowid

Line 572: FROM igs_ad_recruitments

568: WHERE certainty_of_choice_id = x_code_id ;
569:
570: CURSOR cur_rowid7 IS
571: SELECT rowid
572: FROM igs_ad_recruitments
573: WHERE special_services_id = x_code_id ;
574:
575: CURSOR cur_rowid8 IS
576: SELECT rowid

Line 577: FROM igs_ad_recruitments

573: WHERE special_services_id = x_code_id ;
574:
575: CURSOR cur_rowid8 IS
576: SELECT rowid
577: FROM igs_ad_recruitments
578: WHERE employment_id = x_code_id ;
579:
580: CURSOR cur_rowid9 IS
581: SELECT rowid

Line 582: FROM igs_ad_recruitments

578: WHERE employment_id = x_code_id ;
579:
580: CURSOR cur_rowid9 IS
581: SELECT rowid
582: FROM igs_ad_recruitments
583: WHERE special_interest_id = x_code_id ;
584:
585: CURSOR cur_rowid10 IS
586: SELECT rowid

Line 587: FROM igs_ad_recruitments

583: WHERE special_interest_id = x_code_id ;
584:
585: CURSOR cur_rowid10 IS
586: SELECT rowid
587: FROM igs_ad_recruitments
588: WHERE housing_id = x_code_id ;
589:
590: CURSOR cur_rowid11 IS
591: SELECT rowid

Line 592: FROM igs_ad_recruitments

588: WHERE housing_id = x_code_id ;
589:
590: CURSOR cur_rowid11 IS
591: SELECT rowid
592: FROM igs_ad_recruitments
593: WHERE institution_control_id = x_code_id ;
594:
595: CURSOR cur_rowid12 IS
596: SELECT rowid

Line 597: FROM igs_ad_recruitments

593: WHERE institution_control_id = x_code_id ;
594:
595: CURSOR cur_rowid12 IS
596: SELECT rowid
597: FROM igs_ad_recruitments
598: WHERE institution_size_id = x_code_id ;
599:
600: lv_rowid cur_rowid1%RowType;
601:

Line 756: FROM igs_ad_recruitments

752: ***************************************************************/
753:
754: CURSOR cur_rowid IS
755: SELECT rowid
756: FROM igs_ad_recruitments
757: WHERE person_id = x_person_id ;
758:
759: lv_rowid cur_rowid%RowType;
760:

Line 966: cursor C is select ROWID from IGS_AD_RECRUITMENTS

962: Removed the processing for the Obsolete column 'PROBABILITY'
963: (reverse chronological order - newest change first)
964: ***************************************************************/
965:
966: cursor C is select ROWID from IGS_AD_RECRUITMENTS
967: where RECRUITMENT_ID= X_RECRUITMENT_ID
968: ;
969: X_LAST_UPDATE_DATE DATE ;
970: X_LAST_UPDATED_BY NUMBER ;

Line 1024: insert into IGS_AD_RECRUITMENTS (

1020: x_created_by=>X_LAST_UPDATED_BY,
1021: x_last_update_date=>X_LAST_UPDATE_DATE,
1022: x_last_updated_by=>X_LAST_UPDATED_BY,
1023: x_last_update_login=>X_LAST_UPDATE_LOGIN);
1024: insert into IGS_AD_RECRUITMENTS (
1025: CERTAINTY_OF_CHOICE_ID
1026: ,RELIGION_CD
1027: ,ADV_STUDIES_CLASSES
1028: ,HONORS_CLASSES

Line 1154: from IGS_AD_RECRUITMENTS

1150: , EMPLOYMENT_ID
1151: , HOUSING_ID
1152: , DEGREE_GOAL_ID
1153: , UNIT_SET_ID
1154: from IGS_AD_RECRUITMENTS
1155: where ROWID = X_ROWID
1156: for update nowait;
1157: tlinfo c1%rowtype;
1158: begin

Line 1334: update IGS_AD_RECRUITMENTS set

1330: x_created_by=>X_LAST_UPDATED_BY,
1331: x_last_update_date=>X_LAST_UPDATE_DATE,
1332: x_last_updated_by=>X_LAST_UPDATED_BY,
1333: x_last_update_login=>X_LAST_UPDATE_LOGIN);
1334: update IGS_AD_RECRUITMENTS set
1335: CERTAINTY_OF_CHOICE_ID = NEW_REFERENCES.CERTAINTY_OF_CHOICE_ID,
1336: RELIGION_CD = NEW_REFERENCES.RELIGION_CD,
1337: ADV_STUDIES_CLASSES = NEW_REFERENCES.ADV_STUDIES_CLASSES,
1338: HONORS_CLASSES = NEW_REFERENCES.HONORS_CLASSES,

Line 1410: cursor c1 is select ROWID from IGS_AD_RECRUITMENTS

1406:
1407: (reverse chronological order - newest change first)
1408: ***************************************************************/
1409:
1410: cursor c1 is select ROWID from IGS_AD_RECRUITMENTS
1411: where RECRUITMENT_ID= X_RECRUITMENT_ID
1412: ;
1413: begin
1414: open c1;

Line 1493: delete from IGS_AD_RECRUITMENTS

1489: Before_DML (
1490: p_action => 'DELETE',
1491: x_rowid => X_ROWID
1492: );
1493: delete from IGS_AD_RECRUITMENTS
1494: where ROWID = X_ROWID;
1495: if (sql%notfound) then
1496: raise no_data_found;
1497: end if;

Line 1503: END igs_ad_recruitments_pkg;

1499: p_action => 'DELETE',
1500: x_rowid => X_ROWID
1501: );
1502: end DELETE_ROW;
1503: END igs_ad_recruitments_pkg;