DBA Data[Home] [Help]

APPS.OKC_QA_CHECK_LIST_PVT dependencies on OKC_API

Line 15: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;

11:
12: ---------------------------------------------------------------------------
13: -- GLOBAL MESSAGE CONSTANTS
14: ---------------------------------------------------------------------------
15: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
16: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
17: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
18: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
19: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

Line 16: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;

12: ---------------------------------------------------------------------------
13: -- GLOBAL MESSAGE CONSTANTS
14: ---------------------------------------------------------------------------
15: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
16: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
17: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
18: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
19: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
20: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

Line 17: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;

13: -- GLOBAL MESSAGE CONSTANTS
14: ---------------------------------------------------------------------------
15: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
16: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
17: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
18: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
19: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
20: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
21: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

Line 18: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;

14: ---------------------------------------------------------------------------
15: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
16: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
17: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
18: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
19: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
20: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
21: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
22: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

Line 19: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

15: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
16: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
17: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
18: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
19: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
20: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
21: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
22: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
23: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

Line 20: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

16: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
17: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
18: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
19: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
20: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
21: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
22: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
23: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
24: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

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

17: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
18: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
19: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
20: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
21: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
22: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
23: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
24: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
25: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';

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

18: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
19: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
20: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
21: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
22: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
23: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
24: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
25: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
26: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

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

19: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
20: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
21: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
22: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
23: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
24: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
25: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
26: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
27: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

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

20: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
21: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
22: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
23: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
24: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
25: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
26: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
27: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
28: G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPERCASE_REQUIRED';

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

34:
35: -- GLOBAL VARIABLES
36: ---------------------------------------------------------------------------
37: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_QA_CHECK_LIST_PVT';
38: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
39: ---------------------------------------------------------------------------
40:
41: PROCEDURE create_qa_check_list(
42: p_api_version IN NUMBER,

Line 43: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

39: ---------------------------------------------------------------------------
40:
41: PROCEDURE create_qa_check_list(
42: p_api_version IN NUMBER,
43: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
44: x_return_status OUT NOCOPY VARCHAR2,
45: x_msg_count OUT NOCOPY NUMBER,
46: x_msg_data OUT NOCOPY VARCHAR2,
47: p_qclv_rec IN qclv_rec_type,

Line 52: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

48: x_qclv_rec OUT NOCOPY qclv_rec_type);
49:
50: PROCEDURE update_qa_check_list(
51: p_api_version IN NUMBER,
52: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
53: x_return_status OUT NOCOPY VARCHAR2,
54: x_msg_count OUT NOCOPY NUMBER,
55: x_msg_data OUT NOCOPY VARCHAR2,
56: p_qclv_rec IN qclv_rec_type,

Line 61: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

57: x_qclv_rec OUT NOCOPY qclv_rec_type);
58:
59: PROCEDURE delete_qa_check_list(
60: p_api_version IN NUMBER,
61: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
62: x_return_status OUT NOCOPY VARCHAR2,
63: x_msg_count OUT NOCOPY NUMBER,
64: x_msg_data OUT NOCOPY VARCHAR2,
65: p_qclv_rec IN qclv_rec_type);

Line 69: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

65: p_qclv_rec IN qclv_rec_type);
66:
67: PROCEDURE lock_qa_check_list(
68: p_api_version IN NUMBER,
69: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
70: x_return_status OUT NOCOPY VARCHAR2,
71: x_msg_count OUT NOCOPY NUMBER,
72: x_msg_data OUT NOCOPY VARCHAR2,
73: p_qclv_rec IN qclv_rec_type);

Line 77: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

73: p_qclv_rec IN qclv_rec_type);
74:
75: PROCEDURE validate_qa_check_list(
76: p_api_version IN NUMBER,
77: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
78: x_return_status OUT NOCOPY VARCHAR2,
79: x_msg_count OUT NOCOPY NUMBER,
80: x_msg_data OUT NOCOPY VARCHAR2,
81: p_qclv_rec IN qclv_rec_type);

Line 85: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

81: p_qclv_rec IN qclv_rec_type);
82:
83: PROCEDURE create_qa_process(
84: p_api_version IN NUMBER,
85: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
86: x_return_status OUT NOCOPY VARCHAR2,
87: x_msg_count OUT NOCOPY NUMBER,
88: x_msg_data OUT NOCOPY VARCHAR2,
89: p_qlpv_rec IN qlpv_rec_type,

Line 94: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

90: x_qlpv_rec OUT NOCOPY qlpv_rec_type);
91:
92: PROCEDURE update_qa_process(
93: p_api_version IN NUMBER,
94: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_qlpv_rec IN qlpv_rec_type,

Line 103: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

99: x_qlpv_rec OUT NOCOPY qlpv_rec_type);
100:
101: PROCEDURE delete_qa_process(
102: p_api_version IN NUMBER,
103: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
106: x_msg_data OUT NOCOPY VARCHAR2,
107: p_qlpv_rec IN qlpv_rec_type);

Line 111: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

107: p_qlpv_rec IN qlpv_rec_type);
108:
109: PROCEDURE lock_qa_process(
110: p_api_version IN NUMBER,
111: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
112: x_return_status OUT NOCOPY VARCHAR2,
113: x_msg_count OUT NOCOPY NUMBER,
114: x_msg_data OUT NOCOPY VARCHAR2,
115: p_qlpv_rec IN qlpv_rec_type);

Line 119: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

115: p_qlpv_rec IN qlpv_rec_type);
116:
117: PROCEDURE validate_qa_process(
118: p_api_version IN NUMBER,
119: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
120: x_return_status OUT NOCOPY VARCHAR2,
121: x_msg_count OUT NOCOPY NUMBER,
122: x_msg_data OUT NOCOPY VARCHAR2,
123: p_qlpv_rec IN qlpv_rec_type);

Line 127: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

123: p_qlpv_rec IN qlpv_rec_type);
124:
125: PROCEDURE create_qa_parm(
126: p_api_version IN NUMBER,
127: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
128: x_return_status OUT NOCOPY VARCHAR2,
129: x_msg_count OUT NOCOPY NUMBER,
130: x_msg_data OUT NOCOPY VARCHAR2,
131: p_qppv_rec IN qppv_rec_type,

Line 136: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

132: x_qppv_rec OUT NOCOPY qppv_rec_type);
133:
134: PROCEDURE update_qa_parm(
135: p_api_version IN NUMBER,
136: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
137: x_return_status OUT NOCOPY VARCHAR2,
138: x_msg_count OUT NOCOPY NUMBER,
139: x_msg_data OUT NOCOPY VARCHAR2,
140: p_qppv_rec IN qppv_rec_type,

Line 145: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

141: x_qppv_rec OUT NOCOPY qppv_rec_type);
142:
143: PROCEDURE delete_qa_parm(
144: p_api_version IN NUMBER,
145: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
146: x_return_status OUT NOCOPY VARCHAR2,
147: x_msg_count OUT NOCOPY NUMBER,
148: x_msg_data OUT NOCOPY VARCHAR2,
149: p_qppv_rec IN qppv_rec_type);

Line 153: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

149: p_qppv_rec IN qppv_rec_type);
150:
151: PROCEDURE lock_qa_parm(
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2,
157: p_qppv_rec IN qppv_rec_type);

Line 161: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

157: p_qppv_rec IN qppv_rec_type);
158:
159: PROCEDURE validate_qa_parm(
160: p_api_version IN NUMBER,
161: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
162: x_return_status OUT NOCOPY VARCHAR2,
163: x_msg_count OUT NOCOPY NUMBER,
164: x_msg_data OUT NOCOPY VARCHAR2,
165: p_qppv_rec IN qppv_rec_type);