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_ORDERLINES_PVT dependencies on DBMS_SQL

Line 740: dbms_sql.define_column(p_cur_get_mol, 1, P_mol_Rec.LINE_ID);

736: -- Debug Message
737: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Define Columns Begins');
738:
739: -- define all columns for CSP_MOVEORDER_LINES_V view
740: dbms_sql.define_column(p_cur_get_mol, 1, P_mol_Rec.LINE_ID);
741: dbms_sql.define_column(p_cur_get_mol, 2, P_mol_Rec.LAST_UPDATED_LOGIN);
742: dbms_sql.define_column(p_cur_get_mol, 3, P_mol_Rec.HEADER_ID);
743: dbms_sql.define_column(p_cur_get_mol, 4, P_mol_Rec.CUSTOMER_PO, 30);
744: dbms_sql.define_column(p_cur_get_mol, 5, P_mol_Rec.INCIDENT_ID);

Line 741: dbms_sql.define_column(p_cur_get_mol, 2, P_mol_Rec.LAST_UPDATED_LOGIN);

737: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Define Columns Begins');
738:
739: -- define all columns for CSP_MOVEORDER_LINES_V view
740: dbms_sql.define_column(p_cur_get_mol, 1, P_mol_Rec.LINE_ID);
741: dbms_sql.define_column(p_cur_get_mol, 2, P_mol_Rec.LAST_UPDATED_LOGIN);
742: dbms_sql.define_column(p_cur_get_mol, 3, P_mol_Rec.HEADER_ID);
743: dbms_sql.define_column(p_cur_get_mol, 4, P_mol_Rec.CUSTOMER_PO, 30);
744: dbms_sql.define_column(p_cur_get_mol, 5, P_mol_Rec.INCIDENT_ID);
745: dbms_sql.define_column(p_cur_get_mol, 6, P_mol_Rec.TASK_ID);

Line 742: dbms_sql.define_column(p_cur_get_mol, 3, P_mol_Rec.HEADER_ID);

738:
739: -- define all columns for CSP_MOVEORDER_LINES_V view
740: dbms_sql.define_column(p_cur_get_mol, 1, P_mol_Rec.LINE_ID);
741: dbms_sql.define_column(p_cur_get_mol, 2, P_mol_Rec.LAST_UPDATED_LOGIN);
742: dbms_sql.define_column(p_cur_get_mol, 3, P_mol_Rec.HEADER_ID);
743: dbms_sql.define_column(p_cur_get_mol, 4, P_mol_Rec.CUSTOMER_PO, 30);
744: dbms_sql.define_column(p_cur_get_mol, 5, P_mol_Rec.INCIDENT_ID);
745: dbms_sql.define_column(p_cur_get_mol, 6, P_mol_Rec.TASK_ID);
746: dbms_sql.define_column(p_cur_get_mol, 7, P_mol_Rec.TASK_ASSIGNMENT_ID);

Line 743: dbms_sql.define_column(p_cur_get_mol, 4, P_mol_Rec.CUSTOMER_PO, 30);

739: -- define all columns for CSP_MOVEORDER_LINES_V view
740: dbms_sql.define_column(p_cur_get_mol, 1, P_mol_Rec.LINE_ID);
741: dbms_sql.define_column(p_cur_get_mol, 2, P_mol_Rec.LAST_UPDATED_LOGIN);
742: dbms_sql.define_column(p_cur_get_mol, 3, P_mol_Rec.HEADER_ID);
743: dbms_sql.define_column(p_cur_get_mol, 4, P_mol_Rec.CUSTOMER_PO, 30);
744: dbms_sql.define_column(p_cur_get_mol, 5, P_mol_Rec.INCIDENT_ID);
745: dbms_sql.define_column(p_cur_get_mol, 6, P_mol_Rec.TASK_ID);
746: dbms_sql.define_column(p_cur_get_mol, 7, P_mol_Rec.TASK_ASSIGNMENT_ID);
747: dbms_sql.define_column(p_cur_get_mol, 8, P_mol_Rec.COMMENTS, 240);

Line 744: dbms_sql.define_column(p_cur_get_mol, 5, P_mol_Rec.INCIDENT_ID);

740: dbms_sql.define_column(p_cur_get_mol, 1, P_mol_Rec.LINE_ID);
741: dbms_sql.define_column(p_cur_get_mol, 2, P_mol_Rec.LAST_UPDATED_LOGIN);
742: dbms_sql.define_column(p_cur_get_mol, 3, P_mol_Rec.HEADER_ID);
743: dbms_sql.define_column(p_cur_get_mol, 4, P_mol_Rec.CUSTOMER_PO, 30);
744: dbms_sql.define_column(p_cur_get_mol, 5, P_mol_Rec.INCIDENT_ID);
745: dbms_sql.define_column(p_cur_get_mol, 6, P_mol_Rec.TASK_ID);
746: dbms_sql.define_column(p_cur_get_mol, 7, P_mol_Rec.TASK_ASSIGNMENT_ID);
747: dbms_sql.define_column(p_cur_get_mol, 8, P_mol_Rec.COMMENTS, 240);
748: dbms_sql.define_column(p_cur_get_mol, 9, P_mol_Rec.ATTRIBUTE_CATEGORY, 30);

Line 745: dbms_sql.define_column(p_cur_get_mol, 6, P_mol_Rec.TASK_ID);

741: dbms_sql.define_column(p_cur_get_mol, 2, P_mol_Rec.LAST_UPDATED_LOGIN);
742: dbms_sql.define_column(p_cur_get_mol, 3, P_mol_Rec.HEADER_ID);
743: dbms_sql.define_column(p_cur_get_mol, 4, P_mol_Rec.CUSTOMER_PO, 30);
744: dbms_sql.define_column(p_cur_get_mol, 5, P_mol_Rec.INCIDENT_ID);
745: dbms_sql.define_column(p_cur_get_mol, 6, P_mol_Rec.TASK_ID);
746: dbms_sql.define_column(p_cur_get_mol, 7, P_mol_Rec.TASK_ASSIGNMENT_ID);
747: dbms_sql.define_column(p_cur_get_mol, 8, P_mol_Rec.COMMENTS, 240);
748: dbms_sql.define_column(p_cur_get_mol, 9, P_mol_Rec.ATTRIBUTE_CATEGORY, 30);
749: dbms_sql.define_column(p_cur_get_mol, 10, P_mol_Rec.ATTRIBUTE1, 150);

Line 746: dbms_sql.define_column(p_cur_get_mol, 7, P_mol_Rec.TASK_ASSIGNMENT_ID);

742: dbms_sql.define_column(p_cur_get_mol, 3, P_mol_Rec.HEADER_ID);
743: dbms_sql.define_column(p_cur_get_mol, 4, P_mol_Rec.CUSTOMER_PO, 30);
744: dbms_sql.define_column(p_cur_get_mol, 5, P_mol_Rec.INCIDENT_ID);
745: dbms_sql.define_column(p_cur_get_mol, 6, P_mol_Rec.TASK_ID);
746: dbms_sql.define_column(p_cur_get_mol, 7, P_mol_Rec.TASK_ASSIGNMENT_ID);
747: dbms_sql.define_column(p_cur_get_mol, 8, P_mol_Rec.COMMENTS, 240);
748: dbms_sql.define_column(p_cur_get_mol, 9, P_mol_Rec.ATTRIBUTE_CATEGORY, 30);
749: dbms_sql.define_column(p_cur_get_mol, 10, P_mol_Rec.ATTRIBUTE1, 150);
750: dbms_sql.define_column(p_cur_get_mol, 11, P_mol_Rec.ATTRIBUTE2, 150);

Line 747: dbms_sql.define_column(p_cur_get_mol, 8, P_mol_Rec.COMMENTS, 240);

743: dbms_sql.define_column(p_cur_get_mol, 4, P_mol_Rec.CUSTOMER_PO, 30);
744: dbms_sql.define_column(p_cur_get_mol, 5, P_mol_Rec.INCIDENT_ID);
745: dbms_sql.define_column(p_cur_get_mol, 6, P_mol_Rec.TASK_ID);
746: dbms_sql.define_column(p_cur_get_mol, 7, P_mol_Rec.TASK_ASSIGNMENT_ID);
747: dbms_sql.define_column(p_cur_get_mol, 8, P_mol_Rec.COMMENTS, 240);
748: dbms_sql.define_column(p_cur_get_mol, 9, P_mol_Rec.ATTRIBUTE_CATEGORY, 30);
749: dbms_sql.define_column(p_cur_get_mol, 10, P_mol_Rec.ATTRIBUTE1, 150);
750: dbms_sql.define_column(p_cur_get_mol, 11, P_mol_Rec.ATTRIBUTE2, 150);
751: dbms_sql.define_column(p_cur_get_mol, 12, P_mol_Rec.ATTRIBUTE3, 150);

Line 748: dbms_sql.define_column(p_cur_get_mol, 9, P_mol_Rec.ATTRIBUTE_CATEGORY, 30);

744: dbms_sql.define_column(p_cur_get_mol, 5, P_mol_Rec.INCIDENT_ID);
745: dbms_sql.define_column(p_cur_get_mol, 6, P_mol_Rec.TASK_ID);
746: dbms_sql.define_column(p_cur_get_mol, 7, P_mol_Rec.TASK_ASSIGNMENT_ID);
747: dbms_sql.define_column(p_cur_get_mol, 8, P_mol_Rec.COMMENTS, 240);
748: dbms_sql.define_column(p_cur_get_mol, 9, P_mol_Rec.ATTRIBUTE_CATEGORY, 30);
749: dbms_sql.define_column(p_cur_get_mol, 10, P_mol_Rec.ATTRIBUTE1, 150);
750: dbms_sql.define_column(p_cur_get_mol, 11, P_mol_Rec.ATTRIBUTE2, 150);
751: dbms_sql.define_column(p_cur_get_mol, 12, P_mol_Rec.ATTRIBUTE3, 150);
752: dbms_sql.define_column(p_cur_get_mol, 13, P_mol_Rec.ATTRIBUTE4, 150);

Line 749: dbms_sql.define_column(p_cur_get_mol, 10, P_mol_Rec.ATTRIBUTE1, 150);

745: dbms_sql.define_column(p_cur_get_mol, 6, P_mol_Rec.TASK_ID);
746: dbms_sql.define_column(p_cur_get_mol, 7, P_mol_Rec.TASK_ASSIGNMENT_ID);
747: dbms_sql.define_column(p_cur_get_mol, 8, P_mol_Rec.COMMENTS, 240);
748: dbms_sql.define_column(p_cur_get_mol, 9, P_mol_Rec.ATTRIBUTE_CATEGORY, 30);
749: dbms_sql.define_column(p_cur_get_mol, 10, P_mol_Rec.ATTRIBUTE1, 150);
750: dbms_sql.define_column(p_cur_get_mol, 11, P_mol_Rec.ATTRIBUTE2, 150);
751: dbms_sql.define_column(p_cur_get_mol, 12, P_mol_Rec.ATTRIBUTE3, 150);
752: dbms_sql.define_column(p_cur_get_mol, 13, P_mol_Rec.ATTRIBUTE4, 150);
753: dbms_sql.define_column(p_cur_get_mol, 14, P_mol_Rec.ATTRIBUTE5, 150);

Line 750: dbms_sql.define_column(p_cur_get_mol, 11, P_mol_Rec.ATTRIBUTE2, 150);

746: dbms_sql.define_column(p_cur_get_mol, 7, P_mol_Rec.TASK_ASSIGNMENT_ID);
747: dbms_sql.define_column(p_cur_get_mol, 8, P_mol_Rec.COMMENTS, 240);
748: dbms_sql.define_column(p_cur_get_mol, 9, P_mol_Rec.ATTRIBUTE_CATEGORY, 30);
749: dbms_sql.define_column(p_cur_get_mol, 10, P_mol_Rec.ATTRIBUTE1, 150);
750: dbms_sql.define_column(p_cur_get_mol, 11, P_mol_Rec.ATTRIBUTE2, 150);
751: dbms_sql.define_column(p_cur_get_mol, 12, P_mol_Rec.ATTRIBUTE3, 150);
752: dbms_sql.define_column(p_cur_get_mol, 13, P_mol_Rec.ATTRIBUTE4, 150);
753: dbms_sql.define_column(p_cur_get_mol, 14, P_mol_Rec.ATTRIBUTE5, 150);
754: dbms_sql.define_column(p_cur_get_mol, 15, P_mol_Rec.ATTRIBUTE6, 150);

Line 751: dbms_sql.define_column(p_cur_get_mol, 12, P_mol_Rec.ATTRIBUTE3, 150);

747: dbms_sql.define_column(p_cur_get_mol, 8, P_mol_Rec.COMMENTS, 240);
748: dbms_sql.define_column(p_cur_get_mol, 9, P_mol_Rec.ATTRIBUTE_CATEGORY, 30);
749: dbms_sql.define_column(p_cur_get_mol, 10, P_mol_Rec.ATTRIBUTE1, 150);
750: dbms_sql.define_column(p_cur_get_mol, 11, P_mol_Rec.ATTRIBUTE2, 150);
751: dbms_sql.define_column(p_cur_get_mol, 12, P_mol_Rec.ATTRIBUTE3, 150);
752: dbms_sql.define_column(p_cur_get_mol, 13, P_mol_Rec.ATTRIBUTE4, 150);
753: dbms_sql.define_column(p_cur_get_mol, 14, P_mol_Rec.ATTRIBUTE5, 150);
754: dbms_sql.define_column(p_cur_get_mol, 15, P_mol_Rec.ATTRIBUTE6, 150);
755: dbms_sql.define_column(p_cur_get_mol, 16, P_mol_Rec.ATTRIBUTE7, 150);

Line 752: dbms_sql.define_column(p_cur_get_mol, 13, P_mol_Rec.ATTRIBUTE4, 150);

748: dbms_sql.define_column(p_cur_get_mol, 9, P_mol_Rec.ATTRIBUTE_CATEGORY, 30);
749: dbms_sql.define_column(p_cur_get_mol, 10, P_mol_Rec.ATTRIBUTE1, 150);
750: dbms_sql.define_column(p_cur_get_mol, 11, P_mol_Rec.ATTRIBUTE2, 150);
751: dbms_sql.define_column(p_cur_get_mol, 12, P_mol_Rec.ATTRIBUTE3, 150);
752: dbms_sql.define_column(p_cur_get_mol, 13, P_mol_Rec.ATTRIBUTE4, 150);
753: dbms_sql.define_column(p_cur_get_mol, 14, P_mol_Rec.ATTRIBUTE5, 150);
754: dbms_sql.define_column(p_cur_get_mol, 15, P_mol_Rec.ATTRIBUTE6, 150);
755: dbms_sql.define_column(p_cur_get_mol, 16, P_mol_Rec.ATTRIBUTE7, 150);
756: dbms_sql.define_column(p_cur_get_mol, 17, P_mol_Rec.ATTRIBUTE8, 150);

Line 753: dbms_sql.define_column(p_cur_get_mol, 14, P_mol_Rec.ATTRIBUTE5, 150);

749: dbms_sql.define_column(p_cur_get_mol, 10, P_mol_Rec.ATTRIBUTE1, 150);
750: dbms_sql.define_column(p_cur_get_mol, 11, P_mol_Rec.ATTRIBUTE2, 150);
751: dbms_sql.define_column(p_cur_get_mol, 12, P_mol_Rec.ATTRIBUTE3, 150);
752: dbms_sql.define_column(p_cur_get_mol, 13, P_mol_Rec.ATTRIBUTE4, 150);
753: dbms_sql.define_column(p_cur_get_mol, 14, P_mol_Rec.ATTRIBUTE5, 150);
754: dbms_sql.define_column(p_cur_get_mol, 15, P_mol_Rec.ATTRIBUTE6, 150);
755: dbms_sql.define_column(p_cur_get_mol, 16, P_mol_Rec.ATTRIBUTE7, 150);
756: dbms_sql.define_column(p_cur_get_mol, 17, P_mol_Rec.ATTRIBUTE8, 150);
757: dbms_sql.define_column(p_cur_get_mol, 18, P_mol_Rec.ATTRIBUTE9, 150);

Line 754: dbms_sql.define_column(p_cur_get_mol, 15, P_mol_Rec.ATTRIBUTE6, 150);

750: dbms_sql.define_column(p_cur_get_mol, 11, P_mol_Rec.ATTRIBUTE2, 150);
751: dbms_sql.define_column(p_cur_get_mol, 12, P_mol_Rec.ATTRIBUTE3, 150);
752: dbms_sql.define_column(p_cur_get_mol, 13, P_mol_Rec.ATTRIBUTE4, 150);
753: dbms_sql.define_column(p_cur_get_mol, 14, P_mol_Rec.ATTRIBUTE5, 150);
754: dbms_sql.define_column(p_cur_get_mol, 15, P_mol_Rec.ATTRIBUTE6, 150);
755: dbms_sql.define_column(p_cur_get_mol, 16, P_mol_Rec.ATTRIBUTE7, 150);
756: dbms_sql.define_column(p_cur_get_mol, 17, P_mol_Rec.ATTRIBUTE8, 150);
757: dbms_sql.define_column(p_cur_get_mol, 18, P_mol_Rec.ATTRIBUTE9, 150);
758: dbms_sql.define_column(p_cur_get_mol, 19, P_mol_Rec.ATTRIBUTE10, 150);

Line 755: dbms_sql.define_column(p_cur_get_mol, 16, P_mol_Rec.ATTRIBUTE7, 150);

751: dbms_sql.define_column(p_cur_get_mol, 12, P_mol_Rec.ATTRIBUTE3, 150);
752: dbms_sql.define_column(p_cur_get_mol, 13, P_mol_Rec.ATTRIBUTE4, 150);
753: dbms_sql.define_column(p_cur_get_mol, 14, P_mol_Rec.ATTRIBUTE5, 150);
754: dbms_sql.define_column(p_cur_get_mol, 15, P_mol_Rec.ATTRIBUTE6, 150);
755: dbms_sql.define_column(p_cur_get_mol, 16, P_mol_Rec.ATTRIBUTE7, 150);
756: dbms_sql.define_column(p_cur_get_mol, 17, P_mol_Rec.ATTRIBUTE8, 150);
757: dbms_sql.define_column(p_cur_get_mol, 18, P_mol_Rec.ATTRIBUTE9, 150);
758: dbms_sql.define_column(p_cur_get_mol, 19, P_mol_Rec.ATTRIBUTE10, 150);
759: dbms_sql.define_column(p_cur_get_mol, 20, P_mol_Rec.ATTRIBUTE11, 150);

Line 756: dbms_sql.define_column(p_cur_get_mol, 17, P_mol_Rec.ATTRIBUTE8, 150);

752: dbms_sql.define_column(p_cur_get_mol, 13, P_mol_Rec.ATTRIBUTE4, 150);
753: dbms_sql.define_column(p_cur_get_mol, 14, P_mol_Rec.ATTRIBUTE5, 150);
754: dbms_sql.define_column(p_cur_get_mol, 15, P_mol_Rec.ATTRIBUTE6, 150);
755: dbms_sql.define_column(p_cur_get_mol, 16, P_mol_Rec.ATTRIBUTE7, 150);
756: dbms_sql.define_column(p_cur_get_mol, 17, P_mol_Rec.ATTRIBUTE8, 150);
757: dbms_sql.define_column(p_cur_get_mol, 18, P_mol_Rec.ATTRIBUTE9, 150);
758: dbms_sql.define_column(p_cur_get_mol, 19, P_mol_Rec.ATTRIBUTE10, 150);
759: dbms_sql.define_column(p_cur_get_mol, 20, P_mol_Rec.ATTRIBUTE11, 150);
760: dbms_sql.define_column(p_cur_get_mol, 21, P_mol_Rec.ATTRIBUTE12, 150);

Line 757: dbms_sql.define_column(p_cur_get_mol, 18, P_mol_Rec.ATTRIBUTE9, 150);

753: dbms_sql.define_column(p_cur_get_mol, 14, P_mol_Rec.ATTRIBUTE5, 150);
754: dbms_sql.define_column(p_cur_get_mol, 15, P_mol_Rec.ATTRIBUTE6, 150);
755: dbms_sql.define_column(p_cur_get_mol, 16, P_mol_Rec.ATTRIBUTE7, 150);
756: dbms_sql.define_column(p_cur_get_mol, 17, P_mol_Rec.ATTRIBUTE8, 150);
757: dbms_sql.define_column(p_cur_get_mol, 18, P_mol_Rec.ATTRIBUTE9, 150);
758: dbms_sql.define_column(p_cur_get_mol, 19, P_mol_Rec.ATTRIBUTE10, 150);
759: dbms_sql.define_column(p_cur_get_mol, 20, P_mol_Rec.ATTRIBUTE11, 150);
760: dbms_sql.define_column(p_cur_get_mol, 21, P_mol_Rec.ATTRIBUTE12, 150);
761: dbms_sql.define_column(p_cur_get_mol, 22, P_mol_Rec.ATTRIBUTE13, 150);

Line 758: dbms_sql.define_column(p_cur_get_mol, 19, P_mol_Rec.ATTRIBUTE10, 150);

754: dbms_sql.define_column(p_cur_get_mol, 15, P_mol_Rec.ATTRIBUTE6, 150);
755: dbms_sql.define_column(p_cur_get_mol, 16, P_mol_Rec.ATTRIBUTE7, 150);
756: dbms_sql.define_column(p_cur_get_mol, 17, P_mol_Rec.ATTRIBUTE8, 150);
757: dbms_sql.define_column(p_cur_get_mol, 18, P_mol_Rec.ATTRIBUTE9, 150);
758: dbms_sql.define_column(p_cur_get_mol, 19, P_mol_Rec.ATTRIBUTE10, 150);
759: dbms_sql.define_column(p_cur_get_mol, 20, P_mol_Rec.ATTRIBUTE11, 150);
760: dbms_sql.define_column(p_cur_get_mol, 21, P_mol_Rec.ATTRIBUTE12, 150);
761: dbms_sql.define_column(p_cur_get_mol, 22, P_mol_Rec.ATTRIBUTE13, 150);
762: dbms_sql.define_column(p_cur_get_mol, 23, P_mol_Rec.ATTRIBUTE14, 150);

Line 759: dbms_sql.define_column(p_cur_get_mol, 20, P_mol_Rec.ATTRIBUTE11, 150);

755: dbms_sql.define_column(p_cur_get_mol, 16, P_mol_Rec.ATTRIBUTE7, 150);
756: dbms_sql.define_column(p_cur_get_mol, 17, P_mol_Rec.ATTRIBUTE8, 150);
757: dbms_sql.define_column(p_cur_get_mol, 18, P_mol_Rec.ATTRIBUTE9, 150);
758: dbms_sql.define_column(p_cur_get_mol, 19, P_mol_Rec.ATTRIBUTE10, 150);
759: dbms_sql.define_column(p_cur_get_mol, 20, P_mol_Rec.ATTRIBUTE11, 150);
760: dbms_sql.define_column(p_cur_get_mol, 21, P_mol_Rec.ATTRIBUTE12, 150);
761: dbms_sql.define_column(p_cur_get_mol, 22, P_mol_Rec.ATTRIBUTE13, 150);
762: dbms_sql.define_column(p_cur_get_mol, 23, P_mol_Rec.ATTRIBUTE14, 150);
763: dbms_sql.define_column(p_cur_get_mol, 24, P_mol_Rec.ATTRIBUTE15, 150);

Line 760: dbms_sql.define_column(p_cur_get_mol, 21, P_mol_Rec.ATTRIBUTE12, 150);

756: dbms_sql.define_column(p_cur_get_mol, 17, P_mol_Rec.ATTRIBUTE8, 150);
757: dbms_sql.define_column(p_cur_get_mol, 18, P_mol_Rec.ATTRIBUTE9, 150);
758: dbms_sql.define_column(p_cur_get_mol, 19, P_mol_Rec.ATTRIBUTE10, 150);
759: dbms_sql.define_column(p_cur_get_mol, 20, P_mol_Rec.ATTRIBUTE11, 150);
760: dbms_sql.define_column(p_cur_get_mol, 21, P_mol_Rec.ATTRIBUTE12, 150);
761: dbms_sql.define_column(p_cur_get_mol, 22, P_mol_Rec.ATTRIBUTE13, 150);
762: dbms_sql.define_column(p_cur_get_mol, 23, P_mol_Rec.ATTRIBUTE14, 150);
763: dbms_sql.define_column(p_cur_get_mol, 24, P_mol_Rec.ATTRIBUTE15, 150);
764:

Line 761: dbms_sql.define_column(p_cur_get_mol, 22, P_mol_Rec.ATTRIBUTE13, 150);

757: dbms_sql.define_column(p_cur_get_mol, 18, P_mol_Rec.ATTRIBUTE9, 150);
758: dbms_sql.define_column(p_cur_get_mol, 19, P_mol_Rec.ATTRIBUTE10, 150);
759: dbms_sql.define_column(p_cur_get_mol, 20, P_mol_Rec.ATTRIBUTE11, 150);
760: dbms_sql.define_column(p_cur_get_mol, 21, P_mol_Rec.ATTRIBUTE12, 150);
761: dbms_sql.define_column(p_cur_get_mol, 22, P_mol_Rec.ATTRIBUTE13, 150);
762: dbms_sql.define_column(p_cur_get_mol, 23, P_mol_Rec.ATTRIBUTE14, 150);
763: dbms_sql.define_column(p_cur_get_mol, 24, P_mol_Rec.ATTRIBUTE15, 150);
764:
765: -- Debug Message

Line 762: dbms_sql.define_column(p_cur_get_mol, 23, P_mol_Rec.ATTRIBUTE14, 150);

758: dbms_sql.define_column(p_cur_get_mol, 19, P_mol_Rec.ATTRIBUTE10, 150);
759: dbms_sql.define_column(p_cur_get_mol, 20, P_mol_Rec.ATTRIBUTE11, 150);
760: dbms_sql.define_column(p_cur_get_mol, 21, P_mol_Rec.ATTRIBUTE12, 150);
761: dbms_sql.define_column(p_cur_get_mol, 22, P_mol_Rec.ATTRIBUTE13, 150);
762: dbms_sql.define_column(p_cur_get_mol, 23, P_mol_Rec.ATTRIBUTE14, 150);
763: dbms_sql.define_column(p_cur_get_mol, 24, P_mol_Rec.ATTRIBUTE15, 150);
764:
765: -- Debug Message
766: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Define Columns Ends');

Line 763: dbms_sql.define_column(p_cur_get_mol, 24, P_mol_Rec.ATTRIBUTE15, 150);

759: dbms_sql.define_column(p_cur_get_mol, 20, P_mol_Rec.ATTRIBUTE11, 150);
760: dbms_sql.define_column(p_cur_get_mol, 21, P_mol_Rec.ATTRIBUTE12, 150);
761: dbms_sql.define_column(p_cur_get_mol, 22, P_mol_Rec.ATTRIBUTE13, 150);
762: dbms_sql.define_column(p_cur_get_mol, 23, P_mol_Rec.ATTRIBUTE14, 150);
763: dbms_sql.define_column(p_cur_get_mol, 24, P_mol_Rec.ATTRIBUTE15, 150);
764:
765: -- Debug Message
766: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Define Columns Ends');
767: END Define_Columns;

Line 780: dbms_sql.column_value(p_cur_get_mol, 1, X_mol_Rec.LINE_ID);

776: -- Debug Message
777: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Begins');
778:
779: -- get all column values for CSP_MOVEORDER_LINES_V table
780: dbms_sql.column_value(p_cur_get_mol, 1, X_mol_Rec.LINE_ID);
781: dbms_sql.column_value(p_cur_get_mol, 2, X_mol_Rec.LAST_UPDATED_LOGIN);
782: dbms_sql.column_value(p_cur_get_mol, 3, X_mol_Rec.HEADER_ID);
783: dbms_sql.column_value(p_cur_get_mol, 4, X_mol_Rec.CUSTOMER_PO);
784: dbms_sql.column_value(p_cur_get_mol, 5, X_mol_Rec.INCIDENT_ID);

Line 781: dbms_sql.column_value(p_cur_get_mol, 2, X_mol_Rec.LAST_UPDATED_LOGIN);

777: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Begins');
778:
779: -- get all column values for CSP_MOVEORDER_LINES_V table
780: dbms_sql.column_value(p_cur_get_mol, 1, X_mol_Rec.LINE_ID);
781: dbms_sql.column_value(p_cur_get_mol, 2, X_mol_Rec.LAST_UPDATED_LOGIN);
782: dbms_sql.column_value(p_cur_get_mol, 3, X_mol_Rec.HEADER_ID);
783: dbms_sql.column_value(p_cur_get_mol, 4, X_mol_Rec.CUSTOMER_PO);
784: dbms_sql.column_value(p_cur_get_mol, 5, X_mol_Rec.INCIDENT_ID);
785: dbms_sql.column_value(p_cur_get_mol, 6, X_mol_Rec.TASK_ID);

Line 782: dbms_sql.column_value(p_cur_get_mol, 3, X_mol_Rec.HEADER_ID);

778:
779: -- get all column values for CSP_MOVEORDER_LINES_V table
780: dbms_sql.column_value(p_cur_get_mol, 1, X_mol_Rec.LINE_ID);
781: dbms_sql.column_value(p_cur_get_mol, 2, X_mol_Rec.LAST_UPDATED_LOGIN);
782: dbms_sql.column_value(p_cur_get_mol, 3, X_mol_Rec.HEADER_ID);
783: dbms_sql.column_value(p_cur_get_mol, 4, X_mol_Rec.CUSTOMER_PO);
784: dbms_sql.column_value(p_cur_get_mol, 5, X_mol_Rec.INCIDENT_ID);
785: dbms_sql.column_value(p_cur_get_mol, 6, X_mol_Rec.TASK_ID);
786: dbms_sql.column_value(p_cur_get_mol, 7, X_mol_Rec.TASK_ASSIGNMENT_ID);

Line 783: dbms_sql.column_value(p_cur_get_mol, 4, X_mol_Rec.CUSTOMER_PO);

779: -- get all column values for CSP_MOVEORDER_LINES_V table
780: dbms_sql.column_value(p_cur_get_mol, 1, X_mol_Rec.LINE_ID);
781: dbms_sql.column_value(p_cur_get_mol, 2, X_mol_Rec.LAST_UPDATED_LOGIN);
782: dbms_sql.column_value(p_cur_get_mol, 3, X_mol_Rec.HEADER_ID);
783: dbms_sql.column_value(p_cur_get_mol, 4, X_mol_Rec.CUSTOMER_PO);
784: dbms_sql.column_value(p_cur_get_mol, 5, X_mol_Rec.INCIDENT_ID);
785: dbms_sql.column_value(p_cur_get_mol, 6, X_mol_Rec.TASK_ID);
786: dbms_sql.column_value(p_cur_get_mol, 7, X_mol_Rec.TASK_ASSIGNMENT_ID);
787: dbms_sql.column_value(p_cur_get_mol, 8, X_mol_Rec.COMMENTS);

Line 784: dbms_sql.column_value(p_cur_get_mol, 5, X_mol_Rec.INCIDENT_ID);

780: dbms_sql.column_value(p_cur_get_mol, 1, X_mol_Rec.LINE_ID);
781: dbms_sql.column_value(p_cur_get_mol, 2, X_mol_Rec.LAST_UPDATED_LOGIN);
782: dbms_sql.column_value(p_cur_get_mol, 3, X_mol_Rec.HEADER_ID);
783: dbms_sql.column_value(p_cur_get_mol, 4, X_mol_Rec.CUSTOMER_PO);
784: dbms_sql.column_value(p_cur_get_mol, 5, X_mol_Rec.INCIDENT_ID);
785: dbms_sql.column_value(p_cur_get_mol, 6, X_mol_Rec.TASK_ID);
786: dbms_sql.column_value(p_cur_get_mol, 7, X_mol_Rec.TASK_ASSIGNMENT_ID);
787: dbms_sql.column_value(p_cur_get_mol, 8, X_mol_Rec.COMMENTS);
788: dbms_sql.column_value(p_cur_get_mol, 9, X_mol_Rec.ATTRIBUTE_CATEGORY);

Line 785: dbms_sql.column_value(p_cur_get_mol, 6, X_mol_Rec.TASK_ID);

781: dbms_sql.column_value(p_cur_get_mol, 2, X_mol_Rec.LAST_UPDATED_LOGIN);
782: dbms_sql.column_value(p_cur_get_mol, 3, X_mol_Rec.HEADER_ID);
783: dbms_sql.column_value(p_cur_get_mol, 4, X_mol_Rec.CUSTOMER_PO);
784: dbms_sql.column_value(p_cur_get_mol, 5, X_mol_Rec.INCIDENT_ID);
785: dbms_sql.column_value(p_cur_get_mol, 6, X_mol_Rec.TASK_ID);
786: dbms_sql.column_value(p_cur_get_mol, 7, X_mol_Rec.TASK_ASSIGNMENT_ID);
787: dbms_sql.column_value(p_cur_get_mol, 8, X_mol_Rec.COMMENTS);
788: dbms_sql.column_value(p_cur_get_mol, 9, X_mol_Rec.ATTRIBUTE_CATEGORY);
789: dbms_sql.column_value(p_cur_get_mol, 10, X_mol_Rec.ATTRIBUTE1);

Line 786: dbms_sql.column_value(p_cur_get_mol, 7, X_mol_Rec.TASK_ASSIGNMENT_ID);

782: dbms_sql.column_value(p_cur_get_mol, 3, X_mol_Rec.HEADER_ID);
783: dbms_sql.column_value(p_cur_get_mol, 4, X_mol_Rec.CUSTOMER_PO);
784: dbms_sql.column_value(p_cur_get_mol, 5, X_mol_Rec.INCIDENT_ID);
785: dbms_sql.column_value(p_cur_get_mol, 6, X_mol_Rec.TASK_ID);
786: dbms_sql.column_value(p_cur_get_mol, 7, X_mol_Rec.TASK_ASSIGNMENT_ID);
787: dbms_sql.column_value(p_cur_get_mol, 8, X_mol_Rec.COMMENTS);
788: dbms_sql.column_value(p_cur_get_mol, 9, X_mol_Rec.ATTRIBUTE_CATEGORY);
789: dbms_sql.column_value(p_cur_get_mol, 10, X_mol_Rec.ATTRIBUTE1);
790: dbms_sql.column_value(p_cur_get_mol, 11, X_mol_Rec.ATTRIBUTE2);

Line 787: dbms_sql.column_value(p_cur_get_mol, 8, X_mol_Rec.COMMENTS);

783: dbms_sql.column_value(p_cur_get_mol, 4, X_mol_Rec.CUSTOMER_PO);
784: dbms_sql.column_value(p_cur_get_mol, 5, X_mol_Rec.INCIDENT_ID);
785: dbms_sql.column_value(p_cur_get_mol, 6, X_mol_Rec.TASK_ID);
786: dbms_sql.column_value(p_cur_get_mol, 7, X_mol_Rec.TASK_ASSIGNMENT_ID);
787: dbms_sql.column_value(p_cur_get_mol, 8, X_mol_Rec.COMMENTS);
788: dbms_sql.column_value(p_cur_get_mol, 9, X_mol_Rec.ATTRIBUTE_CATEGORY);
789: dbms_sql.column_value(p_cur_get_mol, 10, X_mol_Rec.ATTRIBUTE1);
790: dbms_sql.column_value(p_cur_get_mol, 11, X_mol_Rec.ATTRIBUTE2);
791: dbms_sql.column_value(p_cur_get_mol, 12, X_mol_Rec.ATTRIBUTE3);

Line 788: dbms_sql.column_value(p_cur_get_mol, 9, X_mol_Rec.ATTRIBUTE_CATEGORY);

784: dbms_sql.column_value(p_cur_get_mol, 5, X_mol_Rec.INCIDENT_ID);
785: dbms_sql.column_value(p_cur_get_mol, 6, X_mol_Rec.TASK_ID);
786: dbms_sql.column_value(p_cur_get_mol, 7, X_mol_Rec.TASK_ASSIGNMENT_ID);
787: dbms_sql.column_value(p_cur_get_mol, 8, X_mol_Rec.COMMENTS);
788: dbms_sql.column_value(p_cur_get_mol, 9, X_mol_Rec.ATTRIBUTE_CATEGORY);
789: dbms_sql.column_value(p_cur_get_mol, 10, X_mol_Rec.ATTRIBUTE1);
790: dbms_sql.column_value(p_cur_get_mol, 11, X_mol_Rec.ATTRIBUTE2);
791: dbms_sql.column_value(p_cur_get_mol, 12, X_mol_Rec.ATTRIBUTE3);
792: dbms_sql.column_value(p_cur_get_mol, 13, X_mol_Rec.ATTRIBUTE4);

Line 789: dbms_sql.column_value(p_cur_get_mol, 10, X_mol_Rec.ATTRIBUTE1);

785: dbms_sql.column_value(p_cur_get_mol, 6, X_mol_Rec.TASK_ID);
786: dbms_sql.column_value(p_cur_get_mol, 7, X_mol_Rec.TASK_ASSIGNMENT_ID);
787: dbms_sql.column_value(p_cur_get_mol, 8, X_mol_Rec.COMMENTS);
788: dbms_sql.column_value(p_cur_get_mol, 9, X_mol_Rec.ATTRIBUTE_CATEGORY);
789: dbms_sql.column_value(p_cur_get_mol, 10, X_mol_Rec.ATTRIBUTE1);
790: dbms_sql.column_value(p_cur_get_mol, 11, X_mol_Rec.ATTRIBUTE2);
791: dbms_sql.column_value(p_cur_get_mol, 12, X_mol_Rec.ATTRIBUTE3);
792: dbms_sql.column_value(p_cur_get_mol, 13, X_mol_Rec.ATTRIBUTE4);
793: dbms_sql.column_value(p_cur_get_mol, 14, X_mol_Rec.ATTRIBUTE5);

Line 790: dbms_sql.column_value(p_cur_get_mol, 11, X_mol_Rec.ATTRIBUTE2);

786: dbms_sql.column_value(p_cur_get_mol, 7, X_mol_Rec.TASK_ASSIGNMENT_ID);
787: dbms_sql.column_value(p_cur_get_mol, 8, X_mol_Rec.COMMENTS);
788: dbms_sql.column_value(p_cur_get_mol, 9, X_mol_Rec.ATTRIBUTE_CATEGORY);
789: dbms_sql.column_value(p_cur_get_mol, 10, X_mol_Rec.ATTRIBUTE1);
790: dbms_sql.column_value(p_cur_get_mol, 11, X_mol_Rec.ATTRIBUTE2);
791: dbms_sql.column_value(p_cur_get_mol, 12, X_mol_Rec.ATTRIBUTE3);
792: dbms_sql.column_value(p_cur_get_mol, 13, X_mol_Rec.ATTRIBUTE4);
793: dbms_sql.column_value(p_cur_get_mol, 14, X_mol_Rec.ATTRIBUTE5);
794: dbms_sql.column_value(p_cur_get_mol, 15, X_mol_Rec.ATTRIBUTE6);

Line 791: dbms_sql.column_value(p_cur_get_mol, 12, X_mol_Rec.ATTRIBUTE3);

787: dbms_sql.column_value(p_cur_get_mol, 8, X_mol_Rec.COMMENTS);
788: dbms_sql.column_value(p_cur_get_mol, 9, X_mol_Rec.ATTRIBUTE_CATEGORY);
789: dbms_sql.column_value(p_cur_get_mol, 10, X_mol_Rec.ATTRIBUTE1);
790: dbms_sql.column_value(p_cur_get_mol, 11, X_mol_Rec.ATTRIBUTE2);
791: dbms_sql.column_value(p_cur_get_mol, 12, X_mol_Rec.ATTRIBUTE3);
792: dbms_sql.column_value(p_cur_get_mol, 13, X_mol_Rec.ATTRIBUTE4);
793: dbms_sql.column_value(p_cur_get_mol, 14, X_mol_Rec.ATTRIBUTE5);
794: dbms_sql.column_value(p_cur_get_mol, 15, X_mol_Rec.ATTRIBUTE6);
795: dbms_sql.column_value(p_cur_get_mol, 16, X_mol_Rec.ATTRIBUTE7);

Line 792: dbms_sql.column_value(p_cur_get_mol, 13, X_mol_Rec.ATTRIBUTE4);

788: dbms_sql.column_value(p_cur_get_mol, 9, X_mol_Rec.ATTRIBUTE_CATEGORY);
789: dbms_sql.column_value(p_cur_get_mol, 10, X_mol_Rec.ATTRIBUTE1);
790: dbms_sql.column_value(p_cur_get_mol, 11, X_mol_Rec.ATTRIBUTE2);
791: dbms_sql.column_value(p_cur_get_mol, 12, X_mol_Rec.ATTRIBUTE3);
792: dbms_sql.column_value(p_cur_get_mol, 13, X_mol_Rec.ATTRIBUTE4);
793: dbms_sql.column_value(p_cur_get_mol, 14, X_mol_Rec.ATTRIBUTE5);
794: dbms_sql.column_value(p_cur_get_mol, 15, X_mol_Rec.ATTRIBUTE6);
795: dbms_sql.column_value(p_cur_get_mol, 16, X_mol_Rec.ATTRIBUTE7);
796: dbms_sql.column_value(p_cur_get_mol, 17, X_mol_Rec.ATTRIBUTE8);

Line 793: dbms_sql.column_value(p_cur_get_mol, 14, X_mol_Rec.ATTRIBUTE5);

789: dbms_sql.column_value(p_cur_get_mol, 10, X_mol_Rec.ATTRIBUTE1);
790: dbms_sql.column_value(p_cur_get_mol, 11, X_mol_Rec.ATTRIBUTE2);
791: dbms_sql.column_value(p_cur_get_mol, 12, X_mol_Rec.ATTRIBUTE3);
792: dbms_sql.column_value(p_cur_get_mol, 13, X_mol_Rec.ATTRIBUTE4);
793: dbms_sql.column_value(p_cur_get_mol, 14, X_mol_Rec.ATTRIBUTE5);
794: dbms_sql.column_value(p_cur_get_mol, 15, X_mol_Rec.ATTRIBUTE6);
795: dbms_sql.column_value(p_cur_get_mol, 16, X_mol_Rec.ATTRIBUTE7);
796: dbms_sql.column_value(p_cur_get_mol, 17, X_mol_Rec.ATTRIBUTE8);
797: dbms_sql.column_value(p_cur_get_mol, 18, X_mol_Rec.ATTRIBUTE9);

Line 794: dbms_sql.column_value(p_cur_get_mol, 15, X_mol_Rec.ATTRIBUTE6);

790: dbms_sql.column_value(p_cur_get_mol, 11, X_mol_Rec.ATTRIBUTE2);
791: dbms_sql.column_value(p_cur_get_mol, 12, X_mol_Rec.ATTRIBUTE3);
792: dbms_sql.column_value(p_cur_get_mol, 13, X_mol_Rec.ATTRIBUTE4);
793: dbms_sql.column_value(p_cur_get_mol, 14, X_mol_Rec.ATTRIBUTE5);
794: dbms_sql.column_value(p_cur_get_mol, 15, X_mol_Rec.ATTRIBUTE6);
795: dbms_sql.column_value(p_cur_get_mol, 16, X_mol_Rec.ATTRIBUTE7);
796: dbms_sql.column_value(p_cur_get_mol, 17, X_mol_Rec.ATTRIBUTE8);
797: dbms_sql.column_value(p_cur_get_mol, 18, X_mol_Rec.ATTRIBUTE9);
798: dbms_sql.column_value(p_cur_get_mol, 19, X_mol_Rec.ATTRIBUTE10);

Line 795: dbms_sql.column_value(p_cur_get_mol, 16, X_mol_Rec.ATTRIBUTE7);

791: dbms_sql.column_value(p_cur_get_mol, 12, X_mol_Rec.ATTRIBUTE3);
792: dbms_sql.column_value(p_cur_get_mol, 13, X_mol_Rec.ATTRIBUTE4);
793: dbms_sql.column_value(p_cur_get_mol, 14, X_mol_Rec.ATTRIBUTE5);
794: dbms_sql.column_value(p_cur_get_mol, 15, X_mol_Rec.ATTRIBUTE6);
795: dbms_sql.column_value(p_cur_get_mol, 16, X_mol_Rec.ATTRIBUTE7);
796: dbms_sql.column_value(p_cur_get_mol, 17, X_mol_Rec.ATTRIBUTE8);
797: dbms_sql.column_value(p_cur_get_mol, 18, X_mol_Rec.ATTRIBUTE9);
798: dbms_sql.column_value(p_cur_get_mol, 19, X_mol_Rec.ATTRIBUTE10);
799: dbms_sql.column_value(p_cur_get_mol, 20, X_mol_Rec.ATTRIBUTE11);

Line 796: dbms_sql.column_value(p_cur_get_mol, 17, X_mol_Rec.ATTRIBUTE8);

792: dbms_sql.column_value(p_cur_get_mol, 13, X_mol_Rec.ATTRIBUTE4);
793: dbms_sql.column_value(p_cur_get_mol, 14, X_mol_Rec.ATTRIBUTE5);
794: dbms_sql.column_value(p_cur_get_mol, 15, X_mol_Rec.ATTRIBUTE6);
795: dbms_sql.column_value(p_cur_get_mol, 16, X_mol_Rec.ATTRIBUTE7);
796: dbms_sql.column_value(p_cur_get_mol, 17, X_mol_Rec.ATTRIBUTE8);
797: dbms_sql.column_value(p_cur_get_mol, 18, X_mol_Rec.ATTRIBUTE9);
798: dbms_sql.column_value(p_cur_get_mol, 19, X_mol_Rec.ATTRIBUTE10);
799: dbms_sql.column_value(p_cur_get_mol, 20, X_mol_Rec.ATTRIBUTE11);
800: dbms_sql.column_value(p_cur_get_mol, 21, X_mol_Rec.ATTRIBUTE12);

Line 797: dbms_sql.column_value(p_cur_get_mol, 18, X_mol_Rec.ATTRIBUTE9);

793: dbms_sql.column_value(p_cur_get_mol, 14, X_mol_Rec.ATTRIBUTE5);
794: dbms_sql.column_value(p_cur_get_mol, 15, X_mol_Rec.ATTRIBUTE6);
795: dbms_sql.column_value(p_cur_get_mol, 16, X_mol_Rec.ATTRIBUTE7);
796: dbms_sql.column_value(p_cur_get_mol, 17, X_mol_Rec.ATTRIBUTE8);
797: dbms_sql.column_value(p_cur_get_mol, 18, X_mol_Rec.ATTRIBUTE9);
798: dbms_sql.column_value(p_cur_get_mol, 19, X_mol_Rec.ATTRIBUTE10);
799: dbms_sql.column_value(p_cur_get_mol, 20, X_mol_Rec.ATTRIBUTE11);
800: dbms_sql.column_value(p_cur_get_mol, 21, X_mol_Rec.ATTRIBUTE12);
801: dbms_sql.column_value(p_cur_get_mol, 22, X_mol_Rec.ATTRIBUTE13);

Line 798: dbms_sql.column_value(p_cur_get_mol, 19, X_mol_Rec.ATTRIBUTE10);

794: dbms_sql.column_value(p_cur_get_mol, 15, X_mol_Rec.ATTRIBUTE6);
795: dbms_sql.column_value(p_cur_get_mol, 16, X_mol_Rec.ATTRIBUTE7);
796: dbms_sql.column_value(p_cur_get_mol, 17, X_mol_Rec.ATTRIBUTE8);
797: dbms_sql.column_value(p_cur_get_mol, 18, X_mol_Rec.ATTRIBUTE9);
798: dbms_sql.column_value(p_cur_get_mol, 19, X_mol_Rec.ATTRIBUTE10);
799: dbms_sql.column_value(p_cur_get_mol, 20, X_mol_Rec.ATTRIBUTE11);
800: dbms_sql.column_value(p_cur_get_mol, 21, X_mol_Rec.ATTRIBUTE12);
801: dbms_sql.column_value(p_cur_get_mol, 22, X_mol_Rec.ATTRIBUTE13);
802: dbms_sql.column_value(p_cur_get_mol, 23, X_mol_Rec.ATTRIBUTE14);

Line 799: dbms_sql.column_value(p_cur_get_mol, 20, X_mol_Rec.ATTRIBUTE11);

795: dbms_sql.column_value(p_cur_get_mol, 16, X_mol_Rec.ATTRIBUTE7);
796: dbms_sql.column_value(p_cur_get_mol, 17, X_mol_Rec.ATTRIBUTE8);
797: dbms_sql.column_value(p_cur_get_mol, 18, X_mol_Rec.ATTRIBUTE9);
798: dbms_sql.column_value(p_cur_get_mol, 19, X_mol_Rec.ATTRIBUTE10);
799: dbms_sql.column_value(p_cur_get_mol, 20, X_mol_Rec.ATTRIBUTE11);
800: dbms_sql.column_value(p_cur_get_mol, 21, X_mol_Rec.ATTRIBUTE12);
801: dbms_sql.column_value(p_cur_get_mol, 22, X_mol_Rec.ATTRIBUTE13);
802: dbms_sql.column_value(p_cur_get_mol, 23, X_mol_Rec.ATTRIBUTE14);
803: dbms_sql.column_value(p_cur_get_mol, 24, X_mol_Rec.ATTRIBUTE15);

Line 800: dbms_sql.column_value(p_cur_get_mol, 21, X_mol_Rec.ATTRIBUTE12);

796: dbms_sql.column_value(p_cur_get_mol, 17, X_mol_Rec.ATTRIBUTE8);
797: dbms_sql.column_value(p_cur_get_mol, 18, X_mol_Rec.ATTRIBUTE9);
798: dbms_sql.column_value(p_cur_get_mol, 19, X_mol_Rec.ATTRIBUTE10);
799: dbms_sql.column_value(p_cur_get_mol, 20, X_mol_Rec.ATTRIBUTE11);
800: dbms_sql.column_value(p_cur_get_mol, 21, X_mol_Rec.ATTRIBUTE12);
801: dbms_sql.column_value(p_cur_get_mol, 22, X_mol_Rec.ATTRIBUTE13);
802: dbms_sql.column_value(p_cur_get_mol, 23, X_mol_Rec.ATTRIBUTE14);
803: dbms_sql.column_value(p_cur_get_mol, 24, X_mol_Rec.ATTRIBUTE15);
804:

Line 801: dbms_sql.column_value(p_cur_get_mol, 22, X_mol_Rec.ATTRIBUTE13);

797: dbms_sql.column_value(p_cur_get_mol, 18, X_mol_Rec.ATTRIBUTE9);
798: dbms_sql.column_value(p_cur_get_mol, 19, X_mol_Rec.ATTRIBUTE10);
799: dbms_sql.column_value(p_cur_get_mol, 20, X_mol_Rec.ATTRIBUTE11);
800: dbms_sql.column_value(p_cur_get_mol, 21, X_mol_Rec.ATTRIBUTE12);
801: dbms_sql.column_value(p_cur_get_mol, 22, X_mol_Rec.ATTRIBUTE13);
802: dbms_sql.column_value(p_cur_get_mol, 23, X_mol_Rec.ATTRIBUTE14);
803: dbms_sql.column_value(p_cur_get_mol, 24, X_mol_Rec.ATTRIBUTE15);
804:
805: -- Debug Message

Line 802: dbms_sql.column_value(p_cur_get_mol, 23, X_mol_Rec.ATTRIBUTE14);

798: dbms_sql.column_value(p_cur_get_mol, 19, X_mol_Rec.ATTRIBUTE10);
799: dbms_sql.column_value(p_cur_get_mol, 20, X_mol_Rec.ATTRIBUTE11);
800: dbms_sql.column_value(p_cur_get_mol, 21, X_mol_Rec.ATTRIBUTE12);
801: dbms_sql.column_value(p_cur_get_mol, 22, X_mol_Rec.ATTRIBUTE13);
802: dbms_sql.column_value(p_cur_get_mol, 23, X_mol_Rec.ATTRIBUTE14);
803: dbms_sql.column_value(p_cur_get_mol, 24, X_mol_Rec.ATTRIBUTE15);
804:
805: -- Debug Message
806: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Ends');

Line 803: dbms_sql.column_value(p_cur_get_mol, 24, X_mol_Rec.ATTRIBUTE15);

799: dbms_sql.column_value(p_cur_get_mol, 20, X_mol_Rec.ATTRIBUTE11);
800: dbms_sql.column_value(p_cur_get_mol, 21, X_mol_Rec.ATTRIBUTE12);
801: dbms_sql.column_value(p_cur_get_mol, 22, X_mol_Rec.ATTRIBUTE13);
802: dbms_sql.column_value(p_cur_get_mol, 23, X_mol_Rec.ATTRIBUTE14);
803: dbms_sql.column_value(p_cur_get_mol, 24, X_mol_Rec.ATTRIBUTE15);
804:
805: -- Debug Message
806: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Ends');
807: END Get_Column_Values;

Line 868: DBMS_SQL.BIND_VARIABLE(p_cur_get_mol, ':p_LINE_ID', P_mol_Rec.LINE_ID);

864: -- The following example applies to all columns,
865: -- developers can copy and paste them.
866: IF( (P_mol_Rec.LINE_ID IS NOT NULL) AND (P_mol_Rec.LINE_ID <> FND_API.G_MISS_NUM) )
867: THEN
868: DBMS_SQL.BIND_VARIABLE(p_cur_get_mol, ':p_LINE_ID', P_mol_Rec.LINE_ID);
869: END IF;
870:
871: -- Debug Message
872: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Bind Variables Ends');