DBA Data[Home] [Help]

APPS.OKC_CONTRACT_SEQ_PVT dependencies on OKC_API

Line 10: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

6: subtype lsqv_rec_type is okc_lsq_pvt.lsqv_rec_type;
7: subtype lsqv_tbl_type is okc_lsq_pvt.lsqv_tbl_type;
8:
9: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
10: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
11: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
12: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
13: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
14: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';

Line 11: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

7: subtype lsqv_tbl_type is okc_lsq_pvt.lsqv_tbl_type;
8:
9: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
10: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
11: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
12: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
13: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
14: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
15: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';

Line 12: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

8:
9: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
10: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
11: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
12: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
13: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
14: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
15: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
16: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';

Line 13: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

9: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
10: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
11: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
12: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
13: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
14: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
15: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
16: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
17: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CONTRACT_SEQ_PVT';

Line 18: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

14: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
15: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
16: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
17: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CONTRACT_SEQ_PVT';
18: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
19:
20: PROCEDURE create_seq_header(
21: p_api_version IN NUMBER,
22: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 22: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

18: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
19:
20: PROCEDURE create_seq_header(
21: p_api_version IN NUMBER,
22: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_ksqv_rec IN ksqv_rec_type,

Line 31: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

27: x_ksqv_rec OUT NOCOPY ksqv_rec_type);
28:
29: PROCEDURE create_seq_header(
30: p_api_version IN NUMBER,
31: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_ksqv_tbl IN ksqv_tbl_type,

Line 40: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

36: x_ksqv_tbl OUT NOCOPY ksqv_tbl_type);
37:
38: PROCEDURE update_seq_header(
39: p_api_version IN NUMBER,
40: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_ksqv_rec IN ksqv_rec_type,

Line 49: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

45: x_ksqv_rec OUT NOCOPY ksqv_rec_type);
46:
47: PROCEDURE update_seq_header(
48: p_api_version IN NUMBER,
49: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
50: x_return_status OUT NOCOPY VARCHAR2,
51: x_msg_count OUT NOCOPY NUMBER,
52: x_msg_data OUT NOCOPY VARCHAR2,
53: p_ksqv_tbl IN ksqv_tbl_type,

Line 58: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

54: x_ksqv_tbl OUT NOCOPY ksqv_tbl_type);
55:
56: PROCEDURE delete_seq_header(
57: p_api_version IN NUMBER,
58: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
59: x_return_status OUT NOCOPY VARCHAR2,
60: x_msg_count OUT NOCOPY NUMBER,
61: x_msg_data OUT NOCOPY VARCHAR2,
62: p_ksqv_rec IN ksqv_rec_type);

Line 66: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

62: p_ksqv_rec IN ksqv_rec_type);
63:
64: PROCEDURE delete_seq_header(
65: p_api_version IN NUMBER,
66: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
67: x_return_status OUT NOCOPY VARCHAR2,
68: x_msg_count OUT NOCOPY NUMBER,
69: x_msg_data OUT NOCOPY VARCHAR2,
70: p_ksqv_tbl IN ksqv_tbl_type);

Line 74: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

70: p_ksqv_tbl IN ksqv_tbl_type);
71:
72: PROCEDURE lock_seq_header(
73: p_api_version IN NUMBER,
74: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_ksqv_rec IN ksqv_rec_type);

Line 82: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

78: p_ksqv_rec IN ksqv_rec_type);
79:
80: PROCEDURE lock_seq_header(
81: p_api_version IN NUMBER,
82: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_ksqv_tbl IN ksqv_tbl_type);

Line 90: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

86: p_ksqv_tbl IN ksqv_tbl_type);
87:
88: PROCEDURE validate_seq_header(
89: p_api_version IN NUMBER,
90: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_ksqv_rec IN ksqv_rec_type);

Line 98: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

94: p_ksqv_rec IN ksqv_rec_type);
95:
96: PROCEDURE validate_seq_header(
97: p_api_version IN NUMBER,
98: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_ksqv_tbl IN ksqv_tbl_type);

Line 106: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

102: p_ksqv_tbl IN ksqv_tbl_type);
103:
104: PROCEDURE create_seq_lines(
105: p_api_version IN NUMBER,
106: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
107: x_return_status OUT NOCOPY VARCHAR2,
108: x_msg_count OUT NOCOPY NUMBER,
109: x_msg_data OUT NOCOPY VARCHAR2,
110: p_lsqv_rec IN lsqv_rec_type,

Line 115: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

111: x_lsqv_rec OUT NOCOPY lsqv_rec_type);
112:
113: PROCEDURE create_seq_lines(
114: p_api_version IN NUMBER,
115: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
116: x_return_status OUT NOCOPY VARCHAR2,
117: x_msg_count OUT NOCOPY NUMBER,
118: x_msg_data OUT NOCOPY VARCHAR2,
119: p_lsqv_tbl IN lsqv_tbl_type,

Line 124: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

120: x_lsqv_tbl OUT NOCOPY lsqv_tbl_type);
121:
122: PROCEDURE update_seq_lines(
123: p_api_version IN NUMBER,
124: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
125: x_return_status OUT NOCOPY VARCHAR2,
126: x_msg_count OUT NOCOPY NUMBER,
127: x_msg_data OUT NOCOPY VARCHAR2,
128: p_lsqv_rec IN lsqv_rec_type,

Line 133: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

129: x_lsqv_rec OUT NOCOPY lsqv_rec_type);
130:
131: PROCEDURE update_seq_lines(
132: p_api_version IN NUMBER,
133: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
134: x_return_status OUT NOCOPY VARCHAR2,
135: x_msg_count OUT NOCOPY NUMBER,
136: x_msg_data OUT NOCOPY VARCHAR2,
137: p_lsqv_tbl IN lsqv_tbl_type,

Line 142: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

138: x_lsqv_tbl OUT NOCOPY lsqv_tbl_type);
139:
140: PROCEDURE delete_seq_lines(
141: p_api_version IN NUMBER,
142: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
143: x_return_status OUT NOCOPY VARCHAR2,
144: x_msg_count OUT NOCOPY NUMBER,
145: x_msg_data OUT NOCOPY VARCHAR2,
146: p_lsqv_rec IN lsqv_rec_type);

Line 150: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

146: p_lsqv_rec IN lsqv_rec_type);
147:
148: PROCEDURE delete_seq_lines(
149: p_api_version IN NUMBER,
150: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
151: x_return_status OUT NOCOPY VARCHAR2,
152: x_msg_count OUT NOCOPY NUMBER,
153: x_msg_data OUT NOCOPY VARCHAR2,
154: p_lsqv_tbl IN lsqv_tbl_type);

Line 158: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

154: p_lsqv_tbl IN lsqv_tbl_type);
155:
156: PROCEDURE lock_seq_lines(
157: p_api_version IN NUMBER,
158: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_count OUT NOCOPY NUMBER,
161: x_msg_data OUT NOCOPY VARCHAR2,
162: p_lsqv_rec IN lsqv_rec_type);

Line 166: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

162: p_lsqv_rec IN lsqv_rec_type);
163:
164: PROCEDURE lock_seq_lines(
165: p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
167: x_return_status OUT NOCOPY VARCHAR2,
168: x_msg_count OUT NOCOPY NUMBER,
169: x_msg_data OUT NOCOPY VARCHAR2,
170: p_lsqv_tbl IN lsqv_tbl_type);

Line 174: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

170: p_lsqv_tbl IN lsqv_tbl_type);
171:
172: PROCEDURE validate_seq_lines(
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
175: x_return_status OUT NOCOPY VARCHAR2,
176: x_msg_count OUT NOCOPY NUMBER,
177: x_msg_data OUT NOCOPY VARCHAR2,
178: p_lsqv_rec IN lsqv_rec_type);

Line 182: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

178: p_lsqv_rec IN lsqv_rec_type);
179:
180: PROCEDURE validate_seq_lines(
181: p_api_version IN NUMBER,
182: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
183: x_return_status OUT NOCOPY VARCHAR2,
184: x_msg_count OUT NOCOPY NUMBER,
185: x_msg_data OUT NOCOPY VARCHAR2,
186: p_lsqv_tbl IN lsqv_tbl_type);