71: x_msg_data => x_msg_data);
72: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
73: RAISE FND_API.G_EXC_ERROR;
74: END IF;
75: -- Invoke table handler(CSP_PRODUCT_TASKS_PKG.Insert_Row)
76: CSP_PRODUCT_TASKS_PKG.Insert_Row(
77: px_PRODUCT_TASK_ID => x_PRODUCT_TASK_ID,
78: p_PRODUCT_ID => p_PROD_TASK_rec.PRODUCT_ID,
79: p_TASK_TEMPLATE_ID => p_PROD_TASK_rec.TASK_TEMPLATE_ID,
72: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
73: RAISE FND_API.G_EXC_ERROR;
74: END IF;
75: -- Invoke table handler(CSP_PRODUCT_TASKS_PKG.Insert_Row)
76: CSP_PRODUCT_TASKS_PKG.Insert_Row(
77: px_PRODUCT_TASK_ID => x_PRODUCT_TASK_ID,
78: p_PRODUCT_ID => p_PROD_TASK_rec.PRODUCT_ID,
79: p_TASK_TEMPLATE_ID => p_PROD_TASK_rec.TASK_TEMPLATE_ID,
80: p_AUTO_MANUAL => p_PROD_TASK_rec.AUTO_MANUAL,
191: CREATION_DATE,
192: LAST_UPDATED_BY,
193: LAST_UPDATE_DATE,
194: LAST_UPDATE_LOGIN
195: From CSP_PRODUCT_TASKS
196: WHERE PRODUCT_TASK_ID = L_PRODUCT_TASK_ID
197: -- Hint: Developer need to provide Where clause
198: For Update NOWAIT;
199:
306: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
307: RAISE FND_API.G_EXC_ERROR;
308: END IF;
309: -- Hint: Add corresponding Master-Detail business logic here if necessary.
310: -- Invoke table handler(CSP_PRODUCT_TASKS_PKG.Update_Row)
311:
312: CSP_PRODUCT_TASKS_PKG.Update_Row(
313: p_PRODUCT_TASK_ID => p_PROD_TASK_rec.PRODUCT_TASK_ID,
314: p_PRODUCT_ID => p_PROD_TASK_rec.PRODUCT_ID,
308: END IF;
309: -- Hint: Add corresponding Master-Detail business logic here if necessary.
310: -- Invoke table handler(CSP_PRODUCT_TASKS_PKG.Update_Row)
311:
312: CSP_PRODUCT_TASKS_PKG.Update_Row(
313: p_PRODUCT_TASK_ID => p_PROD_TASK_rec.PRODUCT_TASK_ID,
314: p_PRODUCT_ID => p_PROD_TASK_rec.PRODUCT_ID,
315: p_TASK_TEMPLATE_ID => p_PROD_TASK_rec.TASK_TEMPLATE_ID,
316: p_AUTO_MANUAL => p_PROD_TASK_rec.AUTO_MANUAL,
417: x_return_status := FND_API.G_RET_STS_SUCCESS;
418: --
419: -- Api body
420: --
421: -- Invoke table handler(CSP_PRODUCT_TASKS_PKG.Delete_Row)
422: CSP_PRODUCT_TASKS_PKG.Delete_Row(
423: p_PRODUCT_TASK_ID => p_PROD_TASK_rec.PRODUCT_TASK_ID);
424: --
425: -- End of API body
418: --
419: -- Api body
420: --
421: -- Invoke table handler(CSP_PRODUCT_TASKS_PKG.Delete_Row)
422: CSP_PRODUCT_TASKS_PKG.Delete_Row(
423: p_PRODUCT_TASK_ID => p_PROD_TASK_rec.PRODUCT_TASK_ID);
424: --
425: -- End of API body
426: --
471: p_cur_get_PROD_TASK IN NUMBER
472: )
473: IS
474: BEGIN
475: -- define all columns for CSP_PRODUCT_TASKS view
476: dbms_sql.define_column(p_cur_get_PROD_TASK, 1, P_PROD_TASK_Rec.PRODUCT_TASK_ID);
477: dbms_sql.define_column(p_cur_get_PROD_TASK, 2, P_PROD_TASK_Rec.PRODUCT_ID);
478: dbms_sql.define_column(p_cur_get_PROD_TASK, 3, P_PROD_TASK_Rec.TASK_TEMPLATE_ID);
479: dbms_sql.define_column(p_cur_get_PROD_TASK, 4, P_PROD_TASK_Rec.AUTO_MANUAL, 6);
502: X_PROD_TASK_Rec OUT NOCOPY CSP_PRODUCT_TASK_PUB.PROD_TASK_Rec_Type
503: )
504: IS
505: BEGIN
506: -- get all column values for CSP_PRODUCT_TASKS table
507: dbms_sql.column_value(p_cur_get_PROD_TASK, 1, X_PROD_TASK_Rec.PRODUCT_TASK_ID);
508: dbms_sql.column_value(p_cur_get_PROD_TASK, 2, X_PROD_TASK_Rec.PRODUCT_ID);
509: dbms_sql.column_value(p_cur_get_PROD_TASK, 3, X_PROD_TASK_Rec.TASK_TEMPLATE_ID);
510: dbms_sql.column_value(p_cur_get_PROD_TASK, 4, X_PROD_TASK_Rec.AUTO_MANUAL);
549: )
550: IS
551: BEGIN
552: x_select_cl := 'Select ' ||
553: 'CSP_PRODUCT_TASKS.PRODUCT_TASK_ID,' ||
554: 'CSP_PRODUCT_TASKS.PRODUCT_ID,' ||
555: 'CSP_PRODUCT_TASKS.TASK_TEMPLATE_ID,' ||
556: 'CSP_PRODUCT_TASKS.AUTO_MANUAL,' ||
557: 'CSP_PRODUCT_TASKS.ACTUAL_TIMES_USED,' ||
550: IS
551: BEGIN
552: x_select_cl := 'Select ' ||
553: 'CSP_PRODUCT_TASKS.PRODUCT_TASK_ID,' ||
554: 'CSP_PRODUCT_TASKS.PRODUCT_ID,' ||
555: 'CSP_PRODUCT_TASKS.TASK_TEMPLATE_ID,' ||
556: 'CSP_PRODUCT_TASKS.AUTO_MANUAL,' ||
557: 'CSP_PRODUCT_TASKS.ACTUAL_TIMES_USED,' ||
558: 'CSP_PRODUCT_TASKS.TASK_PERCENTAGE,' ||
551: BEGIN
552: x_select_cl := 'Select ' ||
553: 'CSP_PRODUCT_TASKS.PRODUCT_TASK_ID,' ||
554: 'CSP_PRODUCT_TASKS.PRODUCT_ID,' ||
555: 'CSP_PRODUCT_TASKS.TASK_TEMPLATE_ID,' ||
556: 'CSP_PRODUCT_TASKS.AUTO_MANUAL,' ||
557: 'CSP_PRODUCT_TASKS.ACTUAL_TIMES_USED,' ||
558: 'CSP_PRODUCT_TASKS.TASK_PERCENTAGE,' ||
559: 'CSP_PRODUCT_TASKS.ATTRIBUTE_CATEGORY,' ||
552: x_select_cl := 'Select ' ||
553: 'CSP_PRODUCT_TASKS.PRODUCT_TASK_ID,' ||
554: 'CSP_PRODUCT_TASKS.PRODUCT_ID,' ||
555: 'CSP_PRODUCT_TASKS.TASK_TEMPLATE_ID,' ||
556: 'CSP_PRODUCT_TASKS.AUTO_MANUAL,' ||
557: 'CSP_PRODUCT_TASKS.ACTUAL_TIMES_USED,' ||
558: 'CSP_PRODUCT_TASKS.TASK_PERCENTAGE,' ||
559: 'CSP_PRODUCT_TASKS.ATTRIBUTE_CATEGORY,' ||
560: 'CSP_PRODUCT_TASKS.ATTRIBUTE1,' ||
553: 'CSP_PRODUCT_TASKS.PRODUCT_TASK_ID,' ||
554: 'CSP_PRODUCT_TASKS.PRODUCT_ID,' ||
555: 'CSP_PRODUCT_TASKS.TASK_TEMPLATE_ID,' ||
556: 'CSP_PRODUCT_TASKS.AUTO_MANUAL,' ||
557: 'CSP_PRODUCT_TASKS.ACTUAL_TIMES_USED,' ||
558: 'CSP_PRODUCT_TASKS.TASK_PERCENTAGE,' ||
559: 'CSP_PRODUCT_TASKS.ATTRIBUTE_CATEGORY,' ||
560: 'CSP_PRODUCT_TASKS.ATTRIBUTE1,' ||
561: 'CSP_PRODUCT_TASKS.ATTRIBUTE2,' ||
554: 'CSP_PRODUCT_TASKS.PRODUCT_ID,' ||
555: 'CSP_PRODUCT_TASKS.TASK_TEMPLATE_ID,' ||
556: 'CSP_PRODUCT_TASKS.AUTO_MANUAL,' ||
557: 'CSP_PRODUCT_TASKS.ACTUAL_TIMES_USED,' ||
558: 'CSP_PRODUCT_TASKS.TASK_PERCENTAGE,' ||
559: 'CSP_PRODUCT_TASKS.ATTRIBUTE_CATEGORY,' ||
560: 'CSP_PRODUCT_TASKS.ATTRIBUTE1,' ||
561: 'CSP_PRODUCT_TASKS.ATTRIBUTE2,' ||
562: 'CSP_PRODUCT_TASKS.ATTRIBUTE3,' ||
555: 'CSP_PRODUCT_TASKS.TASK_TEMPLATE_ID,' ||
556: 'CSP_PRODUCT_TASKS.AUTO_MANUAL,' ||
557: 'CSP_PRODUCT_TASKS.ACTUAL_TIMES_USED,' ||
558: 'CSP_PRODUCT_TASKS.TASK_PERCENTAGE,' ||
559: 'CSP_PRODUCT_TASKS.ATTRIBUTE_CATEGORY,' ||
560: 'CSP_PRODUCT_TASKS.ATTRIBUTE1,' ||
561: 'CSP_PRODUCT_TASKS.ATTRIBUTE2,' ||
562: 'CSP_PRODUCT_TASKS.ATTRIBUTE3,' ||
563: 'CSP_PRODUCT_TASKS.ATTRIBUTE4,' ||
556: 'CSP_PRODUCT_TASKS.AUTO_MANUAL,' ||
557: 'CSP_PRODUCT_TASKS.ACTUAL_TIMES_USED,' ||
558: 'CSP_PRODUCT_TASKS.TASK_PERCENTAGE,' ||
559: 'CSP_PRODUCT_TASKS.ATTRIBUTE_CATEGORY,' ||
560: 'CSP_PRODUCT_TASKS.ATTRIBUTE1,' ||
561: 'CSP_PRODUCT_TASKS.ATTRIBUTE2,' ||
562: 'CSP_PRODUCT_TASKS.ATTRIBUTE3,' ||
563: 'CSP_PRODUCT_TASKS.ATTRIBUTE4,' ||
564: 'CSP_PRODUCT_TASKS.ATTRIBUTE5,' ||
557: 'CSP_PRODUCT_TASKS.ACTUAL_TIMES_USED,' ||
558: 'CSP_PRODUCT_TASKS.TASK_PERCENTAGE,' ||
559: 'CSP_PRODUCT_TASKS.ATTRIBUTE_CATEGORY,' ||
560: 'CSP_PRODUCT_TASKS.ATTRIBUTE1,' ||
561: 'CSP_PRODUCT_TASKS.ATTRIBUTE2,' ||
562: 'CSP_PRODUCT_TASKS.ATTRIBUTE3,' ||
563: 'CSP_PRODUCT_TASKS.ATTRIBUTE4,' ||
564: 'CSP_PRODUCT_TASKS.ATTRIBUTE5,' ||
565: 'CSP_PRODUCT_TASKS.ATTRIBUTE6,' ||
558: 'CSP_PRODUCT_TASKS.TASK_PERCENTAGE,' ||
559: 'CSP_PRODUCT_TASKS.ATTRIBUTE_CATEGORY,' ||
560: 'CSP_PRODUCT_TASKS.ATTRIBUTE1,' ||
561: 'CSP_PRODUCT_TASKS.ATTRIBUTE2,' ||
562: 'CSP_PRODUCT_TASKS.ATTRIBUTE3,' ||
563: 'CSP_PRODUCT_TASKS.ATTRIBUTE4,' ||
564: 'CSP_PRODUCT_TASKS.ATTRIBUTE5,' ||
565: 'CSP_PRODUCT_TASKS.ATTRIBUTE6,' ||
566: 'CSP_PRODUCT_TASKS.ATTRIBUTE7,' ||
559: 'CSP_PRODUCT_TASKS.ATTRIBUTE_CATEGORY,' ||
560: 'CSP_PRODUCT_TASKS.ATTRIBUTE1,' ||
561: 'CSP_PRODUCT_TASKS.ATTRIBUTE2,' ||
562: 'CSP_PRODUCT_TASKS.ATTRIBUTE3,' ||
563: 'CSP_PRODUCT_TASKS.ATTRIBUTE4,' ||
564: 'CSP_PRODUCT_TASKS.ATTRIBUTE5,' ||
565: 'CSP_PRODUCT_TASKS.ATTRIBUTE6,' ||
566: 'CSP_PRODUCT_TASKS.ATTRIBUTE7,' ||
567: 'CSP_PRODUCT_TASKS.ATTRIBUTE8,' ||
560: 'CSP_PRODUCT_TASKS.ATTRIBUTE1,' ||
561: 'CSP_PRODUCT_TASKS.ATTRIBUTE2,' ||
562: 'CSP_PRODUCT_TASKS.ATTRIBUTE3,' ||
563: 'CSP_PRODUCT_TASKS.ATTRIBUTE4,' ||
564: 'CSP_PRODUCT_TASKS.ATTRIBUTE5,' ||
565: 'CSP_PRODUCT_TASKS.ATTRIBUTE6,' ||
566: 'CSP_PRODUCT_TASKS.ATTRIBUTE7,' ||
567: 'CSP_PRODUCT_TASKS.ATTRIBUTE8,' ||
568: 'CSP_PRODUCT_TASKS.ATTRIBUTE9,' ||
561: 'CSP_PRODUCT_TASKS.ATTRIBUTE2,' ||
562: 'CSP_PRODUCT_TASKS.ATTRIBUTE3,' ||
563: 'CSP_PRODUCT_TASKS.ATTRIBUTE4,' ||
564: 'CSP_PRODUCT_TASKS.ATTRIBUTE5,' ||
565: 'CSP_PRODUCT_TASKS.ATTRIBUTE6,' ||
566: 'CSP_PRODUCT_TASKS.ATTRIBUTE7,' ||
567: 'CSP_PRODUCT_TASKS.ATTRIBUTE8,' ||
568: 'CSP_PRODUCT_TASKS.ATTRIBUTE9,' ||
569: 'CSP_PRODUCT_TASKS.ATTRIBUTE10,' ||
562: 'CSP_PRODUCT_TASKS.ATTRIBUTE3,' ||
563: 'CSP_PRODUCT_TASKS.ATTRIBUTE4,' ||
564: 'CSP_PRODUCT_TASKS.ATTRIBUTE5,' ||
565: 'CSP_PRODUCT_TASKS.ATTRIBUTE6,' ||
566: 'CSP_PRODUCT_TASKS.ATTRIBUTE7,' ||
567: 'CSP_PRODUCT_TASKS.ATTRIBUTE8,' ||
568: 'CSP_PRODUCT_TASKS.ATTRIBUTE9,' ||
569: 'CSP_PRODUCT_TASKS.ATTRIBUTE10,' ||
570: 'CSP_PRODUCT_TASKS.ATTRIBUTE11,' ||
563: 'CSP_PRODUCT_TASKS.ATTRIBUTE4,' ||
564: 'CSP_PRODUCT_TASKS.ATTRIBUTE5,' ||
565: 'CSP_PRODUCT_TASKS.ATTRIBUTE6,' ||
566: 'CSP_PRODUCT_TASKS.ATTRIBUTE7,' ||
567: 'CSP_PRODUCT_TASKS.ATTRIBUTE8,' ||
568: 'CSP_PRODUCT_TASKS.ATTRIBUTE9,' ||
569: 'CSP_PRODUCT_TASKS.ATTRIBUTE10,' ||
570: 'CSP_PRODUCT_TASKS.ATTRIBUTE11,' ||
571: 'CSP_PRODUCT_TASKS.ATTRIBUTE12,' ||
564: 'CSP_PRODUCT_TASKS.ATTRIBUTE5,' ||
565: 'CSP_PRODUCT_TASKS.ATTRIBUTE6,' ||
566: 'CSP_PRODUCT_TASKS.ATTRIBUTE7,' ||
567: 'CSP_PRODUCT_TASKS.ATTRIBUTE8,' ||
568: 'CSP_PRODUCT_TASKS.ATTRIBUTE9,' ||
569: 'CSP_PRODUCT_TASKS.ATTRIBUTE10,' ||
570: 'CSP_PRODUCT_TASKS.ATTRIBUTE11,' ||
571: 'CSP_PRODUCT_TASKS.ATTRIBUTE12,' ||
572: 'CSP_PRODUCT_TASKS.ATTRIBUTE13,' ||
565: 'CSP_PRODUCT_TASKS.ATTRIBUTE6,' ||
566: 'CSP_PRODUCT_TASKS.ATTRIBUTE7,' ||
567: 'CSP_PRODUCT_TASKS.ATTRIBUTE8,' ||
568: 'CSP_PRODUCT_TASKS.ATTRIBUTE9,' ||
569: 'CSP_PRODUCT_TASKS.ATTRIBUTE10,' ||
570: 'CSP_PRODUCT_TASKS.ATTRIBUTE11,' ||
571: 'CSP_PRODUCT_TASKS.ATTRIBUTE12,' ||
572: 'CSP_PRODUCT_TASKS.ATTRIBUTE13,' ||
573: 'CSP_PRODUCT_TASKS.ATTRIBUTE14,' ||
566: 'CSP_PRODUCT_TASKS.ATTRIBUTE7,' ||
567: 'CSP_PRODUCT_TASKS.ATTRIBUTE8,' ||
568: 'CSP_PRODUCT_TASKS.ATTRIBUTE9,' ||
569: 'CSP_PRODUCT_TASKS.ATTRIBUTE10,' ||
570: 'CSP_PRODUCT_TASKS.ATTRIBUTE11,' ||
571: 'CSP_PRODUCT_TASKS.ATTRIBUTE12,' ||
572: 'CSP_PRODUCT_TASKS.ATTRIBUTE13,' ||
573: 'CSP_PRODUCT_TASKS.ATTRIBUTE14,' ||
574: 'CSP_PRODUCT_TASKS.ATTRIBUTE15,' ||
567: 'CSP_PRODUCT_TASKS.ATTRIBUTE8,' ||
568: 'CSP_PRODUCT_TASKS.ATTRIBUTE9,' ||
569: 'CSP_PRODUCT_TASKS.ATTRIBUTE10,' ||
570: 'CSP_PRODUCT_TASKS.ATTRIBUTE11,' ||
571: 'CSP_PRODUCT_TASKS.ATTRIBUTE12,' ||
572: 'CSP_PRODUCT_TASKS.ATTRIBUTE13,' ||
573: 'CSP_PRODUCT_TASKS.ATTRIBUTE14,' ||
574: 'CSP_PRODUCT_TASKS.ATTRIBUTE15,' ||
575: 'CSP_PRODUCT_TASKS.CREATED_BY,' ||
568: 'CSP_PRODUCT_TASKS.ATTRIBUTE9,' ||
569: 'CSP_PRODUCT_TASKS.ATTRIBUTE10,' ||
570: 'CSP_PRODUCT_TASKS.ATTRIBUTE11,' ||
571: 'CSP_PRODUCT_TASKS.ATTRIBUTE12,' ||
572: 'CSP_PRODUCT_TASKS.ATTRIBUTE13,' ||
573: 'CSP_PRODUCT_TASKS.ATTRIBUTE14,' ||
574: 'CSP_PRODUCT_TASKS.ATTRIBUTE15,' ||
575: 'CSP_PRODUCT_TASKS.CREATED_BY,' ||
576: 'CSP_PRODUCT_TASKS.CREATION_DATE,' ||
569: 'CSP_PRODUCT_TASKS.ATTRIBUTE10,' ||
570: 'CSP_PRODUCT_TASKS.ATTRIBUTE11,' ||
571: 'CSP_PRODUCT_TASKS.ATTRIBUTE12,' ||
572: 'CSP_PRODUCT_TASKS.ATTRIBUTE13,' ||
573: 'CSP_PRODUCT_TASKS.ATTRIBUTE14,' ||
574: 'CSP_PRODUCT_TASKS.ATTRIBUTE15,' ||
575: 'CSP_PRODUCT_TASKS.CREATED_BY,' ||
576: 'CSP_PRODUCT_TASKS.CREATION_DATE,' ||
577: 'CSP_PRODUCT_TASKS.LAST_UPDATED_BY,' ||
570: 'CSP_PRODUCT_TASKS.ATTRIBUTE11,' ||
571: 'CSP_PRODUCT_TASKS.ATTRIBUTE12,' ||
572: 'CSP_PRODUCT_TASKS.ATTRIBUTE13,' ||
573: 'CSP_PRODUCT_TASKS.ATTRIBUTE14,' ||
574: 'CSP_PRODUCT_TASKS.ATTRIBUTE15,' ||
575: 'CSP_PRODUCT_TASKS.CREATED_BY,' ||
576: 'CSP_PRODUCT_TASKS.CREATION_DATE,' ||
577: 'CSP_PRODUCT_TASKS.LAST_UPDATED_BY,' ||
578: 'CSP_PRODUCT_TASKS.LAST_UPDATE_DATE,' ||
571: 'CSP_PRODUCT_TASKS.ATTRIBUTE12,' ||
572: 'CSP_PRODUCT_TASKS.ATTRIBUTE13,' ||
573: 'CSP_PRODUCT_TASKS.ATTRIBUTE14,' ||
574: 'CSP_PRODUCT_TASKS.ATTRIBUTE15,' ||
575: 'CSP_PRODUCT_TASKS.CREATED_BY,' ||
576: 'CSP_PRODUCT_TASKS.CREATION_DATE,' ||
577: 'CSP_PRODUCT_TASKS.LAST_UPDATED_BY,' ||
578: 'CSP_PRODUCT_TASKS.LAST_UPDATE_DATE,' ||
579: 'CSP_PRODUCT_TASKS.LAST_UPDATE_LOGIN,' ||
572: 'CSP_PRODUCT_TASKS.ATTRIBUTE13,' ||
573: 'CSP_PRODUCT_TASKS.ATTRIBUTE14,' ||
574: 'CSP_PRODUCT_TASKS.ATTRIBUTE15,' ||
575: 'CSP_PRODUCT_TASKS.CREATED_BY,' ||
576: 'CSP_PRODUCT_TASKS.CREATION_DATE,' ||
577: 'CSP_PRODUCT_TASKS.LAST_UPDATED_BY,' ||
578: 'CSP_PRODUCT_TASKS.LAST_UPDATE_DATE,' ||
579: 'CSP_PRODUCT_TASKS.LAST_UPDATE_LOGIN,' ||
580: 'from CSP_PRODUCT_TASKS';
573: 'CSP_PRODUCT_TASKS.ATTRIBUTE14,' ||
574: 'CSP_PRODUCT_TASKS.ATTRIBUTE15,' ||
575: 'CSP_PRODUCT_TASKS.CREATED_BY,' ||
576: 'CSP_PRODUCT_TASKS.CREATION_DATE,' ||
577: 'CSP_PRODUCT_TASKS.LAST_UPDATED_BY,' ||
578: 'CSP_PRODUCT_TASKS.LAST_UPDATE_DATE,' ||
579: 'CSP_PRODUCT_TASKS.LAST_UPDATE_LOGIN,' ||
580: 'from CSP_PRODUCT_TASKS';
581: END Gen_Select;
574: 'CSP_PRODUCT_TASKS.ATTRIBUTE15,' ||
575: 'CSP_PRODUCT_TASKS.CREATED_BY,' ||
576: 'CSP_PRODUCT_TASKS.CREATION_DATE,' ||
577: 'CSP_PRODUCT_TASKS.LAST_UPDATED_BY,' ||
578: 'CSP_PRODUCT_TASKS.LAST_UPDATE_DATE,' ||
579: 'CSP_PRODUCT_TASKS.LAST_UPDATE_LOGIN,' ||
580: 'from CSP_PRODUCT_TASKS';
581: END Gen_Select;
582: PROCEDURE Gen_PROD_TASK_Where(
575: 'CSP_PRODUCT_TASKS.CREATED_BY,' ||
576: 'CSP_PRODUCT_TASKS.CREATION_DATE,' ||
577: 'CSP_PRODUCT_TASKS.LAST_UPDATED_BY,' ||
578: 'CSP_PRODUCT_TASKS.LAST_UPDATE_DATE,' ||
579: 'CSP_PRODUCT_TASKS.LAST_UPDATE_LOGIN,' ||
580: 'from CSP_PRODUCT_TASKS';
581: END Gen_Select;
582: PROCEDURE Gen_PROD_TASK_Where(
583: P_PROD_TASK_Rec IN CSP_PRODUCT_TASK_PUB.PROD_TASK_Rec_Type,
576: 'CSP_PRODUCT_TASKS.CREATION_DATE,' ||
577: 'CSP_PRODUCT_TASKS.LAST_UPDATED_BY,' ||
578: 'CSP_PRODUCT_TASKS.LAST_UPDATE_DATE,' ||
579: 'CSP_PRODUCT_TASKS.LAST_UPDATE_LOGIN,' ||
580: 'from CSP_PRODUCT_TASKS';
581: END Gen_Select;
582: PROCEDURE Gen_PROD_TASK_Where(
583: P_PROD_TASK_Rec IN CSP_PRODUCT_TASK_PUB.PROD_TASK_Rec_Type,
584: x_PROD_TASK_where OUT NOCOPY VARCHAR2