eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_MULTI_RATE_SCHEDULES_PVT dependencies on FND_API

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

62: -- 3) Validate number_dim which should equal the number of dimensions in
63: -- p_dims_tbl if it is not empty
64: PROCEDURE Create_Schedule
65: (p_api_version IN NUMBER ,
66: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
67: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
68: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
69: p_name IN CN_RATE_SCHEDULES.NAME%TYPE ,
70: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,

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

63: -- p_dims_tbl if it is not empty
64: PROCEDURE Create_Schedule
65: (p_api_version IN NUMBER ,
66: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
67: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
68: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
69: p_name IN CN_RATE_SCHEDULES.NAME%TYPE ,
70: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
71: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,

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

64: PROCEDURE Create_Schedule
65: (p_api_version IN NUMBER ,
66: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
67: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
68: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
69: p_name IN CN_RATE_SCHEDULES.NAME%TYPE ,
70: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
71: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,
72: p_dims_tbl IN dims_tbl_type := g_miss_dims_tbl,

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

88: -- 6) If this rate table is used, then update of dimensions and
89: -- commission_unit_code is not allowed
90: PROCEDURE Update_Schedule
91: (p_api_version IN NUMBER ,
92: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
93: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
94: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
95: p_rate_schedule_id IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
96: p_name IN CN_RATE_SCHEDULES.NAME%TYPE,

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

89: -- commission_unit_code is not allowed
90: PROCEDURE Update_Schedule
91: (p_api_version IN NUMBER ,
92: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
93: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
94: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
95: p_rate_schedule_id IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
96: p_name IN CN_RATE_SCHEDULES.NAME%TYPE,
97: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,

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

90: PROCEDURE Update_Schedule
91: (p_api_version IN NUMBER ,
92: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
93: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
94: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
95: p_rate_schedule_id IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
96: p_name IN CN_RATE_SCHEDULES.NAME%TYPE,
97: p_commission_unit_code IN CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE,
98: p_number_dim IN CN_RATE_SCHEDULES.NUMBER_DIM%TYPE,

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

110: -- 2) If it can be deleted, delete corresponding records in
111: -- cn_rate_sch_dims and cn_rate_tiers
112: PROCEDURE Delete_Schedule
113: (p_api_version IN NUMBER ,
114: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
115: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117: p_rate_schedule_id IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
118: --R12 MOAC Changes--Start

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

111: -- cn_rate_sch_dims and cn_rate_tiers
112: PROCEDURE Delete_Schedule
113: (p_api_version IN NUMBER ,
114: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
115: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117: p_rate_schedule_id IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
118: --R12 MOAC Changes--Start
119: p_object_version_number IN CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE, -- new

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

112: PROCEDURE Delete_Schedule
113: (p_api_version IN NUMBER ,
114: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
115: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117: p_rate_schedule_id IN CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE,
118: --R12 MOAC Changes--Start
119: p_object_version_number IN CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE, -- new
120: --R12 MOAC Changes--End

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

129: -- 4) rate_dim_sequence is not adjusted here, users should take
130: -- care of the adjustment by calling update_dimension_assign
131: PROCEDURE delete_dimension_assign
132: (p_api_version IN NUMBER ,
133: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
134: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
135: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
136: p_rate_sch_dim_id IN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE,
137: p_rate_schedule_id IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,

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

130: -- care of the adjustment by calling update_dimension_assign
131: PROCEDURE delete_dimension_assign
132: (p_api_version IN NUMBER ,
133: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
134: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
135: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
136: p_rate_sch_dim_id IN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE,
137: p_rate_schedule_id IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,
138: --R12 MOAC Changes--Start

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

131: PROCEDURE delete_dimension_assign
132: (p_api_version IN NUMBER ,
133: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
134: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
135: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
136: p_rate_sch_dim_id IN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE,
137: p_rate_schedule_id IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,
138: --R12 MOAC Changes--Start
139: p_object_version_number IN CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE, -- new

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

147: -- 2) If it can be updated, update records in cn_rate_sch_dims
148: -- and cn_rate_tiers
149: PROCEDURE update_dimension_assign
150: (p_api_version IN NUMBER ,
151: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
152: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
153: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
154: p_rate_sch_dim_id IN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE,
155: p_rate_schedule_id IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,

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

148: -- and cn_rate_tiers
149: PROCEDURE update_dimension_assign
150: (p_api_version IN NUMBER ,
151: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
152: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
153: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
154: p_rate_sch_dim_id IN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE,
155: p_rate_schedule_id IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,
156: p_rate_dimension_id IN CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE := cn_api.g_miss_num,

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

149: PROCEDURE update_dimension_assign
150: (p_api_version IN NUMBER ,
151: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
152: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
153: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
154: p_rate_sch_dim_id IN CN_RATE_SCH_DIMS.RATE_SCH_DIM_ID%TYPE,
155: p_rate_schedule_id IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,
156: p_rate_dimension_id IN CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE := cn_api.g_miss_num,
157: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE := cn_api.g_miss_num,

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

171: -- 4) rate_dim_sequence is not adjusted here, users should do it by
172: -- calling update_dimension_assign
173: PROCEDURE create_dimension_assign
174: (p_api_version IN NUMBER ,
175: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
176: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
177: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
178: p_rate_schedule_id IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,
179: p_rate_dimension_id IN CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE,

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

172: -- calling update_dimension_assign
173: PROCEDURE create_dimension_assign
174: (p_api_version IN NUMBER ,
175: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
176: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
177: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
178: p_rate_schedule_id IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,
179: p_rate_dimension_id IN CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE,
180: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,

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

173: PROCEDURE create_dimension_assign
174: (p_api_version IN NUMBER ,
175: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
176: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
177: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
178: p_rate_schedule_id IN CN_RATE_SCH_DIMS.RATE_SCHEDULE_ID%TYPE,
179: p_rate_dimension_id IN CN_RATE_SCH_DIMS.RATE_DIMENSION_ID%TYPE,
180: p_rate_dim_sequence IN CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE,
181: --R12 MOAC Changes--Start

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

248: );
249:
250: PROCEDURE duplicate_rate_Schedule
251: (p_api_version IN NUMBER ,
252: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
253: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
254: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
255: p_name IN OUT NOCOPY CN_RATE_SCHEDULES.NAME%TYPE ,
256: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new

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

249:
250: PROCEDURE duplicate_rate_Schedule
251: (p_api_version IN NUMBER ,
252: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
253: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
254: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
255: p_name IN OUT NOCOPY CN_RATE_SCHEDULES.NAME%TYPE ,
256: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new
257: --R12 MOAC Changes--End

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

250: PROCEDURE duplicate_rate_Schedule
251: (p_api_version IN NUMBER ,
252: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
253: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
254: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
255: p_name IN OUT NOCOPY CN_RATE_SCHEDULES.NAME%TYPE ,
256: p_org_id IN CN_RATE_SCHEDULES.ORG_ID%TYPE, --new
257: --R12 MOAC Changes--End
258: p_rate_schedule_id IN OUT NOCOPY CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE, --changed