APPS.AHL_OPERATIONS_PKG dependencies on AHL_OPERATIONS_B

Line 61: cursor C is select ROWID from AHL_OPERATIONS_B

57: X_LAST_UPDATE_DATE in DATE,
58: X_LAST_UPDATED_BY in NUMBER,
59: X_LAST_UPDATE_LOGIN in NUMBER
60: ) is
61: cursor C is select ROWID from AHL_OPERATIONS_B
62: where OPERATION_ID = X_OPERATION_ID
63: ;
64: begin
65: insert into AHL_OPERATIONS_B (

Line 65: insert into AHL_OPERATIONS_B (

61: cursor C is select ROWID from AHL_OPERATIONS_B
62: where OPERATION_ID = X_OPERATION_ID
63: ;
64: begin
65: insert into AHL_OPERATIONS_B (
66: QA_INSPECTION_TYPE,
67: SEGMENT8,
68: SEGMENT9,
69: SEGMENT10,

Line 314: from AHL_OPERATIONS_B

310: ATTRIBUTE12,
311: ATTRIBUTE13,
312: ATTRIBUTE14,
313: ATTRIBUTE15
314: from AHL_OPERATIONS_B
315: where OPERATION_ID = X_OPERATION_ID
316: for update of OPERATION_ID nowait;
317: recinfo c%rowtype;
318:

Line 502: update AHL_OPERATIONS_B set

498: X_LAST_UPDATED_BY in NUMBER,
499: X_LAST_UPDATE_LOGIN in NUMBER
500: ) is
501: begin
502: update AHL_OPERATIONS_B set
503: QA_INSPECTION_TYPE = X_QA_INSPECTION_TYPE,
504: SEGMENT8 = X_SEGMENT8,
505: SEGMENT9 = X_SEGMENT9,
506: SEGMENT10 = X_SEGMENT10,

Line 585: delete from AHL_OPERATIONS_B

581: if (sql%notfound) then
582: raise no_data_found;
583: end if;
584:
585: delete from AHL_OPERATIONS_B
586: where OPERATION_ID = X_OPERATION_ID;
587:
588: if (sql%notfound) then
589: raise no_data_found;

Line 599: from AHL_OPERATIONS_B B

595: begin
596: delete from AHL_OPERATIONS_TL T
597: where not exists
598: (select NULL
599: from AHL_OPERATIONS_B B
600: where B.OPERATION_ID = T.OPERATION_ID
601: );
602:
603: update AHL_OPERATIONS_TL T set (