[Home] [Help]
39:
40: -- Procedure to clear the LOV attributes' ID to NULL or G_MISS Values if its
41: -- corresponding displayed field is NULL or G_MISS values
42: PROCEDURE clear_lov_attribute_ids(
43: p_x_uc_header_rec IN OUT NOCOPY ahl_uc_instance_pvt.uc_header_rec_type)
44: IS
45: BEGIN
46: IF (p_x_uc_header_rec.instance_number IS NULL) THEN
47: p_x_uc_header_rec.instance_id := NULL;
58: END clear_lov_attribute_ids;
59:
60: -- Procedure to change G_MISS values to NULL in case they are passed during creation
61: PROCEDURE nullify_attributes(
62: p_x_uc_header_rec IN OUT NOCOPY ahl_uc_instance_pvt.uc_header_rec_type)
63: IS
64: BEGIN
65: IF (p_x_uc_header_rec.active_uc_status_code = FND_API.G_MISS_CHAR) THEN
66: p_x_uc_header_rec.active_uc_status_code := null;
132:
133: --Procedure to convert G_MISS values to NULL and NULL to OLD values during updating
134:
135: PROCEDURE convert_attributes(
136: p_x_uc_header_rec IN OUT NOCOPY ahl_uc_instance_pvt.uc_header_rec_type,
137: x_return_status OUT NOCOPY VARCHAR2)
138: IS
139: l_old_uc_header_rec get_uc_header%ROWTYPE;
140: BEGIN
293: END convert_attributes;
294:
295: -- Procedure to validate individual record attributes
296: PROCEDURE validate_parameters(
297: p_uc_header_rec IN ahl_uc_instance_pvt.uc_header_rec_type,
298: x_return_status OUT NOCOPY VARCHAR2)
299: IS
300: BEGIN
301: x_return_status := FND_API.G_RET_STS_SUCCESS;
503: END validate_csi_instance;
504:
505: -- Procedure to validate individual record attributes
506: PROCEDURE validate_attributes(
507: p_uc_header_rec IN ahl_uc_instance_pvt.uc_header_rec_type,
508: p_dml_operation IN VARCHAR2,
509: x_return_status OUT NOCOPY VARCHAR2)
510: IS
511: CURSOR check_uc_name1(c_uc_name varchar2) IS
601: p_module_type IN VARCHAR2 := NULL,
602: x_return_status OUT NOCOPY VARCHAR2,
603: x_msg_count OUT NOCOPY NUMBER,
604: x_msg_data OUT NOCOPY VARCHAR2,
605: p_x_uc_header_rec IN OUT NOCOPY ahl_uc_instance_pvt.uc_header_rec_type)
606: IS
607: l_api_name CONSTANT VARCHAR2(30) := 'create_uc_header';
608: l_api_version CONSTANT NUMBER := 1.0;
609: l_return_status VARCHAR2(1);
928: p_module_type IN VARCHAR2 := NULL,
929: x_return_status OUT NOCOPY VARCHAR2,
930: x_msg_count OUT NOCOPY NUMBER,
931: x_msg_data OUT NOCOPY VARCHAR2,
932: p_x_uc_header_rec IN OUT NOCOPY ahl_uc_instance_pvt.uc_header_rec_type,
933: p_uc_instance_rec IN ahl_uc_instance_pvt.uc_instance_rec_type)
934: IS
935: l_api_name CONSTANT VARCHAR2(30) := 'update_uc_header';
936: l_api_version CONSTANT NUMBER := 1.0;
929: x_return_status OUT NOCOPY VARCHAR2,
930: x_msg_count OUT NOCOPY NUMBER,
931: x_msg_data OUT NOCOPY VARCHAR2,
932: p_x_uc_header_rec IN OUT NOCOPY ahl_uc_instance_pvt.uc_header_rec_type,
933: p_uc_instance_rec IN ahl_uc_instance_pvt.uc_instance_rec_type)
934: IS
935: l_api_name CONSTANT VARCHAR2(30) := 'update_uc_header';
936: l_api_version CONSTANT NUMBER := 1.0;
937: l_return_status VARCHAR2(1);
1059: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1060: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1061: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': within API','x_return_status='||x_return_status);
1062: END IF;
1063: --Call ahl_uc_instance_pvt.update_instance_attr to update the top node instance attributes
1064: --In front end UI, if there is no change to the instance attributes, then the whole p_uc_instance_rec
1065: --will be null.
1066: IF p_uc_instance_rec.instance_id IS NOT NULL THEN
1067: ahl_uc_instance_pvt.update_instance_attr(
1063: --Call ahl_uc_instance_pvt.update_instance_attr to update the top node instance attributes
1064: --In front end UI, if there is no change to the instance attributes, then the whole p_uc_instance_rec
1065: --will be null.
1066: IF p_uc_instance_rec.instance_id IS NOT NULL THEN
1067: ahl_uc_instance_pvt.update_instance_attr(
1068: p_api_version => 1.0,
1069: p_init_msg_list => FND_API.G_FALSE,
1070: p_commit => FND_API.G_FALSE,
1071: p_validation_level => FND_API.G_VALID_LEVEL_FULL,