APPS.CLN_CH_DISPLAY_LABELS_DTL_PKG dependencies on CLN_CH_DISPLAY_LABELS_DTL_B

Line 47: cursor c1 is select * from CLN_CH_DISPLAY_LABELS_DTL_B where (PARENT_GUID=X_PARENT_GUID)

43: X_DISPLAY_ENABLED_EVENTS_SCR IN VARCHAR2,
44: X_DISPLAY_ENABLED_RESULTS_TBL IN VARCHAR2
45: ) IS
46: cursor c is select * from CLN_CH_DISPLAY_LABELS_HDR where GUID=X_PARENT_GUID;
47: cursor c1 is select * from CLN_CH_DISPLAY_LABELS_DTL_B where (PARENT_GUID=X_PARENT_GUID)
48: AND (GUID=X_GUID);
49: l_fkpresent c%rowtype;
50: l_pkpresent c1%rowtype;
51: l_user_id NUMBER := 0;

Line 64: UPDATE CLN_CH_DISPLAY_LABELS_DTL_B SET

60: OPEN c1;
61: fetch c into l_fkpresent;
62: fetch c1 into l_pkpresent;
63: IF (c1%found) THEN
64: UPDATE CLN_CH_DISPLAY_LABELS_DTL_B SET
65: CLN_COLUMNS=X_CLN_COLUMNS,
66: SEARCH_ENABLED=X_SEARCH_ENABLED,
67: DISPLAY_ENABLED_EVENTS_SCREEN=X_DISPLAY_ENABLED_EVENTS_SCR,
68: DISPLAY_ENABLED_RESULTS_TABLE=X_DISPLAY_ENABLED_RESULTS_TBL,

Line 82: Insert into CLN_CH_DISPLAY_LABELS_DTL_B(

78: SOURCE_LANG=userenv('LANG')
79: WHERE GUID = X_GUID and userenv('LANG') in (LANGUAGE,SOURCE_LANG) ;
80:
81: ELSIF (c1%notfound and c%found) then
82: Insert into CLN_CH_DISPLAY_LABELS_DTL_B(
83: GUID,
84: PARENT_GUID,
85: CLN_COLUMNS,
86: SEARCH_ENABLED,

Line 155: cursor C is select ROWID from CLN_CH_DISPLAY_LABELS_DTL_B

151: X_LAST_UPDATE_DATE in DATE,
152: X_LAST_UPDATED_BY in NUMBER,
153: X_LAST_UPDATE_LOGIN in NUMBER
154: ) is
155: cursor C is select ROWID from CLN_CH_DISPLAY_LABELS_DTL_B
156: where GUID = X_GUID
157: ;
158: begin
159: insert into CLN_CH_DISPLAY_LABELS_DTL_B (

Line 159: insert into CLN_CH_DISPLAY_LABELS_DTL_B (

155: cursor C is select ROWID from CLN_CH_DISPLAY_LABELS_DTL_B
156: where GUID = X_GUID
157: ;
158: begin
159: insert into CLN_CH_DISPLAY_LABELS_DTL_B (
160: GUID,
161: PARENT_GUID,
162: CLN_COLUMNS,
163: SEARCH_ENABLED,

Line 238: from CLN_CH_DISPLAY_LABELS_DTL_B

234: CLN_COLUMNS,
235: SEARCH_ENABLED,
236: DISPLAY_ENABLED_EVENTS_SCREEN,
237: DISPLAY_ENABLED_RESULTS_TABLE
238: from CLN_CH_DISPLAY_LABELS_DTL_B
239: where GUID = X_GUID
240: for update of GUID nowait;
241: recinfo c%rowtype;
242:

Line 303: update CLN_CH_DISPLAY_LABELS_DTL_B set

299: X_LAST_UPDATED_BY in NUMBER,
300: X_LAST_UPDATE_LOGIN in NUMBER
301: ) is
302: begin
303: update CLN_CH_DISPLAY_LABELS_DTL_B set
304: PARENT_GUID = X_PARENT_GUID,
305: CLN_COLUMNS = X_CLN_COLUMNS,
306: SEARCH_ENABLED = X_SEARCH_ENABLED,
307: DISPLAY_ENABLED_EVENTS_SCREEN = X_DISPLAY_ENABLED_EVENTS_SCREE,

Line 343: delete from CLN_CH_DISPLAY_LABELS_DTL_B

339: if (sql%notfound) then
340: raise no_data_found;
341: end if;
342:
343: delete from CLN_CH_DISPLAY_LABELS_DTL_B
344: where GUID = X_GUID;
345:
346: if (sql%notfound) then
347: raise no_data_found;

Line 357: from CLN_CH_DISPLAY_LABELS_DTL_B B

353: begin
354: delete from CLN_CH_DISPLAY_LABELS_DTL_TL T
355: where not exists
356: (select NULL
357: from CLN_CH_DISPLAY_LABELS_DTL_B B
358: where B.GUID = T.GUID
359: );
360:
361: update CLN_CH_DISPLAY_LABELS_DTL_TL T set (