APPS.AHL_WARRANTY_CLAIMS_PKG dependencies on AHL_WARRANTY_CLAIMS_B

Line 61: cursor C is select ROWID from AHL_WARRANTY_CLAIMS_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_WARRANTY_CLAIMS_B
62: where WARRANTY_CLAIM_ID = X_WARRANTY_CLAIM_ID
63: ;
64: begin
65: insert into AHL_WARRANTY_CLAIMS_B (

Line 65: insert into AHL_WARRANTY_CLAIMS_B (

61: cursor C is select ROWID from AHL_WARRANTY_CLAIMS_B
62: where WARRANTY_CLAIM_ID = X_WARRANTY_CLAIM_ID
63: ;
64: begin
65: insert into AHL_WARRANTY_CLAIMS_B (
66: R_ATTRIBUTE13,
67: R_ATTRIBUTE14,
68: R_ATTRIBUTE15,
69: WARRANTY_CLAIM_ID,

Line 315: from AHL_WARRANTY_CLAIMS_B

311: R_ATTRIBUTE9,
312: R_ATTRIBUTE10,
313: R_ATTRIBUTE11,
314: R_ATTRIBUTE12
315: from AHL_WARRANTY_CLAIMS_B
316: where WARRANTY_CLAIM_ID = X_WARRANTY_CLAIM_ID
317: for update of WARRANTY_CLAIM_ID nowait;
318: recinfo c%rowtype;
319:

Line 504: update AHL_WARRANTY_CLAIMS_B set

500: X_LAST_UPDATED_BY in NUMBER,
501: X_LAST_UPDATE_LOGIN in NUMBER
502: ) is
503: begin
504: update AHL_WARRANTY_CLAIMS_B set
505: R_ATTRIBUTE13 = X_R_ATTRIBUTE13,
506: R_ATTRIBUTE14 = X_R_ATTRIBUTE14,
507: R_ATTRIBUTE15 = X_R_ATTRIBUTE15,
508: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,

Line 587: delete from AHL_WARRANTY_CLAIMS_B

583: if (sql%notfound) then
584: raise no_data_found;
585: end if;
586:
587: delete from AHL_WARRANTY_CLAIMS_B
588: where WARRANTY_CLAIM_ID = X_WARRANTY_CLAIM_ID;
589:
590: if (sql%notfound) then
591: raise no_data_found;

Line 601: from AHL_WARRANTY_CLAIMS_B B

597: begin
598: delete from AHL_WARRANTY_CLAIMS_TL T
599: where not exists
600: (select NULL
601: from AHL_WARRANTY_CLAIMS_B B
602: where B.WARRANTY_CLAIM_ID = T.WARRANTY_CLAIM_ID
603: );
604:
605: update AHL_WARRANTY_CLAIMS_TL T set (