APPS.CM_CLDR_HDR_PKG dependencies on CM_CLDR_HDR_B

Line 47: cursor C is select ROWID from CM_CLDR_HDR_B

43: X_LAST_UPDATE_DATE in DATE,
44: X_LAST_UPDATED_BY in NUMBER,
45: X_LAST_UPDATE_LOGIN in NUMBER
46: ) is
47: cursor C is select ROWID from CM_CLDR_HDR_B
48: where CALENDAR_CODE = X_CALENDAR_CODE
49: ;
50: begin
51: insert into CM_CLDR_HDR_B (

Line 51: insert into CM_CLDR_HDR_B (

47: cursor C is select ROWID from CM_CLDR_HDR_B
48: where CALENDAR_CODE = X_CALENDAR_CODE
49: ;
50: begin
51: insert into CM_CLDR_HDR_B (
52: CALENDAR_CODE,
53: START_DATE,
54: IN_USE,
55: TEXT_CODE,

Line 246: from CM_CLDR_HDR_B

242: ATTRIBUTE27,
243: ATTRIBUTE28,
244: ATTRIBUTE29,
245: ATTRIBUTE30
246: from CM_CLDR_HDR_B
247: where CALENDAR_CODE = X_CALENDAR_CODE
248: for update of CALENDAR_CODE nowait;
249: recinfo c%rowtype;
250:

Line 397: update CM_CLDR_HDR_B set

393: X_LAST_UPDATED_BY in NUMBER,
394: X_LAST_UPDATE_LOGIN in NUMBER
395: ) is
396: begin
397: update CM_CLDR_HDR_B set
398: IN_USE = X_IN_USE,
399: START_DATE = X_START_DATE,
400: TEXT_CODE = X_TEXT_CODE,
401: DELETE_MARK = X_DELETE_MARK,

Line 469: * delete from CM_CLDR_HDR_B

465: * raise no_data_found;
466: * end if;
467: *
468: *
469: * delete from CM_CLDR_HDR_B
470: * where CALENDAR_CODE = X_CALENDAR_CODE;
471: */
472:
473: update CM_CLDR_HDR_B

Line 473: update CM_CLDR_HDR_B

469: * delete from CM_CLDR_HDR_B
470: * where CALENDAR_CODE = X_CALENDAR_CODE;
471: */
472:
473: update CM_CLDR_HDR_B
474: set DELETE_MARK = 1
475: where CALENDAR_CODE = X_CALENDAR_CODE;
476:
477: if (sql%notfound) then

Line 488: from CM_CLDR_HDR_B B

484: begin
485: delete from CM_CLDR_HDR_TL T
486: where not exists
487: (select NULL
488: from CM_CLDR_HDR_B B
489: where B.CALENDAR_CODE = T.CALENDAR_CODE
490: );
491:
492: update CM_CLDR_HDR_TL T set (