27: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
28: ------------------------------------------------------------------------------
29: PROCEDURE insert_ins_policies(
30: p_api_version IN NUMBER
31: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
32: ,x_return_status OUT NOCOPY VARCHAR2
33: ,x_msg_count OUT NOCOPY NUMBER
34: ,x_msg_data OUT NOCOPY VARCHAR2
35: ,p_ipyv_tbl IN ipyv_tbl_type
49: * @rep:lifecycle active
50: */
51: PROCEDURE insert_ins_policies(
52: p_api_version IN NUMBER
53: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
54: ,x_return_status OUT NOCOPY VARCHAR2
55: ,x_msg_count OUT NOCOPY NUMBER
56: ,x_msg_data OUT NOCOPY VARCHAR2
57: ,p_ipyv_rec IN ipyv_rec_type
57: ,p_ipyv_rec IN ipyv_rec_type
58: ,x_ipyv_rec OUT NOCOPY ipyv_rec_type);
59: PROCEDURE lock_ins_policies(
60: p_api_version IN NUMBER
61: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
62: ,x_return_status OUT NOCOPY VARCHAR2
63: ,x_msg_count OUT NOCOPY NUMBER
64: ,x_msg_data OUT NOCOPY VARCHAR2
65: ,p_ipyv_tbl IN ipyv_tbl_type);
64: ,x_msg_data OUT NOCOPY VARCHAR2
65: ,p_ipyv_tbl IN ipyv_tbl_type);
66: PROCEDURE lock_ins_policies(
67: p_api_version IN NUMBER
68: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
69: ,x_return_status OUT NOCOPY VARCHAR2
70: ,x_msg_count OUT NOCOPY NUMBER
71: ,x_msg_data OUT NOCOPY VARCHAR2
72: ,p_ipyv_rec IN ipyv_rec_type);
71: ,x_msg_data OUT NOCOPY VARCHAR2
72: ,p_ipyv_rec IN ipyv_rec_type);
73: PROCEDURE update_ins_policies(
74: p_api_version IN NUMBER
75: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
76: ,x_return_status OUT NOCOPY VARCHAR2
77: ,x_msg_count OUT NOCOPY NUMBER
78: ,x_msg_data OUT NOCOPY VARCHAR2
79: ,p_ipyv_tbl IN ipyv_tbl_type
79: ,p_ipyv_tbl IN ipyv_tbl_type
80: ,x_ipyv_tbl OUT NOCOPY ipyv_tbl_type);
81: PROCEDURE update_ins_policies(
82: p_api_version IN NUMBER
83: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
84: ,x_return_status OUT NOCOPY VARCHAR2
85: ,x_msg_count OUT NOCOPY NUMBER
86: ,x_msg_data OUT NOCOPY VARCHAR2
87: ,p_ipyv_rec IN ipyv_rec_type
87: ,p_ipyv_rec IN ipyv_rec_type
88: ,x_ipyv_rec OUT NOCOPY ipyv_rec_type);
89: PROCEDURE delete_ins_policies(
90: p_api_version IN NUMBER
91: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
92: ,x_return_status OUT NOCOPY VARCHAR2
93: ,x_msg_count OUT NOCOPY NUMBER
94: ,x_msg_data OUT NOCOPY VARCHAR2
95: ,p_ipyv_tbl IN ipyv_tbl_type);
94: ,x_msg_data OUT NOCOPY VARCHAR2
95: ,p_ipyv_tbl IN ipyv_tbl_type);
96: PROCEDURE delete_ins_policies(
97: p_api_version IN NUMBER
98: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
99: ,x_return_status OUT NOCOPY VARCHAR2
100: ,x_msg_count OUT NOCOPY NUMBER
101: ,x_msg_data OUT NOCOPY VARCHAR2
102: ,p_ipyv_rec IN ipyv_rec_type);
101: ,x_msg_data OUT NOCOPY VARCHAR2
102: ,p_ipyv_rec IN ipyv_rec_type);
103: PROCEDURE validate_ins_policies(
104: p_api_version IN NUMBER
105: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
106: ,x_return_status OUT NOCOPY VARCHAR2
107: ,x_msg_count OUT NOCOPY NUMBER
108: ,x_msg_data OUT NOCOPY VARCHAR2
109: ,p_ipyv_tbl IN ipyv_tbl_type);
108: ,x_msg_data OUT NOCOPY VARCHAR2
109: ,p_ipyv_tbl IN ipyv_tbl_type);
110: PROCEDURE validate_ins_policies(
111: p_api_version IN NUMBER
112: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
113: ,x_return_status OUT NOCOPY VARCHAR2
114: ,x_msg_count OUT NOCOPY NUMBER
115: ,x_msg_data OUT NOCOPY VARCHAR2
116: ,p_ipyv_rec IN ipyv_rec_type);