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

Line 771: dbms_sql.define_column(p_cur_get_MOH, 1, P_MOH_Rec.HEADER_ID);

767: -- Debug Message
768: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Define Columns Begins');
769:
770: -- define all columns for CSP_MOVEORDER_HEADERS_V view
771: dbms_sql.define_column(p_cur_get_MOH, 1, P_MOH_Rec.HEADER_ID);
772: dbms_sql.define_column(p_cur_get_MOH, 2, P_MOH_Rec.CARRIER, 50);
773: dbms_sql.define_column(p_cur_get_MOH, 3, P_MOH_Rec.SHIPMENT_METHOD, 50);
774: dbms_sql.define_column(p_cur_get_MOH, 4, P_MOH_Rec.AUTORECEIPT_FLAG, 10);
775: dbms_sql.define_column(p_cur_get_MOH, 5, P_MOH_Rec.ATTRIBUTE_CATEGORY, 30);

Line 772: dbms_sql.define_column(p_cur_get_MOH, 2, P_MOH_Rec.CARRIER, 50);

768: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Define Columns Begins');
769:
770: -- define all columns for CSP_MOVEORDER_HEADERS_V view
771: dbms_sql.define_column(p_cur_get_MOH, 1, P_MOH_Rec.HEADER_ID);
772: dbms_sql.define_column(p_cur_get_MOH, 2, P_MOH_Rec.CARRIER, 50);
773: dbms_sql.define_column(p_cur_get_MOH, 3, P_MOH_Rec.SHIPMENT_METHOD, 50);
774: dbms_sql.define_column(p_cur_get_MOH, 4, P_MOH_Rec.AUTORECEIPT_FLAG, 10);
775: dbms_sql.define_column(p_cur_get_MOH, 5, P_MOH_Rec.ATTRIBUTE_CATEGORY, 30);
776: dbms_sql.define_column(p_cur_get_MOH, 6, P_MOH_Rec.LOCATION_ID);

Line 773: dbms_sql.define_column(p_cur_get_MOH, 3, P_MOH_Rec.SHIPMENT_METHOD, 50);

769:
770: -- define all columns for CSP_MOVEORDER_HEADERS_V view
771: dbms_sql.define_column(p_cur_get_MOH, 1, P_MOH_Rec.HEADER_ID);
772: dbms_sql.define_column(p_cur_get_MOH, 2, P_MOH_Rec.CARRIER, 50);
773: dbms_sql.define_column(p_cur_get_MOH, 3, P_MOH_Rec.SHIPMENT_METHOD, 50);
774: dbms_sql.define_column(p_cur_get_MOH, 4, P_MOH_Rec.AUTORECEIPT_FLAG, 10);
775: dbms_sql.define_column(p_cur_get_MOH, 5, P_MOH_Rec.ATTRIBUTE_CATEGORY, 30);
776: dbms_sql.define_column(p_cur_get_MOH, 6, P_MOH_Rec.LOCATION_ID);
777: /*

Line 774: dbms_sql.define_column(p_cur_get_MOH, 4, P_MOH_Rec.AUTORECEIPT_FLAG, 10);

770: -- define all columns for CSP_MOVEORDER_HEADERS_V view
771: dbms_sql.define_column(p_cur_get_MOH, 1, P_MOH_Rec.HEADER_ID);
772: dbms_sql.define_column(p_cur_get_MOH, 2, P_MOH_Rec.CARRIER, 50);
773: dbms_sql.define_column(p_cur_get_MOH, 3, P_MOH_Rec.SHIPMENT_METHOD, 50);
774: dbms_sql.define_column(p_cur_get_MOH, 4, P_MOH_Rec.AUTORECEIPT_FLAG, 10);
775: dbms_sql.define_column(p_cur_get_MOH, 5, P_MOH_Rec.ATTRIBUTE_CATEGORY, 30);
776: dbms_sql.define_column(p_cur_get_MOH, 6, P_MOH_Rec.LOCATION_ID);
777: /*
778: dbms_sql.define_column(p_cur_get_MOH, 7, P_MOH_Rec.ADDRESS1, 240);

Line 775: dbms_sql.define_column(p_cur_get_MOH, 5, P_MOH_Rec.ATTRIBUTE_CATEGORY, 30);

771: dbms_sql.define_column(p_cur_get_MOH, 1, P_MOH_Rec.HEADER_ID);
772: dbms_sql.define_column(p_cur_get_MOH, 2, P_MOH_Rec.CARRIER, 50);
773: dbms_sql.define_column(p_cur_get_MOH, 3, P_MOH_Rec.SHIPMENT_METHOD, 50);
774: dbms_sql.define_column(p_cur_get_MOH, 4, P_MOH_Rec.AUTORECEIPT_FLAG, 10);
775: dbms_sql.define_column(p_cur_get_MOH, 5, P_MOH_Rec.ATTRIBUTE_CATEGORY, 30);
776: dbms_sql.define_column(p_cur_get_MOH, 6, P_MOH_Rec.LOCATION_ID);
777: /*
778: dbms_sql.define_column(p_cur_get_MOH, 7, P_MOH_Rec.ADDRESS1, 240);
779: dbms_sql.define_column(p_cur_get_MOH, 8, P_MOH_Rec.ADDRESS2, 240);

Line 776: dbms_sql.define_column(p_cur_get_MOH, 6, P_MOH_Rec.LOCATION_ID);

772: dbms_sql.define_column(p_cur_get_MOH, 2, P_MOH_Rec.CARRIER, 50);
773: dbms_sql.define_column(p_cur_get_MOH, 3, P_MOH_Rec.SHIPMENT_METHOD, 50);
774: dbms_sql.define_column(p_cur_get_MOH, 4, P_MOH_Rec.AUTORECEIPT_FLAG, 10);
775: dbms_sql.define_column(p_cur_get_MOH, 5, P_MOH_Rec.ATTRIBUTE_CATEGORY, 30);
776: dbms_sql.define_column(p_cur_get_MOH, 6, P_MOH_Rec.LOCATION_ID);
777: /*
778: dbms_sql.define_column(p_cur_get_MOH, 7, P_MOH_Rec.ADDRESS1, 240);
779: dbms_sql.define_column(p_cur_get_MOH, 8, P_MOH_Rec.ADDRESS2, 240);
780: dbms_sql.define_column(p_cur_get_MOH, 9, P_MOH_Rec.ADDRESS3, 240);

Line 778: dbms_sql.define_column(p_cur_get_MOH, 7, P_MOH_Rec.ADDRESS1, 240);

774: dbms_sql.define_column(p_cur_get_MOH, 4, P_MOH_Rec.AUTORECEIPT_FLAG, 10);
775: dbms_sql.define_column(p_cur_get_MOH, 5, P_MOH_Rec.ATTRIBUTE_CATEGORY, 30);
776: dbms_sql.define_column(p_cur_get_MOH, 6, P_MOH_Rec.LOCATION_ID);
777: /*
778: dbms_sql.define_column(p_cur_get_MOH, 7, P_MOH_Rec.ADDRESS1, 240);
779: dbms_sql.define_column(p_cur_get_MOH, 8, P_MOH_Rec.ADDRESS2, 240);
780: dbms_sql.define_column(p_cur_get_MOH, 9, P_MOH_Rec.ADDRESS3, 240);
781: dbms_sql.define_column(p_cur_get_MOH, 10, P_MOH_Rec.ADDRESS4, 240);
782: dbms_sql.define_column(p_cur_get_MOH, 11, P_MOH_Rec.CITY, 60);

Line 779: dbms_sql.define_column(p_cur_get_MOH, 8, P_MOH_Rec.ADDRESS2, 240);

775: dbms_sql.define_column(p_cur_get_MOH, 5, P_MOH_Rec.ATTRIBUTE_CATEGORY, 30);
776: dbms_sql.define_column(p_cur_get_MOH, 6, P_MOH_Rec.LOCATION_ID);
777: /*
778: dbms_sql.define_column(p_cur_get_MOH, 7, P_MOH_Rec.ADDRESS1, 240);
779: dbms_sql.define_column(p_cur_get_MOH, 8, P_MOH_Rec.ADDRESS2, 240);
780: dbms_sql.define_column(p_cur_get_MOH, 9, P_MOH_Rec.ADDRESS3, 240);
781: dbms_sql.define_column(p_cur_get_MOH, 10, P_MOH_Rec.ADDRESS4, 240);
782: dbms_sql.define_column(p_cur_get_MOH, 11, P_MOH_Rec.CITY, 60);
783: dbms_sql.define_column(p_cur_get_MOH, 12, P_MOH_Rec.POSTAL_CODE, 60);

Line 780: dbms_sql.define_column(p_cur_get_MOH, 9, P_MOH_Rec.ADDRESS3, 240);

776: dbms_sql.define_column(p_cur_get_MOH, 6, P_MOH_Rec.LOCATION_ID);
777: /*
778: dbms_sql.define_column(p_cur_get_MOH, 7, P_MOH_Rec.ADDRESS1, 240);
779: dbms_sql.define_column(p_cur_get_MOH, 8, P_MOH_Rec.ADDRESS2, 240);
780: dbms_sql.define_column(p_cur_get_MOH, 9, P_MOH_Rec.ADDRESS3, 240);
781: dbms_sql.define_column(p_cur_get_MOH, 10, P_MOH_Rec.ADDRESS4, 240);
782: dbms_sql.define_column(p_cur_get_MOH, 11, P_MOH_Rec.CITY, 60);
783: dbms_sql.define_column(p_cur_get_MOH, 12, P_MOH_Rec.POSTAL_CODE, 60);
784: dbms_sql.define_column(p_cur_get_MOH, 13, P_MOH_Rec.STATE, 60);

Line 781: dbms_sql.define_column(p_cur_get_MOH, 10, P_MOH_Rec.ADDRESS4, 240);

777: /*
778: dbms_sql.define_column(p_cur_get_MOH, 7, P_MOH_Rec.ADDRESS1, 240);
779: dbms_sql.define_column(p_cur_get_MOH, 8, P_MOH_Rec.ADDRESS2, 240);
780: dbms_sql.define_column(p_cur_get_MOH, 9, P_MOH_Rec.ADDRESS3, 240);
781: dbms_sql.define_column(p_cur_get_MOH, 10, P_MOH_Rec.ADDRESS4, 240);
782: dbms_sql.define_column(p_cur_get_MOH, 11, P_MOH_Rec.CITY, 60);
783: dbms_sql.define_column(p_cur_get_MOH, 12, P_MOH_Rec.POSTAL_CODE, 60);
784: dbms_sql.define_column(p_cur_get_MOH, 13, P_MOH_Rec.STATE, 60);
785: dbms_sql.define_column(p_cur_get_MOH, 14, P_MOH_Rec.PROVINCE, 60);

Line 782: dbms_sql.define_column(p_cur_get_MOH, 11, P_MOH_Rec.CITY, 60);

778: dbms_sql.define_column(p_cur_get_MOH, 7, P_MOH_Rec.ADDRESS1, 240);
779: dbms_sql.define_column(p_cur_get_MOH, 8, P_MOH_Rec.ADDRESS2, 240);
780: dbms_sql.define_column(p_cur_get_MOH, 9, P_MOH_Rec.ADDRESS3, 240);
781: dbms_sql.define_column(p_cur_get_MOH, 10, P_MOH_Rec.ADDRESS4, 240);
782: dbms_sql.define_column(p_cur_get_MOH, 11, P_MOH_Rec.CITY, 60);
783: dbms_sql.define_column(p_cur_get_MOH, 12, P_MOH_Rec.POSTAL_CODE, 60);
784: dbms_sql.define_column(p_cur_get_MOH, 13, P_MOH_Rec.STATE, 60);
785: dbms_sql.define_column(p_cur_get_MOH, 14, P_MOH_Rec.PROVINCE, 60);
786: dbms_sql.define_column(p_cur_get_MOH, 15, P_MOH_Rec.COUNTRY, 60); */

Line 783: dbms_sql.define_column(p_cur_get_MOH, 12, P_MOH_Rec.POSTAL_CODE, 60);

779: dbms_sql.define_column(p_cur_get_MOH, 8, P_MOH_Rec.ADDRESS2, 240);
780: dbms_sql.define_column(p_cur_get_MOH, 9, P_MOH_Rec.ADDRESS3, 240);
781: dbms_sql.define_column(p_cur_get_MOH, 10, P_MOH_Rec.ADDRESS4, 240);
782: dbms_sql.define_column(p_cur_get_MOH, 11, P_MOH_Rec.CITY, 60);
783: dbms_sql.define_column(p_cur_get_MOH, 12, P_MOH_Rec.POSTAL_CODE, 60);
784: dbms_sql.define_column(p_cur_get_MOH, 13, P_MOH_Rec.STATE, 60);
785: dbms_sql.define_column(p_cur_get_MOH, 14, P_MOH_Rec.PROVINCE, 60);
786: dbms_sql.define_column(p_cur_get_MOH, 15, P_MOH_Rec.COUNTRY, 60); */
787:

Line 784: dbms_sql.define_column(p_cur_get_MOH, 13, P_MOH_Rec.STATE, 60);

780: dbms_sql.define_column(p_cur_get_MOH, 9, P_MOH_Rec.ADDRESS3, 240);
781: dbms_sql.define_column(p_cur_get_MOH, 10, P_MOH_Rec.ADDRESS4, 240);
782: dbms_sql.define_column(p_cur_get_MOH, 11, P_MOH_Rec.CITY, 60);
783: dbms_sql.define_column(p_cur_get_MOH, 12, P_MOH_Rec.POSTAL_CODE, 60);
784: dbms_sql.define_column(p_cur_get_MOH, 13, P_MOH_Rec.STATE, 60);
785: dbms_sql.define_column(p_cur_get_MOH, 14, P_MOH_Rec.PROVINCE, 60);
786: dbms_sql.define_column(p_cur_get_MOH, 15, P_MOH_Rec.COUNTRY, 60); */
787:
788: -- Debug Message

Line 785: dbms_sql.define_column(p_cur_get_MOH, 14, P_MOH_Rec.PROVINCE, 60);

781: dbms_sql.define_column(p_cur_get_MOH, 10, P_MOH_Rec.ADDRESS4, 240);
782: dbms_sql.define_column(p_cur_get_MOH, 11, P_MOH_Rec.CITY, 60);
783: dbms_sql.define_column(p_cur_get_MOH, 12, P_MOH_Rec.POSTAL_CODE, 60);
784: dbms_sql.define_column(p_cur_get_MOH, 13, P_MOH_Rec.STATE, 60);
785: dbms_sql.define_column(p_cur_get_MOH, 14, P_MOH_Rec.PROVINCE, 60);
786: dbms_sql.define_column(p_cur_get_MOH, 15, P_MOH_Rec.COUNTRY, 60); */
787:
788: -- Debug Message
789: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Define Columns Ends');

Line 786: dbms_sql.define_column(p_cur_get_MOH, 15, P_MOH_Rec.COUNTRY, 60); */

782: dbms_sql.define_column(p_cur_get_MOH, 11, P_MOH_Rec.CITY, 60);
783: dbms_sql.define_column(p_cur_get_MOH, 12, P_MOH_Rec.POSTAL_CODE, 60);
784: dbms_sql.define_column(p_cur_get_MOH, 13, P_MOH_Rec.STATE, 60);
785: dbms_sql.define_column(p_cur_get_MOH, 14, P_MOH_Rec.PROVINCE, 60);
786: dbms_sql.define_column(p_cur_get_MOH, 15, P_MOH_Rec.COUNTRY, 60); */
787:
788: -- Debug Message
789: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Define Columns Ends');
790: END Define_Columns;

Line 803: dbms_sql.column_value(p_cur_get_MOH, 1, X_MOH_Rec.HEADER_ID);

799: -- Debug Message
800: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Begins');
801:
802: -- get all column values for CSP_MOVEORDER_HEADERS_V table
803: dbms_sql.column_value(p_cur_get_MOH, 1, X_MOH_Rec.HEADER_ID);
804: dbms_sql.column_value(p_cur_get_MOH, 2, X_MOH_Rec.CARRIER);
805: dbms_sql.column_value(p_cur_get_MOH, 3, X_MOH_Rec.SHIPMENT_METHOD);
806: dbms_sql.column_value(p_cur_get_MOH, 4, X_MOH_Rec.AUTORECEIPT_FLAG);
807: dbms_sql.column_value(p_cur_get_MOH, 5, X_MOH_Rec.ATTRIBUTE_CATEGORY);

Line 804: dbms_sql.column_value(p_cur_get_MOH, 2, X_MOH_Rec.CARRIER);

800: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Begins');
801:
802: -- get all column values for CSP_MOVEORDER_HEADERS_V table
803: dbms_sql.column_value(p_cur_get_MOH, 1, X_MOH_Rec.HEADER_ID);
804: dbms_sql.column_value(p_cur_get_MOH, 2, X_MOH_Rec.CARRIER);
805: dbms_sql.column_value(p_cur_get_MOH, 3, X_MOH_Rec.SHIPMENT_METHOD);
806: dbms_sql.column_value(p_cur_get_MOH, 4, X_MOH_Rec.AUTORECEIPT_FLAG);
807: dbms_sql.column_value(p_cur_get_MOH, 5, X_MOH_Rec.ATTRIBUTE_CATEGORY);
808: dbms_sql.column_value(p_cur_get_MOH, 6, X_MOH_Rec.LOCATION_ID);

Line 805: dbms_sql.column_value(p_cur_get_MOH, 3, X_MOH_Rec.SHIPMENT_METHOD);

801:
802: -- get all column values for CSP_MOVEORDER_HEADERS_V table
803: dbms_sql.column_value(p_cur_get_MOH, 1, X_MOH_Rec.HEADER_ID);
804: dbms_sql.column_value(p_cur_get_MOH, 2, X_MOH_Rec.CARRIER);
805: dbms_sql.column_value(p_cur_get_MOH, 3, X_MOH_Rec.SHIPMENT_METHOD);
806: dbms_sql.column_value(p_cur_get_MOH, 4, X_MOH_Rec.AUTORECEIPT_FLAG);
807: dbms_sql.column_value(p_cur_get_MOH, 5, X_MOH_Rec.ATTRIBUTE_CATEGORY);
808: dbms_sql.column_value(p_cur_get_MOH, 6, X_MOH_Rec.LOCATION_ID);
809: /*

Line 806: dbms_sql.column_value(p_cur_get_MOH, 4, X_MOH_Rec.AUTORECEIPT_FLAG);

802: -- get all column values for CSP_MOVEORDER_HEADERS_V table
803: dbms_sql.column_value(p_cur_get_MOH, 1, X_MOH_Rec.HEADER_ID);
804: dbms_sql.column_value(p_cur_get_MOH, 2, X_MOH_Rec.CARRIER);
805: dbms_sql.column_value(p_cur_get_MOH, 3, X_MOH_Rec.SHIPMENT_METHOD);
806: dbms_sql.column_value(p_cur_get_MOH, 4, X_MOH_Rec.AUTORECEIPT_FLAG);
807: dbms_sql.column_value(p_cur_get_MOH, 5, X_MOH_Rec.ATTRIBUTE_CATEGORY);
808: dbms_sql.column_value(p_cur_get_MOH, 6, X_MOH_Rec.LOCATION_ID);
809: /*
810: dbms_sql.column_value(p_cur_get_MOH, 7, X_MOH_Rec.ADDRESS1);

Line 807: dbms_sql.column_value(p_cur_get_MOH, 5, X_MOH_Rec.ATTRIBUTE_CATEGORY);

803: dbms_sql.column_value(p_cur_get_MOH, 1, X_MOH_Rec.HEADER_ID);
804: dbms_sql.column_value(p_cur_get_MOH, 2, X_MOH_Rec.CARRIER);
805: dbms_sql.column_value(p_cur_get_MOH, 3, X_MOH_Rec.SHIPMENT_METHOD);
806: dbms_sql.column_value(p_cur_get_MOH, 4, X_MOH_Rec.AUTORECEIPT_FLAG);
807: dbms_sql.column_value(p_cur_get_MOH, 5, X_MOH_Rec.ATTRIBUTE_CATEGORY);
808: dbms_sql.column_value(p_cur_get_MOH, 6, X_MOH_Rec.LOCATION_ID);
809: /*
810: dbms_sql.column_value(p_cur_get_MOH, 7, X_MOH_Rec.ADDRESS1);
811: dbms_sql.column_value(p_cur_get_MOH, 8, X_MOH_Rec.ADDRESS2);

Line 808: dbms_sql.column_value(p_cur_get_MOH, 6, X_MOH_Rec.LOCATION_ID);

804: dbms_sql.column_value(p_cur_get_MOH, 2, X_MOH_Rec.CARRIER);
805: dbms_sql.column_value(p_cur_get_MOH, 3, X_MOH_Rec.SHIPMENT_METHOD);
806: dbms_sql.column_value(p_cur_get_MOH, 4, X_MOH_Rec.AUTORECEIPT_FLAG);
807: dbms_sql.column_value(p_cur_get_MOH, 5, X_MOH_Rec.ATTRIBUTE_CATEGORY);
808: dbms_sql.column_value(p_cur_get_MOH, 6, X_MOH_Rec.LOCATION_ID);
809: /*
810: dbms_sql.column_value(p_cur_get_MOH, 7, X_MOH_Rec.ADDRESS1);
811: dbms_sql.column_value(p_cur_get_MOH, 8, X_MOH_Rec.ADDRESS2);
812: dbms_sql.column_value(p_cur_get_MOH, 9, X_MOH_Rec.ADDRESS3);

Line 810: dbms_sql.column_value(p_cur_get_MOH, 7, X_MOH_Rec.ADDRESS1);

806: dbms_sql.column_value(p_cur_get_MOH, 4, X_MOH_Rec.AUTORECEIPT_FLAG);
807: dbms_sql.column_value(p_cur_get_MOH, 5, X_MOH_Rec.ATTRIBUTE_CATEGORY);
808: dbms_sql.column_value(p_cur_get_MOH, 6, X_MOH_Rec.LOCATION_ID);
809: /*
810: dbms_sql.column_value(p_cur_get_MOH, 7, X_MOH_Rec.ADDRESS1);
811: dbms_sql.column_value(p_cur_get_MOH, 8, X_MOH_Rec.ADDRESS2);
812: dbms_sql.column_value(p_cur_get_MOH, 9, X_MOH_Rec.ADDRESS3);
813: dbms_sql.column_value(p_cur_get_MOH, 10, X_MOH_Rec.ADDRESS4);
814: dbms_sql.column_value(p_cur_get_MOH, 11, X_MOH_Rec.CITY);

Line 811: dbms_sql.column_value(p_cur_get_MOH, 8, X_MOH_Rec.ADDRESS2);

807: dbms_sql.column_value(p_cur_get_MOH, 5, X_MOH_Rec.ATTRIBUTE_CATEGORY);
808: dbms_sql.column_value(p_cur_get_MOH, 6, X_MOH_Rec.LOCATION_ID);
809: /*
810: dbms_sql.column_value(p_cur_get_MOH, 7, X_MOH_Rec.ADDRESS1);
811: dbms_sql.column_value(p_cur_get_MOH, 8, X_MOH_Rec.ADDRESS2);
812: dbms_sql.column_value(p_cur_get_MOH, 9, X_MOH_Rec.ADDRESS3);
813: dbms_sql.column_value(p_cur_get_MOH, 10, X_MOH_Rec.ADDRESS4);
814: dbms_sql.column_value(p_cur_get_MOH, 11, X_MOH_Rec.CITY);
815: dbms_sql.column_value(p_cur_get_MOH, 12, X_MOH_Rec.POSTAL_CODE);

Line 812: dbms_sql.column_value(p_cur_get_MOH, 9, X_MOH_Rec.ADDRESS3);

808: dbms_sql.column_value(p_cur_get_MOH, 6, X_MOH_Rec.LOCATION_ID);
809: /*
810: dbms_sql.column_value(p_cur_get_MOH, 7, X_MOH_Rec.ADDRESS1);
811: dbms_sql.column_value(p_cur_get_MOH, 8, X_MOH_Rec.ADDRESS2);
812: dbms_sql.column_value(p_cur_get_MOH, 9, X_MOH_Rec.ADDRESS3);
813: dbms_sql.column_value(p_cur_get_MOH, 10, X_MOH_Rec.ADDRESS4);
814: dbms_sql.column_value(p_cur_get_MOH, 11, X_MOH_Rec.CITY);
815: dbms_sql.column_value(p_cur_get_MOH, 12, X_MOH_Rec.POSTAL_CODE);
816: dbms_sql.column_value(p_cur_get_MOH, 13, X_MOH_Rec.STATE);

Line 813: dbms_sql.column_value(p_cur_get_MOH, 10, X_MOH_Rec.ADDRESS4);

809: /*
810: dbms_sql.column_value(p_cur_get_MOH, 7, X_MOH_Rec.ADDRESS1);
811: dbms_sql.column_value(p_cur_get_MOH, 8, X_MOH_Rec.ADDRESS2);
812: dbms_sql.column_value(p_cur_get_MOH, 9, X_MOH_Rec.ADDRESS3);
813: dbms_sql.column_value(p_cur_get_MOH, 10, X_MOH_Rec.ADDRESS4);
814: dbms_sql.column_value(p_cur_get_MOH, 11, X_MOH_Rec.CITY);
815: dbms_sql.column_value(p_cur_get_MOH, 12, X_MOH_Rec.POSTAL_CODE);
816: dbms_sql.column_value(p_cur_get_MOH, 13, X_MOH_Rec.STATE);
817: dbms_sql.column_value(p_cur_get_MOH, 14, X_MOH_Rec.PROVINCE);

Line 814: dbms_sql.column_value(p_cur_get_MOH, 11, X_MOH_Rec.CITY);

810: dbms_sql.column_value(p_cur_get_MOH, 7, X_MOH_Rec.ADDRESS1);
811: dbms_sql.column_value(p_cur_get_MOH, 8, X_MOH_Rec.ADDRESS2);
812: dbms_sql.column_value(p_cur_get_MOH, 9, X_MOH_Rec.ADDRESS3);
813: dbms_sql.column_value(p_cur_get_MOH, 10, X_MOH_Rec.ADDRESS4);
814: dbms_sql.column_value(p_cur_get_MOH, 11, X_MOH_Rec.CITY);
815: dbms_sql.column_value(p_cur_get_MOH, 12, X_MOH_Rec.POSTAL_CODE);
816: dbms_sql.column_value(p_cur_get_MOH, 13, X_MOH_Rec.STATE);
817: dbms_sql.column_value(p_cur_get_MOH, 14, X_MOH_Rec.PROVINCE);
818: dbms_sql.column_value(p_cur_get_MOH, 15, X_MOH_Rec.COUNTRY); */

Line 815: dbms_sql.column_value(p_cur_get_MOH, 12, X_MOH_Rec.POSTAL_CODE);

811: dbms_sql.column_value(p_cur_get_MOH, 8, X_MOH_Rec.ADDRESS2);
812: dbms_sql.column_value(p_cur_get_MOH, 9, X_MOH_Rec.ADDRESS3);
813: dbms_sql.column_value(p_cur_get_MOH, 10, X_MOH_Rec.ADDRESS4);
814: dbms_sql.column_value(p_cur_get_MOH, 11, X_MOH_Rec.CITY);
815: dbms_sql.column_value(p_cur_get_MOH, 12, X_MOH_Rec.POSTAL_CODE);
816: dbms_sql.column_value(p_cur_get_MOH, 13, X_MOH_Rec.STATE);
817: dbms_sql.column_value(p_cur_get_MOH, 14, X_MOH_Rec.PROVINCE);
818: dbms_sql.column_value(p_cur_get_MOH, 15, X_MOH_Rec.COUNTRY); */
819:

Line 816: dbms_sql.column_value(p_cur_get_MOH, 13, X_MOH_Rec.STATE);

812: dbms_sql.column_value(p_cur_get_MOH, 9, X_MOH_Rec.ADDRESS3);
813: dbms_sql.column_value(p_cur_get_MOH, 10, X_MOH_Rec.ADDRESS4);
814: dbms_sql.column_value(p_cur_get_MOH, 11, X_MOH_Rec.CITY);
815: dbms_sql.column_value(p_cur_get_MOH, 12, X_MOH_Rec.POSTAL_CODE);
816: dbms_sql.column_value(p_cur_get_MOH, 13, X_MOH_Rec.STATE);
817: dbms_sql.column_value(p_cur_get_MOH, 14, X_MOH_Rec.PROVINCE);
818: dbms_sql.column_value(p_cur_get_MOH, 15, X_MOH_Rec.COUNTRY); */
819:
820: -- Debug Message

Line 817: dbms_sql.column_value(p_cur_get_MOH, 14, X_MOH_Rec.PROVINCE);

813: dbms_sql.column_value(p_cur_get_MOH, 10, X_MOH_Rec.ADDRESS4);
814: dbms_sql.column_value(p_cur_get_MOH, 11, X_MOH_Rec.CITY);
815: dbms_sql.column_value(p_cur_get_MOH, 12, X_MOH_Rec.POSTAL_CODE);
816: dbms_sql.column_value(p_cur_get_MOH, 13, X_MOH_Rec.STATE);
817: dbms_sql.column_value(p_cur_get_MOH, 14, X_MOH_Rec.PROVINCE);
818: dbms_sql.column_value(p_cur_get_MOH, 15, X_MOH_Rec.COUNTRY); */
819:
820: -- Debug Message
821: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Ends');

Line 818: dbms_sql.column_value(p_cur_get_MOH, 15, X_MOH_Rec.COUNTRY); */

814: dbms_sql.column_value(p_cur_get_MOH, 11, X_MOH_Rec.CITY);
815: dbms_sql.column_value(p_cur_get_MOH, 12, X_MOH_Rec.POSTAL_CODE);
816: dbms_sql.column_value(p_cur_get_MOH, 13, X_MOH_Rec.STATE);
817: dbms_sql.column_value(p_cur_get_MOH, 14, X_MOH_Rec.PROVINCE);
818: dbms_sql.column_value(p_cur_get_MOH, 15, X_MOH_Rec.COUNTRY); */
819:
820: -- Debug Message
821: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Ends');
822: END Get_Column_Values;

Line 883: DBMS_SQL.BIND_VARIABLE(p_cur_get_MOH, ':p_HEADER_ID', P_MOH_Rec.HEADER_ID);

879: -- The following example applies to all columns,
880: -- developers can copy and paste them.
881: IF( (P_MOH_Rec.HEADER_ID IS NOT NULL) AND (P_MOH_Rec.HEADER_ID <> FND_API.G_MISS_NUM) )
882: THEN
883: DBMS_SQL.BIND_VARIABLE(p_cur_get_MOH, ':p_HEADER_ID', P_MOH_Rec.HEADER_ID);
884: END IF;
885:
886: -- Debug Message
887: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Bind Variables Ends');