APPS.OKC_ROLE_SOURCE_PUB dependencies on OKC_ROLE_SOURCES

Line 6: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_ROLE_SOURCES_PUB';

2: /* $Header: OKCPRSCB.pls 120.0 2005/05/26 09:51:09 appldev noship $ */
3: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
4:
5: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
6: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_ROLE_SOURCES_PUB';
7: G_TOO_MANY_SOURCES CONSTANT VARCHAR2(20) := 'OKC_TOO_MANY_SOURCES';
8:
9: procedure reset(p_rscv_rec IN rscv_rec_type) is
10: begin

Line 98: from okc_role_sources

94:
95: -- Changed the select statement with a UNION ALL for performance reasons 08/14/2000
96: cursor c1 is
97: select START_DATE+0.5
98: from okc_role_sources
99: where RLE_CODE = p_rle_code AND p_rle_code is not null
100: and nvl(end_date,sysdate)>=sysdate
101: UNION ALL
102: select START_DATE+0.5

Line 103: from okc_role_sources

99: where RLE_CODE = p_rle_code AND p_rle_code is not null
100: and nvl(end_date,sysdate)>=sysdate
101: UNION ALL
102: select START_DATE+0.5
103: from okc_role_sources
104: where p_rle_code is null
105: and nvl(end_date,sysdate)>=sysdate;
106: d1 date;
107: cursor c2 is

Line 109: -- from okc_role_sources

105: and nvl(end_date,sysdate)>=sysdate;
106: d1 date;
107: cursor c2 is
108: -- select max(count(start_date))
109: -- from okc_role_sources
110: -- where RLE_CODE = NVL(p_rle_code,RLE_CODE)
111: -- and d1 between start_date and NVL(end_date,d1)
112: -- group by RLE_CODE, buy_or_sell;
113: select count(start_date)

Line 114: from okc_role_sources

110: -- where RLE_CODE = NVL(p_rle_code,RLE_CODE)
111: -- and d1 between start_date and NVL(end_date,d1)
112: -- group by RLE_CODE, buy_or_sell;
113: select count(start_date)
114: from okc_role_sources
115: where RLE_CODE = p_rle_code AND p_rle_code is not null
116: and d1 between start_date and NVL(end_date,d1)
117: group by RLE_CODE, buy_or_sell
118: having count(start_date) > 1

Line 121: from okc_role_sources

117: group by RLE_CODE, buy_or_sell
118: having count(start_date) > 1
119: UNION ALL
120: select count(start_date)
121: from okc_role_sources
122: where p_rle_code is null
123: and d1 between start_date and NVL(end_date,d1)
124: group by RLE_CODE, buy_or_sell
125: having count(start_date) > 1;

Line 142: value => 'OKC_ROLE_SOURCES',

138: name => G_TOO_MANY_SOURCES);
139: FND_MESSAGE.SET_TOKEN(token => 'DATE',
140: value => fnd_date.date_to_chardate(d1));
141: FND_MESSAGE.SET_TOKEN(token => 'SOURCE',
142: value => 'OKC_ROLE_SOURCES',
143: translate => TRUE);
144: FND_MSG_PUB.add;
145: x_return_status := OKC_API.G_RET_STS_ERROR;
146: exit;