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_IMP_025 dependencies on IGS_PE_PRIV_LEVEL

Line 1753: l_grp_id igs_pe_priv_level.data_group_id%TYPE;

1749: l_enable_log VARCHAR2(1);
1750: l_request_id NUMBER;
1751: l_app VARCHAR2(50);
1752: l_message_name VARCHAR2(30);
1753: l_grp_id igs_pe_priv_level.data_group_id%TYPE;
1754: l_lvl igs_pe_priv_level.lvl%TYPE;
1755:
1756: --Pick up the records for processing from the privacy details interface table.
1757: CURSOR privacy_cur(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE)

Line 1754: l_lvl igs_pe_priv_level.lvl%TYPE;

1750: l_request_id NUMBER;
1751: l_app VARCHAR2(50);
1752: l_message_name VARCHAR2(30);
1753: l_grp_id igs_pe_priv_level.data_group_id%TYPE;
1754: l_lvl igs_pe_priv_level.lvl%TYPE;
1755:
1756: --Pick up the records for processing from the privacy details interface table.
1757: CURSOR privacy_cur(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE)
1758: IS

Line 1768: CURSOR chk_dup_privacy_cur(cp_person_id igs_pe_priv_level.person_id%TYPE,

1764: i.interface_run_id = cp_interface_run_id AND
1765: ai.interface_run_id = cp_interface_run_id;
1766:
1767: --Cursor to check whether the record in interface table already exists in OSS table
1768: CURSOR chk_dup_privacy_cur(cp_person_id igs_pe_priv_level.person_id%TYPE,
1769: cp_data_group igs_pe_priv_level.data_group%TYPE,
1770: cp_start_dt igs_pe_priv_level.start_date%TYPE)
1771: IS
1772: SELECT p.rowid, p.*

Line 1769: cp_data_group igs_pe_priv_level.data_group%TYPE,

1765: ai.interface_run_id = cp_interface_run_id;
1766:
1767: --Cursor to check whether the record in interface table already exists in OSS table
1768: CURSOR chk_dup_privacy_cur(cp_person_id igs_pe_priv_level.person_id%TYPE,
1769: cp_data_group igs_pe_priv_level.data_group%TYPE,
1770: cp_start_dt igs_pe_priv_level.start_date%TYPE)
1771: IS
1772: SELECT p.rowid, p.*
1773: FROM igs_pe_priv_level p

Line 1770: cp_start_dt igs_pe_priv_level.start_date%TYPE)

1766:
1767: --Cursor to check whether the record in interface table already exists in OSS table
1768: CURSOR chk_dup_privacy_cur(cp_person_id igs_pe_priv_level.person_id%TYPE,
1769: cp_data_group igs_pe_priv_level.data_group%TYPE,
1770: cp_start_dt igs_pe_priv_level.start_date%TYPE)
1771: IS
1772: SELECT p.rowid, p.*
1773: FROM igs_pe_priv_level p
1774: WHERE p.person_id = cp_person_id AND

Line 1773: FROM igs_pe_priv_level p

1769: cp_data_group igs_pe_priv_level.data_group%TYPE,
1770: cp_start_dt igs_pe_priv_level.start_date%TYPE)
1771: IS
1772: SELECT p.rowid, p.*
1773: FROM igs_pe_priv_level p
1774: WHERE p.person_id = cp_person_id AND
1775: p.data_group = cp_data_group AND
1776: p.start_date = cp_start_dt;
1777:

Line 1783: p_grp_id IN igs_pe_priv_level.data_group_id%TYPE)

1779: chk_dup_privacy_cur_rec chk_dup_privacy_cur%ROWTYPE;
1780:
1781: -- Local procedure crt_pe_priv_dtls for inserting new records in the OSS table.
1782: PROCEDURE crt_pe_priv_dtls(p_priv_rec IN privacy_cur%ROWTYPE,
1783: p_grp_id IN igs_pe_priv_level.data_group_id%TYPE)
1784: /*
1785: || Created By : nsidana
1786: || Created On : 9/7/2004
1787: || Purpose : Local procedure to create a new privacy record.

Line 1796: l_privacy_level_id igs_pe_priv_level.privacy_level_id%TYPE;

1792: || nsidana 9/7/2004 Created
1793: */
1794: AS
1795: l_rowid VARCHAR2(25);
1796: l_privacy_level_id igs_pe_priv_level.privacy_level_id%TYPE;
1797: l_error_code igs_pe_privacy_int.error_code%TYPE;
1798: l_org_id NUMBER(15);
1799:
1800: BEGIN

Line 1815: igs_pe_priv_level_pkg.insert_row(

1811:
1812: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1813: END IF;
1814:
1815: igs_pe_priv_level_pkg.insert_row(
1816: x_rowid => l_rowid,
1817: x_privacy_level_id => l_privacy_level_id,
1818: x_person_id => p_priv_rec.person_id,
1819: x_data_group => p_priv_rec.data_group,

Line 1900: igs_pe_priv_level_pkg.update_row (x_rowid => p_oss_rec.rowid,

1896:
1897: BEGIN
1898: SAVEPOINT before_update;
1899:
1900: igs_pe_priv_level_pkg.update_row (x_rowid => p_oss_rec.rowid,
1901: x_privacy_level_id => p_oss_rec.privacy_level_id,
1902: x_person_id => p_oss_rec.person_id,
1903: x_data_group => p_oss_rec.data_group,
1904: x_data_group_id => p_oss_rec.data_group_id,

Line 1970: p_group_id OUT NOCOPY igs_pe_priv_level.data_group_id%TYPE)

1966:
1967: -- Local function to validate the record in the interfce table.
1968: FUNCTION validate_record(p_priv_rec IN privacy_cur%ROWTYPE,
1969: p_mode IN VARCHAR2,
1970: p_group_id OUT NOCOPY igs_pe_priv_level.data_group_id%TYPE)
1971: RETURN BOOLEAN
1972: /*
1973: || Created By : nsidana
1974: || Created On : 9/7/2004

Line 1983: CURSOR chk_data_group_for_ins(cp_data_group igs_pe_priv_level.data_group%TYPE)

1979: || (reverse chronological order - newest change first)
1980: || nsidana 9/7/2004 Created
1981: */
1982: IS
1983: CURSOR chk_data_group_for_ins(cp_data_group igs_pe_priv_level.data_group%TYPE)
1984: IS
1985: SELECT lvl, data_group_id
1986: FROM igs_pe_data_groups
1987: WHERE data_group = cp_data_group AND

Line 1990: CURSOR chk_data_group_for_upd(cp_data_group igs_pe_priv_level.data_group%TYPE)

1986: FROM igs_pe_data_groups
1987: WHERE data_group = cp_data_group AND
1988: closed_ind = 'N';
1989:
1990: CURSOR chk_data_group_for_upd(cp_data_group igs_pe_priv_level.data_group%TYPE)
1991: IS
1992: SELECT lvl, data_group_id
1993: FROM igs_pe_data_groups
1994: WHERE data_group = cp_data_group;

Line 2135: FROM igs_pe_priv_level pi, igs_ad_interface_all ai

2131: WHERE phi.status = '2' AND
2132: phi.interface_run_id = l_interface_run_id AND
2133: EXISTS
2134: (SELECT 1
2135: FROM igs_pe_priv_level pi, igs_ad_interface_all ai
2136: WHERE phi.interface_id = ai.interface_id AND
2137: ai.interface_run_id = l_interface_run_id AND
2138: ai.person_id = pi.person_id AND
2139: pi.data_group = UPPER(phi.data_group) AND

Line 2173: FROM igs_pe_priv_level pi, igs_ad_interface_all ai

2169: phi.interface_run_id = l_interface_run_id AND
2170: phi.match_ind IS NULL AND
2171: EXISTS
2172: (SELECT 1
2173: FROM igs_pe_priv_level pi, igs_ad_interface_all ai
2174: WHERE phi.interface_id = ai.interface_id AND
2175: ai.interface_run_id = l_interface_run_id AND
2176: pi.person_id = ai.person_id AND
2177: pi.data_group = UPPER(phi.data_group) AND

Line 2193: FROM igs_pe_priv_level pi, igs_ad_interface_all ai

2189: UPDATE igs_pe_privacy_int phi
2190: SET status = 3,
2191: match_ind = 20,
2192: dup_privacy_level_id = (SELECT pi.privacy_level_id
2193: FROM igs_pe_priv_level pi, igs_ad_interface_all ai
2194: WHERE ai.interface_id = phi.interface_id AND
2195: ai.interface_run_id = l_interface_run_id AND
2196: ai.person_id = pi.person_id AND
2197: UPPER(phi.data_group) = pi.data_group AND

Line 2204: FROM igs_pe_priv_level pi, igs_ad_interface_all ai

2200: phi.interface_run_id = l_interface_run_id AND
2201: phi.match_ind IS NULL AND
2202: EXISTS
2203: (SELECT 1
2204: FROM igs_pe_priv_level pi, igs_ad_interface_all ai
2205: WHERE ai.interface_run_id = l_interface_run_id AND
2206: ai.interface_id = phi.interface_id AND
2207: ai.person_id = pi.person_id AND
2208: UPPER(phi.data_group) = pi.data_group AND