APPS.IGS_EN_SPLACEMENTS_API dependencies on IGS_EN_SPLACE_SUPS

Line 6: Select rowid from IGS_EN_SPLACE_SUPS where Splacement_id=c_splacement_id

2: /* $Header: IGSENB0B.pls 120.2 2005/10/02 23:47:37 appldev ship $ */
3:
4: --cursor to retrieve rowid forgiven SplacementId and SupervisorId
5: Cursor cur_sp(c_splacement_id NUMBER, c_supervisor_id NUMBER) IS
6: Select rowid from IGS_EN_SPLACE_SUPS where Splacement_id=c_splacement_id
7: and supervisor_id=c_supervisor_id;
8:
9:
10: FUNCTION create_plcmnt_sup (

Line 502: -- Deletes supervisor from IGS_EN_SPLACE_SUPS

498: PROCEDURE delete_supervisor_info(p_splacement_id IN NUMBER, p_supervisor_id IN NUMBER)
499: IS
500: /*--------------------------------------------------------------
501: -- rvangala 01-NOV-2003 Created
502: -- Deletes supervisor from IGS_EN_SPLACE_SUPS
503: --
504: --
505: ----------------------------------------------------------------
506: */

Line 512: igs_en_splace_sups_pkg.DELETE_ROW(l_row_id);

508: BEGIN
509: OPEN cur_sp(p_splacement_id,p_supervisor_id);
510: FETCH cur_sp INTO l_row_id;
511: IF cur_sp%FOUND THEN
512: igs_en_splace_sups_pkg.DELETE_ROW(l_row_id);
513: END IF;
514: CLOSE cur_sp;
515: END delete_supervisor_info;
516:

Line 566: igs_en_splace_sups_pkg.INSERT_ROW(

562: OPEN cur_sp(p_splacement_id,p_person_id);
563: FETCH cur_sp INTO l_rowid;
564:
565: IF cur_sp%NOTFOUND THEN
566: igs_en_splace_sups_pkg.INSERT_ROW(
567: x_rowid => l_rowid,
568: x_splacement_id => p_splacement_id,
569: x_supervisor_id => l_person_id,
570: x_mode => l_mode);