APPS.AHL_UNIT_EFFECTIVITIES_PKG dependencies on AHL_UNIT_EFFECTIVITIES_B

Line 67: cursor C is select ROWID from AHL_UNIT_EFFECTIVITIES_B

63: X_LAST_UPDATE_DATE in DATE,
64: X_LAST_UPDATED_BY in NUMBER,
65: X_LAST_UPDATE_LOGIN in NUMBER
66: ) is
67: cursor C is select ROWID from AHL_UNIT_EFFECTIVITIES_B
68: where UNIT_EFFECTIVITY_ID = X_UNIT_EFFECTIVITY_ID
69: ;
70: begin
71: insert into AHL_UNIT_EFFECTIVITIES_B (

Line 71: insert into AHL_UNIT_EFFECTIVITIES_B (

67: cursor C is select ROWID from AHL_UNIT_EFFECTIVITIES_B
68: where UNIT_EFFECTIVITY_ID = X_UNIT_EFFECTIVITY_ID
69: ;
70: begin
71: insert into AHL_UNIT_EFFECTIVITIES_B (
72: MANUALLY_PLANNED_FLAG,
73: LOG_SERIES_CODE,
74: LOG_SERIES_NUMBER,
75: FLIGHT_NUMBER,

Line 177: AHL_UNIT_EFFECTIVITIES_B_S.NEXTVAL,

173: X_ATTRIBUTE12,
174: X_ATTRIBUTE13,
175: X_ATTRIBUTE14,
176: X_ATTRIBUTE15,
177: AHL_UNIT_EFFECTIVITIES_B_S.NEXTVAL,
178: X_OBJECT_VERSION_NUMBER,
179: X_CSI_ITEM_INSTANCE_ID,
180: X_MR_HEADER_ID,
181: X_MR_EFFECTIVITY_ID,

Line 346: from AHL_UNIT_EFFECTIVITIES_B

342: DUE_DATE,
343: DUE_COUNTER_VALUE,
344: DEFER_FROM_UE_ID,
345: ORIG_DEFERRAL_UE_ID
346: from AHL_UNIT_EFFECTIVITIES_B
347: where UNIT_EFFECTIVITY_ID = X_UNIT_EFFECTIVITY_ID
348: for update of UNIT_EFFECTIVITY_ID nowait;
349: recinfo c%rowtype;
350:

Line 557: update AHL_UNIT_EFFECTIVITIES_B set

553: X_LAST_UPDATED_BY in NUMBER,
554: X_LAST_UPDATE_LOGIN in NUMBER
555: ) is
556: begin
557: update AHL_UNIT_EFFECTIVITIES_B set
558: MANUALLY_PLANNED_FLAG = X_MANUALLY_PLANNED_FLAG,
559: LOG_SERIES_CODE = X_LOG_SERIES_CODE,
560: LOG_SERIES_NUMBER = X_LOG_SERIES_NUMBER,
561: FLIGHT_NUMBER = X_FLIGHT_NUMBER,

Line 646: delete from AHL_UNIT_EFFECTIVITIES_B

642: if (sql%notfound) then
643: raise no_data_found;
644: end if;
645:
646: delete from AHL_UNIT_EFFECTIVITIES_B
647: where UNIT_EFFECTIVITY_ID = X_UNIT_EFFECTIVITY_ID;
648:
649: if (sql%notfound) then
650: raise no_data_found;

Line 660: from AHL_UNIT_EFFECTIVITIES_B B

656: begin
657: delete from AHL_UNIT_EFFECTIVITIES_TL T
658: where not exists
659: (select NULL
660: from AHL_UNIT_EFFECTIVITIES_B B
661: where B.UNIT_EFFECTIVITY_ID = T.UNIT_EFFECTIVITY_ID
662: );
663:
664: update AHL_UNIT_EFFECTIVITIES_TL T set (