48: -- Procedure to create association record
49: PROCEDURE PROCESS_ASSOCIATION
50: (
51: p_api_version IN NUMBER := 1.0 ,
52: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
53: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
54: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
55: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
56: p_x_association_tbl IN OUT NOCOPY association_tbl ,
49: PROCEDURE PROCESS_ASSOCIATION
50: (
51: p_api_version IN NUMBER := 1.0 ,
52: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
53: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
54: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
55: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
56: p_x_association_tbl IN OUT NOCOPY association_tbl ,
57: x_return_status OUT NOCOPY VARCHAR2 ,
50: (
51: p_api_version IN NUMBER := 1.0 ,
52: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
53: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
54: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
55: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
56: p_x_association_tbl IN OUT NOCOPY association_tbl ,
57: x_return_status OUT NOCOPY VARCHAR2 ,
58: x_msg_count OUT NOCOPY NUMBER ,
51: p_api_version IN NUMBER := 1.0 ,
52: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
53: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
54: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
55: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
56: p_x_association_tbl IN OUT NOCOPY association_tbl ,
57: x_return_status OUT NOCOPY VARCHAR2 ,
58: x_msg_count OUT NOCOPY NUMBER ,
59: x_msg_data OUT NOCOPY VARCHAR2);
61: --Procedure to copy new association record
62: Procedure COPY_ASSOCIATION
63: (
64: p_api_version IN NUMBER := 1.0 ,
65: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_TRUE ,
66: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE ,
67: p_validate_only IN VARCHAR2 := Fnd_Api.G_TRUE ,
68: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
69: p_from_object_id IN NUMBER,
62: Procedure COPY_ASSOCIATION
63: (
64: p_api_version IN NUMBER := 1.0 ,
65: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_TRUE ,
66: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE ,
67: p_validate_only IN VARCHAR2 := Fnd_Api.G_TRUE ,
68: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
69: p_from_object_id IN NUMBER,
70: p_from_object_type IN VARCHAR2,
63: (
64: p_api_version IN NUMBER := 1.0 ,
65: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_TRUE ,
66: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE ,
67: p_validate_only IN VARCHAR2 := Fnd_Api.G_TRUE ,
68: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
69: p_from_object_id IN NUMBER,
70: p_from_object_type IN VARCHAR2,
71: p_to_object_id IN NUMBER,
64: p_api_version IN NUMBER := 1.0 ,
65: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_TRUE ,
66: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE ,
67: p_validate_only IN VARCHAR2 := Fnd_Api.G_TRUE ,
68: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
69: p_from_object_id IN NUMBER,
70: p_from_object_type IN VARCHAR2,
71: p_to_object_id IN NUMBER,
72: p_to_object_type IN VARCHAR2,
78: -- Procedure to delete all associations to a particular ASO object
79: Procedure DELETE_ALL_ASSOCIATIONS
80: (
81: p_api_version IN NUMBER := 1.0 ,
82: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
83: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
84: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
85: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
86: p_aso_object_type_code IN VARCHAR2 ,
79: Procedure DELETE_ALL_ASSOCIATIONS
80: (
81: p_api_version IN NUMBER := 1.0 ,
82: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
83: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
84: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
85: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
86: p_aso_object_type_code IN VARCHAR2 ,
87: p_aso_object_id IN NUMBER ,
80: (
81: p_api_version IN NUMBER := 1.0 ,
82: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
83: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
84: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
85: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
86: p_aso_object_type_code IN VARCHAR2 ,
87: p_aso_object_id IN NUMBER ,
88: x_return_status OUT NOCOPY VARCHAR2 ,
81: p_api_version IN NUMBER := 1.0 ,
82: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
83: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
84: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
85: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
86: p_aso_object_type_code IN VARCHAR2 ,
87: p_aso_object_id IN NUMBER ,
88: x_return_status OUT NOCOPY VARCHAR2 ,
89: x_msg_count OUT NOCOPY NUMBER ,