DBA Data[Home] [Help]

APPS.ASO_LINE_RLTSHIP_PVT dependencies on DBMS_SQL

Line 813: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 1, P_LINE_RLTSHIP_Rec.QUOTE_LINE_ID);

809: -- Debug Message
810: --ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Define Columns Begins');
811: /*
812: -- define all columns for ASO_QUOTE_LINES_V view
813: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 1, P_LINE_RLTSHIP_Rec.QUOTE_LINE_ID);
814: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 2, P_LINE_RLTSHIP_Rec.QUOTE_HEADER_ID);
815: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 3, P_LINE_RLTSHIP_Rec.REQUEST_ID);
816: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 4, P_LINE_RLTSHIP_Rec.PROGRAM_APPLICATION_ID);
817: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 5, P_LINE_RLTSHIP_Rec.PROGRAM_ID);

Line 814: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 2, P_LINE_RLTSHIP_Rec.QUOTE_HEADER_ID);

810: --ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Define Columns Begins');
811: /*
812: -- define all columns for ASO_QUOTE_LINES_V view
813: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 1, P_LINE_RLTSHIP_Rec.QUOTE_LINE_ID);
814: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 2, P_LINE_RLTSHIP_Rec.QUOTE_HEADER_ID);
815: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 3, P_LINE_RLTSHIP_Rec.REQUEST_ID);
816: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 4, P_LINE_RLTSHIP_Rec.PROGRAM_APPLICATION_ID);
817: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 5, P_LINE_RLTSHIP_Rec.PROGRAM_ID);
818: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 6, P_LINE_RLTSHIP_Rec.PROGRAM_UPDATE_DATE);

Line 815: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 3, P_LINE_RLTSHIP_Rec.REQUEST_ID);

811: /*
812: -- define all columns for ASO_QUOTE_LINES_V view
813: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 1, P_LINE_RLTSHIP_Rec.QUOTE_LINE_ID);
814: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 2, P_LINE_RLTSHIP_Rec.QUOTE_HEADER_ID);
815: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 3, P_LINE_RLTSHIP_Rec.REQUEST_ID);
816: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 4, P_LINE_RLTSHIP_Rec.PROGRAM_APPLICATION_ID);
817: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 5, P_LINE_RLTSHIP_Rec.PROGRAM_ID);
818: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 6, P_LINE_RLTSHIP_Rec.PROGRAM_UPDATE_DATE);
819: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 7, P_LINE_RLTSHIP_Rec.ORG_ID);

Line 816: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 4, P_LINE_RLTSHIP_Rec.PROGRAM_APPLICATION_ID);

812: -- define all columns for ASO_QUOTE_LINES_V view
813: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 1, P_LINE_RLTSHIP_Rec.QUOTE_LINE_ID);
814: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 2, P_LINE_RLTSHIP_Rec.QUOTE_HEADER_ID);
815: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 3, P_LINE_RLTSHIP_Rec.REQUEST_ID);
816: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 4, P_LINE_RLTSHIP_Rec.PROGRAM_APPLICATION_ID);
817: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 5, P_LINE_RLTSHIP_Rec.PROGRAM_ID);
818: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 6, P_LINE_RLTSHIP_Rec.PROGRAM_UPDATE_DATE);
819: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 7, P_LINE_RLTSHIP_Rec.ORG_ID);
820: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 8, P_LINE_RLTSHIP_Rec.LINE_CATEGORY_CODE, 30);

Line 817: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 5, P_LINE_RLTSHIP_Rec.PROGRAM_ID);

813: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 1, P_LINE_RLTSHIP_Rec.QUOTE_LINE_ID);
814: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 2, P_LINE_RLTSHIP_Rec.QUOTE_HEADER_ID);
815: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 3, P_LINE_RLTSHIP_Rec.REQUEST_ID);
816: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 4, P_LINE_RLTSHIP_Rec.PROGRAM_APPLICATION_ID);
817: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 5, P_LINE_RLTSHIP_Rec.PROGRAM_ID);
818: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 6, P_LINE_RLTSHIP_Rec.PROGRAM_UPDATE_DATE);
819: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 7, P_LINE_RLTSHIP_Rec.ORG_ID);
820: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 8, P_LINE_RLTSHIP_Rec.LINE_CATEGORY_CODE, 30);
821: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 9, P_LINE_RLTSHIP_Rec.ITEM_TYPE_CODE, 30);

Line 818: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 6, P_LINE_RLTSHIP_Rec.PROGRAM_UPDATE_DATE);

814: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 2, P_LINE_RLTSHIP_Rec.QUOTE_HEADER_ID);
815: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 3, P_LINE_RLTSHIP_Rec.REQUEST_ID);
816: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 4, P_LINE_RLTSHIP_Rec.PROGRAM_APPLICATION_ID);
817: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 5, P_LINE_RLTSHIP_Rec.PROGRAM_ID);
818: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 6, P_LINE_RLTSHIP_Rec.PROGRAM_UPDATE_DATE);
819: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 7, P_LINE_RLTSHIP_Rec.ORG_ID);
820: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 8, P_LINE_RLTSHIP_Rec.LINE_CATEGORY_CODE, 30);
821: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 9, P_LINE_RLTSHIP_Rec.ITEM_TYPE_CODE, 30);
822: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 10, P_LINE_RLTSHIP_Rec.LINE_NUMBER);

Line 819: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 7, P_LINE_RLTSHIP_Rec.ORG_ID);

815: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 3, P_LINE_RLTSHIP_Rec.REQUEST_ID);
816: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 4, P_LINE_RLTSHIP_Rec.PROGRAM_APPLICATION_ID);
817: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 5, P_LINE_RLTSHIP_Rec.PROGRAM_ID);
818: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 6, P_LINE_RLTSHIP_Rec.PROGRAM_UPDATE_DATE);
819: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 7, P_LINE_RLTSHIP_Rec.ORG_ID);
820: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 8, P_LINE_RLTSHIP_Rec.LINE_CATEGORY_CODE, 30);
821: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 9, P_LINE_RLTSHIP_Rec.ITEM_TYPE_CODE, 30);
822: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 10, P_LINE_RLTSHIP_Rec.LINE_NUMBER);
823: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 11, P_LINE_RLTSHIP_Rec.START_DATE_ACTIVE);

Line 820: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 8, P_LINE_RLTSHIP_Rec.LINE_CATEGORY_CODE, 30);

816: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 4, P_LINE_RLTSHIP_Rec.PROGRAM_APPLICATION_ID);
817: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 5, P_LINE_RLTSHIP_Rec.PROGRAM_ID);
818: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 6, P_LINE_RLTSHIP_Rec.PROGRAM_UPDATE_DATE);
819: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 7, P_LINE_RLTSHIP_Rec.ORG_ID);
820: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 8, P_LINE_RLTSHIP_Rec.LINE_CATEGORY_CODE, 30);
821: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 9, P_LINE_RLTSHIP_Rec.ITEM_TYPE_CODE, 30);
822: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 10, P_LINE_RLTSHIP_Rec.LINE_NUMBER);
823: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 11, P_LINE_RLTSHIP_Rec.START_DATE_ACTIVE);
824: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 12, P_LINE_RLTSHIP_Rec.END_DATE_ACTIVE);

Line 821: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 9, P_LINE_RLTSHIP_Rec.ITEM_TYPE_CODE, 30);

817: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 5, P_LINE_RLTSHIP_Rec.PROGRAM_ID);
818: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 6, P_LINE_RLTSHIP_Rec.PROGRAM_UPDATE_DATE);
819: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 7, P_LINE_RLTSHIP_Rec.ORG_ID);
820: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 8, P_LINE_RLTSHIP_Rec.LINE_CATEGORY_CODE, 30);
821: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 9, P_LINE_RLTSHIP_Rec.ITEM_TYPE_CODE, 30);
822: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 10, P_LINE_RLTSHIP_Rec.LINE_NUMBER);
823: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 11, P_LINE_RLTSHIP_Rec.START_DATE_ACTIVE);
824: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 12, P_LINE_RLTSHIP_Rec.END_DATE_ACTIVE);
825: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 13, P_LINE_RLTSHIP_Rec.ORDER_LINE_TYPE_ID);

Line 822: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 10, P_LINE_RLTSHIP_Rec.LINE_NUMBER);

818: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 6, P_LINE_RLTSHIP_Rec.PROGRAM_UPDATE_DATE);
819: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 7, P_LINE_RLTSHIP_Rec.ORG_ID);
820: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 8, P_LINE_RLTSHIP_Rec.LINE_CATEGORY_CODE, 30);
821: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 9, P_LINE_RLTSHIP_Rec.ITEM_TYPE_CODE, 30);
822: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 10, P_LINE_RLTSHIP_Rec.LINE_NUMBER);
823: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 11, P_LINE_RLTSHIP_Rec.START_DATE_ACTIVE);
824: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 12, P_LINE_RLTSHIP_Rec.END_DATE_ACTIVE);
825: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 13, P_LINE_RLTSHIP_Rec.ORDER_LINE_TYPE_ID);
826: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 14, P_LINE_RLTSHIP_Rec.ORGANIZATION_ID);

Line 823: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 11, P_LINE_RLTSHIP_Rec.START_DATE_ACTIVE);

819: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 7, P_LINE_RLTSHIP_Rec.ORG_ID);
820: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 8, P_LINE_RLTSHIP_Rec.LINE_CATEGORY_CODE, 30);
821: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 9, P_LINE_RLTSHIP_Rec.ITEM_TYPE_CODE, 30);
822: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 10, P_LINE_RLTSHIP_Rec.LINE_NUMBER);
823: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 11, P_LINE_RLTSHIP_Rec.START_DATE_ACTIVE);
824: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 12, P_LINE_RLTSHIP_Rec.END_DATE_ACTIVE);
825: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 13, P_LINE_RLTSHIP_Rec.ORDER_LINE_TYPE_ID);
826: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 14, P_LINE_RLTSHIP_Rec.ORGANIZATION_ID);
827: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 15, P_LINE_RLTSHIP_Rec.INVENTORY_ITEM_ID);

Line 824: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 12, P_LINE_RLTSHIP_Rec.END_DATE_ACTIVE);

820: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 8, P_LINE_RLTSHIP_Rec.LINE_CATEGORY_CODE, 30);
821: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 9, P_LINE_RLTSHIP_Rec.ITEM_TYPE_CODE, 30);
822: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 10, P_LINE_RLTSHIP_Rec.LINE_NUMBER);
823: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 11, P_LINE_RLTSHIP_Rec.START_DATE_ACTIVE);
824: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 12, P_LINE_RLTSHIP_Rec.END_DATE_ACTIVE);
825: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 13, P_LINE_RLTSHIP_Rec.ORDER_LINE_TYPE_ID);
826: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 14, P_LINE_RLTSHIP_Rec.ORGANIZATION_ID);
827: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 15, P_LINE_RLTSHIP_Rec.INVENTORY_ITEM_ID);
828: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 16, P_LINE_RLTSHIP_Rec.QUANTITY);

Line 825: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 13, P_LINE_RLTSHIP_Rec.ORDER_LINE_TYPE_ID);

821: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 9, P_LINE_RLTSHIP_Rec.ITEM_TYPE_CODE, 30);
822: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 10, P_LINE_RLTSHIP_Rec.LINE_NUMBER);
823: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 11, P_LINE_RLTSHIP_Rec.START_DATE_ACTIVE);
824: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 12, P_LINE_RLTSHIP_Rec.END_DATE_ACTIVE);
825: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 13, P_LINE_RLTSHIP_Rec.ORDER_LINE_TYPE_ID);
826: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 14, P_LINE_RLTSHIP_Rec.ORGANIZATION_ID);
827: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 15, P_LINE_RLTSHIP_Rec.INVENTORY_ITEM_ID);
828: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 16, P_LINE_RLTSHIP_Rec.QUANTITY);
829: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 17, P_LINE_RLTSHIP_Rec.UOM_CODE, 3);

Line 826: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 14, P_LINE_RLTSHIP_Rec.ORGANIZATION_ID);

822: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 10, P_LINE_RLTSHIP_Rec.LINE_NUMBER);
823: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 11, P_LINE_RLTSHIP_Rec.START_DATE_ACTIVE);
824: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 12, P_LINE_RLTSHIP_Rec.END_DATE_ACTIVE);
825: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 13, P_LINE_RLTSHIP_Rec.ORDER_LINE_TYPE_ID);
826: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 14, P_LINE_RLTSHIP_Rec.ORGANIZATION_ID);
827: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 15, P_LINE_RLTSHIP_Rec.INVENTORY_ITEM_ID);
828: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 16, P_LINE_RLTSHIP_Rec.QUANTITY);
829: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 17, P_LINE_RLTSHIP_Rec.UOM_CODE, 3);
830: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 18, P_LINE_RLTSHIP_Rec.MARKETING_SOURCE_CODE_ID);

Line 827: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 15, P_LINE_RLTSHIP_Rec.INVENTORY_ITEM_ID);

823: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 11, P_LINE_RLTSHIP_Rec.START_DATE_ACTIVE);
824: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 12, P_LINE_RLTSHIP_Rec.END_DATE_ACTIVE);
825: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 13, P_LINE_RLTSHIP_Rec.ORDER_LINE_TYPE_ID);
826: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 14, P_LINE_RLTSHIP_Rec.ORGANIZATION_ID);
827: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 15, P_LINE_RLTSHIP_Rec.INVENTORY_ITEM_ID);
828: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 16, P_LINE_RLTSHIP_Rec.QUANTITY);
829: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 17, P_LINE_RLTSHIP_Rec.UOM_CODE, 3);
830: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 18, P_LINE_RLTSHIP_Rec.MARKETING_SOURCE_CODE_ID);
831: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 19, P_LINE_RLTSHIP_Rec.PRICE_LIST_ID);

Line 828: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 16, P_LINE_RLTSHIP_Rec.QUANTITY);

824: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 12, P_LINE_RLTSHIP_Rec.END_DATE_ACTIVE);
825: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 13, P_LINE_RLTSHIP_Rec.ORDER_LINE_TYPE_ID);
826: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 14, P_LINE_RLTSHIP_Rec.ORGANIZATION_ID);
827: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 15, P_LINE_RLTSHIP_Rec.INVENTORY_ITEM_ID);
828: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 16, P_LINE_RLTSHIP_Rec.QUANTITY);
829: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 17, P_LINE_RLTSHIP_Rec.UOM_CODE, 3);
830: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 18, P_LINE_RLTSHIP_Rec.MARKETING_SOURCE_CODE_ID);
831: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 19, P_LINE_RLTSHIP_Rec.PRICE_LIST_ID);
832: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 20, P_LINE_RLTSHIP_Rec.PRICE_LIST_NAME, 240);

Line 829: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 17, P_LINE_RLTSHIP_Rec.UOM_CODE, 3);

825: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 13, P_LINE_RLTSHIP_Rec.ORDER_LINE_TYPE_ID);
826: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 14, P_LINE_RLTSHIP_Rec.ORGANIZATION_ID);
827: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 15, P_LINE_RLTSHIP_Rec.INVENTORY_ITEM_ID);
828: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 16, P_LINE_RLTSHIP_Rec.QUANTITY);
829: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 17, P_LINE_RLTSHIP_Rec.UOM_CODE, 3);
830: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 18, P_LINE_RLTSHIP_Rec.MARKETING_SOURCE_CODE_ID);
831: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 19, P_LINE_RLTSHIP_Rec.PRICE_LIST_ID);
832: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 20, P_LINE_RLTSHIP_Rec.PRICE_LIST_NAME, 240);
833: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 21, P_LINE_RLTSHIP_Rec.PRICE_LIST_LINE_ID);

Line 830: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 18, P_LINE_RLTSHIP_Rec.MARKETING_SOURCE_CODE_ID);

826: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 14, P_LINE_RLTSHIP_Rec.ORGANIZATION_ID);
827: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 15, P_LINE_RLTSHIP_Rec.INVENTORY_ITEM_ID);
828: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 16, P_LINE_RLTSHIP_Rec.QUANTITY);
829: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 17, P_LINE_RLTSHIP_Rec.UOM_CODE, 3);
830: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 18, P_LINE_RLTSHIP_Rec.MARKETING_SOURCE_CODE_ID);
831: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 19, P_LINE_RLTSHIP_Rec.PRICE_LIST_ID);
832: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 20, P_LINE_RLTSHIP_Rec.PRICE_LIST_NAME, 240);
833: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 21, P_LINE_RLTSHIP_Rec.PRICE_LIST_LINE_ID);
834: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 22, P_LINE_RLTSHIP_Rec.CURRENCY_CODE, 15);

Line 831: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 19, P_LINE_RLTSHIP_Rec.PRICE_LIST_ID);

827: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 15, P_LINE_RLTSHIP_Rec.INVENTORY_ITEM_ID);
828: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 16, P_LINE_RLTSHIP_Rec.QUANTITY);
829: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 17, P_LINE_RLTSHIP_Rec.UOM_CODE, 3);
830: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 18, P_LINE_RLTSHIP_Rec.MARKETING_SOURCE_CODE_ID);
831: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 19, P_LINE_RLTSHIP_Rec.PRICE_LIST_ID);
832: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 20, P_LINE_RLTSHIP_Rec.PRICE_LIST_NAME, 240);
833: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 21, P_LINE_RLTSHIP_Rec.PRICE_LIST_LINE_ID);
834: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 22, P_LINE_RLTSHIP_Rec.CURRENCY_CODE, 15);
835: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 23, P_LINE_RLTSHIP_Rec.LINE_LIST_PRICE);

Line 832: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 20, P_LINE_RLTSHIP_Rec.PRICE_LIST_NAME, 240);

828: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 16, P_LINE_RLTSHIP_Rec.QUANTITY);
829: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 17, P_LINE_RLTSHIP_Rec.UOM_CODE, 3);
830: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 18, P_LINE_RLTSHIP_Rec.MARKETING_SOURCE_CODE_ID);
831: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 19, P_LINE_RLTSHIP_Rec.PRICE_LIST_ID);
832: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 20, P_LINE_RLTSHIP_Rec.PRICE_LIST_NAME, 240);
833: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 21, P_LINE_RLTSHIP_Rec.PRICE_LIST_LINE_ID);
834: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 22, P_LINE_RLTSHIP_Rec.CURRENCY_CODE, 15);
835: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 23, P_LINE_RLTSHIP_Rec.LINE_LIST_PRICE);
836: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 24, P_LINE_RLTSHIP_Rec.LINE_ADJUSTED_AMOUNT);

Line 833: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 21, P_LINE_RLTSHIP_Rec.PRICE_LIST_LINE_ID);

829: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 17, P_LINE_RLTSHIP_Rec.UOM_CODE, 3);
830: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 18, P_LINE_RLTSHIP_Rec.MARKETING_SOURCE_CODE_ID);
831: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 19, P_LINE_RLTSHIP_Rec.PRICE_LIST_ID);
832: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 20, P_LINE_RLTSHIP_Rec.PRICE_LIST_NAME, 240);
833: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 21, P_LINE_RLTSHIP_Rec.PRICE_LIST_LINE_ID);
834: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 22, P_LINE_RLTSHIP_Rec.CURRENCY_CODE, 15);
835: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 23, P_LINE_RLTSHIP_Rec.LINE_LIST_PRICE);
836: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 24, P_LINE_RLTSHIP_Rec.LINE_ADJUSTED_AMOUNT);
837: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 25, P_LINE_RLTSHIP_Rec.LINE_ADJUSTED_PERCENT);

Line 834: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 22, P_LINE_RLTSHIP_Rec.CURRENCY_CODE, 15);

830: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 18, P_LINE_RLTSHIP_Rec.MARKETING_SOURCE_CODE_ID);
831: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 19, P_LINE_RLTSHIP_Rec.PRICE_LIST_ID);
832: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 20, P_LINE_RLTSHIP_Rec.PRICE_LIST_NAME, 240);
833: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 21, P_LINE_RLTSHIP_Rec.PRICE_LIST_LINE_ID);
834: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 22, P_LINE_RLTSHIP_Rec.CURRENCY_CODE, 15);
835: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 23, P_LINE_RLTSHIP_Rec.LINE_LIST_PRICE);
836: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 24, P_LINE_RLTSHIP_Rec.LINE_ADJUSTED_AMOUNT);
837: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 25, P_LINE_RLTSHIP_Rec.LINE_ADJUSTED_PERCENT);
838: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 26, P_LINE_RLTSHIP_Rec.LINE_QUOTE_PRICE);

Line 835: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 23, P_LINE_RLTSHIP_Rec.LINE_LIST_PRICE);

831: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 19, P_LINE_RLTSHIP_Rec.PRICE_LIST_ID);
832: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 20, P_LINE_RLTSHIP_Rec.PRICE_LIST_NAME, 240);
833: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 21, P_LINE_RLTSHIP_Rec.PRICE_LIST_LINE_ID);
834: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 22, P_LINE_RLTSHIP_Rec.CURRENCY_CODE, 15);
835: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 23, P_LINE_RLTSHIP_Rec.LINE_LIST_PRICE);
836: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 24, P_LINE_RLTSHIP_Rec.LINE_ADJUSTED_AMOUNT);
837: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 25, P_LINE_RLTSHIP_Rec.LINE_ADJUSTED_PERCENT);
838: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 26, P_LINE_RLTSHIP_Rec.LINE_QUOTE_PRICE);
839: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 27, P_LINE_RLTSHIP_Rec.RELATED_ITEM_ID);

Line 836: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 24, P_LINE_RLTSHIP_Rec.LINE_ADJUSTED_AMOUNT);

832: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 20, P_LINE_RLTSHIP_Rec.PRICE_LIST_NAME, 240);
833: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 21, P_LINE_RLTSHIP_Rec.PRICE_LIST_LINE_ID);
834: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 22, P_LINE_RLTSHIP_Rec.CURRENCY_CODE, 15);
835: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 23, P_LINE_RLTSHIP_Rec.LINE_LIST_PRICE);
836: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 24, P_LINE_RLTSHIP_Rec.LINE_ADJUSTED_AMOUNT);
837: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 25, P_LINE_RLTSHIP_Rec.LINE_ADJUSTED_PERCENT);
838: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 26, P_LINE_RLTSHIP_Rec.LINE_QUOTE_PRICE);
839: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 27, P_LINE_RLTSHIP_Rec.RELATED_ITEM_ID);
840: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 28, P_LINE_RLTSHIP_Rec.ITEM_RELATIONSHIP_TYPE, 15);

Line 837: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 25, P_LINE_RLTSHIP_Rec.LINE_ADJUSTED_PERCENT);

833: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 21, P_LINE_RLTSHIP_Rec.PRICE_LIST_LINE_ID);
834: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 22, P_LINE_RLTSHIP_Rec.CURRENCY_CODE, 15);
835: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 23, P_LINE_RLTSHIP_Rec.LINE_LIST_PRICE);
836: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 24, P_LINE_RLTSHIP_Rec.LINE_ADJUSTED_AMOUNT);
837: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 25, P_LINE_RLTSHIP_Rec.LINE_ADJUSTED_PERCENT);
838: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 26, P_LINE_RLTSHIP_Rec.LINE_QUOTE_PRICE);
839: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 27, P_LINE_RLTSHIP_Rec.RELATED_ITEM_ID);
840: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 28, P_LINE_RLTSHIP_Rec.ITEM_RELATIONSHIP_TYPE, 15);
841: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 29, P_LINE_RLTSHIP_Rec.ACCOUNTING_RULE_ID);

Line 838: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 26, P_LINE_RLTSHIP_Rec.LINE_QUOTE_PRICE);

834: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 22, P_LINE_RLTSHIP_Rec.CURRENCY_CODE, 15);
835: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 23, P_LINE_RLTSHIP_Rec.LINE_LIST_PRICE);
836: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 24, P_LINE_RLTSHIP_Rec.LINE_ADJUSTED_AMOUNT);
837: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 25, P_LINE_RLTSHIP_Rec.LINE_ADJUSTED_PERCENT);
838: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 26, P_LINE_RLTSHIP_Rec.LINE_QUOTE_PRICE);
839: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 27, P_LINE_RLTSHIP_Rec.RELATED_ITEM_ID);
840: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 28, P_LINE_RLTSHIP_Rec.ITEM_RELATIONSHIP_TYPE, 15);
841: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 29, P_LINE_RLTSHIP_Rec.ACCOUNTING_RULE_ID);
842: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 30, P_LINE_RLTSHIP_Rec.INVOICING_RULE_ID);

Line 839: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 27, P_LINE_RLTSHIP_Rec.RELATED_ITEM_ID);

835: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 23, P_LINE_RLTSHIP_Rec.LINE_LIST_PRICE);
836: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 24, P_LINE_RLTSHIP_Rec.LINE_ADJUSTED_AMOUNT);
837: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 25, P_LINE_RLTSHIP_Rec.LINE_ADJUSTED_PERCENT);
838: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 26, P_LINE_RLTSHIP_Rec.LINE_QUOTE_PRICE);
839: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 27, P_LINE_RLTSHIP_Rec.RELATED_ITEM_ID);
840: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 28, P_LINE_RLTSHIP_Rec.ITEM_RELATIONSHIP_TYPE, 15);
841: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 29, P_LINE_RLTSHIP_Rec.ACCOUNTING_RULE_ID);
842: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 30, P_LINE_RLTSHIP_Rec.INVOICING_RULE_ID);
843: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 31, P_LINE_RLTSHIP_Rec.SPLIT_SHIPMENT_FLAG, 1);

Line 840: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 28, P_LINE_RLTSHIP_Rec.ITEM_RELATIONSHIP_TYPE, 15);

836: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 24, P_LINE_RLTSHIP_Rec.LINE_ADJUSTED_AMOUNT);
837: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 25, P_LINE_RLTSHIP_Rec.LINE_ADJUSTED_PERCENT);
838: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 26, P_LINE_RLTSHIP_Rec.LINE_QUOTE_PRICE);
839: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 27, P_LINE_RLTSHIP_Rec.RELATED_ITEM_ID);
840: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 28, P_LINE_RLTSHIP_Rec.ITEM_RELATIONSHIP_TYPE, 15);
841: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 29, P_LINE_RLTSHIP_Rec.ACCOUNTING_RULE_ID);
842: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 30, P_LINE_RLTSHIP_Rec.INVOICING_RULE_ID);
843: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 31, P_LINE_RLTSHIP_Rec.SPLIT_SHIPMENT_FLAG, 1);
844: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 32, P_LINE_RLTSHIP_Rec.BACKORDER_FLAG, 1);

Line 841: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 29, P_LINE_RLTSHIP_Rec.ACCOUNTING_RULE_ID);

837: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 25, P_LINE_RLTSHIP_Rec.LINE_ADJUSTED_PERCENT);
838: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 26, P_LINE_RLTSHIP_Rec.LINE_QUOTE_PRICE);
839: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 27, P_LINE_RLTSHIP_Rec.RELATED_ITEM_ID);
840: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 28, P_LINE_RLTSHIP_Rec.ITEM_RELATIONSHIP_TYPE, 15);
841: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 29, P_LINE_RLTSHIP_Rec.ACCOUNTING_RULE_ID);
842: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 30, P_LINE_RLTSHIP_Rec.INVOICING_RULE_ID);
843: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 31, P_LINE_RLTSHIP_Rec.SPLIT_SHIPMENT_FLAG, 1);
844: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 32, P_LINE_RLTSHIP_Rec.BACKORDER_FLAG, 1);
845: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 33, P_LINE_RLTSHIP_Rec.QUOTE_LINE_DETAIL_ID);

Line 842: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 30, P_LINE_RLTSHIP_Rec.INVOICING_RULE_ID);

838: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 26, P_LINE_RLTSHIP_Rec.LINE_QUOTE_PRICE);
839: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 27, P_LINE_RLTSHIP_Rec.RELATED_ITEM_ID);
840: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 28, P_LINE_RLTSHIP_Rec.ITEM_RELATIONSHIP_TYPE, 15);
841: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 29, P_LINE_RLTSHIP_Rec.ACCOUNTING_RULE_ID);
842: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 30, P_LINE_RLTSHIP_Rec.INVOICING_RULE_ID);
843: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 31, P_LINE_RLTSHIP_Rec.SPLIT_SHIPMENT_FLAG, 1);
844: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 32, P_LINE_RLTSHIP_Rec.BACKORDER_FLAG, 1);
845: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 33, P_LINE_RLTSHIP_Rec.QUOTE_LINE_DETAIL_ID);
846: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 34, P_LINE_RLTSHIP_Rec.SERVICE_COTERMINATE_FLAG, 240);

Line 843: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 31, P_LINE_RLTSHIP_Rec.SPLIT_SHIPMENT_FLAG, 1);

839: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 27, P_LINE_RLTSHIP_Rec.RELATED_ITEM_ID);
840: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 28, P_LINE_RLTSHIP_Rec.ITEM_RELATIONSHIP_TYPE, 15);
841: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 29, P_LINE_RLTSHIP_Rec.ACCOUNTING_RULE_ID);
842: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 30, P_LINE_RLTSHIP_Rec.INVOICING_RULE_ID);
843: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 31, P_LINE_RLTSHIP_Rec.SPLIT_SHIPMENT_FLAG, 1);
844: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 32, P_LINE_RLTSHIP_Rec.BACKORDER_FLAG, 1);
845: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 33, P_LINE_RLTSHIP_Rec.QUOTE_LINE_DETAIL_ID);
846: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 34, P_LINE_RLTSHIP_Rec.SERVICE_COTERMINATE_FLAG, 240);
847: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 35, P_LINE_RLTSHIP_Rec.SERVICE_DURATION);

Line 844: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 32, P_LINE_RLTSHIP_Rec.BACKORDER_FLAG, 1);

840: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 28, P_LINE_RLTSHIP_Rec.ITEM_RELATIONSHIP_TYPE, 15);
841: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 29, P_LINE_RLTSHIP_Rec.ACCOUNTING_RULE_ID);
842: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 30, P_LINE_RLTSHIP_Rec.INVOICING_RULE_ID);
843: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 31, P_LINE_RLTSHIP_Rec.SPLIT_SHIPMENT_FLAG, 1);
844: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 32, P_LINE_RLTSHIP_Rec.BACKORDER_FLAG, 1);
845: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 33, P_LINE_RLTSHIP_Rec.QUOTE_LINE_DETAIL_ID);
846: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 34, P_LINE_RLTSHIP_Rec.SERVICE_COTERMINATE_FLAG, 240);
847: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 35, P_LINE_RLTSHIP_Rec.SERVICE_DURATION);
848: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 36, P_LINE_RLTSHIP_Rec.SERVICE_UNIT_SELLING_PERCENT);

Line 845: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 33, P_LINE_RLTSHIP_Rec.QUOTE_LINE_DETAIL_ID);

841: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 29, P_LINE_RLTSHIP_Rec.ACCOUNTING_RULE_ID);
842: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 30, P_LINE_RLTSHIP_Rec.INVOICING_RULE_ID);
843: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 31, P_LINE_RLTSHIP_Rec.SPLIT_SHIPMENT_FLAG, 1);
844: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 32, P_LINE_RLTSHIP_Rec.BACKORDER_FLAG, 1);
845: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 33, P_LINE_RLTSHIP_Rec.QUOTE_LINE_DETAIL_ID);
846: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 34, P_LINE_RLTSHIP_Rec.SERVICE_COTERMINATE_FLAG, 240);
847: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 35, P_LINE_RLTSHIP_Rec.SERVICE_DURATION);
848: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 36, P_LINE_RLTSHIP_Rec.SERVICE_UNIT_SELLING_PERCENT);
849: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 37, P_LINE_RLTSHIP_Rec.SERVICE_UNIT_LIST_PERCENT);

Line 846: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 34, P_LINE_RLTSHIP_Rec.SERVICE_COTERMINATE_FLAG, 240);

842: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 30, P_LINE_RLTSHIP_Rec.INVOICING_RULE_ID);
843: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 31, P_LINE_RLTSHIP_Rec.SPLIT_SHIPMENT_FLAG, 1);
844: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 32, P_LINE_RLTSHIP_Rec.BACKORDER_FLAG, 1);
845: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 33, P_LINE_RLTSHIP_Rec.QUOTE_LINE_DETAIL_ID);
846: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 34, P_LINE_RLTSHIP_Rec.SERVICE_COTERMINATE_FLAG, 240);
847: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 35, P_LINE_RLTSHIP_Rec.SERVICE_DURATION);
848: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 36, P_LINE_RLTSHIP_Rec.SERVICE_UNIT_SELLING_PERCENT);
849: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 37, P_LINE_RLTSHIP_Rec.SERVICE_UNIT_LIST_PERCENT);
850: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 38, P_LINE_RLTSHIP_Rec.SERVICE_NUMBER);

Line 847: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 35, P_LINE_RLTSHIP_Rec.SERVICE_DURATION);

843: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 31, P_LINE_RLTSHIP_Rec.SPLIT_SHIPMENT_FLAG, 1);
844: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 32, P_LINE_RLTSHIP_Rec.BACKORDER_FLAG, 1);
845: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 33, P_LINE_RLTSHIP_Rec.QUOTE_LINE_DETAIL_ID);
846: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 34, P_LINE_RLTSHIP_Rec.SERVICE_COTERMINATE_FLAG, 240);
847: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 35, P_LINE_RLTSHIP_Rec.SERVICE_DURATION);
848: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 36, P_LINE_RLTSHIP_Rec.SERVICE_UNIT_SELLING_PERCENT);
849: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 37, P_LINE_RLTSHIP_Rec.SERVICE_UNIT_LIST_PERCENT);
850: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 38, P_LINE_RLTSHIP_Rec.SERVICE_NUMBER);
851: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 39, P_LINE_RLTSHIP_Rec.UNIT_PERCENT_BASE_PRICE);

Line 848: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 36, P_LINE_RLTSHIP_Rec.SERVICE_UNIT_SELLING_PERCENT);

844: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 32, P_LINE_RLTSHIP_Rec.BACKORDER_FLAG, 1);
845: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 33, P_LINE_RLTSHIP_Rec.QUOTE_LINE_DETAIL_ID);
846: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 34, P_LINE_RLTSHIP_Rec.SERVICE_COTERMINATE_FLAG, 240);
847: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 35, P_LINE_RLTSHIP_Rec.SERVICE_DURATION);
848: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 36, P_LINE_RLTSHIP_Rec.SERVICE_UNIT_SELLING_PERCENT);
849: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 37, P_LINE_RLTSHIP_Rec.SERVICE_UNIT_LIST_PERCENT);
850: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 38, P_LINE_RLTSHIP_Rec.SERVICE_NUMBER);
851: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 39, P_LINE_RLTSHIP_Rec.UNIT_PERCENT_BASE_PRICE);
852: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 40, P_LINE_RLTSHIP_Rec.SERVICE_PERIOD, 240);

Line 849: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 37, P_LINE_RLTSHIP_Rec.SERVICE_UNIT_LIST_PERCENT);

845: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 33, P_LINE_RLTSHIP_Rec.QUOTE_LINE_DETAIL_ID);
846: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 34, P_LINE_RLTSHIP_Rec.SERVICE_COTERMINATE_FLAG, 240);
847: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 35, P_LINE_RLTSHIP_Rec.SERVICE_DURATION);
848: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 36, P_LINE_RLTSHIP_Rec.SERVICE_UNIT_SELLING_PERCENT);
849: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 37, P_LINE_RLTSHIP_Rec.SERVICE_UNIT_LIST_PERCENT);
850: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 38, P_LINE_RLTSHIP_Rec.SERVICE_NUMBER);
851: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 39, P_LINE_RLTSHIP_Rec.UNIT_PERCENT_BASE_PRICE);
852: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 40, P_LINE_RLTSHIP_Rec.SERVICE_PERIOD, 240);
853: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 41, P_LINE_RLTSHIP_Rec.ATTRIBUTE_CATEGORY, 30);

Line 850: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 38, P_LINE_RLTSHIP_Rec.SERVICE_NUMBER);

846: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 34, P_LINE_RLTSHIP_Rec.SERVICE_COTERMINATE_FLAG, 240);
847: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 35, P_LINE_RLTSHIP_Rec.SERVICE_DURATION);
848: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 36, P_LINE_RLTSHIP_Rec.SERVICE_UNIT_SELLING_PERCENT);
849: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 37, P_LINE_RLTSHIP_Rec.SERVICE_UNIT_LIST_PERCENT);
850: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 38, P_LINE_RLTSHIP_Rec.SERVICE_NUMBER);
851: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 39, P_LINE_RLTSHIP_Rec.UNIT_PERCENT_BASE_PRICE);
852: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 40, P_LINE_RLTSHIP_Rec.SERVICE_PERIOD, 240);
853: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 41, P_LINE_RLTSHIP_Rec.ATTRIBUTE_CATEGORY, 30);
854: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 42, P_LINE_RLTSHIP_Rec.ATTRIBUTE1, 150);

Line 851: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 39, P_LINE_RLTSHIP_Rec.UNIT_PERCENT_BASE_PRICE);

847: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 35, P_LINE_RLTSHIP_Rec.SERVICE_DURATION);
848: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 36, P_LINE_RLTSHIP_Rec.SERVICE_UNIT_SELLING_PERCENT);
849: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 37, P_LINE_RLTSHIP_Rec.SERVICE_UNIT_LIST_PERCENT);
850: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 38, P_LINE_RLTSHIP_Rec.SERVICE_NUMBER);
851: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 39, P_LINE_RLTSHIP_Rec.UNIT_PERCENT_BASE_PRICE);
852: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 40, P_LINE_RLTSHIP_Rec.SERVICE_PERIOD, 240);
853: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 41, P_LINE_RLTSHIP_Rec.ATTRIBUTE_CATEGORY, 30);
854: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 42, P_LINE_RLTSHIP_Rec.ATTRIBUTE1, 150);
855: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 43, P_LINE_RLTSHIP_Rec.ATTRIBUTE2, 150);

Line 852: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 40, P_LINE_RLTSHIP_Rec.SERVICE_PERIOD, 240);

848: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 36, P_LINE_RLTSHIP_Rec.SERVICE_UNIT_SELLING_PERCENT);
849: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 37, P_LINE_RLTSHIP_Rec.SERVICE_UNIT_LIST_PERCENT);
850: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 38, P_LINE_RLTSHIP_Rec.SERVICE_NUMBER);
851: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 39, P_LINE_RLTSHIP_Rec.UNIT_PERCENT_BASE_PRICE);
852: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 40, P_LINE_RLTSHIP_Rec.SERVICE_PERIOD, 240);
853: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 41, P_LINE_RLTSHIP_Rec.ATTRIBUTE_CATEGORY, 30);
854: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 42, P_LINE_RLTSHIP_Rec.ATTRIBUTE1, 150);
855: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 43, P_LINE_RLTSHIP_Rec.ATTRIBUTE2, 150);
856: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 44, P_LINE_RLTSHIP_Rec.ATTRIBUTE3, 150);

Line 853: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 41, P_LINE_RLTSHIP_Rec.ATTRIBUTE_CATEGORY, 30);

849: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 37, P_LINE_RLTSHIP_Rec.SERVICE_UNIT_LIST_PERCENT);
850: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 38, P_LINE_RLTSHIP_Rec.SERVICE_NUMBER);
851: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 39, P_LINE_RLTSHIP_Rec.UNIT_PERCENT_BASE_PRICE);
852: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 40, P_LINE_RLTSHIP_Rec.SERVICE_PERIOD, 240);
853: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 41, P_LINE_RLTSHIP_Rec.ATTRIBUTE_CATEGORY, 30);
854: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 42, P_LINE_RLTSHIP_Rec.ATTRIBUTE1, 150);
855: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 43, P_LINE_RLTSHIP_Rec.ATTRIBUTE2, 150);
856: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 44, P_LINE_RLTSHIP_Rec.ATTRIBUTE3, 150);
857: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 45, P_LINE_RLTSHIP_Rec.ATTRIBUTE4, 150);

Line 854: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 42, P_LINE_RLTSHIP_Rec.ATTRIBUTE1, 150);

850: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 38, P_LINE_RLTSHIP_Rec.SERVICE_NUMBER);
851: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 39, P_LINE_RLTSHIP_Rec.UNIT_PERCENT_BASE_PRICE);
852: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 40, P_LINE_RLTSHIP_Rec.SERVICE_PERIOD, 240);
853: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 41, P_LINE_RLTSHIP_Rec.ATTRIBUTE_CATEGORY, 30);
854: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 42, P_LINE_RLTSHIP_Rec.ATTRIBUTE1, 150);
855: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 43, P_LINE_RLTSHIP_Rec.ATTRIBUTE2, 150);
856: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 44, P_LINE_RLTSHIP_Rec.ATTRIBUTE3, 150);
857: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 45, P_LINE_RLTSHIP_Rec.ATTRIBUTE4, 150);
858: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 46, P_LINE_RLTSHIP_Rec.ATTRIBUTE5, 150);

Line 855: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 43, P_LINE_RLTSHIP_Rec.ATTRIBUTE2, 150);

851: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 39, P_LINE_RLTSHIP_Rec.UNIT_PERCENT_BASE_PRICE);
852: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 40, P_LINE_RLTSHIP_Rec.SERVICE_PERIOD, 240);
853: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 41, P_LINE_RLTSHIP_Rec.ATTRIBUTE_CATEGORY, 30);
854: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 42, P_LINE_RLTSHIP_Rec.ATTRIBUTE1, 150);
855: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 43, P_LINE_RLTSHIP_Rec.ATTRIBUTE2, 150);
856: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 44, P_LINE_RLTSHIP_Rec.ATTRIBUTE3, 150);
857: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 45, P_LINE_RLTSHIP_Rec.ATTRIBUTE4, 150);
858: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 46, P_LINE_RLTSHIP_Rec.ATTRIBUTE5, 150);
859: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 47, P_LINE_RLTSHIP_Rec.ATTRIBUTE6, 150);

Line 856: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 44, P_LINE_RLTSHIP_Rec.ATTRIBUTE3, 150);

852: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 40, P_LINE_RLTSHIP_Rec.SERVICE_PERIOD, 240);
853: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 41, P_LINE_RLTSHIP_Rec.ATTRIBUTE_CATEGORY, 30);
854: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 42, P_LINE_RLTSHIP_Rec.ATTRIBUTE1, 150);
855: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 43, P_LINE_RLTSHIP_Rec.ATTRIBUTE2, 150);
856: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 44, P_LINE_RLTSHIP_Rec.ATTRIBUTE3, 150);
857: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 45, P_LINE_RLTSHIP_Rec.ATTRIBUTE4, 150);
858: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 46, P_LINE_RLTSHIP_Rec.ATTRIBUTE5, 150);
859: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 47, P_LINE_RLTSHIP_Rec.ATTRIBUTE6, 150);
860: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 48, P_LINE_RLTSHIP_Rec.ATTRIBUTE7, 150);

Line 857: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 45, P_LINE_RLTSHIP_Rec.ATTRIBUTE4, 150);

853: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 41, P_LINE_RLTSHIP_Rec.ATTRIBUTE_CATEGORY, 30);
854: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 42, P_LINE_RLTSHIP_Rec.ATTRIBUTE1, 150);
855: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 43, P_LINE_RLTSHIP_Rec.ATTRIBUTE2, 150);
856: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 44, P_LINE_RLTSHIP_Rec.ATTRIBUTE3, 150);
857: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 45, P_LINE_RLTSHIP_Rec.ATTRIBUTE4, 150);
858: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 46, P_LINE_RLTSHIP_Rec.ATTRIBUTE5, 150);
859: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 47, P_LINE_RLTSHIP_Rec.ATTRIBUTE6, 150);
860: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 48, P_LINE_RLTSHIP_Rec.ATTRIBUTE7, 150);
861: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 49, P_LINE_RLTSHIP_Rec.ATTRIBUTE8, 150);

Line 858: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 46, P_LINE_RLTSHIP_Rec.ATTRIBUTE5, 150);

854: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 42, P_LINE_RLTSHIP_Rec.ATTRIBUTE1, 150);
855: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 43, P_LINE_RLTSHIP_Rec.ATTRIBUTE2, 150);
856: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 44, P_LINE_RLTSHIP_Rec.ATTRIBUTE3, 150);
857: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 45, P_LINE_RLTSHIP_Rec.ATTRIBUTE4, 150);
858: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 46, P_LINE_RLTSHIP_Rec.ATTRIBUTE5, 150);
859: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 47, P_LINE_RLTSHIP_Rec.ATTRIBUTE6, 150);
860: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 48, P_LINE_RLTSHIP_Rec.ATTRIBUTE7, 150);
861: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 49, P_LINE_RLTSHIP_Rec.ATTRIBUTE8, 150);
862: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 50, P_LINE_RLTSHIP_Rec.ATTRIBUTE9, 150);

Line 859: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 47, P_LINE_RLTSHIP_Rec.ATTRIBUTE6, 150);

855: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 43, P_LINE_RLTSHIP_Rec.ATTRIBUTE2, 150);
856: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 44, P_LINE_RLTSHIP_Rec.ATTRIBUTE3, 150);
857: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 45, P_LINE_RLTSHIP_Rec.ATTRIBUTE4, 150);
858: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 46, P_LINE_RLTSHIP_Rec.ATTRIBUTE5, 150);
859: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 47, P_LINE_RLTSHIP_Rec.ATTRIBUTE6, 150);
860: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 48, P_LINE_RLTSHIP_Rec.ATTRIBUTE7, 150);
861: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 49, P_LINE_RLTSHIP_Rec.ATTRIBUTE8, 150);
862: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 50, P_LINE_RLTSHIP_Rec.ATTRIBUTE9, 150);
863: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 51, P_LINE_RLTSHIP_Rec.ATTRIBUTE10, 150);

Line 860: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 48, P_LINE_RLTSHIP_Rec.ATTRIBUTE7, 150);

856: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 44, P_LINE_RLTSHIP_Rec.ATTRIBUTE3, 150);
857: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 45, P_LINE_RLTSHIP_Rec.ATTRIBUTE4, 150);
858: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 46, P_LINE_RLTSHIP_Rec.ATTRIBUTE5, 150);
859: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 47, P_LINE_RLTSHIP_Rec.ATTRIBUTE6, 150);
860: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 48, P_LINE_RLTSHIP_Rec.ATTRIBUTE7, 150);
861: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 49, P_LINE_RLTSHIP_Rec.ATTRIBUTE8, 150);
862: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 50, P_LINE_RLTSHIP_Rec.ATTRIBUTE9, 150);
863: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 51, P_LINE_RLTSHIP_Rec.ATTRIBUTE10, 150);
864: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 52, P_LINE_RLTSHIP_Rec.ATTRIBUTE11, 150);

Line 861: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 49, P_LINE_RLTSHIP_Rec.ATTRIBUTE8, 150);

857: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 45, P_LINE_RLTSHIP_Rec.ATTRIBUTE4, 150);
858: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 46, P_LINE_RLTSHIP_Rec.ATTRIBUTE5, 150);
859: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 47, P_LINE_RLTSHIP_Rec.ATTRIBUTE6, 150);
860: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 48, P_LINE_RLTSHIP_Rec.ATTRIBUTE7, 150);
861: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 49, P_LINE_RLTSHIP_Rec.ATTRIBUTE8, 150);
862: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 50, P_LINE_RLTSHIP_Rec.ATTRIBUTE9, 150);
863: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 51, P_LINE_RLTSHIP_Rec.ATTRIBUTE10, 150);
864: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 52, P_LINE_RLTSHIP_Rec.ATTRIBUTE11, 150);
865: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 53, P_LINE_RLTSHIP_Rec.ATTRIBUTE12, 150);

Line 862: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 50, P_LINE_RLTSHIP_Rec.ATTRIBUTE9, 150);

858: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 46, P_LINE_RLTSHIP_Rec.ATTRIBUTE5, 150);
859: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 47, P_LINE_RLTSHIP_Rec.ATTRIBUTE6, 150);
860: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 48, P_LINE_RLTSHIP_Rec.ATTRIBUTE7, 150);
861: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 49, P_LINE_RLTSHIP_Rec.ATTRIBUTE8, 150);
862: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 50, P_LINE_RLTSHIP_Rec.ATTRIBUTE9, 150);
863: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 51, P_LINE_RLTSHIP_Rec.ATTRIBUTE10, 150);
864: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 52, P_LINE_RLTSHIP_Rec.ATTRIBUTE11, 150);
865: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 53, P_LINE_RLTSHIP_Rec.ATTRIBUTE12, 150);
866: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 54, P_LINE_RLTSHIP_Rec.ATTRIBUTE13, 150);

Line 863: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 51, P_LINE_RLTSHIP_Rec.ATTRIBUTE10, 150);

859: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 47, P_LINE_RLTSHIP_Rec.ATTRIBUTE6, 150);
860: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 48, P_LINE_RLTSHIP_Rec.ATTRIBUTE7, 150);
861: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 49, P_LINE_RLTSHIP_Rec.ATTRIBUTE8, 150);
862: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 50, P_LINE_RLTSHIP_Rec.ATTRIBUTE9, 150);
863: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 51, P_LINE_RLTSHIP_Rec.ATTRIBUTE10, 150);
864: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 52, P_LINE_RLTSHIP_Rec.ATTRIBUTE11, 150);
865: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 53, P_LINE_RLTSHIP_Rec.ATTRIBUTE12, 150);
866: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 54, P_LINE_RLTSHIP_Rec.ATTRIBUTE13, 150);
867: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 55, P_LINE_RLTSHIP_Rec.ATTRIBUTE14, 150);

Line 864: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 52, P_LINE_RLTSHIP_Rec.ATTRIBUTE11, 150);

860: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 48, P_LINE_RLTSHIP_Rec.ATTRIBUTE7, 150);
861: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 49, P_LINE_RLTSHIP_Rec.ATTRIBUTE8, 150);
862: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 50, P_LINE_RLTSHIP_Rec.ATTRIBUTE9, 150);
863: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 51, P_LINE_RLTSHIP_Rec.ATTRIBUTE10, 150);
864: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 52, P_LINE_RLTSHIP_Rec.ATTRIBUTE11, 150);
865: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 53, P_LINE_RLTSHIP_Rec.ATTRIBUTE12, 150);
866: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 54, P_LINE_RLTSHIP_Rec.ATTRIBUTE13, 150);
867: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 55, P_LINE_RLTSHIP_Rec.ATTRIBUTE14, 150);
868: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 56, P_LINE_RLTSHIP_Rec.ATTRIBUTE15, 150);

Line 865: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 53, P_LINE_RLTSHIP_Rec.ATTRIBUTE12, 150);

861: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 49, P_LINE_RLTSHIP_Rec.ATTRIBUTE8, 150);
862: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 50, P_LINE_RLTSHIP_Rec.ATTRIBUTE9, 150);
863: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 51, P_LINE_RLTSHIP_Rec.ATTRIBUTE10, 150);
864: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 52, P_LINE_RLTSHIP_Rec.ATTRIBUTE11, 150);
865: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 53, P_LINE_RLTSHIP_Rec.ATTRIBUTE12, 150);
866: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 54, P_LINE_RLTSHIP_Rec.ATTRIBUTE13, 150);
867: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 55, P_LINE_RLTSHIP_Rec.ATTRIBUTE14, 150);
868: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 56, P_LINE_RLTSHIP_Rec.ATTRIBUTE15, 150);
869:

Line 866: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 54, P_LINE_RLTSHIP_Rec.ATTRIBUTE13, 150);

862: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 50, P_LINE_RLTSHIP_Rec.ATTRIBUTE9, 150);
863: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 51, P_LINE_RLTSHIP_Rec.ATTRIBUTE10, 150);
864: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 52, P_LINE_RLTSHIP_Rec.ATTRIBUTE11, 150);
865: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 53, P_LINE_RLTSHIP_Rec.ATTRIBUTE12, 150);
866: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 54, P_LINE_RLTSHIP_Rec.ATTRIBUTE13, 150);
867: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 55, P_LINE_RLTSHIP_Rec.ATTRIBUTE14, 150);
868: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 56, P_LINE_RLTSHIP_Rec.ATTRIBUTE15, 150);
869:
870: -- Debug Message

Line 867: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 55, P_LINE_RLTSHIP_Rec.ATTRIBUTE14, 150);

863: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 51, P_LINE_RLTSHIP_Rec.ATTRIBUTE10, 150);
864: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 52, P_LINE_RLTSHIP_Rec.ATTRIBUTE11, 150);
865: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 53, P_LINE_RLTSHIP_Rec.ATTRIBUTE12, 150);
866: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 54, P_LINE_RLTSHIP_Rec.ATTRIBUTE13, 150);
867: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 55, P_LINE_RLTSHIP_Rec.ATTRIBUTE14, 150);
868: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 56, P_LINE_RLTSHIP_Rec.ATTRIBUTE15, 150);
869:
870: -- Debug Message
871: --ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Define Columns Ends');

Line 868: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 56, P_LINE_RLTSHIP_Rec.ATTRIBUTE15, 150);

864: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 52, P_LINE_RLTSHIP_Rec.ATTRIBUTE11, 150);
865: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 53, P_LINE_RLTSHIP_Rec.ATTRIBUTE12, 150);
866: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 54, P_LINE_RLTSHIP_Rec.ATTRIBUTE13, 150);
867: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 55, P_LINE_RLTSHIP_Rec.ATTRIBUTE14, 150);
868: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 56, P_LINE_RLTSHIP_Rec.ATTRIBUTE15, 150);
869:
870: -- Debug Message
871: --ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Define Columns Ends');
872: */

Line 903: DBMS_SQL.BIND_VARIABLE(p_cur_get_LINE_RLTSHIP, ':p_LINE_RELATIONSHIP_ID', P_LINE_RLTSHIP_Rec.LINE_RELATIONSHIP_ID);

899: -- The following example applies to all columns,
900: -- developers can copy and paste them.
901: IF( (P_LINE_RLTSHIP_Rec.LINE_RELATIONSHIP_ID IS NOT NULL) AND (P_LINE_RLTSHIP_Rec.LINE_RELATIONSHIP_ID <> FND_API.G_MISS_NUM) )
902: THEN
903: DBMS_SQL.BIND_VARIABLE(p_cur_get_LINE_RLTSHIP, ':p_LINE_RELATIONSHIP_ID', P_LINE_RLTSHIP_Rec.LINE_RELATIONSHIP_ID);
904: END IF;
905:
906: -- Debug Message
907: --ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Bind Variables Ends');