DBA Data[Home] [Help]

APPS.CN_QUOTA_ASSIGN_PUB dependencies on FND_API

Line 6: COMP_PLAN_NAME CN_COMP_PLANS.NAME%TYPE := FND_API.G_MISS_CHAR,

2: /*$Header: cnpqtass.pls 120.3 2005/11/08 03:23:17 kjayapau noship $*/
3:
4: TYPE quota_assign_rec_type IS RECORD
5: (
6: COMP_PLAN_NAME CN_COMP_PLANS.NAME%TYPE := FND_API.G_MISS_CHAR,
7: QUOTA_NAME CN_QUOTAS.NAME%TYPE := FND_API.G_MISS_CHAR,
8: QUOTA_SEQUENCE CN_QUOTA_ASSIGNS.QUOTA_SEQUENCE%TYPE := FND_API.G_MISS_NUM,
9: ORG_ID CN_QUOTAS.ORG_ID%TYPE,
10: OLD_QUOTA_NAME CN_QUOTAS.NAME%TYPE := FND_API.G_MISS_CHAR

Line 7: QUOTA_NAME CN_QUOTAS.NAME%TYPE := FND_API.G_MISS_CHAR,

3:
4: TYPE quota_assign_rec_type IS RECORD
5: (
6: COMP_PLAN_NAME CN_COMP_PLANS.NAME%TYPE := FND_API.G_MISS_CHAR,
7: QUOTA_NAME CN_QUOTAS.NAME%TYPE := FND_API.G_MISS_CHAR,
8: QUOTA_SEQUENCE CN_QUOTA_ASSIGNS.QUOTA_SEQUENCE%TYPE := FND_API.G_MISS_NUM,
9: ORG_ID CN_QUOTAS.ORG_ID%TYPE,
10: OLD_QUOTA_NAME CN_QUOTAS.NAME%TYPE := FND_API.G_MISS_CHAR
11: );

Line 8: QUOTA_SEQUENCE CN_QUOTA_ASSIGNS.QUOTA_SEQUENCE%TYPE := FND_API.G_MISS_NUM,

4: TYPE quota_assign_rec_type IS RECORD
5: (
6: COMP_PLAN_NAME CN_COMP_PLANS.NAME%TYPE := FND_API.G_MISS_CHAR,
7: QUOTA_NAME CN_QUOTAS.NAME%TYPE := FND_API.G_MISS_CHAR,
8: QUOTA_SEQUENCE CN_QUOTA_ASSIGNS.QUOTA_SEQUENCE%TYPE := FND_API.G_MISS_NUM,
9: ORG_ID CN_QUOTAS.ORG_ID%TYPE,
10: OLD_QUOTA_NAME CN_QUOTAS.NAME%TYPE := FND_API.G_MISS_CHAR
11: );
12:

Line 10: OLD_QUOTA_NAME CN_QUOTAS.NAME%TYPE := FND_API.G_MISS_CHAR

6: COMP_PLAN_NAME CN_COMP_PLANS.NAME%TYPE := FND_API.G_MISS_CHAR,
7: QUOTA_NAME CN_QUOTAS.NAME%TYPE := FND_API.G_MISS_CHAR,
8: QUOTA_SEQUENCE CN_QUOTA_ASSIGNS.QUOTA_SEQUENCE%TYPE := FND_API.G_MISS_NUM,
9: ORG_ID CN_QUOTAS.ORG_ID%TYPE,
10: OLD_QUOTA_NAME CN_QUOTAS.NAME%TYPE := FND_API.G_MISS_CHAR
11: );
12:
13: -- Start of comments
14: -- API name : Create_Quota_Assign

Line 21: -- Default = FND_API.G_FALSE

17: -- Pre-reqs : None.
18: -- Parameters :
19: -- IN : p_api_version IN NUMBER Required
20: -- p_init_msg_list IN VARCHAR2 Optional
21: -- Default = FND_API.G_FALSE
22: -- p_commit IN VARCHAR2 Optional
23: -- Default = FND_API.G_FALSE
24: -- p_validation_level IN NUMBER Optional
25: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 23: -- Default = FND_API.G_FALSE

19: -- IN : p_api_version IN NUMBER Required
20: -- p_init_msg_list IN VARCHAR2 Optional
21: -- Default = FND_API.G_FALSE
22: -- p_commit IN VARCHAR2 Optional
23: -- Default = FND_API.G_FALSE
24: -- p_validation_level IN NUMBER Optional
25: -- Default = FND_API.G_VALID_LEVEL_FULL
26: -- p_quota_assign_rec IN quota_assign_rec_type
27: -- OUT : x_return_status OUT VARCHAR2(1)

Line 25: -- Default = FND_API.G_VALID_LEVEL_FULL

21: -- Default = FND_API.G_FALSE
22: -- p_commit IN VARCHAR2 Optional
23: -- Default = FND_API.G_FALSE
24: -- p_validation_level IN NUMBER Optional
25: -- Default = FND_API.G_VALID_LEVEL_FULL
26: -- p_quota_assign_rec IN quota_assign_rec_type
27: -- OUT : x_return_status OUT VARCHAR2(1)
28: -- x_msg_count OUT NUMBER
29: -- x_msg_data OUT VARCHAR2(2000)

Line 38: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

34: --
35: -- End of comments
36: PROCEDURE Create_Quota_Assign
37: (p_api_version IN NUMBER ,
38: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
39: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
40: p_validation_level IN NUMBER :=
41: FND_API.G_VALID_LEVEL_FULL ,
42: p_quota_assign_rec IN quota_assign_rec_type ,

Line 39: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

35: -- End of comments
36: PROCEDURE Create_Quota_Assign
37: (p_api_version IN NUMBER ,
38: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
39: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
40: p_validation_level IN NUMBER :=
41: FND_API.G_VALID_LEVEL_FULL ,
42: p_quota_assign_rec IN quota_assign_rec_type ,
43: x_return_status OUT NOCOPY VARCHAR2 ,

Line 41: FND_API.G_VALID_LEVEL_FULL ,

37: (p_api_version IN NUMBER ,
38: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
39: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
40: p_validation_level IN NUMBER :=
41: FND_API.G_VALID_LEVEL_FULL ,
42: p_quota_assign_rec IN quota_assign_rec_type ,
43: x_return_status OUT NOCOPY VARCHAR2 ,
44: x_msg_count OUT NOCOPY NUMBER ,
45: x_msg_data OUT NOCOPY VARCHAR2 );

Line 55: -- Default = FND_API.G_FALSE

51: -- Pre-reqs : None.
52: -- Parameters :
53: -- IN : p_api_version IN NUMBER Required
54: -- p_init_msg_list IN VARCHAR2 Optional
55: -- Default = FND_API.G_FALSE
56: -- p_commit IN VARCHAR2 Optional
57: -- Default = FND_API.G_FALSE
58: -- p_validation_level IN NUMBER Optional
59: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 57: -- Default = FND_API.G_FALSE

53: -- IN : p_api_version IN NUMBER Required
54: -- p_init_msg_list IN VARCHAR2 Optional
55: -- Default = FND_API.G_FALSE
56: -- p_commit IN VARCHAR2 Optional
57: -- Default = FND_API.G_FALSE
58: -- p_validation_level IN NUMBER Optional
59: -- Default = FND_API.G_VALID_LEVEL_FULL
60: -- p_quota_assign_rec IN quota_assign_rec_type
61: -- OUT : x_return_status OUT VARCHAR2(1)

Line 59: -- Default = FND_API.G_VALID_LEVEL_FULL

55: -- Default = FND_API.G_FALSE
56: -- p_commit IN VARCHAR2 Optional
57: -- Default = FND_API.G_FALSE
58: -- p_validation_level IN NUMBER Optional
59: -- Default = FND_API.G_VALID_LEVEL_FULL
60: -- p_quota_assign_rec IN quota_assign_rec_type
61: -- OUT : x_return_status OUT VARCHAR2(1)
62: -- x_msg_count OUT NUMBER
63: -- x_msg_data OUT VARCHAR2(2000)

Line 72: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

68: --
69: -- End of comments
70: PROCEDURE Update_Quota_Assign
71: (p_api_version IN NUMBER ,
72: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
73: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
74: p_validation_level IN NUMBER :=
75: FND_API.G_VALID_LEVEL_FULL ,
76: p_quota_assign_rec IN quota_assign_rec_type ,

Line 73: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

69: -- End of comments
70: PROCEDURE Update_Quota_Assign
71: (p_api_version IN NUMBER ,
72: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
73: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
74: p_validation_level IN NUMBER :=
75: FND_API.G_VALID_LEVEL_FULL ,
76: p_quota_assign_rec IN quota_assign_rec_type ,
77: x_return_status OUT NOCOPY VARCHAR2 ,

Line 75: FND_API.G_VALID_LEVEL_FULL ,

71: (p_api_version IN NUMBER ,
72: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
73: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
74: p_validation_level IN NUMBER :=
75: FND_API.G_VALID_LEVEL_FULL ,
76: p_quota_assign_rec IN quota_assign_rec_type ,
77: x_return_status OUT NOCOPY VARCHAR2 ,
78: x_msg_count OUT NOCOPY NUMBER ,
79: x_msg_data OUT NOCOPY VARCHAR2 );

Line 89: -- Default = FND_API.G_FALSE

85: -- Pre-reqs : None.
86: -- Parameters :
87: -- IN : p_api_version IN NUMBER Required
88: -- p_init_msg_list IN VARCHAR2 Optional
89: -- Default = FND_API.G_FALSE
90: -- p_commit IN VARCHAR2 Optional
91: -- Default = FND_API.G_FALSE
92: -- p_validation_level IN NUMBER Optional
93: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 91: -- Default = FND_API.G_FALSE

87: -- IN : p_api_version IN NUMBER Required
88: -- p_init_msg_list IN VARCHAR2 Optional
89: -- Default = FND_API.G_FALSE
90: -- p_commit IN VARCHAR2 Optional
91: -- Default = FND_API.G_FALSE
92: -- p_validation_level IN NUMBER Optional
93: -- Default = FND_API.G_VALID_LEVEL_FULL
94: -- p_quota_assign_rec IN quota_assign_rec_type
95: -- OUT : x_return_status OUT VARCHAR2(1)

Line 93: -- Default = FND_API.G_VALID_LEVEL_FULL

89: -- Default = FND_API.G_FALSE
90: -- p_commit IN VARCHAR2 Optional
91: -- Default = FND_API.G_FALSE
92: -- p_validation_level IN NUMBER Optional
93: -- Default = FND_API.G_VALID_LEVEL_FULL
94: -- p_quota_assign_rec IN quota_assign_rec_type
95: -- OUT : x_return_status OUT VARCHAR2(1)
96: -- x_msg_count OUT NUMBER
97: -- x_msg_data OUT VARCHAR2(2000)

Line 106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

102: --
103: -- End of comments
104: PROCEDURE Delete_Quota_Assign
105: (p_api_version IN NUMBER ,
106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
107: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
108: p_validation_level IN NUMBER :=
109: FND_API.G_VALID_LEVEL_FULL ,
110: p_quota_assign_rec IN quota_assign_rec_type ,

Line 107: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

103: -- End of comments
104: PROCEDURE Delete_Quota_Assign
105: (p_api_version IN NUMBER ,
106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
107: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
108: p_validation_level IN NUMBER :=
109: FND_API.G_VALID_LEVEL_FULL ,
110: p_quota_assign_rec IN quota_assign_rec_type ,
111: x_return_status OUT NOCOPY VARCHAR2 ,

Line 109: FND_API.G_VALID_LEVEL_FULL ,

105: (p_api_version IN NUMBER ,
106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
107: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
108: p_validation_level IN NUMBER :=
109: FND_API.G_VALID_LEVEL_FULL ,
110: p_quota_assign_rec IN quota_assign_rec_type ,
111: x_return_status OUT NOCOPY VARCHAR2 ,
112: x_msg_count OUT NOCOPY NUMBER ,
113: x_msg_data OUT NOCOPY VARCHAR2 );