APPS.AHL_VISITS_PKG dependencies on AHL_VISITS_B

Line 79: insert into AHL_VISITS_B (

75: -- SKPATHAK :: Bug #9171735 :: 02-MAR-2010
76: -- Call insert statement in a loop, till either DUP_VAL_ON_INDEX is not thrown or l_count < L_MAX_RETRIES
77: WHILE l_count < L_MAX_RETRIES LOOP
78: begin
79: insert into AHL_VISITS_B (
80: ESTIMATED_PRICE,
81: PRIORITY_CODE,
82: PROJECT_TEMPLATE_ID,
83: UNIT_SCHEDULE_ID,

Line 212: select MAX(visit_number) + 1 INTO l_visit_number FROM Ahl_Visits_B;

208: IF (l_count = L_MAX_RETRIES - 1) THEN
209: RAISE DUP_VAL_ON_INDEX;
210: END IF;
211: l_count := l_count + 1;
212: select MAX(visit_number) + 1 INTO l_visit_number FROM Ahl_Visits_B;
213: END; -- Nested block with Exception Handler
214: END LOOP;
215: END INTERNAL_INSERT_B_ROW;
216:

Line 283: cursor C is select ROWID from AHL_VISITS_B

279: X_FIRMED_FLAG in VARCHAR2, -- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
280: X_LOCKED_FLAG in VARCHAR2, -- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
281: X_AUTO_VISIT_TYPE_FLAG IN VARCHAR2 := null -- added by tchimira for ER 14015560
282: ) is
283: cursor C is select ROWID from AHL_VISITS_B
284: where VISIT_ID = X_VISIT_ID
285: ;
286: begin
287: -- Changed by skpathak on 17-FEB-2009 for bug 8223329

Line 288: -- Call the new internal procedure to insert into AHL_VISITS_B

284: where VISIT_ID = X_VISIT_ID
285: ;
286: begin
287: -- Changed by skpathak on 17-FEB-2009 for bug 8223329
288: -- Call the new internal procedure to insert into AHL_VISITS_B
289: INTERNAL_INSERT_B_ROW (
290: X_ESTIMATED_PRICE,
291: X_PRIORITY_CODE,
292: X_PROJECT_TEMPLATE_ID,

Line 498: from AHL_VISITS_B

494: ATTRIBUTE12,
495: ATTRIBUTE13,
496: ATTRIBUTE14,
497: ATTRIBUTE15
498: from AHL_VISITS_B
499: where VISIT_ID = X_VISIT_ID
500: for update of VISIT_ID nowait;
501: recinfo c%rowtype;
502:

Line 700: update AHL_VISITS_B set

696: X_ITEM_OWNER_FLAG IN VARCHAR2, --ARUNJK added for Marshalling
697: X_AUTO_VISIT_TYPE_FLAG IN VARCHAR2 := null -- added by tchimira for ER 14015560
698: ) is
699: begin
700: update AHL_VISITS_B set
701: ESTIMATED_PRICE = X_ESTIMATED_PRICE,
702: PRIORITY_CODE = X_PRIORITY_CODE,
703: PROJECT_TEMPLATE_ID = X_PROJECT_TEMPLATE_ID,
704: UNIT_SCHEDULE_ID = X_UNIT_SCHEDULE_ID,

Line 790: delete from AHL_VISITS_B

786: if (sql%notfound) then
787: raise no_data_found;
788: end if;
789:
790: delete from AHL_VISITS_B
791: where VISIT_ID = X_VISIT_ID;
792:
793: if (sql%notfound) then
794: raise no_data_found;

Line 804: from AHL_VISITS_B B

800: begin
801: delete from AHL_VISITS_TL T
802: where not exists
803: (select NULL
804: from AHL_VISITS_B B
805: where B.VISIT_ID = T.VISIT_ID
806: );
807:
808: update AHL_VISITS_TL T set (