5: subtype PTMv_tbl_type is okl_PTM_pvt.PTMv_tbl_type;
6: ------------------------------------------------------------------------------
7: -- Global Variables
8: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_PROCESS_TMPLTS_PUB';
9: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
10: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
11: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
12: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
13: ------------------------------------------------------------------------------
18:
19:
20: PROCEDURE insert_PROCESS_TMPLTS(
21: p_api_version IN NUMBER
22: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
23: ,x_return_status OUT NOCOPY VARCHAR2
24: ,x_msg_count OUT NOCOPY NUMBER
25: ,x_msg_data OUT NOCOPY VARCHAR2
26: ,p_PTMv_tbl IN PTMv_tbl_type
27: ,x_PTMv_tbl OUT NOCOPY PTMv_tbl_type);
28:
29: PROCEDURE insert_PROCESS_TMPLTS(
30: p_api_version IN NUMBER
31: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_PTMv_rec IN PTMv_rec_type
36: ,x_PTMv_rec OUT NOCOPY PTMv_rec_type);
37:
38: PROCEDURE lock_PROCESS_TMPLTS(
39: p_api_version IN NUMBER
40: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
41: ,x_return_status OUT NOCOPY VARCHAR2
42: ,x_msg_count OUT NOCOPY NUMBER
43: ,x_msg_data OUT NOCOPY VARCHAR2
44: ,p_PTMv_tbl IN PTMv_tbl_type);
44: ,p_PTMv_tbl IN PTMv_tbl_type);
45:
46: PROCEDURE lock_PROCESS_TMPLTS(
47: p_api_version IN NUMBER
48: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
49: ,x_return_status OUT NOCOPY VARCHAR2
50: ,x_msg_count OUT NOCOPY NUMBER
51: ,x_msg_data OUT NOCOPY VARCHAR2
52: ,p_PTMv_rec IN PTMv_rec_type);
52: ,p_PTMv_rec IN PTMv_rec_type);
53:
54: PROCEDURE update_PROCESS_TMPLTS(
55: p_api_version IN NUMBER
56: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
57: ,x_return_status OUT NOCOPY VARCHAR2
58: ,x_msg_count OUT NOCOPY NUMBER
59: ,x_msg_data OUT NOCOPY VARCHAR2
60: ,p_PTMv_tbl IN PTMv_tbl_type
61: ,x_PTMv_tbl OUT NOCOPY PTMv_tbl_type);
62:
63: PROCEDURE update_PROCESS_TMPLTS(
64: p_api_version IN NUMBER
65: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
66: ,x_return_status OUT NOCOPY VARCHAR2
67: ,x_msg_count OUT NOCOPY NUMBER
68: ,x_msg_data OUT NOCOPY VARCHAR2
69: ,p_PTMv_rec IN PTMv_rec_type
70: ,x_PTMv_rec OUT NOCOPY PTMv_rec_type);
71:
72: PROCEDURE delete_PROCESS_TMPLTS(
73: p_api_version IN NUMBER
74: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
75: ,x_return_status OUT NOCOPY VARCHAR2
76: ,x_msg_count OUT NOCOPY NUMBER
77: ,x_msg_data OUT NOCOPY VARCHAR2
78: ,p_PTMv_tbl IN PTMv_tbl_type);
78: ,p_PTMv_tbl IN PTMv_tbl_type);
79:
80: PROCEDURE delete_PROCESS_TMPLTS(
81: p_api_version IN NUMBER
82: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
83: ,x_return_status OUT NOCOPY VARCHAR2
84: ,x_msg_count OUT NOCOPY NUMBER
85: ,x_msg_data OUT NOCOPY VARCHAR2
86: ,p_PTMv_rec IN PTMv_rec_type);
86: ,p_PTMv_rec IN PTMv_rec_type);
87:
88: PROCEDURE validate_PROCESS_TMPLTS(
89: p_api_version IN NUMBER
90: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
91: ,x_return_status OUT NOCOPY VARCHAR2
92: ,x_msg_count OUT NOCOPY NUMBER
93: ,x_msg_data OUT NOCOPY VARCHAR2
94: ,p_PTMv_tbl IN PTMv_tbl_type);
94: ,p_PTMv_tbl IN PTMv_tbl_type);
95:
96: PROCEDURE validate_PROCESS_TMPLTS(
97: p_api_version IN NUMBER
98: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_PTMv_rec IN PTMv_rec_type);