DBA Data[Home] [Help]

APPS.CN_SFP_GROUP_UTIL_PVT dependencies on FND_API

Line 31: -- Default = FND_API.G_FALSE

27: -- Pre-reqs : None.
28: -- Parameters :
29: -- IN : p_api_version IN NUMBER Required
30: -- p_init_msg_list IN VARCHAR2 Optional
31: -- Default = FND_API.G_FALSE
32: -- p_commit IN VARCHAR2 Optional
33: -- Default = FND_API.G_FALSE
34: -- p_validation_level IN NUMBER Optional
35: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 33: -- Default = FND_API.G_FALSE

29: -- IN : p_api_version IN NUMBER Required
30: -- p_init_msg_list IN VARCHAR2 Optional
31: -- Default = FND_API.G_FALSE
32: -- p_commit IN VARCHAR2 Optional
33: -- Default = FND_API.G_FALSE
34: -- p_validation_level IN NUMBER Optional
35: -- Default = FND_API.G_VALID_LEVEL_FULL
36: -- p_selected_groups IN DBMS_SQL.NUMBER_TABLE,
37: -- p_effective_date

Line 35: -- Default = FND_API.G_VALID_LEVEL_FULL

31: -- Default = FND_API.G_FALSE
32: -- p_commit IN VARCHAR2 Optional
33: -- Default = FND_API.G_FALSE
34: -- p_validation_level IN NUMBER Optional
35: -- Default = FND_API.G_VALID_LEVEL_FULL
36: -- p_selected_groups IN DBMS_SQL.NUMBER_TABLE,
37: -- p_effective_date
38: -- OUT : x_return_status OUT VARCHAR2(1)
39: -- x_msg_count OUT NUMBER

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

49: -- End of comments
50:
51: PROCEDURE Get_Descendant_Groups
52: ( p_api_version IN NUMBER,
53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54: p_commit IN VARCHAR2 := FND_API.G_FALSE,
55: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
56: p_selected_groups IN grpnum_tbl_type,
57: p_effective_date IN DATE := SYSDATE,

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

50:
51: PROCEDURE Get_Descendant_Groups
52: ( p_api_version IN NUMBER,
53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54: p_commit IN VARCHAR2 := FND_API.G_FALSE,
55: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
56: p_selected_groups IN grpnum_tbl_type,
57: p_effective_date IN DATE := SYSDATE,
58: x_descendant_groups OUT NOCOPY grpnum_tbl_type,

Line 55: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

51: PROCEDURE Get_Descendant_Groups
52: ( p_api_version IN NUMBER,
53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54: p_commit IN VARCHAR2 := FND_API.G_FALSE,
55: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
56: p_selected_groups IN grpnum_tbl_type,
57: p_effective_date IN DATE := SYSDATE,
58: x_descendant_groups OUT NOCOPY grpnum_tbl_type,
59: x_return_status OUT NOCOPY VARCHAR2 ,

Line 72: -- Default = FND_API.G_FALSE

68: -- Pre-reqs : None.
69: -- Parameters :
70: -- IN : p_api_version IN NUMBER Required
71: -- p_init_msg_list IN VARCHAR2 Optional
72: -- Default = FND_API.G_FALSE
73: -- p_commit IN VARCHAR2 Optional
74: -- Default = FND_API.G_FALSE
75: -- p_validation_level IN NUMBER Optional
76: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 74: -- Default = FND_API.G_FALSE

70: -- IN : p_api_version IN NUMBER Required
71: -- p_init_msg_list IN VARCHAR2 Optional
72: -- Default = FND_API.G_FALSE
73: -- p_commit IN VARCHAR2 Optional
74: -- Default = FND_API.G_FALSE
75: -- p_validation_level IN NUMBER Optional
76: -- Default = FND_API.G_VALID_LEVEL_FULL
77: -- p_selected_groups IN DBMS_SQL.NUMBER_TABLE,
78: -- p_status IN VARCHAR2

Line 76: -- Default = FND_API.G_VALID_LEVEL_FULL

72: -- Default = FND_API.G_FALSE
73: -- p_commit IN VARCHAR2 Optional
74: -- Default = FND_API.G_FALSE
75: -- p_validation_level IN NUMBER Optional
76: -- Default = FND_API.G_VALID_LEVEL_FULL
77: -- p_selected_groups IN DBMS_SQL.NUMBER_TABLE,
78: -- p_status IN VARCHAR2
79: -- p_effective_date IN DATE
80: -- OUT : x_return_status OUT VARCHAR2(1)

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

93: -- End of comments
94:
95: PROCEDURE Get_Salesrep_Roles
96: ( p_api_version IN NUMBER,
97: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
98: p_commit IN VARCHAR2 := FND_API.G_FALSE,
99: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
100: p_selected_groups IN grpnum_tbl_type,
101: p_status IN VARCHAR2 := 'ALL',

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

94:
95: PROCEDURE Get_Salesrep_Roles
96: ( p_api_version IN NUMBER,
97: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
98: p_commit IN VARCHAR2 := FND_API.G_FALSE,
99: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
100: p_selected_groups IN grpnum_tbl_type,
101: p_status IN VARCHAR2 := 'ALL',
102: p_effective_date IN DATE := SYSDATE,

Line 99: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

95: PROCEDURE Get_Salesrep_Roles
96: ( p_api_version IN NUMBER,
97: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
98: p_commit IN VARCHAR2 := FND_API.G_FALSE,
99: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
100: p_selected_groups IN grpnum_tbl_type,
101: p_status IN VARCHAR2 := 'ALL',
102: p_effective_date IN DATE := SYSDATE,
103: x_salesrep_roles OUT NOCOPY srprole_tbl_type,

Line 118: -- Default = FND_API.G_FALSE

114: -- Pre-reqs : None.
115: -- Parameters :
116: -- IN : p_api_version IN NUMBER Required
117: -- p_init_msg_list IN VARCHAR2 Optional
118: -- Default = FND_API.G_FALSE
119: -- p_commit IN VARCHAR2 Optional
120: -- Default = FND_API.G_FALSE
121: -- p_validation_level IN NUMBER Optional
122: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 120: -- Default = FND_API.G_FALSE

116: -- IN : p_api_version IN NUMBER Required
117: -- p_init_msg_list IN VARCHAR2 Optional
118: -- Default = FND_API.G_FALSE
119: -- p_commit IN VARCHAR2 Optional
120: -- Default = FND_API.G_FALSE
121: -- p_validation_level IN NUMBER Optional
122: -- Default = FND_API.G_VALID_LEVEL_FULL
123: -- p_comp_group_id IN NUMBER,
124: -- p_effective_date IN DATE

Line 122: -- Default = FND_API.G_VALID_LEVEL_FULL

118: -- Default = FND_API.G_FALSE
119: -- p_commit IN VARCHAR2 Optional
120: -- Default = FND_API.G_FALSE
121: -- p_validation_level IN NUMBER Optional
122: -- Default = FND_API.G_VALID_LEVEL_FULL
123: -- p_comp_group_id IN NUMBER,
124: -- p_effective_date IN DATE
125: -- OUT : x_return_status OUT VARCHAR2(1)
126: -- x_msg_count OUT NUMBER

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

139: --
140: -- End of comments
141: PROCEDURE Get_Grp_Organization_Access
142: ( p_api_version IN NUMBER,
143: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
144: p_commit IN VARCHAR2 := FND_API.G_FALSE,
145: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
146: p_comp_group_id IN NUMBER,
147: p_effective_date IN DATE := SYSDATE,

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

140: -- End of comments
141: PROCEDURE Get_Grp_Organization_Access
142: ( p_api_version IN NUMBER,
143: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
144: p_commit IN VARCHAR2 := FND_API.G_FALSE,
145: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
146: p_comp_group_id IN NUMBER,
147: p_effective_date IN DATE := SYSDATE,
148: x_updview_organization OUT NOCOPY grporg_tbl_type,

Line 145: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

141: PROCEDURE Get_Grp_Organization_Access
142: ( p_api_version IN NUMBER,
143: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
144: p_commit IN VARCHAR2 := FND_API.G_FALSE,
145: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
146: p_comp_group_id IN NUMBER,
147: p_effective_date IN DATE := SYSDATE,
148: x_updview_organization OUT NOCOPY grporg_tbl_type,
149: x_upd_organization OUT NOCOPY grporg_tbl_type,