DBA Data[Home] [Help]

APPS.CN_COMP_PLAN_PVT dependencies on CN_ROLE_PLANS

Line 49: ROLE_PLAN_ID CN_ROLE_PLANS.ROLE_PLAN_ID%TYPE := CN_API.G_MISS_ID,

45:
46: -- sales role
47: TYPE sales_role_rec_type IS RECORD
48: (
49: ROLE_PLAN_ID CN_ROLE_PLANS.ROLE_PLAN_ID%TYPE := CN_API.G_MISS_ID,
50: ROLE_ID CN_ROLE_PLANS.ROLE_ID%TYPE := CN_API.G_MISS_ID,
51: COMP_PLAN_ID CN_ROLE_PLANS.COMP_PLAN_ID%TYPE := CN_API.G_MISS_ID,
52: NAME CN_ROLES.NAME%TYPE := FND_API.G_MISS_CHAR,
53: DESCRIPTION CN_ROLES.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,

Line 50: ROLE_ID CN_ROLE_PLANS.ROLE_ID%TYPE := CN_API.G_MISS_ID,

46: -- sales role
47: TYPE sales_role_rec_type IS RECORD
48: (
49: ROLE_PLAN_ID CN_ROLE_PLANS.ROLE_PLAN_ID%TYPE := CN_API.G_MISS_ID,
50: ROLE_ID CN_ROLE_PLANS.ROLE_ID%TYPE := CN_API.G_MISS_ID,
51: COMP_PLAN_ID CN_ROLE_PLANS.COMP_PLAN_ID%TYPE := CN_API.G_MISS_ID,
52: NAME CN_ROLES.NAME%TYPE := FND_API.G_MISS_CHAR,
53: DESCRIPTION CN_ROLES.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,
54: START_DATE CN_ROLE_PLANS.START_DATE%TYPE := FND_API.G_MISS_DATE,

Line 51: COMP_PLAN_ID CN_ROLE_PLANS.COMP_PLAN_ID%TYPE := CN_API.G_MISS_ID,

47: TYPE sales_role_rec_type IS RECORD
48: (
49: ROLE_PLAN_ID CN_ROLE_PLANS.ROLE_PLAN_ID%TYPE := CN_API.G_MISS_ID,
50: ROLE_ID CN_ROLE_PLANS.ROLE_ID%TYPE := CN_API.G_MISS_ID,
51: COMP_PLAN_ID CN_ROLE_PLANS.COMP_PLAN_ID%TYPE := CN_API.G_MISS_ID,
52: NAME CN_ROLES.NAME%TYPE := FND_API.G_MISS_CHAR,
53: DESCRIPTION CN_ROLES.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,
54: START_DATE CN_ROLE_PLANS.START_DATE%TYPE := FND_API.G_MISS_DATE,
55: END_DATE CN_ROLE_PLANS.END_DATE%TYPE := FND_API.G_MISS_DATE,

Line 54: START_DATE CN_ROLE_PLANS.START_DATE%TYPE := FND_API.G_MISS_DATE,

50: ROLE_ID CN_ROLE_PLANS.ROLE_ID%TYPE := CN_API.G_MISS_ID,
51: COMP_PLAN_ID CN_ROLE_PLANS.COMP_PLAN_ID%TYPE := CN_API.G_MISS_ID,
52: NAME CN_ROLES.NAME%TYPE := FND_API.G_MISS_CHAR,
53: DESCRIPTION CN_ROLES.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,
54: START_DATE CN_ROLE_PLANS.START_DATE%TYPE := FND_API.G_MISS_DATE,
55: END_DATE CN_ROLE_PLANS.END_DATE%TYPE := FND_API.G_MISS_DATE,
56: OBJECT_VERSION_NUMBER CN_ROLE_PLANS.OBJECT_VERSION_NUMBER%TYPE := NULL
57: ) ;
58:

Line 55: END_DATE CN_ROLE_PLANS.END_DATE%TYPE := FND_API.G_MISS_DATE,

51: COMP_PLAN_ID CN_ROLE_PLANS.COMP_PLAN_ID%TYPE := CN_API.G_MISS_ID,
52: NAME CN_ROLES.NAME%TYPE := FND_API.G_MISS_CHAR,
53: DESCRIPTION CN_ROLES.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,
54: START_DATE CN_ROLE_PLANS.START_DATE%TYPE := FND_API.G_MISS_DATE,
55: END_DATE CN_ROLE_PLANS.END_DATE%TYPE := FND_API.G_MISS_DATE,
56: OBJECT_VERSION_NUMBER CN_ROLE_PLANS.OBJECT_VERSION_NUMBER%TYPE := NULL
57: ) ;
58:
59: TYPE sales_role_tbl_type IS

Line 56: OBJECT_VERSION_NUMBER CN_ROLE_PLANS.OBJECT_VERSION_NUMBER%TYPE := NULL

52: NAME CN_ROLES.NAME%TYPE := FND_API.G_MISS_CHAR,
53: DESCRIPTION CN_ROLES.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,
54: START_DATE CN_ROLE_PLANS.START_DATE%TYPE := FND_API.G_MISS_DATE,
55: END_DATE CN_ROLE_PLANS.END_DATE%TYPE := FND_API.G_MISS_DATE,
56: OBJECT_VERSION_NUMBER CN_ROLE_PLANS.OBJECT_VERSION_NUMBER%TYPE := NULL
57: ) ;
58:
59: TYPE sales_role_tbl_type IS
60: TABLE OF sales_role_rec_type INDEX BY BINARY_INTEGER ;