DBA Data[Home] [Help]

APPS.IGR_GEN_001 dependencies on IGR_I_A_PKGITM_PKG

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 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 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,