[Home] [Help]
1: PACKAGE BODY EAM_WO_NETWORK_VALIDATE_PVT AS
2: /* $Header: EAMVWNVB.pls 120.2.12000000.3 2007/05/10 08:54:04 syenaman ship $ */
3: /***************************************************************************
4: --
5: -- Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA
10: -- EAMVWNVB.pls
11: --
12: -- DESCRIPTION
13: --
14: -- Body of package EAM_WO_NETWORK_VALIDATE_PVT
15: --
16: -- NOTES
17: --
18: -- HISTORY
19: --
20: -- 11-SEP-2003 Basanth Roy Initial Creation
21: ***************************************************************************/
22:
23: G_Pkg_Name VARCHAR2(30) := 'EAM_WO_NETWORK_VALIDATE_PVT';
24:
25: g_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
26: g_dummy NUMBER;
27:
103: AND WDJ2.STATUS_TYPE = nvl(l_status_check,WDJ2.STATUS_TYPE);
104:
105: BEGIN
106: -- Standard Start of API savepoint
107: SAVEPOINT EAM_WO_NETWORK_VALIDATE_PVT;
108: -- Standard call to check for call compatibility.
109: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
110: p_api_version ,
111: l_api_name ,
249: /* Call Parent Child Constraint Checks */
250: l_return_status := NULL;
251:
252: l_stmt_num := 60;
253: EAM_WO_NETWORK_VALIDATE_PVT.Check_Constrained_Children
254: (
255: p_api_version => 1.0,
256: p_parent_object_id => l_top_level_object_id,
257: p_parent_object_type_id => l_top_level_object_type_id,
808: END IF;
809:
810: /* Recursive Call to the validation API */
811: l_stmt_num := 40;
812: EAM_WO_NETWORK_VALIDATE_PVT.Check_Constrained_Children
813: (
814: p_api_version => 1.0,
815: p_parent_object_id => child.child_object_id,
816: p_parent_object_type_id => child.child_object_type_id,
1133: END IF;
1134:
1135: FOR child IN constrained_children_cur(p_work_object_id, p_work_object_type_id)
1136: LOOP
1137: EAM_WO_NETWORK_VALIDATE_PVT.Validate_Network_Status
1138: (p_work_object_id => child.child_object_id,
1139: p_work_object_type_id => child.child_object_type_id,
1140: p_wo_relationship_exc_tbl => p_wo_relationship_exc_tbl
1141: );
1150:
1151: END Validate_Network_Status;
1152:
1153:
1154: END EAM_WO_NETWORK_VALIDATE_PVT;