DBA Data[Home] [Help]

APPS.OKL_QSH_PVT dependencies on OKL_API

Line 29: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;

25: INDEX BY BINARY_INTEGER;
26: ---------------------------------------------------------------------------
27: -- GLOBAL MESSAGE CONSTANTS
28: ---------------------------------------------------------------------------
29: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
30: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
31: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
32: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
33: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;

Line 30: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;

26: ---------------------------------------------------------------------------
27: -- GLOBAL MESSAGE CONSTANTS
28: ---------------------------------------------------------------------------
29: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
30: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
31: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
32: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
33: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
34: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

Line 31: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;

27: -- GLOBAL MESSAGE CONSTANTS
28: ---------------------------------------------------------------------------
29: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
30: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
31: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
32: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
33: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
34: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
35: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

Line 32: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;

28: ---------------------------------------------------------------------------
29: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
30: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
31: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
32: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
33: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
34: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
35: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
36: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

Line 33: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;

29: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
30: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
31: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
32: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
33: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
34: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
35: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
36: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
37: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;

Line 34: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

30: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
31: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
32: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
33: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
34: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
35: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
36: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
37: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
38: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;

Line 35: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

31: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
32: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
33: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
34: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
35: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
36: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
37: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
38: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
39: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';

Line 36: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

32: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
33: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
34: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
35: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
36: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
37: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
38: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
39: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
40: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

Line 37: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;

33: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
34: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
35: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
36: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
37: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
38: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
39: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
40: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
41: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

Line 38: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;

34: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
35: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
36: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
37: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
38: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
39: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
40: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
41: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
42:

Line 52: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

48: ---------------------------------------------------------------------------
49: -- GLOBAL VARIABLES
50: ---------------------------------------------------------------------------
51: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_QSH_PVT';
52: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
53: ---------------------------------------------------------------------------
54: -- Procedures and Functions
55: ---------------------------------------------------------------------------
56:

Line 62: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

58: PROCEDURE change_version;
59: PROCEDURE api_copy;
60: PROCEDURE insert_row(
61: p_api_version IN NUMBER,
62: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
63: x_return_status OUT NOCOPY VARCHAR2,
64: x_msg_count OUT NOCOPY NUMBER,
65: x_msg_data OUT NOCOPY VARCHAR2,
66: p_qsh_rec IN qsh_rec_type,

Line 70: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

66: p_qsh_rec IN qsh_rec_type,
67: x_qsh_rec OUT NOCOPY qsh_rec_type);
68: PROCEDURE insert_row(
69: p_api_version IN NUMBER,
70: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
71: x_return_status OUT NOCOPY VARCHAR2,
72: x_msg_count OUT NOCOPY NUMBER,
73: x_msg_data OUT NOCOPY VARCHAR2,
74: p_qsh_tbl IN qsh_tbl_type,

Line 76: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

72: x_msg_count OUT NOCOPY NUMBER,
73: x_msg_data OUT NOCOPY VARCHAR2,
74: p_qsh_tbl IN qsh_tbl_type,
75: x_qsh_tbl OUT NOCOPY qsh_tbl_type,
76: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
77: PROCEDURE insert_row(
78: p_api_version IN NUMBER,
79: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
80: x_return_status OUT NOCOPY VARCHAR2,

Line 79: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

75: x_qsh_tbl OUT NOCOPY qsh_tbl_type,
76: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
77: PROCEDURE insert_row(
78: p_api_version IN NUMBER,
79: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
80: x_return_status OUT NOCOPY VARCHAR2,
81: x_msg_count OUT NOCOPY NUMBER,
82: x_msg_data OUT NOCOPY VARCHAR2,
83: p_qsh_tbl IN qsh_tbl_type,

Line 87: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

83: p_qsh_tbl IN qsh_tbl_type,
84: x_qsh_tbl OUT NOCOPY qsh_tbl_type);
85: PROCEDURE lock_row(
86: p_api_version IN NUMBER,
87: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
88: x_return_status OUT NOCOPY VARCHAR2,
89: x_msg_count OUT NOCOPY NUMBER,
90: x_msg_data OUT NOCOPY VARCHAR2,
91: p_qsh_rec IN qsh_rec_type);

Line 94: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

90: x_msg_data OUT NOCOPY VARCHAR2,
91: p_qsh_rec IN qsh_rec_type);
92: PROCEDURE lock_row(
93: p_api_version IN NUMBER,
94: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
95: x_return_status OUT NOCOPY VARCHAR2,
96: x_msg_count OUT NOCOPY NUMBER,
97: x_msg_data OUT NOCOPY VARCHAR2,
98: p_qsh_tbl IN qsh_tbl_type,

Line 99: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

95: x_return_status OUT NOCOPY VARCHAR2,
96: x_msg_count OUT NOCOPY NUMBER,
97: x_msg_data OUT NOCOPY VARCHAR2,
98: p_qsh_tbl IN qsh_tbl_type,
99: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
100: PROCEDURE lock_row(
101: p_api_version IN NUMBER,
102: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
103: x_return_status OUT NOCOPY VARCHAR2,

Line 102: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

98: p_qsh_tbl IN qsh_tbl_type,
99: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
100: PROCEDURE lock_row(
101: p_api_version IN NUMBER,
102: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
103: x_return_status OUT NOCOPY VARCHAR2,
104: x_msg_count OUT NOCOPY NUMBER,
105: x_msg_data OUT NOCOPY VARCHAR2,
106: p_qsh_tbl IN qsh_tbl_type);

Line 109: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

105: x_msg_data OUT NOCOPY VARCHAR2,
106: p_qsh_tbl IN qsh_tbl_type);
107: PROCEDURE update_row(
108: p_api_version IN NUMBER,
109: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
110: x_return_status OUT NOCOPY VARCHAR2,
111: x_msg_count OUT NOCOPY NUMBER,
112: x_msg_data OUT NOCOPY VARCHAR2,
113: p_qsh_rec IN qsh_rec_type,

Line 117: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

113: p_qsh_rec IN qsh_rec_type,
114: x_qsh_rec OUT NOCOPY qsh_rec_type);
115: PROCEDURE update_row(
116: p_api_version IN NUMBER,
117: p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_qsh_tbl IN qsh_tbl_type,

Line 123: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

119: x_msg_count OUT NOCOPY NUMBER,
120: x_msg_data OUT NOCOPY VARCHAR2,
121: p_qsh_tbl IN qsh_tbl_type,
122: x_qsh_tbl OUT NOCOPY qsh_tbl_type,
123: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
124: PROCEDURE update_row(
125: p_api_version IN NUMBER,
126: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
127: x_return_status OUT NOCOPY VARCHAR2,

Line 126: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

122: x_qsh_tbl OUT NOCOPY qsh_tbl_type,
123: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
124: PROCEDURE update_row(
125: p_api_version IN NUMBER,
126: p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_qsh_tbl IN qsh_tbl_type,

Line 134: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

130: p_qsh_tbl IN qsh_tbl_type,
131: x_qsh_tbl OUT NOCOPY qsh_tbl_type);
132: PROCEDURE delete_row(
133: p_api_version IN NUMBER,
134: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
135: x_return_status OUT NOCOPY VARCHAR2,
136: x_msg_count OUT NOCOPY NUMBER,
137: x_msg_data OUT NOCOPY VARCHAR2,
138: p_qsh_rec IN qsh_rec_type);

Line 141: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

137: x_msg_data OUT NOCOPY VARCHAR2,
138: p_qsh_rec IN qsh_rec_type);
139: PROCEDURE delete_row(
140: p_api_version IN NUMBER,
141: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
142: x_return_status OUT NOCOPY VARCHAR2,
143: x_msg_count OUT NOCOPY NUMBER,
144: x_msg_data OUT NOCOPY VARCHAR2,
145: p_qsh_tbl IN qsh_tbl_type,

Line 146: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

142: x_return_status OUT NOCOPY VARCHAR2,
143: x_msg_count OUT NOCOPY NUMBER,
144: x_msg_data OUT NOCOPY VARCHAR2,
145: p_qsh_tbl IN qsh_tbl_type,
146: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
147: PROCEDURE delete_row(
148: p_api_version IN NUMBER,
149: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
150: x_return_status OUT NOCOPY VARCHAR2,

Line 149: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

145: p_qsh_tbl IN qsh_tbl_type,
146: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
147: PROCEDURE delete_row(
148: p_api_version IN NUMBER,
149: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
150: x_return_status OUT NOCOPY VARCHAR2,
151: x_msg_count OUT NOCOPY NUMBER,
152: x_msg_data OUT NOCOPY VARCHAR2,
153: p_qsh_tbl IN qsh_tbl_type);

Line 156: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

152: x_msg_data OUT NOCOPY VARCHAR2,
153: p_qsh_tbl IN qsh_tbl_type);
154: PROCEDURE validate_row(
155: p_api_version IN NUMBER,
156: p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_qsh_rec IN qsh_rec_type);

Line 163: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

159: x_msg_data OUT NOCOPY VARCHAR2,
160: p_qsh_rec IN qsh_rec_type);
161: PROCEDURE validate_row(
162: p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,
166: x_msg_data OUT NOCOPY VARCHAR2,
167: p_qsh_tbl IN qsh_tbl_type,

Line 168: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,
166: x_msg_data OUT NOCOPY VARCHAR2,
167: p_qsh_tbl IN qsh_tbl_type,
168: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
169: PROCEDURE validate_row(
170: p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
172: x_return_status OUT NOCOPY VARCHAR2,

Line 171: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

167: p_qsh_tbl IN qsh_tbl_type,
168: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
169: PROCEDURE validate_row(
170: p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2,
175: p_qsh_tbl IN qsh_tbl_type);