DBA Data[Home] [Help]

APPS.OKS_PM_PROGRAMS_PVT dependencies on OKC_API

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

3: --------- ------ ------------------------------------------
4: -- GLOBAL VARIABLES
5: ---------------------------------------------------------------------------
6: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_PM_PROGRAMS_PVT';
7: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
8: G_APP_NAME_OKS CONSTANT VARCHAR2(3) := 'OKS';
9: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
10: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
11: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

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

9: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
10: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
11: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
12: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
13: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
14: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
15:
16: --for debug log
17: G_DEBUG_ENABLED VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

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

10: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
11: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
12: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
13: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
14: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
15:
16: --for debug log
17: G_DEBUG_ENABLED VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
18:

Line 76: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

72: TYPE pm_tbl_type IS TABLE OF pm_rec_type INDEX BY BINARY_INTEGER;
73:
74: PROCEDURE GENERATE_SCHEDULE
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_periods IN NUMBER,

Line 92: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

88: x_pms_tbl OUT NOCOPY pms_tbl_type);
89:
90: PROCEDURE RENEW_PM_PROGRAM_SCHEDULE
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_contract_line_id IN NUMBER);

Line 100: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

96: p_contract_line_id IN NUMBER);
97:
98: PROCEDURE ADJUST_PM_PROGRAM_SCHEDULE
99: (p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
101: p_contract_line_id IN NUMBER,
102: p_new_start_date IN DATE,
103: p_new_end_date IN DATE,
104: x_return_status OUT NOCOPY VARCHAR2,

Line 111: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

107:
108:
109: /* --for upgrade from Phase I - this needs to be changed for rules rearchitecture
110: PROCEDURE update_pmp_rule_id(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:

Line 118: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

114: x_msg_data OUT NOCOPY VARCHAR2);*/
115:
116: PROCEDURE CREATE_PM_PROGRAM_SCHEDULE
117: (p_api_version IN NUMBER,
118: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
119: x_return_status OUT NOCOPY VARCHAR2,
120: x_msg_count OUT NOCOPY NUMBER,
121: x_msg_data OUT NOCOPY VARCHAR2,
122: p_template_cle_id IN NUMBER,

Line 129: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

125: p_cov_end_date IN DATE);
126:
127: PROCEDURE REFRESH_PM_PROGRAM_SCHEDULE
128: (p_api_version IN NUMBER,
129: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
130: x_return_status OUT NOCOPY VARCHAR2,
131: x_msg_count OUT NOCOPY NUMBER,
132: x_msg_data OUT NOCOPY VARCHAR2,
133: p_cov_tbl IN okc_contract_pub.clev_tbl_type,

Line 140: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

136: x_pmschv_tbl OUT NOCOPY pmsch_refresh_tbl_type);
137:
138: PROCEDURE POPULATE_SCHEDULE
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_pmlrulv_tbl IN oks_pml_pvt.pmlv_tbl_type,

Line 153: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 162: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

158: PROCEDURE migrate_to_activities
159: ( p_start_rowid IN ROWID,
160: p_end_rowid IN ROWID,
161: p_api_version IN NUMBER,
162: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
163: x_msg_count OUT NOCOPY NUMBER,
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_data OUT NOCOPY VARCHAR2);
166:

Line 170: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

166:
167: --New procedure to be called from coverage comparison code
168: PROCEDURE check_pm_match
169: ( p_api_version IN NUMBER,
170: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
171: x_return_status OUT NOCOPY VARCHAR2,
172: x_msg_count OUT NOCOPY NUMBER,
173: x_msg_data OUT NOCOPY VARCHAR2,
174: P_Source_coverage_Line_Id IN NUMBER,

Line 202: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

198:
199: PROCEDURE UNDO_PM_LINE
200: (
201: p_api_version IN NUMBER,
202: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
203: x_return_status OUT NOCOPY VARCHAR2,
204: x_msg_count OUT NOCOPY NUMBER,
205: x_msg_data OUT NOCOPY VARCHAR2,
206: p_cle_id IN NUMBER);

Line 247: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

243:
244: -- New procedure for copying PM for coverage template
245: PROCEDURE Copy_PM_Template (
246: p_api_version IN NUMBER,
247: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
248: x_return_status OUT NOCOPY VARCHAR2,
249: x_msg_count OUT NOCOPY NUMBER,
250: x_msg_data OUT NOCOPY VARCHAR2,
251: p_old_coverage_id IN NUMBER,