eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSP_TASK_PART_PVT dependencies on DBMS_SQL

Line 616: dbms_sql.define_column(p_cur_get_TASK_PART, 1, P_TASK_PART_Rec.TASK_PART_ID);

612: BEGIN
613: -- Debug Message
614: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Private API: Define Columns Begins');
615: -- define all columns for CSP_TASK_PARTS view
616: dbms_sql.define_column(p_cur_get_TASK_PART, 1, P_TASK_PART_Rec.TASK_PART_ID);
617: dbms_sql.define_column(p_cur_get_TASK_PART, 2, P_TASK_PART_Rec.PRODUCT_TASK_ID);
618: dbms_sql.define_column(p_cur_get_TASK_PART, 3, P_TASK_PART_Rec.INVENTORY_ITEM_ID);
619: dbms_sql.define_column(p_cur_get_TASK_PART, 4, P_TASK_PART_Rec.MANUAL_QUANTITY);
620: dbms_sql.define_column(p_cur_get_TASK_PART, 5, P_TASK_PART_Rec.MANUAL_PERCENTAGE);

Line 617: dbms_sql.define_column(p_cur_get_TASK_PART, 2, P_TASK_PART_Rec.PRODUCT_TASK_ID);

613: -- Debug Message
614: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Private API: Define Columns Begins');
615: -- define all columns for CSP_TASK_PARTS view
616: dbms_sql.define_column(p_cur_get_TASK_PART, 1, P_TASK_PART_Rec.TASK_PART_ID);
617: dbms_sql.define_column(p_cur_get_TASK_PART, 2, P_TASK_PART_Rec.PRODUCT_TASK_ID);
618: dbms_sql.define_column(p_cur_get_TASK_PART, 3, P_TASK_PART_Rec.INVENTORY_ITEM_ID);
619: dbms_sql.define_column(p_cur_get_TASK_PART, 4, P_TASK_PART_Rec.MANUAL_QUANTITY);
620: dbms_sql.define_column(p_cur_get_TASK_PART, 5, P_TASK_PART_Rec.MANUAL_PERCENTAGE);
621: dbms_sql.define_column(p_cur_get_TASK_PART, 6, P_TASK_PART_Rec.QUANTITY_USED);

Line 618: dbms_sql.define_column(p_cur_get_TASK_PART, 3, P_TASK_PART_Rec.INVENTORY_ITEM_ID);

614: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Private API: Define Columns Begins');
615: -- define all columns for CSP_TASK_PARTS view
616: dbms_sql.define_column(p_cur_get_TASK_PART, 1, P_TASK_PART_Rec.TASK_PART_ID);
617: dbms_sql.define_column(p_cur_get_TASK_PART, 2, P_TASK_PART_Rec.PRODUCT_TASK_ID);
618: dbms_sql.define_column(p_cur_get_TASK_PART, 3, P_TASK_PART_Rec.INVENTORY_ITEM_ID);
619: dbms_sql.define_column(p_cur_get_TASK_PART, 4, P_TASK_PART_Rec.MANUAL_QUANTITY);
620: dbms_sql.define_column(p_cur_get_TASK_PART, 5, P_TASK_PART_Rec.MANUAL_PERCENTAGE);
621: dbms_sql.define_column(p_cur_get_TASK_PART, 6, P_TASK_PART_Rec.QUANTITY_USED);
622: dbms_sql.define_column(p_cur_get_TASK_PART, 7, P_TASK_PART_Rec.ACTUAL_TIMES_USED);

Line 619: dbms_sql.define_column(p_cur_get_TASK_PART, 4, P_TASK_PART_Rec.MANUAL_QUANTITY);

615: -- define all columns for CSP_TASK_PARTS view
616: dbms_sql.define_column(p_cur_get_TASK_PART, 1, P_TASK_PART_Rec.TASK_PART_ID);
617: dbms_sql.define_column(p_cur_get_TASK_PART, 2, P_TASK_PART_Rec.PRODUCT_TASK_ID);
618: dbms_sql.define_column(p_cur_get_TASK_PART, 3, P_TASK_PART_Rec.INVENTORY_ITEM_ID);
619: dbms_sql.define_column(p_cur_get_TASK_PART, 4, P_TASK_PART_Rec.MANUAL_QUANTITY);
620: dbms_sql.define_column(p_cur_get_TASK_PART, 5, P_TASK_PART_Rec.MANUAL_PERCENTAGE);
621: dbms_sql.define_column(p_cur_get_TASK_PART, 6, P_TASK_PART_Rec.QUANTITY_USED);
622: dbms_sql.define_column(p_cur_get_TASK_PART, 7, P_TASK_PART_Rec.ACTUAL_TIMES_USED);
623: dbms_sql.define_column(p_cur_get_TASK_PART, 10, P_TASK_PART_Rec.ATTRIBUTE_CATEGORY, 30);

Line 620: dbms_sql.define_column(p_cur_get_TASK_PART, 5, P_TASK_PART_Rec.MANUAL_PERCENTAGE);

616: dbms_sql.define_column(p_cur_get_TASK_PART, 1, P_TASK_PART_Rec.TASK_PART_ID);
617: dbms_sql.define_column(p_cur_get_TASK_PART, 2, P_TASK_PART_Rec.PRODUCT_TASK_ID);
618: dbms_sql.define_column(p_cur_get_TASK_PART, 3, P_TASK_PART_Rec.INVENTORY_ITEM_ID);
619: dbms_sql.define_column(p_cur_get_TASK_PART, 4, P_TASK_PART_Rec.MANUAL_QUANTITY);
620: dbms_sql.define_column(p_cur_get_TASK_PART, 5, P_TASK_PART_Rec.MANUAL_PERCENTAGE);
621: dbms_sql.define_column(p_cur_get_TASK_PART, 6, P_TASK_PART_Rec.QUANTITY_USED);
622: dbms_sql.define_column(p_cur_get_TASK_PART, 7, P_TASK_PART_Rec.ACTUAL_TIMES_USED);
623: dbms_sql.define_column(p_cur_get_TASK_PART, 10, P_TASK_PART_Rec.ATTRIBUTE_CATEGORY, 30);
624: dbms_sql.define_column(p_cur_get_TASK_PART, 11, P_TASK_PART_Rec.ATTRIBUTE1, 150);

Line 621: dbms_sql.define_column(p_cur_get_TASK_PART, 6, P_TASK_PART_Rec.QUANTITY_USED);

617: dbms_sql.define_column(p_cur_get_TASK_PART, 2, P_TASK_PART_Rec.PRODUCT_TASK_ID);
618: dbms_sql.define_column(p_cur_get_TASK_PART, 3, P_TASK_PART_Rec.INVENTORY_ITEM_ID);
619: dbms_sql.define_column(p_cur_get_TASK_PART, 4, P_TASK_PART_Rec.MANUAL_QUANTITY);
620: dbms_sql.define_column(p_cur_get_TASK_PART, 5, P_TASK_PART_Rec.MANUAL_PERCENTAGE);
621: dbms_sql.define_column(p_cur_get_TASK_PART, 6, P_TASK_PART_Rec.QUANTITY_USED);
622: dbms_sql.define_column(p_cur_get_TASK_PART, 7, P_TASK_PART_Rec.ACTUAL_TIMES_USED);
623: dbms_sql.define_column(p_cur_get_TASK_PART, 10, P_TASK_PART_Rec.ATTRIBUTE_CATEGORY, 30);
624: dbms_sql.define_column(p_cur_get_TASK_PART, 11, P_TASK_PART_Rec.ATTRIBUTE1, 150);
625: dbms_sql.define_column(p_cur_get_TASK_PART, 12, P_TASK_PART_Rec.ATTRIBUTE2, 150);

Line 622: dbms_sql.define_column(p_cur_get_TASK_PART, 7, P_TASK_PART_Rec.ACTUAL_TIMES_USED);

618: dbms_sql.define_column(p_cur_get_TASK_PART, 3, P_TASK_PART_Rec.INVENTORY_ITEM_ID);
619: dbms_sql.define_column(p_cur_get_TASK_PART, 4, P_TASK_PART_Rec.MANUAL_QUANTITY);
620: dbms_sql.define_column(p_cur_get_TASK_PART, 5, P_TASK_PART_Rec.MANUAL_PERCENTAGE);
621: dbms_sql.define_column(p_cur_get_TASK_PART, 6, P_TASK_PART_Rec.QUANTITY_USED);
622: dbms_sql.define_column(p_cur_get_TASK_PART, 7, P_TASK_PART_Rec.ACTUAL_TIMES_USED);
623: dbms_sql.define_column(p_cur_get_TASK_PART, 10, P_TASK_PART_Rec.ATTRIBUTE_CATEGORY, 30);
624: dbms_sql.define_column(p_cur_get_TASK_PART, 11, P_TASK_PART_Rec.ATTRIBUTE1, 150);
625: dbms_sql.define_column(p_cur_get_TASK_PART, 12, P_TASK_PART_Rec.ATTRIBUTE2, 150);
626: dbms_sql.define_column(p_cur_get_TASK_PART, 13, P_TASK_PART_Rec.ATTRIBUTE3, 150);

Line 623: dbms_sql.define_column(p_cur_get_TASK_PART, 10, P_TASK_PART_Rec.ATTRIBUTE_CATEGORY, 30);

619: dbms_sql.define_column(p_cur_get_TASK_PART, 4, P_TASK_PART_Rec.MANUAL_QUANTITY);
620: dbms_sql.define_column(p_cur_get_TASK_PART, 5, P_TASK_PART_Rec.MANUAL_PERCENTAGE);
621: dbms_sql.define_column(p_cur_get_TASK_PART, 6, P_TASK_PART_Rec.QUANTITY_USED);
622: dbms_sql.define_column(p_cur_get_TASK_PART, 7, P_TASK_PART_Rec.ACTUAL_TIMES_USED);
623: dbms_sql.define_column(p_cur_get_TASK_PART, 10, P_TASK_PART_Rec.ATTRIBUTE_CATEGORY, 30);
624: dbms_sql.define_column(p_cur_get_TASK_PART, 11, P_TASK_PART_Rec.ATTRIBUTE1, 150);
625: dbms_sql.define_column(p_cur_get_TASK_PART, 12, P_TASK_PART_Rec.ATTRIBUTE2, 150);
626: dbms_sql.define_column(p_cur_get_TASK_PART, 13, P_TASK_PART_Rec.ATTRIBUTE3, 150);
627: dbms_sql.define_column(p_cur_get_TASK_PART, 14, P_TASK_PART_Rec.ATTRIBUTE4, 150);

Line 624: dbms_sql.define_column(p_cur_get_TASK_PART, 11, P_TASK_PART_Rec.ATTRIBUTE1, 150);

620: dbms_sql.define_column(p_cur_get_TASK_PART, 5, P_TASK_PART_Rec.MANUAL_PERCENTAGE);
621: dbms_sql.define_column(p_cur_get_TASK_PART, 6, P_TASK_PART_Rec.QUANTITY_USED);
622: dbms_sql.define_column(p_cur_get_TASK_PART, 7, P_TASK_PART_Rec.ACTUAL_TIMES_USED);
623: dbms_sql.define_column(p_cur_get_TASK_PART, 10, P_TASK_PART_Rec.ATTRIBUTE_CATEGORY, 30);
624: dbms_sql.define_column(p_cur_get_TASK_PART, 11, P_TASK_PART_Rec.ATTRIBUTE1, 150);
625: dbms_sql.define_column(p_cur_get_TASK_PART, 12, P_TASK_PART_Rec.ATTRIBUTE2, 150);
626: dbms_sql.define_column(p_cur_get_TASK_PART, 13, P_TASK_PART_Rec.ATTRIBUTE3, 150);
627: dbms_sql.define_column(p_cur_get_TASK_PART, 14, P_TASK_PART_Rec.ATTRIBUTE4, 150);
628: dbms_sql.define_column(p_cur_get_TASK_PART, 15, P_TASK_PART_Rec.ATTRIBUTE5, 150);

Line 625: dbms_sql.define_column(p_cur_get_TASK_PART, 12, P_TASK_PART_Rec.ATTRIBUTE2, 150);

621: dbms_sql.define_column(p_cur_get_TASK_PART, 6, P_TASK_PART_Rec.QUANTITY_USED);
622: dbms_sql.define_column(p_cur_get_TASK_PART, 7, P_TASK_PART_Rec.ACTUAL_TIMES_USED);
623: dbms_sql.define_column(p_cur_get_TASK_PART, 10, P_TASK_PART_Rec.ATTRIBUTE_CATEGORY, 30);
624: dbms_sql.define_column(p_cur_get_TASK_PART, 11, P_TASK_PART_Rec.ATTRIBUTE1, 150);
625: dbms_sql.define_column(p_cur_get_TASK_PART, 12, P_TASK_PART_Rec.ATTRIBUTE2, 150);
626: dbms_sql.define_column(p_cur_get_TASK_PART, 13, P_TASK_PART_Rec.ATTRIBUTE3, 150);
627: dbms_sql.define_column(p_cur_get_TASK_PART, 14, P_TASK_PART_Rec.ATTRIBUTE4, 150);
628: dbms_sql.define_column(p_cur_get_TASK_PART, 15, P_TASK_PART_Rec.ATTRIBUTE5, 150);
629: dbms_sql.define_column(p_cur_get_TASK_PART, 16, P_TASK_PART_Rec.ATTRIBUTE6, 150);

Line 626: dbms_sql.define_column(p_cur_get_TASK_PART, 13, P_TASK_PART_Rec.ATTRIBUTE3, 150);

622: dbms_sql.define_column(p_cur_get_TASK_PART, 7, P_TASK_PART_Rec.ACTUAL_TIMES_USED);
623: dbms_sql.define_column(p_cur_get_TASK_PART, 10, P_TASK_PART_Rec.ATTRIBUTE_CATEGORY, 30);
624: dbms_sql.define_column(p_cur_get_TASK_PART, 11, P_TASK_PART_Rec.ATTRIBUTE1, 150);
625: dbms_sql.define_column(p_cur_get_TASK_PART, 12, P_TASK_PART_Rec.ATTRIBUTE2, 150);
626: dbms_sql.define_column(p_cur_get_TASK_PART, 13, P_TASK_PART_Rec.ATTRIBUTE3, 150);
627: dbms_sql.define_column(p_cur_get_TASK_PART, 14, P_TASK_PART_Rec.ATTRIBUTE4, 150);
628: dbms_sql.define_column(p_cur_get_TASK_PART, 15, P_TASK_PART_Rec.ATTRIBUTE5, 150);
629: dbms_sql.define_column(p_cur_get_TASK_PART, 16, P_TASK_PART_Rec.ATTRIBUTE6, 150);
630: dbms_sql.define_column(p_cur_get_TASK_PART, 17, P_TASK_PART_Rec.ATTRIBUTE7, 150);

Line 627: dbms_sql.define_column(p_cur_get_TASK_PART, 14, P_TASK_PART_Rec.ATTRIBUTE4, 150);

623: dbms_sql.define_column(p_cur_get_TASK_PART, 10, P_TASK_PART_Rec.ATTRIBUTE_CATEGORY, 30);
624: dbms_sql.define_column(p_cur_get_TASK_PART, 11, P_TASK_PART_Rec.ATTRIBUTE1, 150);
625: dbms_sql.define_column(p_cur_get_TASK_PART, 12, P_TASK_PART_Rec.ATTRIBUTE2, 150);
626: dbms_sql.define_column(p_cur_get_TASK_PART, 13, P_TASK_PART_Rec.ATTRIBUTE3, 150);
627: dbms_sql.define_column(p_cur_get_TASK_PART, 14, P_TASK_PART_Rec.ATTRIBUTE4, 150);
628: dbms_sql.define_column(p_cur_get_TASK_PART, 15, P_TASK_PART_Rec.ATTRIBUTE5, 150);
629: dbms_sql.define_column(p_cur_get_TASK_PART, 16, P_TASK_PART_Rec.ATTRIBUTE6, 150);
630: dbms_sql.define_column(p_cur_get_TASK_PART, 17, P_TASK_PART_Rec.ATTRIBUTE7, 150);
631: dbms_sql.define_column(p_cur_get_TASK_PART, 18, P_TASK_PART_Rec.ATTRIBUTE8, 150);

Line 628: dbms_sql.define_column(p_cur_get_TASK_PART, 15, P_TASK_PART_Rec.ATTRIBUTE5, 150);

624: dbms_sql.define_column(p_cur_get_TASK_PART, 11, P_TASK_PART_Rec.ATTRIBUTE1, 150);
625: dbms_sql.define_column(p_cur_get_TASK_PART, 12, P_TASK_PART_Rec.ATTRIBUTE2, 150);
626: dbms_sql.define_column(p_cur_get_TASK_PART, 13, P_TASK_PART_Rec.ATTRIBUTE3, 150);
627: dbms_sql.define_column(p_cur_get_TASK_PART, 14, P_TASK_PART_Rec.ATTRIBUTE4, 150);
628: dbms_sql.define_column(p_cur_get_TASK_PART, 15, P_TASK_PART_Rec.ATTRIBUTE5, 150);
629: dbms_sql.define_column(p_cur_get_TASK_PART, 16, P_TASK_PART_Rec.ATTRIBUTE6, 150);
630: dbms_sql.define_column(p_cur_get_TASK_PART, 17, P_TASK_PART_Rec.ATTRIBUTE7, 150);
631: dbms_sql.define_column(p_cur_get_TASK_PART, 18, P_TASK_PART_Rec.ATTRIBUTE8, 150);
632: dbms_sql.define_column(p_cur_get_TASK_PART, 19, P_TASK_PART_Rec.ATTRIBUTE9, 150);

Line 629: dbms_sql.define_column(p_cur_get_TASK_PART, 16, P_TASK_PART_Rec.ATTRIBUTE6, 150);

625: dbms_sql.define_column(p_cur_get_TASK_PART, 12, P_TASK_PART_Rec.ATTRIBUTE2, 150);
626: dbms_sql.define_column(p_cur_get_TASK_PART, 13, P_TASK_PART_Rec.ATTRIBUTE3, 150);
627: dbms_sql.define_column(p_cur_get_TASK_PART, 14, P_TASK_PART_Rec.ATTRIBUTE4, 150);
628: dbms_sql.define_column(p_cur_get_TASK_PART, 15, P_TASK_PART_Rec.ATTRIBUTE5, 150);
629: dbms_sql.define_column(p_cur_get_TASK_PART, 16, P_TASK_PART_Rec.ATTRIBUTE6, 150);
630: dbms_sql.define_column(p_cur_get_TASK_PART, 17, P_TASK_PART_Rec.ATTRIBUTE7, 150);
631: dbms_sql.define_column(p_cur_get_TASK_PART, 18, P_TASK_PART_Rec.ATTRIBUTE8, 150);
632: dbms_sql.define_column(p_cur_get_TASK_PART, 19, P_TASK_PART_Rec.ATTRIBUTE9, 150);
633: dbms_sql.define_column(p_cur_get_TASK_PART, 20, P_TASK_PART_Rec.ATTRIBUTE10, 150);

Line 630: dbms_sql.define_column(p_cur_get_TASK_PART, 17, P_TASK_PART_Rec.ATTRIBUTE7, 150);

626: dbms_sql.define_column(p_cur_get_TASK_PART, 13, P_TASK_PART_Rec.ATTRIBUTE3, 150);
627: dbms_sql.define_column(p_cur_get_TASK_PART, 14, P_TASK_PART_Rec.ATTRIBUTE4, 150);
628: dbms_sql.define_column(p_cur_get_TASK_PART, 15, P_TASK_PART_Rec.ATTRIBUTE5, 150);
629: dbms_sql.define_column(p_cur_get_TASK_PART, 16, P_TASK_PART_Rec.ATTRIBUTE6, 150);
630: dbms_sql.define_column(p_cur_get_TASK_PART, 17, P_TASK_PART_Rec.ATTRIBUTE7, 150);
631: dbms_sql.define_column(p_cur_get_TASK_PART, 18, P_TASK_PART_Rec.ATTRIBUTE8, 150);
632: dbms_sql.define_column(p_cur_get_TASK_PART, 19, P_TASK_PART_Rec.ATTRIBUTE9, 150);
633: dbms_sql.define_column(p_cur_get_TASK_PART, 20, P_TASK_PART_Rec.ATTRIBUTE10, 150);
634: dbms_sql.define_column(p_cur_get_TASK_PART, 21, P_TASK_PART_Rec.ATTRIBUTE11, 150);

Line 631: dbms_sql.define_column(p_cur_get_TASK_PART, 18, P_TASK_PART_Rec.ATTRIBUTE8, 150);

627: dbms_sql.define_column(p_cur_get_TASK_PART, 14, P_TASK_PART_Rec.ATTRIBUTE4, 150);
628: dbms_sql.define_column(p_cur_get_TASK_PART, 15, P_TASK_PART_Rec.ATTRIBUTE5, 150);
629: dbms_sql.define_column(p_cur_get_TASK_PART, 16, P_TASK_PART_Rec.ATTRIBUTE6, 150);
630: dbms_sql.define_column(p_cur_get_TASK_PART, 17, P_TASK_PART_Rec.ATTRIBUTE7, 150);
631: dbms_sql.define_column(p_cur_get_TASK_PART, 18, P_TASK_PART_Rec.ATTRIBUTE8, 150);
632: dbms_sql.define_column(p_cur_get_TASK_PART, 19, P_TASK_PART_Rec.ATTRIBUTE9, 150);
633: dbms_sql.define_column(p_cur_get_TASK_PART, 20, P_TASK_PART_Rec.ATTRIBUTE10, 150);
634: dbms_sql.define_column(p_cur_get_TASK_PART, 21, P_TASK_PART_Rec.ATTRIBUTE11, 150);
635: dbms_sql.define_column(p_cur_get_TASK_PART, 22, P_TASK_PART_Rec.ATTRIBUTE12, 150);

Line 632: dbms_sql.define_column(p_cur_get_TASK_PART, 19, P_TASK_PART_Rec.ATTRIBUTE9, 150);

628: dbms_sql.define_column(p_cur_get_TASK_PART, 15, P_TASK_PART_Rec.ATTRIBUTE5, 150);
629: dbms_sql.define_column(p_cur_get_TASK_PART, 16, P_TASK_PART_Rec.ATTRIBUTE6, 150);
630: dbms_sql.define_column(p_cur_get_TASK_PART, 17, P_TASK_PART_Rec.ATTRIBUTE7, 150);
631: dbms_sql.define_column(p_cur_get_TASK_PART, 18, P_TASK_PART_Rec.ATTRIBUTE8, 150);
632: dbms_sql.define_column(p_cur_get_TASK_PART, 19, P_TASK_PART_Rec.ATTRIBUTE9, 150);
633: dbms_sql.define_column(p_cur_get_TASK_PART, 20, P_TASK_PART_Rec.ATTRIBUTE10, 150);
634: dbms_sql.define_column(p_cur_get_TASK_PART, 21, P_TASK_PART_Rec.ATTRIBUTE11, 150);
635: dbms_sql.define_column(p_cur_get_TASK_PART, 22, P_TASK_PART_Rec.ATTRIBUTE12, 150);
636: dbms_sql.define_column(p_cur_get_TASK_PART, 23, P_TASK_PART_Rec.ATTRIBUTE13, 150);

Line 633: dbms_sql.define_column(p_cur_get_TASK_PART, 20, P_TASK_PART_Rec.ATTRIBUTE10, 150);

629: dbms_sql.define_column(p_cur_get_TASK_PART, 16, P_TASK_PART_Rec.ATTRIBUTE6, 150);
630: dbms_sql.define_column(p_cur_get_TASK_PART, 17, P_TASK_PART_Rec.ATTRIBUTE7, 150);
631: dbms_sql.define_column(p_cur_get_TASK_PART, 18, P_TASK_PART_Rec.ATTRIBUTE8, 150);
632: dbms_sql.define_column(p_cur_get_TASK_PART, 19, P_TASK_PART_Rec.ATTRIBUTE9, 150);
633: dbms_sql.define_column(p_cur_get_TASK_PART, 20, P_TASK_PART_Rec.ATTRIBUTE10, 150);
634: dbms_sql.define_column(p_cur_get_TASK_PART, 21, P_TASK_PART_Rec.ATTRIBUTE11, 150);
635: dbms_sql.define_column(p_cur_get_TASK_PART, 22, P_TASK_PART_Rec.ATTRIBUTE12, 150);
636: dbms_sql.define_column(p_cur_get_TASK_PART, 23, P_TASK_PART_Rec.ATTRIBUTE13, 150);
637: dbms_sql.define_column(p_cur_get_TASK_PART, 24, P_TASK_PART_Rec.ATTRIBUTE14, 150);

Line 634: dbms_sql.define_column(p_cur_get_TASK_PART, 21, P_TASK_PART_Rec.ATTRIBUTE11, 150);

630: dbms_sql.define_column(p_cur_get_TASK_PART, 17, P_TASK_PART_Rec.ATTRIBUTE7, 150);
631: dbms_sql.define_column(p_cur_get_TASK_PART, 18, P_TASK_PART_Rec.ATTRIBUTE8, 150);
632: dbms_sql.define_column(p_cur_get_TASK_PART, 19, P_TASK_PART_Rec.ATTRIBUTE9, 150);
633: dbms_sql.define_column(p_cur_get_TASK_PART, 20, P_TASK_PART_Rec.ATTRIBUTE10, 150);
634: dbms_sql.define_column(p_cur_get_TASK_PART, 21, P_TASK_PART_Rec.ATTRIBUTE11, 150);
635: dbms_sql.define_column(p_cur_get_TASK_PART, 22, P_TASK_PART_Rec.ATTRIBUTE12, 150);
636: dbms_sql.define_column(p_cur_get_TASK_PART, 23, P_TASK_PART_Rec.ATTRIBUTE13, 150);
637: dbms_sql.define_column(p_cur_get_TASK_PART, 24, P_TASK_PART_Rec.ATTRIBUTE14, 150);
638: dbms_sql.define_column(p_cur_get_TASK_PART, 25, P_TASK_PART_Rec.ATTRIBUTE15, 150);

Line 635: dbms_sql.define_column(p_cur_get_TASK_PART, 22, P_TASK_PART_Rec.ATTRIBUTE12, 150);

631: dbms_sql.define_column(p_cur_get_TASK_PART, 18, P_TASK_PART_Rec.ATTRIBUTE8, 150);
632: dbms_sql.define_column(p_cur_get_TASK_PART, 19, P_TASK_PART_Rec.ATTRIBUTE9, 150);
633: dbms_sql.define_column(p_cur_get_TASK_PART, 20, P_TASK_PART_Rec.ATTRIBUTE10, 150);
634: dbms_sql.define_column(p_cur_get_TASK_PART, 21, P_TASK_PART_Rec.ATTRIBUTE11, 150);
635: dbms_sql.define_column(p_cur_get_TASK_PART, 22, P_TASK_PART_Rec.ATTRIBUTE12, 150);
636: dbms_sql.define_column(p_cur_get_TASK_PART, 23, P_TASK_PART_Rec.ATTRIBUTE13, 150);
637: dbms_sql.define_column(p_cur_get_TASK_PART, 24, P_TASK_PART_Rec.ATTRIBUTE14, 150);
638: dbms_sql.define_column(p_cur_get_TASK_PART, 25, P_TASK_PART_Rec.ATTRIBUTE15, 150);
639: dbms_sql.define_column(p_cur_get_TASK_PART, 26, P_TASK_PART_Rec.PRIMARY_UOM_CODE, 3);

Line 636: dbms_sql.define_column(p_cur_get_TASK_PART, 23, P_TASK_PART_Rec.ATTRIBUTE13, 150);

632: dbms_sql.define_column(p_cur_get_TASK_PART, 19, P_TASK_PART_Rec.ATTRIBUTE9, 150);
633: dbms_sql.define_column(p_cur_get_TASK_PART, 20, P_TASK_PART_Rec.ATTRIBUTE10, 150);
634: dbms_sql.define_column(p_cur_get_TASK_PART, 21, P_TASK_PART_Rec.ATTRIBUTE11, 150);
635: dbms_sql.define_column(p_cur_get_TASK_PART, 22, P_TASK_PART_Rec.ATTRIBUTE12, 150);
636: dbms_sql.define_column(p_cur_get_TASK_PART, 23, P_TASK_PART_Rec.ATTRIBUTE13, 150);
637: dbms_sql.define_column(p_cur_get_TASK_PART, 24, P_TASK_PART_Rec.ATTRIBUTE14, 150);
638: dbms_sql.define_column(p_cur_get_TASK_PART, 25, P_TASK_PART_Rec.ATTRIBUTE15, 150);
639: dbms_sql.define_column(p_cur_get_TASK_PART, 26, P_TASK_PART_Rec.PRIMARY_UOM_CODE, 3);
640: dbms_sql.define_column(p_cur_get_TASK_PART, 27, P_TASK_PART_Rec.REVISION, 30);

Line 637: dbms_sql.define_column(p_cur_get_TASK_PART, 24, P_TASK_PART_Rec.ATTRIBUTE14, 150);

633: dbms_sql.define_column(p_cur_get_TASK_PART, 20, P_TASK_PART_Rec.ATTRIBUTE10, 150);
634: dbms_sql.define_column(p_cur_get_TASK_PART, 21, P_TASK_PART_Rec.ATTRIBUTE11, 150);
635: dbms_sql.define_column(p_cur_get_TASK_PART, 22, P_TASK_PART_Rec.ATTRIBUTE12, 150);
636: dbms_sql.define_column(p_cur_get_TASK_PART, 23, P_TASK_PART_Rec.ATTRIBUTE13, 150);
637: dbms_sql.define_column(p_cur_get_TASK_PART, 24, P_TASK_PART_Rec.ATTRIBUTE14, 150);
638: dbms_sql.define_column(p_cur_get_TASK_PART, 25, P_TASK_PART_Rec.ATTRIBUTE15, 150);
639: dbms_sql.define_column(p_cur_get_TASK_PART, 26, P_TASK_PART_Rec.PRIMARY_UOM_CODE, 3);
640: dbms_sql.define_column(p_cur_get_TASK_PART, 27, P_TASK_PART_Rec.REVISION, 30);
641: dbms_sql.define_column(p_cur_get_TASK_PART, 28, P_TASK_PART_Rec.START_DATE);

Line 638: dbms_sql.define_column(p_cur_get_TASK_PART, 25, P_TASK_PART_Rec.ATTRIBUTE15, 150);

634: dbms_sql.define_column(p_cur_get_TASK_PART, 21, P_TASK_PART_Rec.ATTRIBUTE11, 150);
635: dbms_sql.define_column(p_cur_get_TASK_PART, 22, P_TASK_PART_Rec.ATTRIBUTE12, 150);
636: dbms_sql.define_column(p_cur_get_TASK_PART, 23, P_TASK_PART_Rec.ATTRIBUTE13, 150);
637: dbms_sql.define_column(p_cur_get_TASK_PART, 24, P_TASK_PART_Rec.ATTRIBUTE14, 150);
638: dbms_sql.define_column(p_cur_get_TASK_PART, 25, P_TASK_PART_Rec.ATTRIBUTE15, 150);
639: dbms_sql.define_column(p_cur_get_TASK_PART, 26, P_TASK_PART_Rec.PRIMARY_UOM_CODE, 3);
640: dbms_sql.define_column(p_cur_get_TASK_PART, 27, P_TASK_PART_Rec.REVISION, 30);
641: dbms_sql.define_column(p_cur_get_TASK_PART, 28, P_TASK_PART_Rec.START_DATE);
642: dbms_sql.define_column(p_cur_get_TASK_PART, 29, P_TASK_PART_Rec.END_DATE);

Line 639: dbms_sql.define_column(p_cur_get_TASK_PART, 26, P_TASK_PART_Rec.PRIMARY_UOM_CODE, 3);

635: dbms_sql.define_column(p_cur_get_TASK_PART, 22, P_TASK_PART_Rec.ATTRIBUTE12, 150);
636: dbms_sql.define_column(p_cur_get_TASK_PART, 23, P_TASK_PART_Rec.ATTRIBUTE13, 150);
637: dbms_sql.define_column(p_cur_get_TASK_PART, 24, P_TASK_PART_Rec.ATTRIBUTE14, 150);
638: dbms_sql.define_column(p_cur_get_TASK_PART, 25, P_TASK_PART_Rec.ATTRIBUTE15, 150);
639: dbms_sql.define_column(p_cur_get_TASK_PART, 26, P_TASK_PART_Rec.PRIMARY_UOM_CODE, 3);
640: dbms_sql.define_column(p_cur_get_TASK_PART, 27, P_TASK_PART_Rec.REVISION, 30);
641: dbms_sql.define_column(p_cur_get_TASK_PART, 28, P_TASK_PART_Rec.START_DATE);
642: dbms_sql.define_column(p_cur_get_TASK_PART, 29, P_TASK_PART_Rec.END_DATE);
643: dbms_sql.define_column(p_cur_get_TASK_PART, 29, P_TASK_PART_Rec.ROLLUP_QUANTITY_USED);

Line 640: dbms_sql.define_column(p_cur_get_TASK_PART, 27, P_TASK_PART_Rec.REVISION, 30);

636: dbms_sql.define_column(p_cur_get_TASK_PART, 23, P_TASK_PART_Rec.ATTRIBUTE13, 150);
637: dbms_sql.define_column(p_cur_get_TASK_PART, 24, P_TASK_PART_Rec.ATTRIBUTE14, 150);
638: dbms_sql.define_column(p_cur_get_TASK_PART, 25, P_TASK_PART_Rec.ATTRIBUTE15, 150);
639: dbms_sql.define_column(p_cur_get_TASK_PART, 26, P_TASK_PART_Rec.PRIMARY_UOM_CODE, 3);
640: dbms_sql.define_column(p_cur_get_TASK_PART, 27, P_TASK_PART_Rec.REVISION, 30);
641: dbms_sql.define_column(p_cur_get_TASK_PART, 28, P_TASK_PART_Rec.START_DATE);
642: dbms_sql.define_column(p_cur_get_TASK_PART, 29, P_TASK_PART_Rec.END_DATE);
643: dbms_sql.define_column(p_cur_get_TASK_PART, 29, P_TASK_PART_Rec.ROLLUP_QUANTITY_USED);
644: dbms_sql.define_column(p_cur_get_TASK_PART, 29, P_TASK_PART_Rec.ROLLUP_TIMES_USED);

Line 641: dbms_sql.define_column(p_cur_get_TASK_PART, 28, P_TASK_PART_Rec.START_DATE);

637: dbms_sql.define_column(p_cur_get_TASK_PART, 24, P_TASK_PART_Rec.ATTRIBUTE14, 150);
638: dbms_sql.define_column(p_cur_get_TASK_PART, 25, P_TASK_PART_Rec.ATTRIBUTE15, 150);
639: dbms_sql.define_column(p_cur_get_TASK_PART, 26, P_TASK_PART_Rec.PRIMARY_UOM_CODE, 3);
640: dbms_sql.define_column(p_cur_get_TASK_PART, 27, P_TASK_PART_Rec.REVISION, 30);
641: dbms_sql.define_column(p_cur_get_TASK_PART, 28, P_TASK_PART_Rec.START_DATE);
642: dbms_sql.define_column(p_cur_get_TASK_PART, 29, P_TASK_PART_Rec.END_DATE);
643: dbms_sql.define_column(p_cur_get_TASK_PART, 29, P_TASK_PART_Rec.ROLLUP_QUANTITY_USED);
644: dbms_sql.define_column(p_cur_get_TASK_PART, 29, P_TASK_PART_Rec.ROLLUP_TIMES_USED);
645: dbms_sql.define_column(p_cur_get_TASK_PART, 30, p_TASK_PART_Rec.SUBSTITUTE_ITEM );

Line 642: dbms_sql.define_column(p_cur_get_TASK_PART, 29, P_TASK_PART_Rec.END_DATE);

638: dbms_sql.define_column(p_cur_get_TASK_PART, 25, P_TASK_PART_Rec.ATTRIBUTE15, 150);
639: dbms_sql.define_column(p_cur_get_TASK_PART, 26, P_TASK_PART_Rec.PRIMARY_UOM_CODE, 3);
640: dbms_sql.define_column(p_cur_get_TASK_PART, 27, P_TASK_PART_Rec.REVISION, 30);
641: dbms_sql.define_column(p_cur_get_TASK_PART, 28, P_TASK_PART_Rec.START_DATE);
642: dbms_sql.define_column(p_cur_get_TASK_PART, 29, P_TASK_PART_Rec.END_DATE);
643: dbms_sql.define_column(p_cur_get_TASK_PART, 29, P_TASK_PART_Rec.ROLLUP_QUANTITY_USED);
644: dbms_sql.define_column(p_cur_get_TASK_PART, 29, P_TASK_PART_Rec.ROLLUP_TIMES_USED);
645: dbms_sql.define_column(p_cur_get_TASK_PART, 30, p_TASK_PART_Rec.SUBSTITUTE_ITEM );
646: -- Debug Message

Line 643: dbms_sql.define_column(p_cur_get_TASK_PART, 29, P_TASK_PART_Rec.ROLLUP_QUANTITY_USED);

639: dbms_sql.define_column(p_cur_get_TASK_PART, 26, P_TASK_PART_Rec.PRIMARY_UOM_CODE, 3);
640: dbms_sql.define_column(p_cur_get_TASK_PART, 27, P_TASK_PART_Rec.REVISION, 30);
641: dbms_sql.define_column(p_cur_get_TASK_PART, 28, P_TASK_PART_Rec.START_DATE);
642: dbms_sql.define_column(p_cur_get_TASK_PART, 29, P_TASK_PART_Rec.END_DATE);
643: dbms_sql.define_column(p_cur_get_TASK_PART, 29, P_TASK_PART_Rec.ROLLUP_QUANTITY_USED);
644: dbms_sql.define_column(p_cur_get_TASK_PART, 29, P_TASK_PART_Rec.ROLLUP_TIMES_USED);
645: dbms_sql.define_column(p_cur_get_TASK_PART, 30, p_TASK_PART_Rec.SUBSTITUTE_ITEM );
646: -- Debug Message
647: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Private API: Define Columns Ends');

Line 644: dbms_sql.define_column(p_cur_get_TASK_PART, 29, P_TASK_PART_Rec.ROLLUP_TIMES_USED);

640: dbms_sql.define_column(p_cur_get_TASK_PART, 27, P_TASK_PART_Rec.REVISION, 30);
641: dbms_sql.define_column(p_cur_get_TASK_PART, 28, P_TASK_PART_Rec.START_DATE);
642: dbms_sql.define_column(p_cur_get_TASK_PART, 29, P_TASK_PART_Rec.END_DATE);
643: dbms_sql.define_column(p_cur_get_TASK_PART, 29, P_TASK_PART_Rec.ROLLUP_QUANTITY_USED);
644: dbms_sql.define_column(p_cur_get_TASK_PART, 29, P_TASK_PART_Rec.ROLLUP_TIMES_USED);
645: dbms_sql.define_column(p_cur_get_TASK_PART, 30, p_TASK_PART_Rec.SUBSTITUTE_ITEM );
646: -- Debug Message
647: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Private API: Define Columns Ends');
648: END Define_Columns;

Line 645: dbms_sql.define_column(p_cur_get_TASK_PART, 30, p_TASK_PART_Rec.SUBSTITUTE_ITEM );

641: dbms_sql.define_column(p_cur_get_TASK_PART, 28, P_TASK_PART_Rec.START_DATE);
642: dbms_sql.define_column(p_cur_get_TASK_PART, 29, P_TASK_PART_Rec.END_DATE);
643: dbms_sql.define_column(p_cur_get_TASK_PART, 29, P_TASK_PART_Rec.ROLLUP_QUANTITY_USED);
644: dbms_sql.define_column(p_cur_get_TASK_PART, 29, P_TASK_PART_Rec.ROLLUP_TIMES_USED);
645: dbms_sql.define_column(p_cur_get_TASK_PART, 30, p_TASK_PART_Rec.SUBSTITUTE_ITEM );
646: -- Debug Message
647: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Private API: Define Columns Ends');
648: END Define_Columns;
649: -- This procudure gets column values by the Dynamic SQL.

Line 659: dbms_sql.column_value(p_cur_get_TASK_PART, 1, X_TASK_PART_Rec.TASK_PART_ID);

655: BEGIN
656: -- Debug Message
657: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Private API: Get Column Values Begins');
658: -- get all column values for CSP_TASK_PARTS table
659: dbms_sql.column_value(p_cur_get_TASK_PART, 1, X_TASK_PART_Rec.TASK_PART_ID);
660: dbms_sql.column_value(p_cur_get_TASK_PART, 2, X_TASK_PART_Rec.PRODUCT_TASK_ID);
661: dbms_sql.column_value(p_cur_get_TASK_PART, 3, X_TASK_PART_Rec.INVENTORY_ITEM_ID);
662: dbms_sql.column_value(p_cur_get_TASK_PART, 4, X_TASK_PART_Rec.MANUAL_QUANTITY);
663: dbms_sql.column_value(p_cur_get_TASK_PART, 5, X_TASK_PART_Rec.MANUAL_PERCENTAGE);

Line 660: dbms_sql.column_value(p_cur_get_TASK_PART, 2, X_TASK_PART_Rec.PRODUCT_TASK_ID);

656: -- Debug Message
657: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Private API: Get Column Values Begins');
658: -- get all column values for CSP_TASK_PARTS table
659: dbms_sql.column_value(p_cur_get_TASK_PART, 1, X_TASK_PART_Rec.TASK_PART_ID);
660: dbms_sql.column_value(p_cur_get_TASK_PART, 2, X_TASK_PART_Rec.PRODUCT_TASK_ID);
661: dbms_sql.column_value(p_cur_get_TASK_PART, 3, X_TASK_PART_Rec.INVENTORY_ITEM_ID);
662: dbms_sql.column_value(p_cur_get_TASK_PART, 4, X_TASK_PART_Rec.MANUAL_QUANTITY);
663: dbms_sql.column_value(p_cur_get_TASK_PART, 5, X_TASK_PART_Rec.MANUAL_PERCENTAGE);
664: dbms_sql.column_value(p_cur_get_TASK_PART, 6, X_TASK_PART_Rec.QUANTITY_USED);

Line 661: dbms_sql.column_value(p_cur_get_TASK_PART, 3, X_TASK_PART_Rec.INVENTORY_ITEM_ID);

657: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Private API: Get Column Values Begins');
658: -- get all column values for CSP_TASK_PARTS table
659: dbms_sql.column_value(p_cur_get_TASK_PART, 1, X_TASK_PART_Rec.TASK_PART_ID);
660: dbms_sql.column_value(p_cur_get_TASK_PART, 2, X_TASK_PART_Rec.PRODUCT_TASK_ID);
661: dbms_sql.column_value(p_cur_get_TASK_PART, 3, X_TASK_PART_Rec.INVENTORY_ITEM_ID);
662: dbms_sql.column_value(p_cur_get_TASK_PART, 4, X_TASK_PART_Rec.MANUAL_QUANTITY);
663: dbms_sql.column_value(p_cur_get_TASK_PART, 5, X_TASK_PART_Rec.MANUAL_PERCENTAGE);
664: dbms_sql.column_value(p_cur_get_TASK_PART, 6, X_TASK_PART_Rec.QUANTITY_USED);
665: dbms_sql.column_value(p_cur_get_TASK_PART, 7, X_TASK_PART_Rec.ACTUAL_TIMES_USED);

Line 662: dbms_sql.column_value(p_cur_get_TASK_PART, 4, X_TASK_PART_Rec.MANUAL_QUANTITY);

658: -- get all column values for CSP_TASK_PARTS table
659: dbms_sql.column_value(p_cur_get_TASK_PART, 1, X_TASK_PART_Rec.TASK_PART_ID);
660: dbms_sql.column_value(p_cur_get_TASK_PART, 2, X_TASK_PART_Rec.PRODUCT_TASK_ID);
661: dbms_sql.column_value(p_cur_get_TASK_PART, 3, X_TASK_PART_Rec.INVENTORY_ITEM_ID);
662: dbms_sql.column_value(p_cur_get_TASK_PART, 4, X_TASK_PART_Rec.MANUAL_QUANTITY);
663: dbms_sql.column_value(p_cur_get_TASK_PART, 5, X_TASK_PART_Rec.MANUAL_PERCENTAGE);
664: dbms_sql.column_value(p_cur_get_TASK_PART, 6, X_TASK_PART_Rec.QUANTITY_USED);
665: dbms_sql.column_value(p_cur_get_TASK_PART, 7, X_TASK_PART_Rec.ACTUAL_TIMES_USED);
666: dbms_sql.column_value(p_cur_get_TASK_PART, 10, X_TASK_PART_Rec.ATTRIBUTE_CATEGORY);

Line 663: dbms_sql.column_value(p_cur_get_TASK_PART, 5, X_TASK_PART_Rec.MANUAL_PERCENTAGE);

659: dbms_sql.column_value(p_cur_get_TASK_PART, 1, X_TASK_PART_Rec.TASK_PART_ID);
660: dbms_sql.column_value(p_cur_get_TASK_PART, 2, X_TASK_PART_Rec.PRODUCT_TASK_ID);
661: dbms_sql.column_value(p_cur_get_TASK_PART, 3, X_TASK_PART_Rec.INVENTORY_ITEM_ID);
662: dbms_sql.column_value(p_cur_get_TASK_PART, 4, X_TASK_PART_Rec.MANUAL_QUANTITY);
663: dbms_sql.column_value(p_cur_get_TASK_PART, 5, X_TASK_PART_Rec.MANUAL_PERCENTAGE);
664: dbms_sql.column_value(p_cur_get_TASK_PART, 6, X_TASK_PART_Rec.QUANTITY_USED);
665: dbms_sql.column_value(p_cur_get_TASK_PART, 7, X_TASK_PART_Rec.ACTUAL_TIMES_USED);
666: dbms_sql.column_value(p_cur_get_TASK_PART, 10, X_TASK_PART_Rec.ATTRIBUTE_CATEGORY);
667: dbms_sql.column_value(p_cur_get_TASK_PART, 11, X_TASK_PART_Rec.ATTRIBUTE1);

Line 664: dbms_sql.column_value(p_cur_get_TASK_PART, 6, X_TASK_PART_Rec.QUANTITY_USED);

660: dbms_sql.column_value(p_cur_get_TASK_PART, 2, X_TASK_PART_Rec.PRODUCT_TASK_ID);
661: dbms_sql.column_value(p_cur_get_TASK_PART, 3, X_TASK_PART_Rec.INVENTORY_ITEM_ID);
662: dbms_sql.column_value(p_cur_get_TASK_PART, 4, X_TASK_PART_Rec.MANUAL_QUANTITY);
663: dbms_sql.column_value(p_cur_get_TASK_PART, 5, X_TASK_PART_Rec.MANUAL_PERCENTAGE);
664: dbms_sql.column_value(p_cur_get_TASK_PART, 6, X_TASK_PART_Rec.QUANTITY_USED);
665: dbms_sql.column_value(p_cur_get_TASK_PART, 7, X_TASK_PART_Rec.ACTUAL_TIMES_USED);
666: dbms_sql.column_value(p_cur_get_TASK_PART, 10, X_TASK_PART_Rec.ATTRIBUTE_CATEGORY);
667: dbms_sql.column_value(p_cur_get_TASK_PART, 11, X_TASK_PART_Rec.ATTRIBUTE1);
668: dbms_sql.column_value(p_cur_get_TASK_PART, 12, X_TASK_PART_Rec.ATTRIBUTE2);

Line 665: dbms_sql.column_value(p_cur_get_TASK_PART, 7, X_TASK_PART_Rec.ACTUAL_TIMES_USED);

661: dbms_sql.column_value(p_cur_get_TASK_PART, 3, X_TASK_PART_Rec.INVENTORY_ITEM_ID);
662: dbms_sql.column_value(p_cur_get_TASK_PART, 4, X_TASK_PART_Rec.MANUAL_QUANTITY);
663: dbms_sql.column_value(p_cur_get_TASK_PART, 5, X_TASK_PART_Rec.MANUAL_PERCENTAGE);
664: dbms_sql.column_value(p_cur_get_TASK_PART, 6, X_TASK_PART_Rec.QUANTITY_USED);
665: dbms_sql.column_value(p_cur_get_TASK_PART, 7, X_TASK_PART_Rec.ACTUAL_TIMES_USED);
666: dbms_sql.column_value(p_cur_get_TASK_PART, 10, X_TASK_PART_Rec.ATTRIBUTE_CATEGORY);
667: dbms_sql.column_value(p_cur_get_TASK_PART, 11, X_TASK_PART_Rec.ATTRIBUTE1);
668: dbms_sql.column_value(p_cur_get_TASK_PART, 12, X_TASK_PART_Rec.ATTRIBUTE2);
669: dbms_sql.column_value(p_cur_get_TASK_PART, 13, X_TASK_PART_Rec.ATTRIBUTE3);

Line 666: dbms_sql.column_value(p_cur_get_TASK_PART, 10, X_TASK_PART_Rec.ATTRIBUTE_CATEGORY);

662: dbms_sql.column_value(p_cur_get_TASK_PART, 4, X_TASK_PART_Rec.MANUAL_QUANTITY);
663: dbms_sql.column_value(p_cur_get_TASK_PART, 5, X_TASK_PART_Rec.MANUAL_PERCENTAGE);
664: dbms_sql.column_value(p_cur_get_TASK_PART, 6, X_TASK_PART_Rec.QUANTITY_USED);
665: dbms_sql.column_value(p_cur_get_TASK_PART, 7, X_TASK_PART_Rec.ACTUAL_TIMES_USED);
666: dbms_sql.column_value(p_cur_get_TASK_PART, 10, X_TASK_PART_Rec.ATTRIBUTE_CATEGORY);
667: dbms_sql.column_value(p_cur_get_TASK_PART, 11, X_TASK_PART_Rec.ATTRIBUTE1);
668: dbms_sql.column_value(p_cur_get_TASK_PART, 12, X_TASK_PART_Rec.ATTRIBUTE2);
669: dbms_sql.column_value(p_cur_get_TASK_PART, 13, X_TASK_PART_Rec.ATTRIBUTE3);
670: dbms_sql.column_value(p_cur_get_TASK_PART, 14, X_TASK_PART_Rec.ATTRIBUTE4);

Line 667: dbms_sql.column_value(p_cur_get_TASK_PART, 11, X_TASK_PART_Rec.ATTRIBUTE1);

663: dbms_sql.column_value(p_cur_get_TASK_PART, 5, X_TASK_PART_Rec.MANUAL_PERCENTAGE);
664: dbms_sql.column_value(p_cur_get_TASK_PART, 6, X_TASK_PART_Rec.QUANTITY_USED);
665: dbms_sql.column_value(p_cur_get_TASK_PART, 7, X_TASK_PART_Rec.ACTUAL_TIMES_USED);
666: dbms_sql.column_value(p_cur_get_TASK_PART, 10, X_TASK_PART_Rec.ATTRIBUTE_CATEGORY);
667: dbms_sql.column_value(p_cur_get_TASK_PART, 11, X_TASK_PART_Rec.ATTRIBUTE1);
668: dbms_sql.column_value(p_cur_get_TASK_PART, 12, X_TASK_PART_Rec.ATTRIBUTE2);
669: dbms_sql.column_value(p_cur_get_TASK_PART, 13, X_TASK_PART_Rec.ATTRIBUTE3);
670: dbms_sql.column_value(p_cur_get_TASK_PART, 14, X_TASK_PART_Rec.ATTRIBUTE4);
671: dbms_sql.column_value(p_cur_get_TASK_PART, 15, X_TASK_PART_Rec.ATTRIBUTE5);

Line 668: dbms_sql.column_value(p_cur_get_TASK_PART, 12, X_TASK_PART_Rec.ATTRIBUTE2);

664: dbms_sql.column_value(p_cur_get_TASK_PART, 6, X_TASK_PART_Rec.QUANTITY_USED);
665: dbms_sql.column_value(p_cur_get_TASK_PART, 7, X_TASK_PART_Rec.ACTUAL_TIMES_USED);
666: dbms_sql.column_value(p_cur_get_TASK_PART, 10, X_TASK_PART_Rec.ATTRIBUTE_CATEGORY);
667: dbms_sql.column_value(p_cur_get_TASK_PART, 11, X_TASK_PART_Rec.ATTRIBUTE1);
668: dbms_sql.column_value(p_cur_get_TASK_PART, 12, X_TASK_PART_Rec.ATTRIBUTE2);
669: dbms_sql.column_value(p_cur_get_TASK_PART, 13, X_TASK_PART_Rec.ATTRIBUTE3);
670: dbms_sql.column_value(p_cur_get_TASK_PART, 14, X_TASK_PART_Rec.ATTRIBUTE4);
671: dbms_sql.column_value(p_cur_get_TASK_PART, 15, X_TASK_PART_Rec.ATTRIBUTE5);
672: dbms_sql.column_value(p_cur_get_TASK_PART, 16, X_TASK_PART_Rec.ATTRIBUTE6);

Line 669: dbms_sql.column_value(p_cur_get_TASK_PART, 13, X_TASK_PART_Rec.ATTRIBUTE3);

665: dbms_sql.column_value(p_cur_get_TASK_PART, 7, X_TASK_PART_Rec.ACTUAL_TIMES_USED);
666: dbms_sql.column_value(p_cur_get_TASK_PART, 10, X_TASK_PART_Rec.ATTRIBUTE_CATEGORY);
667: dbms_sql.column_value(p_cur_get_TASK_PART, 11, X_TASK_PART_Rec.ATTRIBUTE1);
668: dbms_sql.column_value(p_cur_get_TASK_PART, 12, X_TASK_PART_Rec.ATTRIBUTE2);
669: dbms_sql.column_value(p_cur_get_TASK_PART, 13, X_TASK_PART_Rec.ATTRIBUTE3);
670: dbms_sql.column_value(p_cur_get_TASK_PART, 14, X_TASK_PART_Rec.ATTRIBUTE4);
671: dbms_sql.column_value(p_cur_get_TASK_PART, 15, X_TASK_PART_Rec.ATTRIBUTE5);
672: dbms_sql.column_value(p_cur_get_TASK_PART, 16, X_TASK_PART_Rec.ATTRIBUTE6);
673: dbms_sql.column_value(p_cur_get_TASK_PART, 17, X_TASK_PART_Rec.ATTRIBUTE7);

Line 670: dbms_sql.column_value(p_cur_get_TASK_PART, 14, X_TASK_PART_Rec.ATTRIBUTE4);

666: dbms_sql.column_value(p_cur_get_TASK_PART, 10, X_TASK_PART_Rec.ATTRIBUTE_CATEGORY);
667: dbms_sql.column_value(p_cur_get_TASK_PART, 11, X_TASK_PART_Rec.ATTRIBUTE1);
668: dbms_sql.column_value(p_cur_get_TASK_PART, 12, X_TASK_PART_Rec.ATTRIBUTE2);
669: dbms_sql.column_value(p_cur_get_TASK_PART, 13, X_TASK_PART_Rec.ATTRIBUTE3);
670: dbms_sql.column_value(p_cur_get_TASK_PART, 14, X_TASK_PART_Rec.ATTRIBUTE4);
671: dbms_sql.column_value(p_cur_get_TASK_PART, 15, X_TASK_PART_Rec.ATTRIBUTE5);
672: dbms_sql.column_value(p_cur_get_TASK_PART, 16, X_TASK_PART_Rec.ATTRIBUTE6);
673: dbms_sql.column_value(p_cur_get_TASK_PART, 17, X_TASK_PART_Rec.ATTRIBUTE7);
674: dbms_sql.column_value(p_cur_get_TASK_PART, 18, X_TASK_PART_Rec.ATTRIBUTE8);

Line 671: dbms_sql.column_value(p_cur_get_TASK_PART, 15, X_TASK_PART_Rec.ATTRIBUTE5);

667: dbms_sql.column_value(p_cur_get_TASK_PART, 11, X_TASK_PART_Rec.ATTRIBUTE1);
668: dbms_sql.column_value(p_cur_get_TASK_PART, 12, X_TASK_PART_Rec.ATTRIBUTE2);
669: dbms_sql.column_value(p_cur_get_TASK_PART, 13, X_TASK_PART_Rec.ATTRIBUTE3);
670: dbms_sql.column_value(p_cur_get_TASK_PART, 14, X_TASK_PART_Rec.ATTRIBUTE4);
671: dbms_sql.column_value(p_cur_get_TASK_PART, 15, X_TASK_PART_Rec.ATTRIBUTE5);
672: dbms_sql.column_value(p_cur_get_TASK_PART, 16, X_TASK_PART_Rec.ATTRIBUTE6);
673: dbms_sql.column_value(p_cur_get_TASK_PART, 17, X_TASK_PART_Rec.ATTRIBUTE7);
674: dbms_sql.column_value(p_cur_get_TASK_PART, 18, X_TASK_PART_Rec.ATTRIBUTE8);
675: dbms_sql.column_value(p_cur_get_TASK_PART, 19, X_TASK_PART_Rec.ATTRIBUTE9);

Line 672: dbms_sql.column_value(p_cur_get_TASK_PART, 16, X_TASK_PART_Rec.ATTRIBUTE6);

668: dbms_sql.column_value(p_cur_get_TASK_PART, 12, X_TASK_PART_Rec.ATTRIBUTE2);
669: dbms_sql.column_value(p_cur_get_TASK_PART, 13, X_TASK_PART_Rec.ATTRIBUTE3);
670: dbms_sql.column_value(p_cur_get_TASK_PART, 14, X_TASK_PART_Rec.ATTRIBUTE4);
671: dbms_sql.column_value(p_cur_get_TASK_PART, 15, X_TASK_PART_Rec.ATTRIBUTE5);
672: dbms_sql.column_value(p_cur_get_TASK_PART, 16, X_TASK_PART_Rec.ATTRIBUTE6);
673: dbms_sql.column_value(p_cur_get_TASK_PART, 17, X_TASK_PART_Rec.ATTRIBUTE7);
674: dbms_sql.column_value(p_cur_get_TASK_PART, 18, X_TASK_PART_Rec.ATTRIBUTE8);
675: dbms_sql.column_value(p_cur_get_TASK_PART, 19, X_TASK_PART_Rec.ATTRIBUTE9);
676: dbms_sql.column_value(p_cur_get_TASK_PART, 20, X_TASK_PART_Rec.ATTRIBUTE10);

Line 673: dbms_sql.column_value(p_cur_get_TASK_PART, 17, X_TASK_PART_Rec.ATTRIBUTE7);

669: dbms_sql.column_value(p_cur_get_TASK_PART, 13, X_TASK_PART_Rec.ATTRIBUTE3);
670: dbms_sql.column_value(p_cur_get_TASK_PART, 14, X_TASK_PART_Rec.ATTRIBUTE4);
671: dbms_sql.column_value(p_cur_get_TASK_PART, 15, X_TASK_PART_Rec.ATTRIBUTE5);
672: dbms_sql.column_value(p_cur_get_TASK_PART, 16, X_TASK_PART_Rec.ATTRIBUTE6);
673: dbms_sql.column_value(p_cur_get_TASK_PART, 17, X_TASK_PART_Rec.ATTRIBUTE7);
674: dbms_sql.column_value(p_cur_get_TASK_PART, 18, X_TASK_PART_Rec.ATTRIBUTE8);
675: dbms_sql.column_value(p_cur_get_TASK_PART, 19, X_TASK_PART_Rec.ATTRIBUTE9);
676: dbms_sql.column_value(p_cur_get_TASK_PART, 20, X_TASK_PART_Rec.ATTRIBUTE10);
677: dbms_sql.column_value(p_cur_get_TASK_PART, 21, X_TASK_PART_Rec.ATTRIBUTE11);

Line 674: dbms_sql.column_value(p_cur_get_TASK_PART, 18, X_TASK_PART_Rec.ATTRIBUTE8);

670: dbms_sql.column_value(p_cur_get_TASK_PART, 14, X_TASK_PART_Rec.ATTRIBUTE4);
671: dbms_sql.column_value(p_cur_get_TASK_PART, 15, X_TASK_PART_Rec.ATTRIBUTE5);
672: dbms_sql.column_value(p_cur_get_TASK_PART, 16, X_TASK_PART_Rec.ATTRIBUTE6);
673: dbms_sql.column_value(p_cur_get_TASK_PART, 17, X_TASK_PART_Rec.ATTRIBUTE7);
674: dbms_sql.column_value(p_cur_get_TASK_PART, 18, X_TASK_PART_Rec.ATTRIBUTE8);
675: dbms_sql.column_value(p_cur_get_TASK_PART, 19, X_TASK_PART_Rec.ATTRIBUTE9);
676: dbms_sql.column_value(p_cur_get_TASK_PART, 20, X_TASK_PART_Rec.ATTRIBUTE10);
677: dbms_sql.column_value(p_cur_get_TASK_PART, 21, X_TASK_PART_Rec.ATTRIBUTE11);
678: dbms_sql.column_value(p_cur_get_TASK_PART, 22, X_TASK_PART_Rec.ATTRIBUTE12);

Line 675: dbms_sql.column_value(p_cur_get_TASK_PART, 19, X_TASK_PART_Rec.ATTRIBUTE9);

671: dbms_sql.column_value(p_cur_get_TASK_PART, 15, X_TASK_PART_Rec.ATTRIBUTE5);
672: dbms_sql.column_value(p_cur_get_TASK_PART, 16, X_TASK_PART_Rec.ATTRIBUTE6);
673: dbms_sql.column_value(p_cur_get_TASK_PART, 17, X_TASK_PART_Rec.ATTRIBUTE7);
674: dbms_sql.column_value(p_cur_get_TASK_PART, 18, X_TASK_PART_Rec.ATTRIBUTE8);
675: dbms_sql.column_value(p_cur_get_TASK_PART, 19, X_TASK_PART_Rec.ATTRIBUTE9);
676: dbms_sql.column_value(p_cur_get_TASK_PART, 20, X_TASK_PART_Rec.ATTRIBUTE10);
677: dbms_sql.column_value(p_cur_get_TASK_PART, 21, X_TASK_PART_Rec.ATTRIBUTE11);
678: dbms_sql.column_value(p_cur_get_TASK_PART, 22, X_TASK_PART_Rec.ATTRIBUTE12);
679: dbms_sql.column_value(p_cur_get_TASK_PART, 23, X_TASK_PART_Rec.ATTRIBUTE13);

Line 676: dbms_sql.column_value(p_cur_get_TASK_PART, 20, X_TASK_PART_Rec.ATTRIBUTE10);

672: dbms_sql.column_value(p_cur_get_TASK_PART, 16, X_TASK_PART_Rec.ATTRIBUTE6);
673: dbms_sql.column_value(p_cur_get_TASK_PART, 17, X_TASK_PART_Rec.ATTRIBUTE7);
674: dbms_sql.column_value(p_cur_get_TASK_PART, 18, X_TASK_PART_Rec.ATTRIBUTE8);
675: dbms_sql.column_value(p_cur_get_TASK_PART, 19, X_TASK_PART_Rec.ATTRIBUTE9);
676: dbms_sql.column_value(p_cur_get_TASK_PART, 20, X_TASK_PART_Rec.ATTRIBUTE10);
677: dbms_sql.column_value(p_cur_get_TASK_PART, 21, X_TASK_PART_Rec.ATTRIBUTE11);
678: dbms_sql.column_value(p_cur_get_TASK_PART, 22, X_TASK_PART_Rec.ATTRIBUTE12);
679: dbms_sql.column_value(p_cur_get_TASK_PART, 23, X_TASK_PART_Rec.ATTRIBUTE13);
680: dbms_sql.column_value(p_cur_get_TASK_PART, 24, X_TASK_PART_Rec.ATTRIBUTE14);

Line 677: dbms_sql.column_value(p_cur_get_TASK_PART, 21, X_TASK_PART_Rec.ATTRIBUTE11);

673: dbms_sql.column_value(p_cur_get_TASK_PART, 17, X_TASK_PART_Rec.ATTRIBUTE7);
674: dbms_sql.column_value(p_cur_get_TASK_PART, 18, X_TASK_PART_Rec.ATTRIBUTE8);
675: dbms_sql.column_value(p_cur_get_TASK_PART, 19, X_TASK_PART_Rec.ATTRIBUTE9);
676: dbms_sql.column_value(p_cur_get_TASK_PART, 20, X_TASK_PART_Rec.ATTRIBUTE10);
677: dbms_sql.column_value(p_cur_get_TASK_PART, 21, X_TASK_PART_Rec.ATTRIBUTE11);
678: dbms_sql.column_value(p_cur_get_TASK_PART, 22, X_TASK_PART_Rec.ATTRIBUTE12);
679: dbms_sql.column_value(p_cur_get_TASK_PART, 23, X_TASK_PART_Rec.ATTRIBUTE13);
680: dbms_sql.column_value(p_cur_get_TASK_PART, 24, X_TASK_PART_Rec.ATTRIBUTE14);
681: dbms_sql.column_value(p_cur_get_TASK_PART, 25, X_TASK_PART_Rec.ATTRIBUTE15);

Line 678: dbms_sql.column_value(p_cur_get_TASK_PART, 22, X_TASK_PART_Rec.ATTRIBUTE12);

674: dbms_sql.column_value(p_cur_get_TASK_PART, 18, X_TASK_PART_Rec.ATTRIBUTE8);
675: dbms_sql.column_value(p_cur_get_TASK_PART, 19, X_TASK_PART_Rec.ATTRIBUTE9);
676: dbms_sql.column_value(p_cur_get_TASK_PART, 20, X_TASK_PART_Rec.ATTRIBUTE10);
677: dbms_sql.column_value(p_cur_get_TASK_PART, 21, X_TASK_PART_Rec.ATTRIBUTE11);
678: dbms_sql.column_value(p_cur_get_TASK_PART, 22, X_TASK_PART_Rec.ATTRIBUTE12);
679: dbms_sql.column_value(p_cur_get_TASK_PART, 23, X_TASK_PART_Rec.ATTRIBUTE13);
680: dbms_sql.column_value(p_cur_get_TASK_PART, 24, X_TASK_PART_Rec.ATTRIBUTE14);
681: dbms_sql.column_value(p_cur_get_TASK_PART, 25, X_TASK_PART_Rec.ATTRIBUTE15);
682: dbms_sql.column_value(p_cur_get_TASK_PART, 26, X_TASK_PART_Rec.PRIMARY_UOM_CODE);

Line 679: dbms_sql.column_value(p_cur_get_TASK_PART, 23, X_TASK_PART_Rec.ATTRIBUTE13);

675: dbms_sql.column_value(p_cur_get_TASK_PART, 19, X_TASK_PART_Rec.ATTRIBUTE9);
676: dbms_sql.column_value(p_cur_get_TASK_PART, 20, X_TASK_PART_Rec.ATTRIBUTE10);
677: dbms_sql.column_value(p_cur_get_TASK_PART, 21, X_TASK_PART_Rec.ATTRIBUTE11);
678: dbms_sql.column_value(p_cur_get_TASK_PART, 22, X_TASK_PART_Rec.ATTRIBUTE12);
679: dbms_sql.column_value(p_cur_get_TASK_PART, 23, X_TASK_PART_Rec.ATTRIBUTE13);
680: dbms_sql.column_value(p_cur_get_TASK_PART, 24, X_TASK_PART_Rec.ATTRIBUTE14);
681: dbms_sql.column_value(p_cur_get_TASK_PART, 25, X_TASK_PART_Rec.ATTRIBUTE15);
682: dbms_sql.column_value(p_cur_get_TASK_PART, 26, X_TASK_PART_Rec.PRIMARY_UOM_CODE);
683: dbms_sql.column_value(p_cur_get_TASK_PART, 27, X_TASK_PART_Rec.REVISION);

Line 680: dbms_sql.column_value(p_cur_get_TASK_PART, 24, X_TASK_PART_Rec.ATTRIBUTE14);

676: dbms_sql.column_value(p_cur_get_TASK_PART, 20, X_TASK_PART_Rec.ATTRIBUTE10);
677: dbms_sql.column_value(p_cur_get_TASK_PART, 21, X_TASK_PART_Rec.ATTRIBUTE11);
678: dbms_sql.column_value(p_cur_get_TASK_PART, 22, X_TASK_PART_Rec.ATTRIBUTE12);
679: dbms_sql.column_value(p_cur_get_TASK_PART, 23, X_TASK_PART_Rec.ATTRIBUTE13);
680: dbms_sql.column_value(p_cur_get_TASK_PART, 24, X_TASK_PART_Rec.ATTRIBUTE14);
681: dbms_sql.column_value(p_cur_get_TASK_PART, 25, X_TASK_PART_Rec.ATTRIBUTE15);
682: dbms_sql.column_value(p_cur_get_TASK_PART, 26, X_TASK_PART_Rec.PRIMARY_UOM_CODE);
683: dbms_sql.column_value(p_cur_get_TASK_PART, 27, X_TASK_PART_Rec.REVISION);
684: dbms_sql.column_value(p_cur_get_TASK_PART, 28, X_TASK_PART_Rec.START_DATE);

Line 681: dbms_sql.column_value(p_cur_get_TASK_PART, 25, X_TASK_PART_Rec.ATTRIBUTE15);

677: dbms_sql.column_value(p_cur_get_TASK_PART, 21, X_TASK_PART_Rec.ATTRIBUTE11);
678: dbms_sql.column_value(p_cur_get_TASK_PART, 22, X_TASK_PART_Rec.ATTRIBUTE12);
679: dbms_sql.column_value(p_cur_get_TASK_PART, 23, X_TASK_PART_Rec.ATTRIBUTE13);
680: dbms_sql.column_value(p_cur_get_TASK_PART, 24, X_TASK_PART_Rec.ATTRIBUTE14);
681: dbms_sql.column_value(p_cur_get_TASK_PART, 25, X_TASK_PART_Rec.ATTRIBUTE15);
682: dbms_sql.column_value(p_cur_get_TASK_PART, 26, X_TASK_PART_Rec.PRIMARY_UOM_CODE);
683: dbms_sql.column_value(p_cur_get_TASK_PART, 27, X_TASK_PART_Rec.REVISION);
684: dbms_sql.column_value(p_cur_get_TASK_PART, 28, X_TASK_PART_Rec.START_DATE);
685: dbms_sql.column_value(p_cur_get_TASK_PART, 29, X_TASK_PART_Rec.END_DATE);

Line 682: dbms_sql.column_value(p_cur_get_TASK_PART, 26, X_TASK_PART_Rec.PRIMARY_UOM_CODE);

678: dbms_sql.column_value(p_cur_get_TASK_PART, 22, X_TASK_PART_Rec.ATTRIBUTE12);
679: dbms_sql.column_value(p_cur_get_TASK_PART, 23, X_TASK_PART_Rec.ATTRIBUTE13);
680: dbms_sql.column_value(p_cur_get_TASK_PART, 24, X_TASK_PART_Rec.ATTRIBUTE14);
681: dbms_sql.column_value(p_cur_get_TASK_PART, 25, X_TASK_PART_Rec.ATTRIBUTE15);
682: dbms_sql.column_value(p_cur_get_TASK_PART, 26, X_TASK_PART_Rec.PRIMARY_UOM_CODE);
683: dbms_sql.column_value(p_cur_get_TASK_PART, 27, X_TASK_PART_Rec.REVISION);
684: dbms_sql.column_value(p_cur_get_TASK_PART, 28, X_TASK_PART_Rec.START_DATE);
685: dbms_sql.column_value(p_cur_get_TASK_PART, 29, X_TASK_PART_Rec.END_DATE);
686: dbms_sql.column_value(p_cur_get_TASK_PART, 29, X_TASK_PART_Rec.ROLLUP_QUANTITY_USED);

Line 683: dbms_sql.column_value(p_cur_get_TASK_PART, 27, X_TASK_PART_Rec.REVISION);

679: dbms_sql.column_value(p_cur_get_TASK_PART, 23, X_TASK_PART_Rec.ATTRIBUTE13);
680: dbms_sql.column_value(p_cur_get_TASK_PART, 24, X_TASK_PART_Rec.ATTRIBUTE14);
681: dbms_sql.column_value(p_cur_get_TASK_PART, 25, X_TASK_PART_Rec.ATTRIBUTE15);
682: dbms_sql.column_value(p_cur_get_TASK_PART, 26, X_TASK_PART_Rec.PRIMARY_UOM_CODE);
683: dbms_sql.column_value(p_cur_get_TASK_PART, 27, X_TASK_PART_Rec.REVISION);
684: dbms_sql.column_value(p_cur_get_TASK_PART, 28, X_TASK_PART_Rec.START_DATE);
685: dbms_sql.column_value(p_cur_get_TASK_PART, 29, X_TASK_PART_Rec.END_DATE);
686: dbms_sql.column_value(p_cur_get_TASK_PART, 29, X_TASK_PART_Rec.ROLLUP_QUANTITY_USED);
687: dbms_sql.column_value(p_cur_get_TASK_PART, 29, X_TASK_PART_Rec.ROLLUP_TIMES_USED);

Line 684: dbms_sql.column_value(p_cur_get_TASK_PART, 28, X_TASK_PART_Rec.START_DATE);

680: dbms_sql.column_value(p_cur_get_TASK_PART, 24, X_TASK_PART_Rec.ATTRIBUTE14);
681: dbms_sql.column_value(p_cur_get_TASK_PART, 25, X_TASK_PART_Rec.ATTRIBUTE15);
682: dbms_sql.column_value(p_cur_get_TASK_PART, 26, X_TASK_PART_Rec.PRIMARY_UOM_CODE);
683: dbms_sql.column_value(p_cur_get_TASK_PART, 27, X_TASK_PART_Rec.REVISION);
684: dbms_sql.column_value(p_cur_get_TASK_PART, 28, X_TASK_PART_Rec.START_DATE);
685: dbms_sql.column_value(p_cur_get_TASK_PART, 29, X_TASK_PART_Rec.END_DATE);
686: dbms_sql.column_value(p_cur_get_TASK_PART, 29, X_TASK_PART_Rec.ROLLUP_QUANTITY_USED);
687: dbms_sql.column_value(p_cur_get_TASK_PART, 29, X_TASK_PART_Rec.ROLLUP_TIMES_USED);
688: dbms_sql.column_value(p_cur_get_TASK_PART, 30, X_TASK_PART_Rec.SUBSTITUTE_ITEM );

Line 685: dbms_sql.column_value(p_cur_get_TASK_PART, 29, X_TASK_PART_Rec.END_DATE);

681: dbms_sql.column_value(p_cur_get_TASK_PART, 25, X_TASK_PART_Rec.ATTRIBUTE15);
682: dbms_sql.column_value(p_cur_get_TASK_PART, 26, X_TASK_PART_Rec.PRIMARY_UOM_CODE);
683: dbms_sql.column_value(p_cur_get_TASK_PART, 27, X_TASK_PART_Rec.REVISION);
684: dbms_sql.column_value(p_cur_get_TASK_PART, 28, X_TASK_PART_Rec.START_DATE);
685: dbms_sql.column_value(p_cur_get_TASK_PART, 29, X_TASK_PART_Rec.END_DATE);
686: dbms_sql.column_value(p_cur_get_TASK_PART, 29, X_TASK_PART_Rec.ROLLUP_QUANTITY_USED);
687: dbms_sql.column_value(p_cur_get_TASK_PART, 29, X_TASK_PART_Rec.ROLLUP_TIMES_USED);
688: dbms_sql.column_value(p_cur_get_TASK_PART, 30, X_TASK_PART_Rec.SUBSTITUTE_ITEM );
689:

Line 686: dbms_sql.column_value(p_cur_get_TASK_PART, 29, X_TASK_PART_Rec.ROLLUP_QUANTITY_USED);

682: dbms_sql.column_value(p_cur_get_TASK_PART, 26, X_TASK_PART_Rec.PRIMARY_UOM_CODE);
683: dbms_sql.column_value(p_cur_get_TASK_PART, 27, X_TASK_PART_Rec.REVISION);
684: dbms_sql.column_value(p_cur_get_TASK_PART, 28, X_TASK_PART_Rec.START_DATE);
685: dbms_sql.column_value(p_cur_get_TASK_PART, 29, X_TASK_PART_Rec.END_DATE);
686: dbms_sql.column_value(p_cur_get_TASK_PART, 29, X_TASK_PART_Rec.ROLLUP_QUANTITY_USED);
687: dbms_sql.column_value(p_cur_get_TASK_PART, 29, X_TASK_PART_Rec.ROLLUP_TIMES_USED);
688: dbms_sql.column_value(p_cur_get_TASK_PART, 30, X_TASK_PART_Rec.SUBSTITUTE_ITEM );
689:
690: -- Debug Message

Line 687: dbms_sql.column_value(p_cur_get_TASK_PART, 29, X_TASK_PART_Rec.ROLLUP_TIMES_USED);

683: dbms_sql.column_value(p_cur_get_TASK_PART, 27, X_TASK_PART_Rec.REVISION);
684: dbms_sql.column_value(p_cur_get_TASK_PART, 28, X_TASK_PART_Rec.START_DATE);
685: dbms_sql.column_value(p_cur_get_TASK_PART, 29, X_TASK_PART_Rec.END_DATE);
686: dbms_sql.column_value(p_cur_get_TASK_PART, 29, X_TASK_PART_Rec.ROLLUP_QUANTITY_USED);
687: dbms_sql.column_value(p_cur_get_TASK_PART, 29, X_TASK_PART_Rec.ROLLUP_TIMES_USED);
688: dbms_sql.column_value(p_cur_get_TASK_PART, 30, X_TASK_PART_Rec.SUBSTITUTE_ITEM );
689:
690: -- Debug Message
691: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Private API: Get Column Values Ends');

Line 688: dbms_sql.column_value(p_cur_get_TASK_PART, 30, X_TASK_PART_Rec.SUBSTITUTE_ITEM );

684: dbms_sql.column_value(p_cur_get_TASK_PART, 28, X_TASK_PART_Rec.START_DATE);
685: dbms_sql.column_value(p_cur_get_TASK_PART, 29, X_TASK_PART_Rec.END_DATE);
686: dbms_sql.column_value(p_cur_get_TASK_PART, 29, X_TASK_PART_Rec.ROLLUP_QUANTITY_USED);
687: dbms_sql.column_value(p_cur_get_TASK_PART, 29, X_TASK_PART_Rec.ROLLUP_TIMES_USED);
688: dbms_sql.column_value(p_cur_get_TASK_PART, 30, X_TASK_PART_Rec.SUBSTITUTE_ITEM );
689:
690: -- Debug Message
691: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Private API: Get Column Values Ends');
692: END Get_Column_Values;

Line 745: DBMS_SQL.BIND_VARIABLE(p_cur_get_TASK_PART, ':p_TASK_PART_ID', P_TASK_PART_Rec.TASK_PART_ID);

741: -- The following example applies to all columns,
742: -- developers can copy and paste them.
743: IF( (P_TASK_PART_Rec.TASK_PART_ID IS NOT NULL) AND (P_TASK_PART_Rec.TASK_PART_ID <> FND_API.G_MISS_NUM) )
744: THEN
745: DBMS_SQL.BIND_VARIABLE(p_cur_get_TASK_PART, ':p_TASK_PART_ID', P_TASK_PART_Rec.TASK_PART_ID);
746: END IF;
747: -- Debug Message
748: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Private API: Bind Variables Ends');
749: END Bind;