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_RATE_DIMENSIONS_PVT dependencies on FND_API

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

25: -- tiers in p_tiers_tbl if it is not empty
26: -- 4) Validate dimension tiers (max_amount > min_amount)
27: PROCEDURE Create_Dimension
28: (p_api_version IN NUMBER ,
29: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
30: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
31: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
32: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
33: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,

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

26: -- 4) Validate dimension tiers (max_amount > min_amount)
27: PROCEDURE Create_Dimension
28: (p_api_version IN NUMBER ,
29: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
30: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
31: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
32: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
33: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
34: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,

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

27: PROCEDURE Create_Dimension
28: (p_api_version IN NUMBER ,
29: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
30: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
31: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
32: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
33: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
34: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
35: p_number_tier IN CN_RATE_DIMENSIONS.NUMBER_TIER%TYPE,

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

54: -- turn used in a formula, then dim_unit_code
55: -- can not be updated
56: PROCEDURE Update_Dimension
57: (p_api_version IN NUMBER ,
58: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
59: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
60: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
61: p_rate_dimension_id IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE,
62: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,

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

55: -- can not be updated
56: PROCEDURE Update_Dimension
57: (p_api_version IN NUMBER ,
58: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
59: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
60: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
61: p_rate_dimension_id IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE,
62: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
63: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,

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

56: PROCEDURE Update_Dimension
57: (p_api_version IN NUMBER ,
58: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
59: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
60: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
61: p_rate_dimension_id IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE,
62: p_name IN CN_RATE_DIMENSIONS.NAME%TYPE,
63: p_description IN CN_RATE_DIMENSIONS.DESCRIPTION%TYPE := NULL,
64: p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,

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

75: -- Notes : Delete rate dimensions and dimension tiers
76: -- 1) If it is used in a rate table, it can not be deleted
77: PROCEDURE Delete_Dimension
78: (p_api_version IN NUMBER ,
79: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
80: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
81: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
82: p_rate_dimension_id IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE,
83: -- R12 MOAC Changes --Start

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

76: -- 1) If it is used in a rate table, it can not be deleted
77: PROCEDURE Delete_Dimension
78: (p_api_version IN NUMBER ,
79: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
80: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
81: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
82: p_rate_dimension_id IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE,
83: -- R12 MOAC Changes --Start
84: p_object_version_number IN CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE, --new

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

77: PROCEDURE Delete_Dimension
78: (p_api_version IN NUMBER ,
79: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
80: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
81: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
82: p_rate_dimension_id IN CN_RATE_DIMENSIONS.RATE_DIMENSION_ID%TYPE,
83: -- R12 MOAC Changes --Start
84: p_object_version_number IN CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE, --new
85: -- R12 MOAC Changes --End

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

99: -- 5) the other validations should be done by users also
100: -- (like minimum_amount < maximum_amount, etc.)
101: PROCEDURE delete_tier
102: (p_api_version IN NUMBER ,
103: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
104: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
105: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
106: p_rate_dim_tier_id IN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,
107: x_return_status OUT NOCOPY VARCHAR2 ,

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

100: -- (like minimum_amount < maximum_amount, etc.)
101: PROCEDURE delete_tier
102: (p_api_version IN NUMBER ,
103: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
104: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
105: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
106: p_rate_dim_tier_id IN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,
107: x_return_status OUT NOCOPY VARCHAR2 ,
108: x_msg_count OUT NOCOPY NUMBER ,

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

101: PROCEDURE delete_tier
102: (p_api_version IN NUMBER ,
103: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
104: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
105: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
106: p_rate_dim_tier_id IN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,
107: x_return_status OUT NOCOPY VARCHAR2 ,
108: x_msg_count OUT NOCOPY NUMBER ,
109: x_msg_data OUT NOCOPY VARCHAR2 );

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

110:
111: -- Notes : Update dimension tiers
112: PROCEDURE update_tier
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_dim_tier_id IN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,
118: p_rate_dimension_id IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,

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

111: -- Notes : Update dimension tiers
112: PROCEDURE update_tier
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_dim_tier_id IN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,
118: p_rate_dimension_id IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
119: p_dim_unit_code IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE,

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

112: PROCEDURE update_tier
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_dim_tier_id IN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,
118: p_rate_dimension_id IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
119: p_dim_unit_code IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE,
120: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := cn_api.g_miss_num,

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

141: -- 5) validation of minimum_amount = previous maximum_amount should be
142: -- done by users
143: PROCEDURE create_tier
144: (p_api_version IN NUMBER ,
145: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
146: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
147: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
148: p_rate_dimension_id IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
149: p_dim_unit_code IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE,

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

142: -- done by users
143: PROCEDURE create_tier
144: (p_api_version IN NUMBER ,
145: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
146: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
147: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
148: p_rate_dimension_id IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
149: p_dim_unit_code IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE,
150: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := null,

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

143: PROCEDURE create_tier
144: (p_api_version IN NUMBER ,
145: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
146: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
147: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
148: p_rate_dimension_id IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
149: p_dim_unit_code IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE,
150: p_minimum_amount IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := null,
151: p_maximum_amount IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := null,