19: --
20: -- Declare cursors and local variables
21: --
22: -- out variables
23: l_profile_snapshot_id irc_apl_profile_snapshots.profile_snapshot_id%TYPE;
24: l_object_version_number irc_apl_profile_snapshots.object_version_number%TYPE;
25:
26: l_effective_date date;
27: l_proc varchar2(72) := g_package||'create_applicant_snapshot';
20: -- Declare cursors and local variables
21: --
22: -- out variables
23: l_profile_snapshot_id irc_apl_profile_snapshots.profile_snapshot_id%TYPE;
24: l_object_version_number irc_apl_profile_snapshots.object_version_number%TYPE;
25:
26: l_effective_date date;
27: l_proc varchar2(72) := g_package||'create_applicant_snapshot';
28:
148: --
149: -- Declare cursors and local variables
150: --
151: -- out variables
152: l_profile_snapshot_id irc_apl_profile_snapshots.profile_snapshot_id%TYPE;
153: l_object_version_number irc_apl_profile_snapshots.object_version_number%TYPE;
154:
155: l_effective_date date;
156: l_proc varchar2(72) := g_package||'update_applicant_snapshot';
149: -- Declare cursors and local variables
150: --
151: -- out variables
152: l_profile_snapshot_id irc_apl_profile_snapshots.profile_snapshot_id%TYPE;
153: l_object_version_number irc_apl_profile_snapshots.object_version_number%TYPE;
154:
155: l_effective_date date;
156: l_proc varchar2(72) := g_package||'update_applicant_snapshot';
157:
282: --
283: -- Declare cursors and local variables
284: --
285: -- out variables
286: l_profile_snapshot_id irc_apl_profile_snapshots.profile_snapshot_id%TYPE;
287: l_object_version_number irc_apl_profile_snapshots.object_version_number%TYPE;
288:
289: l_effective_date date;
290: l_proc varchar2(72) := g_package||'delete_applicant_snapshot';
283: -- Declare cursors and local variables
284: --
285: -- out variables
286: l_profile_snapshot_id irc_apl_profile_snapshots.profile_snapshot_id%TYPE;
287: l_object_version_number irc_apl_profile_snapshots.object_version_number%TYPE;
288:
289: l_effective_date date;
290: l_proc varchar2(72) := g_package||'delete_applicant_snapshot';
291: