DBA Data[Home] [Help]

APPS.AHL_MC_MASTERCONFIG_PVT dependencies on AHL_MC_NODE_PVT

Line 66: p_x_node_rec IN OUT NOCOPY AHL_MC_Node_PVT.Node_Rec_Type

62: x_return_status OUT NOCOPY VARCHAR2,
63: x_msg_count OUT NOCOPY NUMBER,
64: x_msg_data OUT NOCOPY VARCHAR2,
65: p_x_mc_header_rec IN OUT NOCOPY Header_Rec_Type,
66: p_x_node_rec IN OUT NOCOPY AHL_MC_Node_PVT.Node_Rec_Type
67: )
68: IS
69: -- Define cursor check_other_mc_name_unique to to check uniqueness of MC name across other MCs
70: -- for the case of creating new revision of an MC

Line 90: l_counter_rules_tbl AHL_MC_Node_PVT.Counter_Rules_Tbl_Type;

86: l_msg_count NUMBER;
87: l_msg_data VARCHAR2(2000);
88:
89: l_row_id ROWID;
90: l_counter_rules_tbl AHL_MC_Node_PVT.Counter_Rules_Tbl_Type;
91: l_subconfig_tbl AHL_MC_Node_PVT.Subconfig_Tbl_Type;
92:
93: BEGIN
94:

Line 91: l_subconfig_tbl AHL_MC_Node_PVT.Subconfig_Tbl_Type;

87: l_msg_data VARCHAR2(2000);
88:
89: l_row_id ROWID;
90: l_counter_rules_tbl AHL_MC_Node_PVT.Counter_Rules_Tbl_Type;
91: l_subconfig_tbl AHL_MC_Node_PVT.Subconfig_Tbl_Type;
92:
93: BEGIN
94:
95: -- Standard start of API savepoint

Line 371: 'Node validation successful... Calling AHL_MC_Node_PVT.Create_Node'

367: fnd_log.string
368: (
369: fnd_log.level_statement,
370: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
371: 'Node validation successful... Calling AHL_MC_Node_PVT.Create_Node'
372: );
373: END IF;
374:
375: -- 11. Call AHL_MC_NODE_PVT.Create_Node to create MC topnode

Line 375: -- 11. Call AHL_MC_NODE_PVT.Create_Node to create MC topnode

371: 'Node validation successful... Calling AHL_MC_Node_PVT.Create_Node'
372: );
373: END IF;
374:
375: -- 11. Call AHL_MC_NODE_PVT.Create_Node to create MC topnode
376: AHL_MC_Node_PVT.Create_Node
377: (
378: p_api_version => 1.0,
379: p_init_msg_list => FND_API.G_FALSE,

Line 376: AHL_MC_Node_PVT.Create_Node

372: );
373: END IF;
374:
375: -- 11. Call AHL_MC_NODE_PVT.Create_Node to create MC topnode
376: AHL_MC_Node_PVT.Create_Node
377: (
378: p_api_version => 1.0,
379: p_init_msg_list => FND_API.G_FALSE,
380: p_commit => FND_API.G_FALSE,

Line 474: p_x_node_rec IN OUT NOCOPY AHL_MC_Node_PVT.Node_Rec_Type

470: x_return_status OUT NOCOPY VARCHAR2,
471: x_msg_count OUT NOCOPY NUMBER,
472: x_msg_data OUT NOCOPY VARCHAR2,
473: p_x_mc_header_rec IN OUT NOCOPY Header_Rec_Type,
474: p_x_node_rec IN OUT NOCOPY AHL_MC_Node_PVT.Node_Rec_Type
475: )
476: IS
477: -- Define local variables
478: l_api_name CONSTANT VARCHAR2(30) := 'Modify_Master_Config';

Line 484: l_counter_rules_tbl AHL_MC_Node_PVT.Counter_Rules_Tbl_Type;

480: l_return_status VARCHAR2(1);
481: l_msg_count NUMBER;
482: l_msg_data VARCHAR2(2000);
483:
484: l_counter_rules_tbl AHL_MC_Node_PVT.Counter_Rules_Tbl_Type;
485: l_subconfig_tbl AHL_MC_Node_PVT.Subconfig_Tbl_Type;
486: l_header_status VARCHAR2(30);
487:
488: BEGIN

Line 485: l_subconfig_tbl AHL_MC_Node_PVT.Subconfig_Tbl_Type;

481: l_msg_count NUMBER;
482: l_msg_data VARCHAR2(2000);
483:
484: l_counter_rules_tbl AHL_MC_Node_PVT.Counter_Rules_Tbl_Type;
485: l_subconfig_tbl AHL_MC_Node_PVT.Subconfig_Tbl_Type;
486: l_header_status VARCHAR2(30);
487:
488: BEGIN
489:

Line 729: 'Node validation successful... Calling AHL_MC_Node_PVT.Modify_Node'

725: fnd_log.string
726: (
727: fnd_log.level_statement,
728: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
729: 'Node validation successful... Calling AHL_MC_Node_PVT.Modify_Node'
730: );
731: END IF;
732:
733: -- Set values for p_x_node_rec

Line 737: -- 2g. Call AHL_MC_NODE_PVT.Modify_Node to modify MC topnode

733: -- Set values for p_x_node_rec
734: p_x_node_rec.mc_header_id := p_x_mc_header_rec.mc_header_id;
735: p_x_node_rec.operation_flag := G_DML_UPDATE;
736:
737: -- 2g. Call AHL_MC_NODE_PVT.Modify_Node to modify MC topnode
738: AHL_MC_Node_PVT.Modify_Node
739: (
740: p_api_version => 1.0,
741: p_init_msg_list => FND_API.G_FALSE,

Line 738: AHL_MC_Node_PVT.Modify_Node

734: p_x_node_rec.mc_header_id := p_x_mc_header_rec.mc_header_id;
735: p_x_node_rec.operation_flag := G_DML_UPDATE;
736:
737: -- 2g. Call AHL_MC_NODE_PVT.Modify_Node to modify MC topnode
738: AHL_MC_Node_PVT.Modify_Node
739: (
740: p_api_version => 1.0,
741: p_init_msg_list => FND_API.G_FALSE,
742: p_commit => FND_API.G_FALSE,

Line 1047: -- 6c. Call AHL_MC_NODE_PVT.Delete_Node to delete the MC tree starting from the topnode

1043: OPEN get_mc_topnode_details(p_mc_header_id);
1044: FETCH get_mc_topnode_details INTO l_topnode_rel_id, l_topnode_object_ver_num;
1045: CLOSE get_mc_topnode_details;
1046:
1047: -- 6c. Call AHL_MC_NODE_PVT.Delete_Node to delete the MC tree starting from the topnode
1048: AHL_MC_NODE_PVT.Delete_Node
1049: (
1050: p_api_version => 1.0,
1051: p_init_msg_list => FND_API.G_FALSE,

Line 1048: AHL_MC_NODE_PVT.Delete_Node

1044: FETCH get_mc_topnode_details INTO l_topnode_rel_id, l_topnode_object_ver_num;
1045: CLOSE get_mc_topnode_details;
1046:
1047: -- 6c. Call AHL_MC_NODE_PVT.Delete_Node to delete the MC tree starting from the topnode
1048: AHL_MC_NODE_PVT.Delete_Node
1049: (
1050: p_api_version => 1.0,
1051: p_init_msg_list => FND_API.G_FALSE,
1052: p_commit => FND_API.G_FALSE,

Line 1260: p_x_node_rec IN OUT NOCOPY AHL_MC_Node_PVT.Node_Rec_Type

1256: x_return_status OUT NOCOPY VARCHAR2,
1257: x_msg_count OUT NOCOPY NUMBER,
1258: x_msg_data OUT NOCOPY VARCHAR2,
1259: p_x_mc_header_rec IN OUT NOCOPY Header_Rec_Type,
1260: p_x_node_rec IN OUT NOCOPY AHL_MC_Node_PVT.Node_Rec_Type
1261: )
1262: IS
1263:
1264: -- 1. Define local variables

Line 1401: AHL_MC_Node_PVT.Copy_MC_Nodes

1397: );
1398: END IF;
1399:
1400: -- 9. Copy all other child nodes to the topnode of the source MC
1401: AHL_MC_Node_PVT.Copy_MC_Nodes
1402: (
1403: p_api_version => 1.0,
1404: p_init_msg_list => FND_API.G_FALSE,
1405: p_commit => FND_API.G_FALSE,

Line 1670: l_node_rec AHL_MC_Node_PVT.Node_Rec_Type;

1666: l_header_rec get_header_rec_csr%ROWTYPE;
1667: l_mc_header_rec Header_Rec_Type;
1668: l_old_node_id NUMBER;
1669: l_topnode_rec get_topnode_rec_csr%ROWTYPE;
1670: l_node_rec AHL_MC_Node_PVT.Node_Rec_Type;
1671:
1672: BEGIN
1673:
1674: -- Standard start of API savepoint

Line 1911: AHL_MC_Node_PVT.Copy_MC_Nodes

1907: );
1908: END IF;
1909:
1910: -- 17. Copy all other child nodes to the topnode of the source MC
1911: AHL_MC_Node_PVT.Copy_MC_Nodes
1912: (
1913: p_api_version => 1.0,
1914: p_init_msg_list => FND_API.G_FALSE,
1915: p_commit => FND_API.G_FALSE,