DBA Data[Home] [Help]

APPS.OKC_SECTIONS_PUB dependencies on OKC_API

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

7: subtype sccv_tbl_type is okc_sections_pvt.sccv_tbl_type;
8:
9: -- Global variables for user hooks
10: g_pkg_name CONSTANT VARCHAR2(200) := 'OKC_SECTIONS_PUB';
11: g_app_name CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
12:
13: g_scnv_rec scnv_rec_type;
14: g_scnv_tbl scnv_tbl_type;
15: g_sccv_rec sccv_rec_type;

Line 20: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

16: g_sccv_tbl sccv_tbl_type;
17:
18: PROCEDURE create_section(
19: p_api_version IN NUMBER,
20: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
21: x_return_status OUT NOCOPY VARCHAR2,
22: x_msg_count OUT NOCOPY NUMBER,
23: x_msg_data OUT NOCOPY VARCHAR2,
24: p_scnv_rec IN scnv_rec_type,

Line 29: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

25: x_scnv_rec OUT NOCOPY scnv_rec_type);
26:
27: PROCEDURE create_section(
28: p_api_version IN NUMBER,
29: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
30: x_return_status OUT NOCOPY VARCHAR2,
31: x_msg_count OUT NOCOPY NUMBER,
32: x_msg_data OUT NOCOPY VARCHAR2,
33: p_scnv_tbl IN scnv_tbl_type,

Line 38: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

34: x_scnv_tbl OUT NOCOPY scnv_tbl_type);
35:
36: PROCEDURE update_section(
37: p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
39: x_return_status OUT NOCOPY VARCHAR2,
40: x_msg_count OUT NOCOPY NUMBER,
41: x_msg_data OUT NOCOPY VARCHAR2,
42: p_scnv_rec IN scnv_rec_type,

Line 47: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

43: x_scnv_rec OUT NOCOPY scnv_rec_type);
44:
45: PROCEDURE update_section(
46: p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
48: x_return_status OUT NOCOPY VARCHAR2,
49: x_msg_count OUT NOCOPY NUMBER,
50: x_msg_data OUT NOCOPY VARCHAR2,
51: p_scnv_tbl IN scnv_tbl_type,

Line 56: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

52: x_scnv_tbl OUT NOCOPY scnv_tbl_type);
53:
54: PROCEDURE delete_section(
55: p_api_version IN NUMBER,
56: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_scnv_rec IN scnv_rec_type);

Line 64: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

60: p_scnv_rec IN scnv_rec_type);
61:
62: PROCEDURE delete_section(
63: p_api_version IN NUMBER,
64: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
65: x_return_status OUT NOCOPY VARCHAR2,
66: x_msg_count OUT NOCOPY NUMBER,
67: x_msg_data OUT NOCOPY VARCHAR2,
68: p_scnv_tbl IN scnv_tbl_type);

Line 72: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

68: p_scnv_tbl IN scnv_tbl_type);
69:
70: PROCEDURE lock_section(
71: p_api_version IN NUMBER,
72: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
73: x_return_status OUT NOCOPY VARCHAR2,
74: x_msg_count OUT NOCOPY NUMBER,
75: x_msg_data OUT NOCOPY VARCHAR2,
76: p_scnv_rec IN scnv_rec_type);

Line 80: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

76: p_scnv_rec IN scnv_rec_type);
77:
78: PROCEDURE lock_section(
79: p_api_version IN NUMBER,
80: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
81: x_return_status OUT NOCOPY VARCHAR2,
82: x_msg_count OUT NOCOPY NUMBER,
83: x_msg_data OUT NOCOPY VARCHAR2,
84: p_scnv_tbl IN scnv_tbl_type);

Line 88: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

84: p_scnv_tbl IN scnv_tbl_type);
85:
86: PROCEDURE validate_section(
87: p_api_version IN NUMBER,
88: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
89: x_return_status OUT NOCOPY VARCHAR2,
90: x_msg_count OUT NOCOPY NUMBER,
91: x_msg_data OUT NOCOPY VARCHAR2,
92: p_scnv_rec IN scnv_rec_type);

Line 96: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

92: p_scnv_rec IN scnv_rec_type);
93:
94: PROCEDURE validate_section(
95: p_api_version IN NUMBER,
96: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
97: x_return_status OUT NOCOPY VARCHAR2,
98: x_msg_count OUT NOCOPY NUMBER,
99: x_msg_data OUT NOCOPY VARCHAR2,
100: p_scnv_tbl IN scnv_tbl_type);

Line 104: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

100: p_scnv_tbl IN scnv_tbl_type);
101:
102: PROCEDURE create_section_content(
103: p_api_version IN NUMBER,
104: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
105: x_return_status OUT NOCOPY VARCHAR2,
106: x_msg_count OUT NOCOPY NUMBER,
107: x_msg_data OUT NOCOPY VARCHAR2,
108: p_sccv_rec IN sccv_rec_type,

Line 113: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

109: x_sccv_rec OUT NOCOPY sccv_rec_type);
110:
111: PROCEDURE create_section_content(
112: p_api_version IN NUMBER,
113: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
114: x_return_status OUT NOCOPY VARCHAR2,
115: x_msg_count OUT NOCOPY NUMBER,
116: x_msg_data OUT NOCOPY VARCHAR2,
117: p_sccv_tbl IN sccv_tbl_type,

Line 122: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

118: x_sccv_tbl OUT NOCOPY sccv_tbl_type);
119:
120: PROCEDURE update_section_content(
121: p_api_version IN NUMBER,
122: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
123: x_return_status OUT NOCOPY VARCHAR2,
124: x_msg_count OUT NOCOPY NUMBER,
125: x_msg_data OUT NOCOPY VARCHAR2,
126: p_sccv_rec IN sccv_rec_type,

Line 131: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

127: x_sccv_rec OUT NOCOPY sccv_rec_type);
128:
129: PROCEDURE update_section_content(
130: p_api_version IN NUMBER,
131: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
132: x_return_status OUT NOCOPY VARCHAR2,
133: x_msg_count OUT NOCOPY NUMBER,
134: x_msg_data OUT NOCOPY VARCHAR2,
135: p_sccv_tbl IN sccv_tbl_type,

Line 140: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

136: x_sccv_tbl OUT NOCOPY sccv_tbl_type);
137:
138: PROCEDURE delete_section_content(
139: p_api_version IN NUMBER,
140: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2,
144: p_sccv_rec IN sccv_rec_type);

Line 148: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

144: p_sccv_rec IN sccv_rec_type);
145:
146: PROCEDURE delete_section_content(
147: p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,
151: x_msg_data OUT NOCOPY VARCHAR2,
152: p_sccv_tbl IN sccv_tbl_type);

Line 156: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

152: p_sccv_tbl IN sccv_tbl_type);
153:
154: PROCEDURE lock_section_content(
155: p_api_version IN NUMBER,
156: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
157: x_return_status OUT NOCOPY VARCHAR2,
158: x_msg_count OUT NOCOPY NUMBER,
159: x_msg_data OUT NOCOPY VARCHAR2,
160: p_sccv_rec IN sccv_rec_type);

Line 164: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

160: p_sccv_rec IN sccv_rec_type);
161:
162: PROCEDURE lock_section_content(
163: p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
165: x_return_status OUT NOCOPY VARCHAR2,
166: x_msg_count OUT NOCOPY NUMBER,
167: x_msg_data OUT NOCOPY VARCHAR2,
168: p_sccv_tbl IN sccv_tbl_type);

Line 172: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

168: p_sccv_tbl IN sccv_tbl_type);
169:
170: PROCEDURE validate_section_content(
171: p_api_version IN NUMBER,
172: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
173: x_return_status OUT NOCOPY VARCHAR2,
174: x_msg_count OUT NOCOPY NUMBER,
175: x_msg_data OUT NOCOPY VARCHAR2,
176: p_sccv_rec IN sccv_rec_type);

Line 180: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

176: p_sccv_rec IN sccv_rec_type);
177:
178: PROCEDURE validate_section_content(
179: p_api_version IN NUMBER,
180: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
181: x_return_status OUT NOCOPY VARCHAR2,
182: x_msg_count OUT NOCOPY NUMBER,
183: x_msg_data OUT NOCOPY VARCHAR2,
184: p_sccv_tbl IN sccv_tbl_type);