APPS.IGS_AD_RECRUIT_PI_PKG dependencies on IGS_AD_RECRUIT_PI

Line 1: PACKAGE BODY igs_ad_recruit_pi_pkg AS

1: PACKAGE BODY igs_ad_recruit_pi_pkg AS
2: /* $Header: IGSAIE5B.pls 115.11 2003/12/09 11:08:04 akadam ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_recruit_pi%ROWTYPE;

Line 5: old_references igs_ad_recruit_pi%ROWTYPE;

1: PACKAGE BODY igs_ad_recruit_pi_pkg AS
2: /* $Header: IGSAIE5B.pls 115.11 2003/12/09 11:08:04 akadam ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_recruit_pi%ROWTYPE;
6: new_references igs_ad_recruit_pi%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ad_recruit_pi%ROWTYPE;

2: /* $Header: IGSAIE5B.pls 115.11 2003/12/09 11:08:04 akadam ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_recruit_pi%ROWTYPE;
6: new_references igs_ad_recruit_pi%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 35: FROM IGS_AD_RECRUIT_PI

31: */
32:
33: CURSOR cur_old_ref_values IS
34: SELECT *
35: FROM IGS_AD_RECRUIT_PI
36: WHERE rowid = x_rowid;
37:
38: BEGIN
39:

Line 205: FROM igs_ad_recruit_pi

201: || (reverse chronological order - newest change first)
202: */
203: CURSOR cur_rowid IS
204: SELECT rowid
205: FROM igs_ad_recruit_pi
206: WHERE probability_index_id = x_probability_index_id
207: FOR UPDATE NOWAIT;
208:
209: lv_rowid cur_rowid%RowType;

Line 242: FROM igs_ad_recruit_pi

238: || (reverse chronological order - newest change first)
239: */
240: CURSOR cur_rowid IS
241: SELECT rowid
242: FROM igs_ad_recruit_pi
243: WHERE probability_type_code_id = x_probability_type_code_id
244: AND TRUNC(calculation_date) = TRUNC(x_calculation_date)
245: AND person_id = x_person_id
246: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 279: FROM igs_ad_recruit_pi

275: || (reverse chronological order - newest change first)
276: */
277: CURSOR cur_rowid IS
278: SELECT rowid
279: FROM igs_ad_recruit_pi
280: WHERE ((person_id = x_party_id));
281:
282: lv_rowid cur_rowid%RowType;
283:

Line 314: FROM igs_ad_recruit_pi

310: || (reverse chronological order - newest change first)
311: */
312: CURSOR cur_rowid IS
313: SELECT rowid
314: FROM igs_ad_recruit_pi
315: WHERE ((probability_type_code_id = x_code_id))
316: OR ((probability_source_code_id = x_code_id));
317:
318: lv_rowid cur_rowid%RowType;

Line 438: FROM igs_ad_recruit_pi

434: || (reverse chronological order - newest change first)
435: */
436: CURSOR c IS
437: SELECT rowid
438: FROM igs_ad_recruit_pi
439: WHERE probability_index_id = x_probability_index_id;
440:
441: x_last_update_date DATE;
442: x_last_updated_by NUMBER;

Line 483: INSERT INTO igs_ad_recruit_pi (

479: x_last_updated_by => x_last_updated_by,
480: x_last_update_login => x_last_update_login
481: );
482:
483: INSERT INTO igs_ad_recruit_pi (
484: probability_index_id,
485: person_id,
486: probability_type_code_id,
487: calculation_date,

Line 496: igs_ad_recruit_pi_s.NEXTVAL,

492: last_update_date,
493: last_updated_by,
494: last_update_login
495: ) VALUES (
496: igs_ad_recruit_pi_s.NEXTVAL,
497: new_references.person_id,
498: new_references.probability_type_code_id,
499: new_references.calculation_date,
500: new_references.probability_value,

Line 545: FROM igs_ad_recruit_pi

541: probability_type_code_id,
542: calculation_date,
543: probability_value,
544: probability_source_code_id
545: FROM igs_ad_recruit_pi
546: WHERE rowid = x_rowid
547: FOR UPDATE NOWAIT;
548:
549: tlinfo c1%ROWTYPE;

Line 643: UPDATE igs_ad_recruit_pi

639: x_last_updated_by => x_last_updated_by,
640: x_last_update_login => x_last_update_login
641: );
642:
643: UPDATE igs_ad_recruit_pi
644: SET
645: person_id = new_references.person_id,
646: probability_type_code_id = new_references.probability_type_code_id,
647: calculation_date = new_references.calculation_date,

Line 683: FROM igs_ad_recruit_pi

679: || (reverse chronological order - newest change first)
680: */
681: CURSOR c1 IS
682: SELECT rowid
683: FROM igs_ad_recruit_pi
684: WHERE probability_index_id = x_probability_index_id;
685:
686: BEGIN
687:

Line 740: DELETE FROM igs_ad_recruit_pi

736: p_action => 'DELETE',
737: x_rowid => x_rowid
738: );
739:
740: DELETE FROM igs_ad_recruit_pi
741: WHERE rowid = x_rowid;
742:
743: IF (SQL%NOTFOUND) THEN
744: RAISE NO_DATA_FOUND;

Line 750: END igs_ad_recruit_pi_pkg;

746:
747: END delete_row;
748:
749:
750: END igs_ad_recruit_pi_pkg;