DBA Data[Home] [Help]

APPS.CSP_PRODUCT_TASK_PVT dependencies on CSP_PRODUCT_TASKS

Line 75: -- Invoke table handler(CSP_PRODUCT_TASKS_PKG.Insert_Row)

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,

Line 76: CSP_PRODUCT_TASKS_PKG.Insert_Row(

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,

Line 195: From CSP_PRODUCT_TASKS

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:

Line 310: -- Invoke table handler(CSP_PRODUCT_TASKS_PKG.Update_Row)

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,

Line 312: CSP_PRODUCT_TASKS_PKG.Update_Row(

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,

Line 421: -- Invoke table handler(CSP_PRODUCT_TASKS_PKG.Delete_Row)

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

Line 422: CSP_PRODUCT_TASKS_PKG.Delete_Row(

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: --

Line 475: -- define all columns for CSP_PRODUCT_TASKS view

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);

Line 506: -- get all column values for CSP_PRODUCT_TASKS table

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);

Line 553: 'CSP_PRODUCT_TASKS.PRODUCT_TASK_ID,' ||

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,' ||

Line 554: 'CSP_PRODUCT_TASKS.PRODUCT_ID,' ||

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,' ||

Line 555: 'CSP_PRODUCT_TASKS.TASK_TEMPLATE_ID,' ||

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,' ||

Line 556: 'CSP_PRODUCT_TASKS.AUTO_MANUAL,' ||

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,' ||

Line 557: 'CSP_PRODUCT_TASKS.ACTUAL_TIMES_USED,' ||

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,' ||

Line 558: 'CSP_PRODUCT_TASKS.TASK_PERCENTAGE,' ||

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,' ||

Line 559: 'CSP_PRODUCT_TASKS.ATTRIBUTE_CATEGORY,' ||

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,' ||

Line 560: 'CSP_PRODUCT_TASKS.ATTRIBUTE1,' ||

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,' ||

Line 561: 'CSP_PRODUCT_TASKS.ATTRIBUTE2,' ||

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,' ||

Line 562: 'CSP_PRODUCT_TASKS.ATTRIBUTE3,' ||

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,' ||

Line 563: 'CSP_PRODUCT_TASKS.ATTRIBUTE4,' ||

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,' ||

Line 564: 'CSP_PRODUCT_TASKS.ATTRIBUTE5,' ||

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,' ||

Line 565: 'CSP_PRODUCT_TASKS.ATTRIBUTE6,' ||

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,' ||

Line 566: 'CSP_PRODUCT_TASKS.ATTRIBUTE7,' ||

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,' ||

Line 567: 'CSP_PRODUCT_TASKS.ATTRIBUTE8,' ||

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,' ||

Line 568: 'CSP_PRODUCT_TASKS.ATTRIBUTE9,' ||

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,' ||

Line 569: 'CSP_PRODUCT_TASKS.ATTRIBUTE10,' ||

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,' ||

Line 570: 'CSP_PRODUCT_TASKS.ATTRIBUTE11,' ||

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,' ||

Line 571: 'CSP_PRODUCT_TASKS.ATTRIBUTE12,' ||

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,' ||

Line 572: 'CSP_PRODUCT_TASKS.ATTRIBUTE13,' ||

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,' ||

Line 573: 'CSP_PRODUCT_TASKS.ATTRIBUTE14,' ||

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,' ||

Line 574: 'CSP_PRODUCT_TASKS.ATTRIBUTE15,' ||

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,' ||

Line 575: 'CSP_PRODUCT_TASKS.CREATED_BY,' ||

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,' ||

Line 576: 'CSP_PRODUCT_TASKS.CREATION_DATE,' ||

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';

Line 577: 'CSP_PRODUCT_TASKS.LAST_UPDATED_BY,' ||

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;

Line 578: 'CSP_PRODUCT_TASKS.LAST_UPDATE_DATE,' ||

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(

Line 579: 'CSP_PRODUCT_TASKS.LAST_UPDATE_LOGIN,' ||

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,

Line 580: 'from CSP_PRODUCT_TASKS';

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