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.IGR_GEN_001 dependencies on IGR_I_A_PKGITM

Line 143: CURSOR c_eapmpi ( cp_person_id igr_i_a_pkgitm.person_id%TYPE,

139:
140:
141: --Cursor to check if there are any unsent (Mailed Date Null) available for the current Inquiry Instance.
142: --Modified the cursor to fetch the Inquiry Instances having at least Package Item's Mailed Date as NULL. Bug:2664699
143: CURSOR c_eapmpi ( cp_person_id igr_i_a_pkgitm.person_id%TYPE,
144: cp_enquiry_appl_number igr_i_a_pkgitm.enquiry_appl_number%TYPE) IS
145: SELECT 'X'
146: FROM igr_i_a_pkgitm eapmpi,
147: igr_i_pkg_items_v epi

Line 144: cp_enquiry_appl_number igr_i_a_pkgitm.enquiry_appl_number%TYPE) IS

140:
141: --Cursor to check if there are any unsent (Mailed Date Null) available for the current Inquiry Instance.
142: --Modified the cursor to fetch the Inquiry Instances having at least Package Item's Mailed Date as NULL. Bug:2664699
143: CURSOR c_eapmpi ( cp_person_id igr_i_a_pkgitm.person_id%TYPE,
144: cp_enquiry_appl_number igr_i_a_pkgitm.enquiry_appl_number%TYPE) IS
145: SELECT 'X'
146: FROM igr_i_a_pkgitm eapmpi,
147: igr_i_pkg_items_v epi
148: WHERE eapmpi.person_id = cp_person_id AND

Line 146: FROM igr_i_a_pkgitm eapmpi,

142: --Modified the cursor to fetch the Inquiry Instances having at least Package Item's Mailed Date as NULL. Bug:2664699
143: CURSOR c_eapmpi ( cp_person_id igr_i_a_pkgitm.person_id%TYPE,
144: cp_enquiry_appl_number igr_i_a_pkgitm.enquiry_appl_number%TYPE) IS
145: SELECT 'X'
146: FROM igr_i_a_pkgitm eapmpi,
147: igr_i_pkg_items_v epi
148: WHERE eapmpi.person_id = cp_person_id AND
149: eapmpi.enquiry_appl_number = cp_enquiry_appl_number AND
150: eapmpi.mailed_dt IS NULL AND

Line 156: CURSOR c_eapmpi_epi ( cp_person_id igr_i_a_pkgitm.person_id%TYPE,

152:
153:
154: -- Modified the following cursor as part of build of CRM recruitment changes. Bug: 2664699
155: -- Modified to verify the Non-Availability of package item depending on the available date range.
156: CURSOR c_eapmpi_epi ( cp_person_id igr_i_a_pkgitm.person_id%TYPE,
157: cp_enquiry_appl_number igr_i_a_pkgitm.enquiry_appl_number%TYPE) IS
158: SELECT 'X'
159: FROM igr_i_a_pkgitm eapmpi,
160: igr_i_pkg_items_v epi

Line 157: cp_enquiry_appl_number igr_i_a_pkgitm.enquiry_appl_number%TYPE) IS

153:
154: -- Modified the following cursor as part of build of CRM recruitment changes. Bug: 2664699
155: -- Modified to verify the Non-Availability of package item depending on the available date range.
156: CURSOR c_eapmpi_epi ( cp_person_id igr_i_a_pkgitm.person_id%TYPE,
157: cp_enquiry_appl_number igr_i_a_pkgitm.enquiry_appl_number%TYPE) IS
158: SELECT 'X'
159: FROM igr_i_a_pkgitm eapmpi,
160: igr_i_pkg_items_v epi
161: WHERE eapmpi.person_id = cp_person_id AND

Line 159: FROM igr_i_a_pkgitm eapmpi,

155: -- Modified to verify the Non-Availability of package item depending on the available date range.
156: CURSOR c_eapmpi_epi ( cp_person_id igr_i_a_pkgitm.person_id%TYPE,
157: cp_enquiry_appl_number igr_i_a_pkgitm.enquiry_appl_number%TYPE) IS
158: SELECT 'X'
159: FROM igr_i_a_pkgitm eapmpi,
160: igr_i_pkg_items_v epi
161: WHERE eapmpi.person_id = cp_person_id AND
162: eapmpi.enquiry_appl_number = cp_enquiry_appl_number AND
163: eapmpi.mailed_dt IS NULL AND

Line 170: CURSOR c_eapmpi_get_epi ( cp_person_id igr_i_a_pkgitm.person_id%TYPE,

166: epi.actual_avail_to_date < SYSDATE);
167:
168: -- Modified the following cursor as part of build of CRM recruitment changes. Bug: 2664699
169: -- Modified to verify the Availability of package item depending on the available date range.
170: CURSOR c_eapmpi_get_epi ( cp_person_id igr_i_a_pkgitm.person_id%TYPE,
171: cp_enquiry_appl_number igr_i_a_pkgitm.enquiry_appl_number%TYPE) IS
172: SELECT 'X'
173: FROM igr_i_a_pkgitm eapmpi,
174: igr_i_pkg_items_v epi

Line 171: cp_enquiry_appl_number igr_i_a_pkgitm.enquiry_appl_number%TYPE) IS

167:
168: -- Modified the following cursor as part of build of CRM recruitment changes. Bug: 2664699
169: -- Modified to verify the Availability of package item depending on the available date range.
170: CURSOR c_eapmpi_get_epi ( cp_person_id igr_i_a_pkgitm.person_id%TYPE,
171: cp_enquiry_appl_number igr_i_a_pkgitm.enquiry_appl_number%TYPE) IS
172: SELECT 'X'
173: FROM igr_i_a_pkgitm eapmpi,
174: igr_i_pkg_items_v epi
175: WHERE eapmpi.person_id = cp_person_id AND

Line 173: FROM igr_i_a_pkgitm eapmpi,

169: -- Modified to verify the Availability of package item depending on the available date range.
170: CURSOR c_eapmpi_get_epi ( cp_person_id igr_i_a_pkgitm.person_id%TYPE,
171: cp_enquiry_appl_number igr_i_a_pkgitm.enquiry_appl_number%TYPE) IS
172: SELECT 'X'
173: FROM igr_i_a_pkgitm eapmpi,
174: igr_i_pkg_items_v epi
175: WHERE eapmpi.person_id = cp_person_id AND
176: eapmpi.enquiry_appl_number = cp_enquiry_appl_number AND
177: eapmpi.mailed_dt IS NULL AND

Line 188: cp_person_id igr_i_a_pkgitm.person_id%TYPE,

184: /** IDOPA2 New cursors added to take care of package items if p_inq_info_type is not null **/
185:
186: -- Modified the following cursor as part of build of CRM recruitment changes. Bug: 2664699
187: CURSOR c_pkgitems_exist (
188: cp_person_id igr_i_a_pkgitm.person_id%TYPE,
189: cp_enquiry_appl_number igr_i_a_pkgitm.enquiry_appl_number%TYPE) IS
190: SELECT 'X'
191: FROM igr_i_a_pkgitm eapmpi, --Transaction table holding Package items of the inquiry instance
192: igr_i_pkg_items_v epi --Setup (joined with CRM setup to hold all the attributes of Packge Items)

Line 189: cp_enquiry_appl_number igr_i_a_pkgitm.enquiry_appl_number%TYPE) IS

185:
186: -- Modified the following cursor as part of build of CRM recruitment changes. Bug: 2664699
187: CURSOR c_pkgitems_exist (
188: cp_person_id igr_i_a_pkgitm.person_id%TYPE,
189: cp_enquiry_appl_number igr_i_a_pkgitm.enquiry_appl_number%TYPE) IS
190: SELECT 'X'
191: FROM igr_i_a_pkgitm eapmpi, --Transaction table holding Package items of the inquiry instance
192: igr_i_pkg_items_v epi --Setup (joined with CRM setup to hold all the attributes of Packge Items)
193: WHERE eapmpi.person_id = cp_person_id AND

Line 191: FROM igr_i_a_pkgitm eapmpi, --Transaction table holding Package items of the inquiry instance

187: CURSOR c_pkgitems_exist (
188: cp_person_id igr_i_a_pkgitm.person_id%TYPE,
189: cp_enquiry_appl_number igr_i_a_pkgitm.enquiry_appl_number%TYPE) IS
190: SELECT 'X'
191: FROM igr_i_a_pkgitm eapmpi, --Transaction table holding Package items of the inquiry instance
192: igr_i_pkg_items_v epi --Setup (joined with CRM setup to hold all the attributes of Packge Items)
193: WHERE eapmpi.person_id = cp_person_id AND
194: eapmpi.enquiry_appl_number = cp_enquiry_appl_number AND
195: eapmpi.mailed_dt IS NULL AND

Line 202: cp_person_id igr_i_a_pkgitm.person_id%TYPE,

198:
199: --Cursor to fetch the inquiry instances having the UNSENT (Mailed Date as NULL) package items for the
200: --given enquiry instance. Added as part of Bug: 2664699
201: CURSOR c_pkgitems_exist_more (
202: cp_person_id igr_i_a_pkgitm.person_id%TYPE,
203: cp_enquiry_appl_number igr_i_a_pkgitm.enquiry_appl_number%TYPE) IS
204: SELECT 'X'
205: FROM igr_i_a_pkgitm eapmpi, --Transaction table (Inquiry Instance table holding Package items)
206: igr_i_pkg_items_v epi

Line 203: cp_enquiry_appl_number igr_i_a_pkgitm.enquiry_appl_number%TYPE) IS

199: --Cursor to fetch the inquiry instances having the UNSENT (Mailed Date as NULL) package items for the
200: --given enquiry instance. Added as part of Bug: 2664699
201: CURSOR c_pkgitems_exist_more (
202: cp_person_id igr_i_a_pkgitm.person_id%TYPE,
203: cp_enquiry_appl_number igr_i_a_pkgitm.enquiry_appl_number%TYPE) IS
204: SELECT 'X'
205: FROM igr_i_a_pkgitm eapmpi, --Transaction table (Inquiry Instance table holding Package items)
206: igr_i_pkg_items_v epi
207: WHERE eapmpi.person_id = cp_person_id AND

Line 205: FROM igr_i_a_pkgitm eapmpi, --Transaction table (Inquiry Instance table holding Package items)

201: CURSOR c_pkgitems_exist_more (
202: cp_person_id igr_i_a_pkgitm.person_id%TYPE,
203: cp_enquiry_appl_number igr_i_a_pkgitm.enquiry_appl_number%TYPE) IS
204: SELECT 'X'
205: FROM igr_i_a_pkgitm eapmpi, --Transaction table (Inquiry Instance table holding Package items)
206: igr_i_pkg_items_v epi
207: WHERE eapmpi.person_id = cp_person_id AND
208: eapmpi.enquiry_appl_number = cp_enquiry_appl_number AND
209: eapmpi.mailed_dt IS NULL AND

Line 218: cp_person_id igr_i_a_pkgitm.person_id%TYPE,

214:
215: -- Modified the following cursor as part of build of CRM recruitment changes. Bug: 2664699
216: -- The following cursor if returns Row(s) then it means that the corresponding Package Item(s) are Available.
217: CURSOR c_pkgitems_avail (
218: cp_person_id igr_i_a_pkgitm.person_id%TYPE,
219: cp_enquiry_appl_number igr_i_a_pkgitm.enquiry_appl_number%TYPE) IS
220: SELECT 'X'
221: FROM igr_i_a_pkgitm eapmpi,
222: igr_i_pkg_items_v epi

Line 219: cp_enquiry_appl_number igr_i_a_pkgitm.enquiry_appl_number%TYPE) IS

215: -- Modified the following cursor as part of build of CRM recruitment changes. Bug: 2664699
216: -- The following cursor if returns Row(s) then it means that the corresponding Package Item(s) are Available.
217: CURSOR c_pkgitems_avail (
218: cp_person_id igr_i_a_pkgitm.person_id%TYPE,
219: cp_enquiry_appl_number igr_i_a_pkgitm.enquiry_appl_number%TYPE) IS
220: SELECT 'X'
221: FROM igr_i_a_pkgitm eapmpi,
222: igr_i_pkg_items_v epi
223: WHERE eapmpi.person_id = cp_person_id AND

Line 221: FROM igr_i_a_pkgitm eapmpi,

217: CURSOR c_pkgitems_avail (
218: cp_person_id igr_i_a_pkgitm.person_id%TYPE,
219: cp_enquiry_appl_number igr_i_a_pkgitm.enquiry_appl_number%TYPE) IS
220: SELECT 'X'
221: FROM igr_i_a_pkgitm eapmpi,
222: igr_i_pkg_items_v epi
223: WHERE eapmpi.person_id = cp_person_id AND
224: eapmpi.enquiry_appl_number = cp_enquiry_appl_number AND
225: eapmpi.mailed_dt IS NULL AND

Line 232: cp_person_id igr_i_a_pkgitm.person_id%TYPE,

228: epi.actual_avail_to_date < SYSDATE);
229:
230: --Cursor to get the AVAILABLE package Items for the given Inquiry Instance.Bug: 2664699
231: CURSOR c_pkgitems_get_avail (
232: cp_person_id igr_i_a_pkgitm.person_id%TYPE,
233: cp_enquiry_appl_number igr_i_a_pkgitm.enquiry_appl_number%TYPE) IS
234: SELECT 'X'
235: FROM igr_i_a_pkgitm eapmpi,
236: igr_i_pkg_items_v epi

Line 233: cp_enquiry_appl_number igr_i_a_pkgitm.enquiry_appl_number%TYPE) IS

229:
230: --Cursor to get the AVAILABLE package Items for the given Inquiry Instance.Bug: 2664699
231: CURSOR c_pkgitems_get_avail (
232: cp_person_id igr_i_a_pkgitm.person_id%TYPE,
233: cp_enquiry_appl_number igr_i_a_pkgitm.enquiry_appl_number%TYPE) IS
234: SELECT 'X'
235: FROM igr_i_a_pkgitm eapmpi,
236: igr_i_pkg_items_v epi
237: WHERE eapmpi.person_id = cp_person_id AND

Line 235: FROM igr_i_a_pkgitm eapmpi,

231: CURSOR c_pkgitems_get_avail (
232: cp_person_id igr_i_a_pkgitm.person_id%TYPE,
233: cp_enquiry_appl_number igr_i_a_pkgitm.enquiry_appl_number%TYPE) IS
234: SELECT 'X'
235: FROM igr_i_a_pkgitm eapmpi,
236: igr_i_pkg_items_v epi
237: WHERE eapmpi.person_id = cp_person_id AND
238: eapmpi.enquiry_appl_number = cp_enquiry_appl_number AND
239: eapmpi.mailed_dt IS NULL AND

Line 255: p_person_id igr_i_a_pkgitm.person_id%TYPE,

251:
252: /** IDOPA2 New cursors added to take care of package items if p_inq_info_type is not null **/
253:
254: PROCEDURE update_mailed_dt (
255: p_person_id igr_i_a_pkgitm.person_id%TYPE,
256: p_enquiry_appl_number igr_i_a_pkgitm.enquiry_appl_number%TYPE,
257: p_mailed_dt igr_i_a_pkgitm.mailed_dt%TYPE)
258: IS
259: /****************************************************************************

Line 256: p_enquiry_appl_number igr_i_a_pkgitm.enquiry_appl_number%TYPE,

252: /** IDOPA2 New cursors added to take care of package items if p_inq_info_type is not null **/
253:
254: PROCEDURE update_mailed_dt (
255: p_person_id igr_i_a_pkgitm.person_id%TYPE,
256: p_enquiry_appl_number igr_i_a_pkgitm.enquiry_appl_number%TYPE,
257: p_mailed_dt igr_i_a_pkgitm.mailed_dt%TYPE)
258: IS
259: /****************************************************************************
260: Created By :

Line 257: p_mailed_dt igr_i_a_pkgitm.mailed_dt%TYPE)

253:
254: PROCEDURE update_mailed_dt (
255: p_person_id igr_i_a_pkgitm.person_id%TYPE,
256: p_enquiry_appl_number igr_i_a_pkgitm.enquiry_appl_number%TYPE,
257: p_mailed_dt igr_i_a_pkgitm.mailed_dt%TYPE)
258: IS
259: /****************************************************************************
260: Created By :
261: Date Created On :

Line 275: FROM igr_i_a_pkgitm eapmpi,

271:
272: -- Modified the following cursor as part of build of CRM recruitment changes. Bug: 2664699
273: CURSOR c_eapmpi_epi IS
274: SELECT eapmpi.ROWID, eapmpi.*
275: FROM igr_i_a_pkgitm eapmpi,
276: igr_i_pkg_items_v epi -- Package Items setup view
277: WHERE eapmpi.person_id = p_person_id AND
278: eapmpi.enquiry_appl_number = p_enquiry_appl_number AND
279: eapmpi.mailed_dt IS NULL AND

Line 293: igr_i_a_pkgitm_pkg.update_row (

289: l_action VARCHAR2(255);
290: BEGIN
291: FOR rec_igs_in_applml_pkgitm IN c_eapmpi_epi LOOP
292:
293: igr_i_a_pkgitm_pkg.update_row (
294: X_Mode => 'R',
295: X_RowId => rec_igs_in_applml_pkgitm.rowid,
296: X_Person_Id => rec_igs_in_applml_pkgitm.person_id,
297: X_Enquiry_Appl_Number => rec_igs_in_applml_pkgitm.enquiry_appl_number,

Line 1604: -- Description: This routine will delete all IGR_I_A_PKGITM records

1600: *****************************************************************************/
1601:
1602:
1603: BEGIN -- admp_del_eap_eitpi
1604: -- Description: This routine will delete all IGR_I_A_PKGITM records
1605: -- associated with an IGR_I_A_ITYPE record which is being deleted.
1606: DECLARE
1607: v_message_name VARCHAR2(30);
1608: e_resource_busy_exception EXCEPTION;

Line 1640: FROM IGR_I_A_PKGITM eapmpi

1636:
1637: CURSOR c_eapmpi_del(
1638: cp_package_item_id AMS_DELIV_KIT_ITEMS.deliverable_kit_part_id%TYPE) IS
1639: SELECT ROWID, eapmpi.*
1640: FROM IGR_I_A_PKGITM eapmpi
1641: WHERE eapmpi.person_id = p_person_id AND
1642: eapmpi.enquiry_appl_number = p_enquiry_appl_number AND
1643: eapmpi.package_item_id = cp_package_item_id
1644: FOR UPDATE OF eapmpi.person_id NOWAIT;

Line 1680: IGR_I_A_PKGITM_PKG.DELETE_ROW (

1676: BEGIN
1677: --No matches found so record can be deleted.
1678: FOR v_eapmpi_del IN c_eapmpi_del(
1679: v_eitpi_rec.deliverable_kit_part_id) LOOP
1680: IGR_I_A_PKGITM_PKG.DELETE_ROW (
1681: X_ROWID => V_EAPMPI_DEL.ROWID );
1682: END LOOP;
1683: EXCEPTION
1684: WHEN e_resource_busy_exception THEN

Line 1727: -- Insert records into the IGR_I_A_PKGITMtable for a nominated

1723: lv_msg_data VARCHAR2(2000);
1724: lv_msg_count NUMBER;
1725: l_action VARCHAR2(10);
1726: BEGIN -- admp_ins_eap_eitpi
1727: -- Insert records into the IGR_I_A_PKGITMtable for a nominated
1728: -- IGS_IN_ENQ_INFO_TYPE.
1729: DECLARE
1730: v_message_name varchar2(30);
1731: v_dummy VARCHAR2(1);

Line 1747: IGR_I_A_PKGITM.package_item_id%TYPE) IS

1743:
1744:
1745: CURSOR c_eapmpi_exists (
1746: cp_package_item_id
1747: IGR_I_A_PKGITM.package_item_id%TYPE) IS
1748: SELECT 'x'
1749: FROM IGR_I_A_PKGITM eapmpi
1750: WHERE eapmpi.person_id = p_person_id AND
1751: eapmpi.enquiry_appl_number = p_enquiry_appl_number AND

Line 1749: FROM IGR_I_A_PKGITM eapmpi

1745: CURSOR c_eapmpi_exists (
1746: cp_package_item_id
1747: IGR_I_A_PKGITM.package_item_id%TYPE) IS
1748: SELECT 'x'
1749: FROM IGR_I_A_PKGITM eapmpi
1750: WHERE eapmpi.person_id = p_person_id AND
1751: eapmpi.enquiry_appl_number = p_enquiry_appl_number AND
1752: eapmpi.package_item_id = cp_package_item_id;
1753: lv_rowid VARCHAR2(25);

Line 1777: -- IGR_I_A_PKGITMtable.

1773: -- enquiry information type. Join to the IGS_IN_ENQ_PKG_ITEM table to
1774: -- ensure that the package item is not closed.
1775: FOR v_eitpi_rec IN c_eitpi LOOP
1776: -- Check that the package item is not already defined in the
1777: -- IGR_I_A_PKGITMtable.
1778: OPEN c_eapmpi_exists (
1779: v_eitpi_rec.deliverable_kit_part_id);
1780: FETCH c_eapmpi_exists INTO v_dummy;
1781: IF c_eapmpi_exists%NOTFOUND THEN

Line 1783: IGR_I_A_PKGITM_Pkg.Insert_Row (

1779: v_eitpi_rec.deliverable_kit_part_id);
1780: FETCH c_eapmpi_exists INTO v_dummy;
1781: IF c_eapmpi_exists%NOTFOUND THEN
1782: CLOSE c_eapmpi_exists;
1783: IGR_I_A_PKGITM_Pkg.Insert_Row (
1784: X_Mode => 'R',
1785: X_RowId => lv_rowid,
1786: X_Person_Id => p_person_id,
1787: X_Enquiry_Appl_Number => p_enquiry_appl_number,