APPS.CSD_REPAIR_TYPES_PKG dependencies on CSD_REPAIR_TYPES_B

Line 59: cursor C is select ROWID from CSD_REPAIR_TYPES_B

55: X_THIRD_PARTY_FLAG in Varchar2 := null,
56: X_OBJECT_VERSION_NUMBER in Number,
57: X_START_FLOW_STATUS_ID in Number
58: ) is
59: cursor C is select ROWID from CSD_REPAIR_TYPES_B
60: where REPAIR_TYPE_ID = X_REPAIR_TYPE_ID;
61: begin
62: insert into CSD_REPAIR_TYPES_B (
63: REPAIR_TYPE_ID,

Line 62: insert into CSD_REPAIR_TYPES_B (

58: ) is
59: cursor C is select ROWID from CSD_REPAIR_TYPES_B
60: where REPAIR_TYPE_ID = X_REPAIR_TYPE_ID;
61: begin
62: insert into CSD_REPAIR_TYPES_B (
63: REPAIR_TYPE_ID,
64: WORKFLOW_ITEM_TYPE,
65: START_DATE_ACTIVE,
66: END_DATE_ACTIVE,

Line 209: from CSD_REPAIR_TYPES_B

205: ) is
206:
207: cursor c is
208: select object_version_number
209: from CSD_REPAIR_TYPES_B
210: where REPAIR_TYPE_ID = X_REPAIR_TYPE_ID
211: for update nowait;
212:
213: recinfo c%rowtype;

Line 291: update CSD_REPAIR_TYPES_B set

287: X_OBJECT_VERSION_NUMBER in Number,
288: X_START_FLOW_STATUS_ID in Number
289: ) is
290: begin
291: update CSD_REPAIR_TYPES_B set
292: WORKFLOW_ITEM_TYPE = X_WORKFLOW_ITEM_TYPE,
293: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
294: END_DATE_ACTIVE = X_END_DATE_ACTIVE,
295: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,

Line 369: delete from CSD_REPAIR_TYPES_B

365: if (sql%notfound) then
366: raise no_data_found;
367: end if;
368:
369: delete from CSD_REPAIR_TYPES_B
370: where REPAIR_TYPE_ID = X_REPAIR_TYPE_ID;
371:
372: if (sql%notfound) then
373: raise no_data_found;

Line 383: from CSD_REPAIR_TYPES_B B

379: begin
380: delete from CSD_REPAIR_TYPES_TL T
381: where not exists
382: (select NULL
383: from CSD_REPAIR_TYPES_B B
384: where B.REPAIR_TYPE_ID = T.REPAIR_TYPE_ID
385: );
386:
387: update CSD_REPAIR_TYPES_TL T set (

Line 509: select count(*) from CSD_REPAIR_TYPES_B

505: l_user_id NUMBER := 0;
506: l_count number := 0;
507:
508: CURSOR Cur_repair_type_count(p_repair_type_id IN NUMBER) IS
509: select count(*) from CSD_REPAIR_TYPES_B
510: where repair_type_id = p_repair_type_id and last_updated_by <> 1;
511:
512: --
513: BEGIN