APPS.CSD_REPAIR_TYPES_PKG dependencies on CSD_REPAIR_TYPES_B

Line 60: cursor C is select ROWID from CSD_REPAIR_TYPES_B

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

Line 63: insert into CSD_REPAIR_TYPES_B (

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

Line 212: from CSD_REPAIR_TYPES_B

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

Line 295: update CSD_REPAIR_TYPES_B set

291: X_START_FLOW_STATUS_ID in Number,
292: X_RES_DT_CALC_POINT IN VARCHAR2 := fnd_api.g_miss_char
293: ) is
294: begin
295: update CSD_REPAIR_TYPES_B set
296: WORKFLOW_ITEM_TYPE = X_WORKFLOW_ITEM_TYPE,
297: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
298: END_DATE_ACTIVE = X_END_DATE_ACTIVE,
299: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,

Line 374: delete from CSD_REPAIR_TYPES_B

370: if (sql%notfound) then
371: raise no_data_found;
372: end if;
373:
374: delete from CSD_REPAIR_TYPES_B
375: where REPAIR_TYPE_ID = X_REPAIR_TYPE_ID;
376:
377: if (sql%notfound) then
378: raise no_data_found;

Line 388: from CSD_REPAIR_TYPES_B B

384: begin
385: delete from CSD_REPAIR_TYPES_TL T
386: where not exists
387: (select NULL
388: from CSD_REPAIR_TYPES_B B
389: where B.REPAIR_TYPE_ID = T.REPAIR_TYPE_ID
390: );
391:
392: update CSD_REPAIR_TYPES_TL T set (

Line 514: select count(*) from CSD_REPAIR_TYPES_B

510: l_user_id NUMBER := 0;
511: l_count number := 0;
512:
513: CURSOR Cur_repair_type_count(p_repair_type_id IN NUMBER) IS
514: select count(*) from CSD_REPAIR_TYPES_B
515: where repair_type_id = p_repair_type_id and last_updated_by <> 1;
516:
517: --
518: BEGIN