APPS.AHL_UNIT_EFFECTIVITIES_PKG dependencies on AHL_UNIT_EFFECTIVITIES_B

Line 68: cursor C is select ROWID from AHL_UNIT_EFFECTIVITIES_B

64: X_LAST_UPDATED_BY in NUMBER,
65: X_LAST_UPDATE_LOGIN in NUMBER,
66: X_FLEET_HEADER_ID IN NUMBER := NULL -- JKJain, NR Analysis and Forecasting
67: ) is
68: cursor C is select ROWID from AHL_UNIT_EFFECTIVITIES_B
69: where UNIT_EFFECTIVITY_ID = X_UNIT_EFFECTIVITY_ID
70: ;
71: begin
72: insert into AHL_UNIT_EFFECTIVITIES_B (

Line 72: insert into AHL_UNIT_EFFECTIVITIES_B (

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

Line 179: AHL_UNIT_EFFECTIVITIES_B_S.NEXTVAL,

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

Line 349: from AHL_UNIT_EFFECTIVITIES_B

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

Line 561: update AHL_UNIT_EFFECTIVITIES_B set

557: X_LAST_UPDATE_LOGIN in NUMBER,
558: X_FLEET_HEADER_ID IN NUMBER := NULL
559: ) is
560: begin
561: update AHL_UNIT_EFFECTIVITIES_B set
562: MANUALLY_PLANNED_FLAG = X_MANUALLY_PLANNED_FLAG,
563: LOG_SERIES_CODE = X_LOG_SERIES_CODE,
564: LOG_SERIES_NUMBER = X_LOG_SERIES_NUMBER,
565: FLIGHT_NUMBER = X_FLIGHT_NUMBER,

Line 651: delete from AHL_UNIT_EFFECTIVITIES_B

647: if (sql%notfound) then
648: raise no_data_found;
649: end if;
650:
651: delete from AHL_UNIT_EFFECTIVITIES_B
652: where UNIT_EFFECTIVITY_ID = X_UNIT_EFFECTIVITY_ID;
653:
654: if (sql%notfound) then
655: raise no_data_found;

Line 665: from AHL_UNIT_EFFECTIVITIES_B B

661: begin
662: delete from AHL_UNIT_EFFECTIVITIES_TL T
663: where not exists
664: (select NULL
665: from AHL_UNIT_EFFECTIVITIES_B B
666: where B.UNIT_EFFECTIVITY_ID = T.UNIT_EFFECTIVITY_ID
667: );
668:
669: update AHL_UNIT_EFFECTIVITIES_TL T set (