DBA Data[Home] [Help]

APPS.OKC_CONTRACT_SEQ_PUB 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_contract_seq_pvt.lsqv_rec_type;
7: subtype lsqv_tbl_type is okc_contract_seq_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_contract_seq_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_PUB';

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_PUB';
18: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
19: --
20: NO_SETUP_FOUND CONSTANT VARCHAR2(1) := 'N';
21: --
22: PROCEDURE create_seq_header(

Line 24: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

20: NO_SETUP_FOUND CONSTANT VARCHAR2(1) := 'N';
21: --
22: PROCEDURE create_seq_header(
23: p_api_version IN NUMBER,
24: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
25: x_return_status OUT NOCOPY VARCHAR2,
26: x_msg_count OUT NOCOPY NUMBER,
27: x_msg_data OUT NOCOPY VARCHAR2,
28: p_ksqv_rec IN ksqv_rec_type,

Line 33: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

29: x_ksqv_rec OUT NOCOPY ksqv_rec_type);
30:
31: PROCEDURE create_seq_header(
32: p_api_version IN NUMBER,
33: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
34: x_return_status OUT NOCOPY VARCHAR2,
35: x_msg_count OUT NOCOPY NUMBER,
36: x_msg_data OUT NOCOPY VARCHAR2,
37: p_ksqv_tbl IN ksqv_tbl_type,

Line 42: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

38: x_ksqv_tbl OUT NOCOPY ksqv_tbl_type);
39:
40: PROCEDURE update_seq_header(
41: p_api_version IN NUMBER,
42: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
43: x_return_status OUT NOCOPY VARCHAR2,
44: x_msg_count OUT NOCOPY NUMBER,
45: x_msg_data OUT NOCOPY VARCHAR2,
46: p_ksqv_rec IN ksqv_rec_type,

Line 51: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 60: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 68: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

64: p_ksqv_rec IN ksqv_rec_type);
65:
66: PROCEDURE delete_seq_header(
67: p_api_version IN NUMBER,
68: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_ksqv_tbl IN ksqv_tbl_type);

Line 76: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

72: p_ksqv_tbl IN ksqv_tbl_type);
73:
74: PROCEDURE lock_seq_header(
75: p_api_version IN NUMBER,
76: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
77: x_return_status OUT NOCOPY VARCHAR2,
78: x_msg_count OUT NOCOPY NUMBER,
79: x_msg_data OUT NOCOPY VARCHAR2,
80: p_ksqv_rec IN ksqv_rec_type);

Line 84: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

80: p_ksqv_rec IN ksqv_rec_type);
81:
82: PROCEDURE lock_seq_header(
83: p_api_version IN NUMBER,
84: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
85: x_return_status OUT NOCOPY VARCHAR2,
86: x_msg_count OUT NOCOPY NUMBER,
87: x_msg_data OUT NOCOPY VARCHAR2,
88: p_ksqv_tbl IN ksqv_tbl_type);

Line 92: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

88: p_ksqv_tbl IN ksqv_tbl_type);
89:
90: PROCEDURE validate_seq_header(
91: p_api_version IN NUMBER,
92: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
93: x_return_status OUT NOCOPY VARCHAR2,
94: x_msg_count OUT NOCOPY NUMBER,
95: x_msg_data OUT NOCOPY VARCHAR2,
96: p_ksqv_rec IN ksqv_rec_type);

Line 100: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

96: p_ksqv_rec IN ksqv_rec_type);
97:
98: PROCEDURE validate_seq_header(
99: p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
101: x_return_status OUT NOCOPY VARCHAR2,
102: x_msg_count OUT NOCOPY NUMBER,
103: x_msg_data OUT NOCOPY VARCHAR2,
104: p_ksqv_tbl IN ksqv_tbl_type);

Line 108: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 117: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 126: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 135: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 144: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 152: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 160: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 168: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 176: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 184: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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