eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_RENEW_PVT dependencies on OKC_API

Line 23: p_context varchar2(30) DEFAULT OKC_API.G_MISS_CHAR,

19: p_orig_start_date date,
20: p_orig_end_date date,
21: p_uom_code okx_units_of_measure_v.uom_code%type,
22: p_duration number,
23: p_context varchar2(30) DEFAULT OKC_API.G_MISS_CHAR,
24: p_perpetual_flag varchar2(1) DEFAULT OKC_API.G_FALSE
25: );
26:
27:

Line 24: p_perpetual_flag varchar2(1) DEFAULT OKC_API.G_FALSE

20: p_orig_end_date date,
21: p_uom_code okx_units_of_measure_v.uom_code%type,
22: p_duration number,
23: p_context varchar2(30) DEFAULT OKC_API.G_MISS_CHAR,
24: p_perpetual_flag varchar2(1) DEFAULT OKC_API.G_FALSE
25: );
26:
27:
28: Type Renew_in_parameters_tbl is table of Renew_in_parameters_rec

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

43: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
44: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
45: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
46: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_RENEW_PVT';
47: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
48: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
49: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
50: G_DNR_MSG CONSTANT VARCHAR2(200) := 'OKC_DNR_MSG';
51:

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

44: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
45: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
46: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_RENEW_PVT';
47: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
48: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
49: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
50: G_DNR_MSG CONSTANT VARCHAR2(200) := 'OKC_DNR_MSG';
51:
52: ---------------------------------------------------------------------------

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

45: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
46: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_RENEW_PVT';
47: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
48: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
49: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
50: G_DNR_MSG CONSTANT VARCHAR2(200) := 'OKC_DNR_MSG';
51:
52: ---------------------------------------------------------------------------
53:

Line 85: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

81: --of the contract to be renewed and adjust the dates on the various components of this
82: --copy
83: --------------------------------------------------------------------------------------------
84: Procedure Create_Renewed_Contract( 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: x_contract_id OUT NOCOPY NUMBER,

Line 92: p_ren_type IN varchar2 DEFAULT OKC_API.G_MISS_CHAR,

88: x_msg_data OUT NOCOPY VARCHAR2,
89: x_contract_id OUT NOCOPY NUMBER,
90: p_renew_in_parameters_rec IN Renew_in_parameters_rec,
91: x_renew_in_parameters_rec OUT NOCOPY Renew_in_parameters_rec,
92: p_ren_type IN varchar2 DEFAULT OKC_API.G_MISS_CHAR,
93: p_renewal_called_from_ui IN VARCHAR2 DEFAULT 'Y' /* added for bugfix 2093117 */
94: );
95:
96: --function to validate the line

Line 105: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

101: -- and a few other things depending on the renew rule defined on the contract
102: --------------------------------------------------------------------------------------------
103: PROCEDURE post_renewed_contract(
104: p_api_version IN NUMBER,
105: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
106: x_return_status OUT NOCOPY VARCHAR2,
107: x_msg_count OUT NOCOPY NUMBER,
108: x_msg_data OUT NOCOPY VARCHAR2,
109: p_renew_chr_id IN number,

Line 111: p_ren_type IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,

107: x_msg_count OUT NOCOPY NUMBER,
108: x_msg_data OUT NOCOPY VARCHAR2,
109: p_renew_chr_id IN number,
110: p_renew_in_parameters_rec IN Renew_in_parameters_rec,
111: p_ren_type IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
112: p_contact IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR);
113:
114: --------------------------------------------------------------------------------------------
115: -- this procedure runs the validations on the contract to be renewed

Line 112: p_contact IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR);

108: x_msg_data OUT NOCOPY VARCHAR2,
109: p_renew_chr_id IN number,
110: p_renew_in_parameters_rec IN Renew_in_parameters_rec,
111: p_ren_type IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
112: p_contact IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR);
113:
114: --------------------------------------------------------------------------------------------
115: -- this procedure runs the validations on the contract to be renewed
116: --------------------------------------------------------------------------------------------

Line 118: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

114: --------------------------------------------------------------------------------------------
115: -- this procedure runs the validations on the contract to be renewed
116: --------------------------------------------------------------------------------------------
117: Procedure validate( 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_renew_in_parameters_rec IN Renew_in_parameters_rec,

Line 131: p_old_k IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,

127: -- sets the notification message to be sent after the renewal
128: --------------------------------------------------------------------------------------------
129: PROCEDURE set_notify(
130: x_return_status OUT NOCOPY VARCHAR2 ,
131: p_old_k IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
132: p_old_mod IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
133: p_new_k IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
134: p_new_mod IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
135: p_qa_stat IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,

Line 132: p_old_mod IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,

128: --------------------------------------------------------------------------------------------
129: PROCEDURE set_notify(
130: x_return_status OUT NOCOPY VARCHAR2 ,
131: p_old_k IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
132: p_old_mod IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
133: p_new_k IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
134: p_new_mod IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
135: p_qa_stat IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
136: p_wf_found IN VARCHAR2 DEFAULT 'T',

Line 133: p_new_k IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,

129: PROCEDURE set_notify(
130: x_return_status OUT NOCOPY VARCHAR2 ,
131: p_old_k IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
132: p_old_mod IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
133: p_new_k IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
134: p_new_mod IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
135: p_qa_stat IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
136: p_wf_found IN VARCHAR2 DEFAULT 'T',
137: p_subj_msg IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,

Line 134: p_new_mod IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,

130: x_return_status OUT NOCOPY VARCHAR2 ,
131: p_old_k IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
132: p_old_mod IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
133: p_new_k IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
134: p_new_mod IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
135: p_qa_stat IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
136: p_wf_found IN VARCHAR2 DEFAULT 'T',
137: p_subj_msg IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
138: p_ren_type IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR);

Line 135: p_qa_stat IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,

131: p_old_k IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
132: p_old_mod IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
133: p_new_k IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
134: p_new_mod IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
135: p_qa_stat IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
136: p_wf_found IN VARCHAR2 DEFAULT 'T',
137: p_subj_msg IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
138: p_ren_type IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR);
139:

Line 137: p_subj_msg IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,

133: p_new_k IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
134: p_new_mod IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
135: p_qa_stat IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
136: p_wf_found IN VARCHAR2 DEFAULT 'T',
137: p_subj_msg IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
138: p_ren_type IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR);
139:
140:
141: -- this procedure is called in the OKCRRENB.pls by OKC but exposed

Line 138: p_ren_type IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR);

134: p_new_mod IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
135: p_qa_stat IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
136: p_wf_found IN VARCHAR2 DEFAULT 'T',
137: p_subj_msg IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
138: p_ren_type IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR);
139:
140:
141: -- this procedure is called in the OKCRRENB.pls by OKC but exposed
142: --outside to be called by OKS renew consolidation

Line 145: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

141: -- this procedure is called in the OKCRRENB.pls by OKC but exposed
142: --outside to be called by OKS renew consolidation
143: PROCEDURE update_renewal_dates(
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_chr_id IN number,

Line 150: p_parent_cle_id IN number DEFAULT OKC_API.G_MISS_NUM,

146: x_return_status OUT NOCOPY VARCHAR2,
147: x_msg_count OUT NOCOPY NUMBER,
148: x_msg_data OUT NOCOPY VARCHAR2,
149: p_chr_id IN number,
150: p_parent_cle_id IN number DEFAULT OKC_API.G_MISS_NUM,
151: p_parent_new_st_dt IN DATE,
152: p_parent_new_end_dt IN DATE,
153: p_parent_old_st_dt IN DATE,
154: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

Line 154: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

150: p_parent_cle_id IN number DEFAULT OKC_API.G_MISS_NUM,
151: p_parent_new_st_dt IN DATE,
152: p_parent_new_end_dt IN DATE,
153: p_parent_old_st_dt IN DATE,
154: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
155: p_rencon_yn IN VARCHAR2 DEFAULT 'N');
156:
157: --------------------------------------------------------------------------------
158: -- This procedure updates Date_Renewed field in headers and lines table

Line 167: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

163: -- and is updated by by the maximum Date_Renewed of all the top lines
164: --------------------------------------------------------------------------------
165:
166: Procedure Update_Parents_Date_Renewed( p_api_version IN NUMBER,
167: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
168: x_return_status OUT NOCOPY VARCHAR2,
169: x_msg_count OUT NOCOPY NUMBER,
170: x_msg_data OUT NOCOPY VARCHAR2,
171: p_chr_id IN NUMBER