APPS.AHL_MC_HEADERS_PKG dependencies on AHL_MC_HEADERS_B

Line 37: cursor C is select ROWID from AHL_MC_HEADERS_B

33: X_LAST_UPDATE_DATE in DATE,
34: X_LAST_UPDATED_BY in NUMBER,
35: X_LAST_UPDATE_LOGIN in NUMBER
36: ) is
37: cursor C is select ROWID from AHL_MC_HEADERS_B
38: where MC_HEADER_ID = X_MC_HEADER_ID
39: ;
40: begin
41: insert into AHL_MC_HEADERS_B (

Line 41: insert into AHL_MC_HEADERS_B (

37: cursor C is select ROWID from AHL_MC_HEADERS_B
38: where MC_HEADER_ID = X_MC_HEADER_ID
39: ;
40: begin
41: insert into AHL_MC_HEADERS_B (
42: MC_HEADER_ID,
43: NAME,
44: MC_ID,
45: VERSION_NUMBER,

Line 198: from AHL_MC_HEADERS_B

194: ATTRIBUTE12,
195: ATTRIBUTE13,
196: ATTRIBUTE14,
197: ATTRIBUTE15
198: from AHL_MC_HEADERS_B
199: where MC_HEADER_ID = X_MC_HEADER_ID
200: for update of MC_HEADER_ID nowait;
201: recinfo c%rowtype;
202:

Line 317: update AHL_MC_HEADERS_B set

313: X_LAST_UPDATED_BY in NUMBER,
314: X_LAST_UPDATE_LOGIN in NUMBER
315: ) is
316: begin
317: update AHL_MC_HEADERS_B set
318: NAME = X_NAME,
319: MC_ID = X_MC_ID,
320: VERSION_NUMBER = X_VERSION_NUMBER,
321: REVISION = X_REVISION,

Line 376: delete from AHL_MC_HEADERS_B

372: if (sql%notfound) then
373: raise no_data_found;
374: end if;
375:
376: delete from AHL_MC_HEADERS_B
377: where MC_HEADER_ID = X_MC_HEADER_ID;
378:
379: if (sql%notfound) then
380: raise no_data_found;

Line 390: from AHL_MC_HEADERS_B B

386: begin
387: delete from AHL_MC_HEADERS_TL T
388: where not exists
389: (select NULL
390: from AHL_MC_HEADERS_B B
391: where B.MC_HEADER_ID = T.MC_HEADER_ID
392: );
393:
394: update AHL_MC_HEADERS_TL T set (

Line 486: from ahl_mc_headers_b

482: end if;
483:
484: select mc_header_id
485: into l_mc_header_id
486: from ahl_mc_headers_b
487: where mc_header_id = X_MC_HEADER_ID;
488:
489: UPDATE_ROW (
490: X_MC_HEADER_ID => l_mc_header_id,

Line 524: select ahl_mc_headers_b_s.nextval

520:
521: exception
522: when NO_DATA_FOUND then
523:
524: select ahl_mc_headers_b_s.nextval
525: into l_mc_header_id
526: from dual;
527:
528: INSERT_ROW (