4: -- Register a new profile for a base table
5: PROCEDURE registerProfile(
6: p_ProfileName IN JTF_PROFILE_MAPPINGS_TL.profileName%TYPE,
7: p_BaseTable IN JTF_PROFILE_MAPPINGS_TL.baseTable%TYPE,
8: p_AppID IN JTF_PROFILE_MAPPINGS_B.ownerID%TYPE,
9: p_userID IN JTF_PROFILE_MAPPINGS_B.created_by%TYPE) IS
10:
11: v_pKey NUMBER;
12:
5: PROCEDURE registerProfile(
6: p_ProfileName IN JTF_PROFILE_MAPPINGS_TL.profileName%TYPE,
7: p_BaseTable IN JTF_PROFILE_MAPPINGS_TL.baseTable%TYPE,
8: p_AppID IN JTF_PROFILE_MAPPINGS_B.ownerID%TYPE,
9: p_userID IN JTF_PROFILE_MAPPINGS_B.created_by%TYPE) IS
10:
11: v_pKey NUMBER;
12:
13: BEGIN
11: v_pKey NUMBER;
12:
13: BEGIN
14:
15: /* Step 1: First insert row in JTF_PROFILE_MAPPINGS_B table */
16: select jtf_profile_mappings_b_s1.nextVal
17: into v_pKey
18: from dual;
19:
12:
13: BEGIN
14:
15: /* Step 1: First insert row in JTF_PROFILE_MAPPINGS_B table */
16: select jtf_profile_mappings_b_s1.nextVal
17: into v_pKey
18: from dual;
19:
20: JTF_AE_PROFMAPS.INSERT_ROW(