APPS.AHL_OPERATIONS_PKG dependencies on AHL_OPERATIONS_B

Line 65: cursor C is select ROWID from AHL_OPERATIONS_B

61: X_LAST_UPDATE_DATE in DATE,
62: X_LAST_UPDATED_BY in NUMBER,
63: X_LAST_UPDATE_LOGIN in NUMBER
64: ) is
65: cursor C is select ROWID from AHL_OPERATIONS_B
66: where OPERATION_ID = X_OPERATION_ID
67: ;
68: begin
69: insert into AHL_OPERATIONS_B (

Line 69: insert into AHL_OPERATIONS_B (

65: cursor C is select ROWID from AHL_OPERATIONS_B
66: where OPERATION_ID = X_OPERATION_ID
67: ;
68: begin
69: insert into AHL_OPERATIONS_B (
70: QA_INSPECTION_TYPE,
71: SEGMENT8,
72: SEGMENT9,
73: SEGMENT10,

Line 334: from AHL_OPERATIONS_B

330: ATTRIBUTE12,
331: ATTRIBUTE13,
332: ATTRIBUTE14,
333: ATTRIBUTE15
334: from AHL_OPERATIONS_B
335: where OPERATION_ID = X_OPERATION_ID
336: for update of OPERATION_ID nowait;
337: recinfo c%rowtype;
338:

Line 532: update AHL_OPERATIONS_B set

528: X_LAST_UPDATED_BY in NUMBER,
529: X_LAST_UPDATE_LOGIN in NUMBER
530: ) is
531: begin
532: update AHL_OPERATIONS_B set
533: QA_INSPECTION_TYPE = X_QA_INSPECTION_TYPE,
534: SEGMENT8 = X_SEGMENT8,
535: SEGMENT9 = X_SEGMENT9,
536: SEGMENT10 = X_SEGMENT10,

Line 619: delete from AHL_OPERATIONS_B

615: if (sql%notfound) then
616: raise no_data_found;
617: end if;
618:
619: delete from AHL_OPERATIONS_B
620: where OPERATION_ID = X_OPERATION_ID;
621:
622: if (sql%notfound) then
623: raise no_data_found;

Line 633: from AHL_OPERATIONS_B B

629: begin
630: delete from AHL_OPERATIONS_TL T
631: where not exists
632: (select NULL
633: from AHL_OPERATIONS_B B
634: where B.OPERATION_ID = T.OPERATION_ID
635: );
636:
637: update AHL_OPERATIONS_TL T set (