APPS.AHL_MC_RULE_STMT_PVT dependencies on AHL_MC_RULE_PVT

Line 18: PROCEDURE validate_pos_quantity_rule(p_rule_stmt_rec IN AHL_MC_RULE_PVT.Rule_Stmt_Rec_Type);

14: -- New APIs declared: -
15: FUNCTION get_fnd_lkup_meaning(p_lookup_type IN VARCHAR2, p_lookup_code IN VARCHAR2)
16: RETURN VARCHAR2;
17:
18: PROCEDURE validate_pos_quantity_rule(p_rule_stmt_rec IN AHL_MC_RULE_PVT.Rule_Stmt_Rec_Type);
19:
20: --
21: ------------------------
22: -- Declare Procedures --

Line 33: -- p_rule_stmt_rec IN AHL_MC_RULE_PVT.Rule_Stmt_Rec_Type Required

29: -- Pre-reqs :
30: -- Parameters :
31: --
32: -- Validate_Rule_Stmt Parameters:
33: -- p_rule_stmt_rec IN AHL_MC_RULE_PVT.Rule_Stmt_Rec_Type Required
34: --
35: -- End of Comments.
36:
37: PROCEDURE Validate_Rule_Stmt (

Line 44: p_rule_stmt_rec IN AHL_MC_RULE_PVT.Rule_Stmt_Rec_Type)

40: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
41: x_return_status OUT NOCOPY VARCHAR2,
42: x_msg_count OUT NOCOPY NUMBER,
43: x_msg_data OUT NOCOPY VARCHAR2,
44: p_rule_stmt_rec IN AHL_MC_RULE_PVT.Rule_Stmt_Rec_Type)
45: IS
46: --
47: CURSOR Check_rule_type_csr (p_rule_id IN NUMBER) IS
48: SELECT rule_type_code FROM ahl_mc_rules_b

Line 405: -- p_x_rule_stmt_rec IN OUT NOCOPY AHL_MC_RULE_PVT.Rule_Stmt_Rec_Type Required

401: -- Pre-reqs :
402: -- Parameters :
403: --
404: -- Insert_Rule_Stmt Parameters:
405: -- p_x_rule_stmt_rec IN OUT NOCOPY AHL_MC_RULE_PVT.Rule_Stmt_Rec_Type Required
406: --
407: -- End of Comments.
408:
409: PROCEDURE Insert_Rule_Stmt (

Line 418: p_x_rule_stmt_rec IN OUT NOCOPY AHL_MC_RULE_PVT.Rule_Stmt_Rec_Type)

414: x_return_status OUT NOCOPY VARCHAR2,
415: x_msg_count OUT NOCOPY NUMBER,
416: x_msg_data OUT NOCOPY VARCHAR2,
417: p_module IN VARCHAR2 := 'JSP',
418: p_x_rule_stmt_rec IN OUT NOCOPY AHL_MC_RULE_PVT.Rule_Stmt_Rec_Type)
419: IS
420: --
421: CURSOR next_rule_stmt_id_csr IS
422: SELECT ahl_mc_rule_statements_s.nextval FROM DUAL;

Line 657: -- p_x_rule_stmt_rec IN OUT NOCOPY AHL_MC_RULE_PVT.Rule_Stmt_Rec_Type Required

653: -- Pre-reqs :
654: -- Parameters :
655: --
656: -- Update_Rule_Stmt Parameters:
657: -- p_x_rule_stmt_rec IN OUT NOCOPY AHL_MC_RULE_PVT.Rule_Stmt_Rec_Type Required
658: --
659: -- End of Comments.
660:
661: PROCEDURE Update_Rule_Stmt (

Line 670: p_rule_stmt_rec IN AHL_MC_RULE_PVT.Rule_Stmt_Rec_Type)

666: x_return_status OUT NOCOPY VARCHAR2,
667: x_msg_count OUT NOCOPY NUMBER,
668: x_msg_data OUT NOCOPY VARCHAR2,
669: p_module IN VARCHAR2 := 'JSP',
670: p_rule_stmt_rec IN AHL_MC_RULE_PVT.Rule_Stmt_Rec_Type)
671: IS
672: --
673: CURSOR ahl_mc_rule_stmt_csr (p_rstmt_id IN NUMBER) IS
674: SELECT *

Line 681: l_rule_stmt_rec AHL_MC_RULE_PVT.Rule_Stmt_Rec_Type;

677: --
678: l_api_version CONSTANT NUMBER := 1.0;
679: l_api_name CONSTANT VARCHAR2(30) := 'Update_Rule_Stmt';
680: l_old_rstmt_rec ahl_mc_rule_stmt_csr%ROWTYPE;
681: l_rule_stmt_rec AHL_MC_RULE_PVT.Rule_Stmt_Rec_Type;
682: --
683: BEGIN
684: -- Standard start of API savepoint
685: SAVEPOINT Update_Rule_Stmt_pvt;

Line 959: l_rstmt_rec AHL_MC_RULE_PVT.Rule_Stmt_Rec_Type;

955: --
956: l_api_version CONSTANT NUMBER := 1.0;
957: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Rule_Stmt';
958: l_stmt_rec get_rule_stmt_csr%ROWTYPE;
959: l_rstmt_rec AHL_MC_RULE_PVT.Rule_Stmt_Rec_Type;
960: l_new_subject_id NUMBER;
961: l_new_object_id NUMBER;
962: --
963: BEGIN

Line 1324: -- p_rule_stmt_rec IN AHL_MC_RULE_PVT.Rule_Stmt_Rec_Type Required

1320: -- Pre-reqs :
1321: -- Parameters :
1322: --
1323: -- validate_pos_quantity_rule Parameters:
1324: -- p_rule_stmt_rec IN AHL_MC_RULE_PVT.Rule_Stmt_Rec_Type Required
1325: --
1326: -- API added for FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 03-Dec-2007
1327: --
1328: -- End of Comments.

Line 1330: PROCEDURE validate_pos_quantity_rule (p_rule_stmt_rec IN AHL_MC_RULE_PVT.Rule_Stmt_Rec_Type)

1326: -- API added for FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 03-Dec-2007
1327: --
1328: -- End of Comments.
1329:
1330: PROCEDURE validate_pos_quantity_rule (p_rule_stmt_rec IN AHL_MC_RULE_PVT.Rule_Stmt_Rec_Type)
1331: IS
1332: --
1333: /*
1334: The following cursor retrieves all the relationships, corresponding to the path_position_id for which the rule is defined.

Line 1550: l_rstmt_rec AHL_MC_RULE_PVT.Rule_Stmt_Rec_Type;

1546: l_api_version CONSTANT NUMBER := 1.0;
1547: l_api_name CONSTANT VARCHAR2(30) := 'validate_quantity_rules_for_mc';
1548: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.validate_quantity_rules_for_mc';
1549: l_quant_stmt_rec get_quantity_rule_stmt_csr%ROWTYPE;
1550: l_rstmt_rec AHL_MC_RULE_PVT.Rule_Stmt_Rec_Type;
1551:
1552: --
1553: BEGIN
1554: -- Initialize Procedure return status to success