36: -- for the specified risk type and its descendant.
37: -- ===============================================================
38: PROCEDURE Delete_Risk_Types(
39: p_setup_risk_type_id IN NUMBER,
40: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
41: p_commit IN VARCHAR2 := FND_API.G_FALSE,
42: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
43: x_return_status OUT NOCOPY VARCHAR2,
44: x_msg_count OUT NOCOPY NUMBER,
37: -- ===============================================================
38: PROCEDURE Delete_Risk_Types(
39: p_setup_risk_type_id IN NUMBER,
40: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
41: p_commit IN VARCHAR2 := FND_API.G_FALSE,
42: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
43: x_return_status OUT NOCOPY VARCHAR2,
44: x_msg_count OUT NOCOPY NUMBER,
45: x_msg_data OUT NOCOPY VARCHAR2
38: PROCEDURE Delete_Risk_Types(
39: p_setup_risk_type_id IN NUMBER,
40: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
41: p_commit IN VARCHAR2 := FND_API.G_FALSE,
42: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
43: x_return_status OUT NOCOPY VARCHAR2,
44: x_msg_count OUT NOCOPY NUMBER,
45: x_msg_data OUT NOCOPY VARCHAR2
46: );
53: -- ===============================================================
54: PROCEDURE InValidate_Risk_Types(
55: p_setup_risk_type_id IN NUMBER,
56: p_end_date IN DATE,
57: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
58: p_commit IN VARCHAR2 := FND_API.G_FALSE,
59: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
60: x_return_status OUT NOCOPY VARCHAR2,
61: x_msg_count OUT NOCOPY NUMBER,
54: PROCEDURE InValidate_Risk_Types(
55: p_setup_risk_type_id IN NUMBER,
56: p_end_date IN DATE,
57: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
58: p_commit IN VARCHAR2 := FND_API.G_FALSE,
59: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
60: x_return_status OUT NOCOPY VARCHAR2,
61: x_msg_count OUT NOCOPY NUMBER,
62: x_msg_data OUT NOCOPY VARCHAR2
55: p_setup_risk_type_id IN NUMBER,
56: p_end_date IN DATE,
57: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
58: p_commit IN VARCHAR2 := FND_API.G_FALSE,
59: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
60: x_return_status OUT NOCOPY VARCHAR2,
61: x_msg_count OUT NOCOPY NUMBER,
62: x_msg_data OUT NOCOPY VARCHAR2
63: );
111: -- Update the risk-riskTypes associations(store in table AMW_RISK_TYPE)
112: -- depending on the specified p_select_flag .
113: -- ===============================================================
114: PROCEDURE PROCESS_RISK_TYPE_ASSOCS (
115: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
116: p_commit IN VARCHAR2 := FND_API.G_FALSE,
117: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
118: p_select_flag IN VARCHAR2,
119: p_risk_rev_id IN NUMBER,
112: -- depending on the specified p_select_flag .
113: -- ===============================================================
114: PROCEDURE PROCESS_RISK_TYPE_ASSOCS (
115: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
116: p_commit IN VARCHAR2 := FND_API.G_FALSE,
117: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
118: p_select_flag IN VARCHAR2,
119: p_risk_rev_id IN NUMBER,
120: p_risk_type_code IN VARCHAR2,
113: -- ===============================================================
114: PROCEDURE PROCESS_RISK_TYPE_ASSOCS (
115: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
116: p_commit IN VARCHAR2 := FND_API.G_FALSE,
117: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
118: p_select_flag IN VARCHAR2,
119: p_risk_rev_id IN NUMBER,
120: p_risk_type_code IN VARCHAR2,
121: x_return_status OUT NOCOPY VARCHAR2,
180: -- return 'Y' if the passed-in p_setup_risk_type and its descendants
181: -- are currently associated with the specified risk (p_risk_rev_id)
182: -- ===============================================================
183: PROCEDURE IS_ASSOC_TO_RISK (
184: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
185: p_commit IN VARCHAR2 := FND_API.G_FALSE,
186: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
187: p_setup_risk_type_id IN NUMBER,
188: x_is_assoc_to_risk OUT NOCOPY VARCHAR2,
181: -- are currently associated with the specified risk (p_risk_rev_id)
182: -- ===============================================================
183: PROCEDURE IS_ASSOC_TO_RISK (
184: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
185: p_commit IN VARCHAR2 := FND_API.G_FALSE,
186: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
187: p_setup_risk_type_id IN NUMBER,
188: x_is_assoc_to_risk OUT NOCOPY VARCHAR2,
189: x_return_status OUT NOCOPY VARCHAR2,
182: -- ===============================================================
183: PROCEDURE IS_ASSOC_TO_RISK (
184: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
185: p_commit IN VARCHAR2 := FND_API.G_FALSE,
186: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
187: p_setup_risk_type_id IN NUMBER,
188: x_is_assoc_to_risk OUT NOCOPY VARCHAR2,
189: x_return_status OUT NOCOPY VARCHAR2,
190: x_msg_count OUT NOCOPY NUMBER,