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.AHL_MC_RULE_PUB dependencies on AHL_MC_RULE_PVT

Line 10: p_x_rule_rec IN OUT NOCOPY AHL_MC_RULE_PVT.Rule_Rec_Type,

6: ------------------------------------------------------------------------------------
7: -- Local API Declaration
8: ------------------------------------------------------------------------------------
9: PROCEDURE Convert_Rule_Values_to_Id (
10: p_x_rule_rec IN OUT NOCOPY AHL_MC_RULE_PVT.Rule_Rec_Type,
11: p_operation_flag IN VARCHAR2
12: );
13:
14: PROCEDURE Convert_Rule_Stmt_Values_to_Id (

Line 15: p_x_ui_rule_stmt_tbl IN OUT NOCOPY AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type,

11: p_operation_flag IN VARCHAR2
12: );
13:
14: PROCEDURE Convert_Rule_Stmt_Values_to_Id (
15: p_x_ui_rule_stmt_tbl IN OUT NOCOPY AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type,
16: p_operation_flag IN VARCHAR2
17: );
18:
19: ------------------------------------------------------------------------------------

Line 28: -- p_x_rule_rec IN OUT NOCOPY AHL_MC_RULE_PVT.Rule_Rec_Type Required

24: -- Pre-reqs :
25: -- Parameters :
26: --
27: -- Insert_Rule Parameters:
28: -- p_x_rule_rec IN OUT NOCOPY AHL_MC_RULE_PVT.Rule_Rec_Type Required
29: -- p_rule_stmt_tbl IN AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type Required
30: --
31: -- End of Comments
32:

Line 29: -- p_rule_stmt_tbl IN AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type Required

25: -- Parameters :
26: --
27: -- Insert_Rule Parameters:
28: -- p_x_rule_rec IN OUT NOCOPY AHL_MC_RULE_PVT.Rule_Rec_Type Required
29: -- p_rule_stmt_tbl IN AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type Required
30: --
31: -- End of Comments
32:
33: PROCEDURE Insert_Rule (

Line 39: p_rule_stmt_tbl IN AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type,

35: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
36: p_commit IN VARCHAR2 := FND_API.G_FALSE,
37: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
38: p_module IN VARCHAR2 := 'JSP',
39: p_rule_stmt_tbl IN AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type,
40: p_x_rule_rec IN OUT NOCOPY AHL_MC_RULE_PVT.Rule_Rec_Type,
41: x_return_status OUT NOCOPY VARCHAR2,
42: x_msg_count OUT NOCOPY NUMBER,
43: x_msg_data OUT NOCOPY VARCHAR2

Line 40: p_x_rule_rec IN OUT NOCOPY AHL_MC_RULE_PVT.Rule_Rec_Type,

36: p_commit IN VARCHAR2 := FND_API.G_FALSE,
37: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
38: p_module IN VARCHAR2 := 'JSP',
39: p_rule_stmt_tbl IN AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type,
40: p_x_rule_rec IN OUT NOCOPY AHL_MC_RULE_PVT.Rule_Rec_Type,
41: x_return_status OUT NOCOPY VARCHAR2,
42: x_msg_count OUT NOCOPY NUMBER,
43: x_msg_data OUT NOCOPY VARCHAR2
44: ) IS

Line 51: l_rule_stmt_tbl AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type DEFAULT p_rule_stmt_tbl;

47: l_api_version CONSTANT NUMBER := 1.0;
48: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Rule';
49: l_full_name CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
50:
51: l_rule_stmt_tbl AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type DEFAULT p_rule_stmt_tbl;
52: --
53:
54: BEGIN
55: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

Line 117: AHL_MC_RULE_PVT.Insert_Rule(

113: FND_LOG.string(FND_LOG.level_statement,l_full_name,'Calling private API.');
114: END IF;
115:
116: -- call the private API
117: AHL_MC_RULE_PVT.Insert_Rule(
118: p_api_version => p_api_version,
119: p_init_msg_list => p_init_msg_list,
120: p_commit => p_commit,
121: p_validation_level => p_validation_level,

Line 196: -- p_rule_rec IN AHL_MC_RULE_PVT.Rule_Rec_Type Required

192: -- Pre-reqs :
193: -- Parameters :
194: --
195: -- Update_Rule Parameters:
196: -- p_rule_rec IN AHL_MC_RULE_PVT.Rule_Rec_Type Required
197: -- p_rule_stmt_tbl IN AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type Required
198: --
199: -- End of Comments
200:

Line 197: -- p_rule_stmt_tbl IN AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type Required

193: -- Parameters :
194: --
195: -- Update_Rule Parameters:
196: -- p_rule_rec IN AHL_MC_RULE_PVT.Rule_Rec_Type Required
197: -- p_rule_stmt_tbl IN AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type Required
198: --
199: -- End of Comments
200:
201: PROCEDURE Update_Rule (

Line 207: p_rule_rec IN AHL_MC_RULE_PVT.Rule_Rec_Type,

203: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
204: p_commit IN VARCHAR2 := FND_API.G_FALSE,
205: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
206: p_module IN VARCHAR2 := 'JSP',
207: p_rule_rec IN AHL_MC_RULE_PVT.Rule_Rec_Type,
208: p_rule_stmt_tbl IN AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type,
209: x_return_status OUT NOCOPY VARCHAR2,
210: x_msg_count OUT NOCOPY NUMBER,
211: x_msg_data OUT NOCOPY VARCHAR2

Line 208: p_rule_stmt_tbl IN AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type,

204: p_commit IN VARCHAR2 := FND_API.G_FALSE,
205: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
206: p_module IN VARCHAR2 := 'JSP',
207: p_rule_rec IN AHL_MC_RULE_PVT.Rule_Rec_Type,
208: p_rule_stmt_tbl IN AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type,
209: x_return_status OUT NOCOPY VARCHAR2,
210: x_msg_count OUT NOCOPY NUMBER,
211: x_msg_data OUT NOCOPY VARCHAR2
212: ) IS

Line 219: l_rule_rec AHL_MC_RULE_PVT.Rule_Rec_Type DEFAULT p_rule_rec;

215: l_api_version CONSTANT NUMBER := 1.0;
216: l_api_name CONSTANT VARCHAR2(30) := 'Update_Rule';
217: l_full_name CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
218:
219: l_rule_rec AHL_MC_RULE_PVT.Rule_Rec_Type DEFAULT p_rule_rec;
220: l_rule_stmt_tbl AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type DEFAULT p_rule_stmt_tbl;
221: --
222:
223: BEGIN

Line 220: l_rule_stmt_tbl AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type DEFAULT p_rule_stmt_tbl;

216: l_api_name CONSTANT VARCHAR2(30) := 'Update_Rule';
217: l_full_name CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
218:
219: l_rule_rec AHL_MC_RULE_PVT.Rule_Rec_Type DEFAULT p_rule_rec;
220: l_rule_stmt_tbl AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type DEFAULT p_rule_stmt_tbl;
221: --
222:
223: BEGIN
224: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

Line 293: AHL_MC_RULE_PVT.Update_Rule(

289: FND_LOG.string(FND_LOG.level_statement,l_full_name,'Calling private API.');
290: END IF;
291:
292: -- call the private API
293: AHL_MC_RULE_PVT.Update_Rule(
294: p_api_version => p_api_version,
295: p_init_msg_list => p_init_msg_list,
296: p_commit => p_commit,
297: p_validation_level => p_validation_level,

Line 389: p_rule_rec IN AHL_MC_RULE_PVT.Rule_Rec_Type,

385: p_api_version IN NUMBER,
386: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
387: p_commit IN VARCHAR2 := FND_API.G_FALSE,
388: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
389: p_rule_rec IN AHL_MC_RULE_PVT.Rule_Rec_Type,
390: x_return_status OUT NOCOPY VARCHAR2,
391: x_msg_count OUT NOCOPY NUMBER,
392: x_msg_data OUT NOCOPY VARCHAR2
393: ) IS

Line 400: l_rule_rec AHL_MC_RULE_PVT.Rule_Rec_Type DEFAULT p_rule_rec;

396: l_api_version CONSTANT NUMBER := 1.0;
397: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Rule';
398: l_full_name CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
399:
400: l_rule_rec AHL_MC_RULE_PVT.Rule_Rec_Type DEFAULT p_rule_rec;
401: --
402:
403: BEGIN
404: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

Line 460: AHL_MC_RULE_PVT.Delete_Rule(

456: FND_LOG.string(FND_LOG.level_statement,l_full_name,'Calling private API.');
457: END IF;
458:
459: -- call the private API
460: AHL_MC_RULE_PVT.Delete_Rule(
461: p_api_version => p_api_version,
462: p_init_msg_list => p_init_msg_list,
463: p_commit => p_commit,
464: p_validation_level => p_validation_level,

Line 717: AHL_MC_RULE_PVT.Copy_Rules_For_MC(

713: FND_LOG.string(FND_LOG.level_statement,l_full_name,'Calling private API.');
714: END IF;
715:
716: -- call the private API
717: AHL_MC_RULE_PVT.Copy_Rules_For_MC(
718: p_api_version => p_api_version,
719: p_init_msg_list => p_init_msg_list,
720: p_commit => p_commit,
721: p_validation_level => p_validation_level,

Line 917: AHL_MC_RULE_PVT.Delete_Rules_For_MC(

913: FND_LOG.string(FND_LOG.level_statement,l_full_name,'Calling private API.');
914: END IF;
915:
916: -- call the private API
917: AHL_MC_RULE_PVT.Delete_Rules_For_MC(
918: p_api_version => p_api_version,
919: p_init_msg_list => p_init_msg_list,
920: p_commit => p_commit,
921: p_validation_level => p_validation_level,

Line 1001: -- x_rule_tbl OUT AHL_MC_RULE_PVT.Rule_Tbl_Type Required

997: -- or
998: -- p_mc_name IN VARCHAR2 Required
999: -- p_revision IN NUMBER Required
1000: --
1001: -- x_rule_tbl OUT AHL_MC_RULE_PVT.Rule_Tbl_Type Required
1002: --
1003: -- End of Comments
1004:
1005: PROCEDURE Get_Rules_For_Position (

Line 1014: x_rule_tbl OUT NOCOPY AHL_MC_RULE_PVT.Rule_Tbl_Type,

1010: p_mc_header_id IN NUMBER,
1011: p_encoded_path IN VARCHAR2,
1012: p_mc_name IN VARCHAR2,
1013: p_revision IN VARCHAR2,
1014: x_rule_tbl OUT NOCOPY AHL_MC_RULE_PVT.Rule_Tbl_Type,
1015: x_return_status OUT NOCOPY VARCHAR2,
1016: x_msg_count OUT NOCOPY NUMBER,
1017: x_msg_data OUT NOCOPY VARCHAR2
1018: ) IS

Line 1129: AHL_MC_RULE_PVT.Get_Rules_For_Position(

1125: FND_LOG.string(FND_LOG.level_statement,l_full_name,'Calling private API.');
1126: END IF;
1127:
1128: -- call the private API
1129: AHL_MC_RULE_PVT.Get_Rules_For_Position(
1130: p_api_version => p_api_version,
1131: p_init_msg_list => p_init_msg_list,
1132: p_commit => p_commit,
1133: p_validation_level => p_validation_level,

Line 1213: -- p_x_rule_rec IN OUT AHL_MC_RULE_PVT.Rule_Rec_Type

1209: -- Pre-reqs :
1210: -- Parameters :
1211: --
1212: -- Convert_Rule_Values_to_Id Parameters:
1213: -- p_x_rule_rec IN OUT AHL_MC_RULE_PVT.Rule_Rec_Type
1214: --
1215: -- End of Comments
1216:
1217: PROCEDURE Convert_Rule_Values_to_Id (

Line 1218: p_x_rule_rec IN OUT NOCOPY AHL_MC_RULE_PVT.Rule_Rec_Type,

1214: --
1215: -- End of Comments
1216:
1217: PROCEDURE Convert_Rule_Values_to_Id (
1218: p_x_rule_rec IN OUT NOCOPY AHL_MC_RULE_PVT.Rule_Rec_Type,
1219: p_operation_flag IN VARCHAR2
1220: ) IS
1221:
1222: CURSOR chk_mc_header_id_csr (p_mc_header_id NUMBER) IS

Line 1253: l_rule_rec AHL_MC_RULE_PVT.Rule_Rec_Type DEFAULT p_x_rule_rec;

1249: --
1250: l_api_name CONSTANT VARCHAR2(30) := 'Convert_Rule_Values_to_Id';
1251: l_full_name CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
1252:
1253: l_rule_rec AHL_MC_RULE_PVT.Rule_Rec_Type DEFAULT p_x_rule_rec;
1254: l_rule_id NUMBER;
1255: l_mc_header_id NUMBER;
1256: l_rule_type_code FND_LOOKUPS.LOOKUP_CODE%TYPE;
1257: l_return_val BOOLEAN;

Line 1472: -- p_x_ui_rule_stmt_tbl IN OUT AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type

1468: -- Pre-reqs :
1469: -- Parameters :
1470: --
1471: -- Convert_Rule_Stmt_Values_to_Id Parameters:
1472: -- p_x_ui_rule_stmt_tbl IN OUT AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type
1473: --
1474: -- End of Comments
1475:
1476: PROCEDURE Convert_Rule_Stmt_Values_to_Id (

Line 1477: p_x_ui_rule_stmt_tbl IN OUT NOCOPY AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type,

1473: --
1474: -- End of Comments
1475:
1476: PROCEDURE Convert_Rule_Stmt_Values_to_Id (
1477: p_x_ui_rule_stmt_tbl IN OUT NOCOPY AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type,
1478: p_operation_flag IN VARCHAR2
1479: ) IS
1480:
1481: CURSOR chk_item_id_csr (p_item_id NUMBER) IS

Line 1527: l_ui_rule_stmt_tbl AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type DEFAULT p_x_ui_rule_stmt_tbl;

1523: l_full_name CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
1524:
1525: l_item_id NUMBER;
1526: l_mc_id NUMBER;
1527: l_ui_rule_stmt_tbl AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type DEFAULT p_x_ui_rule_stmt_tbl;
1528: l_rule_operator FND_LOOKUPS.LOOKUP_CODE%TYPE;
1529: l_rule_rule_operator FND_LOOKUPS.LOOKUP_CODE%TYPE;
1530: l_rule_object_type FND_LOOKUPS.LOOKUP_CODE%TYPE;
1531: l_return_val BOOLEAN;