DBA Data[Home] [Help]

APPS.JTF_AE_SQLUTIL_API dependencies on JTF_PROFILE_MAPPINGS_B

Line 8: p_AppID IN JTF_PROFILE_MAPPINGS_B.ownerID%TYPE,

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:

Line 9: p_userID IN JTF_PROFILE_MAPPINGS_B.created_by%TYPE) IS

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

Line 15: /* Step 1: First insert row in JTF_PROFILE_MAPPINGS_B table */

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:

Line 16: select jtf_profile_mappings_b_s1.nextVal

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(