APPS.CSI_T_TXN_LINE_DTLS_PVT dependencies on DBMS_SQL

Line 2618: dbms_sql.bind_variable(p_dtl_qry_cur_id,'transaction_line_id',

2614:
2615: -- transaction lines variables bind
2616: IF nvl(p_txn_line_query_rec.transaction_line_id,fnd_api.g_miss_num) <>
2617: fnd_api.g_miss_num THEN
2618: dbms_sql.bind_variable(p_dtl_qry_cur_id,'transaction_line_id',
2619: p_txn_line_query_rec.transaction_line_id);
2620: END IF;
2621:
2622: IF nvl(p_txn_line_query_rec.source_txn_header_id,fnd_api.g_miss_num) <>

Line 2624: dbms_sql.bind_variable(p_dtl_qry_cur_id,'source_txn_header_id',

2620: END IF;
2621:
2622: IF nvl(p_txn_line_query_rec.source_txn_header_id,fnd_api.g_miss_num) <>
2623: fnd_api.g_miss_num THEN
2624: dbms_sql.bind_variable(p_dtl_qry_cur_id,'source_txn_header_id',
2625: p_txn_line_query_rec.source_txn_header_id);
2626: END IF;
2627:
2628: IF nvl(p_txn_line_query_rec.source_transaction_id,fnd_api.g_miss_num) <>

Line 2630: dbms_sql.bind_variable(p_dtl_qry_cur_id,'source_transaction_id',

2626: END IF;
2627:
2628: IF nvl(p_txn_line_query_rec.source_transaction_id,fnd_api.g_miss_num) <>
2629: fnd_api.g_miss_num THEN
2630: dbms_sql.bind_variable(p_dtl_qry_cur_id,'source_transaction_id',
2631: p_txn_line_query_rec.source_transaction_id);
2632: END IF;
2633:
2634: IF nvl(p_txn_line_query_rec.source_transaction_table,fnd_api.g_miss_char) <>

Line 2636: dbms_sql.bind_variable(p_dtl_qry_cur_id,'source_transaction_table',

2632: END IF;
2633:
2634: IF nvl(p_txn_line_query_rec.source_transaction_table,fnd_api.g_miss_char) <>
2635: fnd_api.g_miss_char THEN
2636: dbms_sql.bind_variable(p_dtl_qry_cur_id,'source_transaction_table',
2637: p_txn_line_query_rec.source_transaction_table);
2638: END IF;
2639:
2640: IF nvl(p_txn_line_query_rec.error_code,fnd_api.g_miss_char) <>

Line 2642: dbms_sql.bind_variable(p_dtl_qry_cur_id,'error_code',

2638: END IF;
2639:
2640: IF nvl(p_txn_line_query_rec.error_code,fnd_api.g_miss_char) <>
2641: fnd_api.g_miss_char THEN
2642: dbms_sql.bind_variable(p_dtl_qry_cur_id,'error_code',
2643: p_txn_line_query_rec.error_code);
2644: END IF;
2645:
2646: IF nvl(p_txn_line_query_rec.processing_status,fnd_api.g_miss_char) <>

Line 2648: dbms_sql.bind_variable(p_dtl_qry_cur_id,'processing_status',

2644: END IF;
2645:
2646: IF nvl(p_txn_line_query_rec.processing_status,fnd_api.g_miss_char) <>
2647: fnd_api.g_miss_char THEN
2648: dbms_sql.bind_variable(p_dtl_qry_cur_id,'processing_status',
2649: p_txn_line_query_rec.processing_status);
2650: END IF;
2651:
2652: IF nvl(p_txn_line_query_rec.config_session_hdr_id,fnd_api.g_miss_num) <>

Line 2654: dbms_sql.bind_variable(p_dtl_qry_cur_id,'config_session_hdr_id',

2650: END IF;
2651:
2652: IF nvl(p_txn_line_query_rec.config_session_hdr_id,fnd_api.g_miss_num) <>
2653: fnd_api.g_miss_num THEN
2654: dbms_sql.bind_variable(p_dtl_qry_cur_id,'config_session_hdr_id',
2655: p_txn_line_query_rec.config_session_hdr_id);
2656: END IF;
2657:
2658: IF nvl(p_txn_line_query_rec.config_session_rev_num,fnd_api.g_miss_num) <>

Line 2660: dbms_sql.bind_variable(p_dtl_qry_cur_id,'config_session_rev_num',

2656: END IF;
2657:
2658: IF nvl(p_txn_line_query_rec.config_session_rev_num,fnd_api.g_miss_num) <>
2659: fnd_api.g_miss_num THEN
2660: dbms_sql.bind_variable(p_dtl_qry_cur_id,'config_session_rev_num',
2661: p_txn_line_query_rec.config_session_rev_num);
2662: END IF;
2663:
2664: IF nvl(p_txn_line_query_rec.config_session_item_id,fnd_api.g_miss_num) <>

Line 2666: dbms_sql.bind_variable(p_dtl_qry_cur_id,'config_session_item_id',

2662: END IF;
2663:
2664: IF nvl(p_txn_line_query_rec.config_session_item_id,fnd_api.g_miss_num) <>
2665: fnd_api.g_miss_num THEN
2666: dbms_sql.bind_variable(p_dtl_qry_cur_id,'config_session_item_id',
2667: p_txn_line_query_rec.config_session_item_id);
2668: END IF;
2669:
2670: -- txn_line details variables bind

Line 2675: dbms_sql.bind_variable(p_dtl_qry_cur_id, 'dtl_transaction_line_id',

2671:
2672: IF nvl(p_txn_line_detail_query_rec.transaction_line_id, fnd_api.g_miss_num) <>
2673: fnd_api.g_miss_num
2674: THEN
2675: dbms_sql.bind_variable(p_dtl_qry_cur_id, 'dtl_transaction_line_id',
2676: p_txn_line_detail_query_rec.transaction_line_id);
2677: END IF;
2678:
2679: IF nvl(p_txn_line_detail_query_rec.txn_line_detail_id, fnd_api.g_miss_num) <>

Line 2682: dbms_sql.bind_variable(p_dtl_qry_cur_id,'txn_line_detail_id',

2678:
2679: IF nvl(p_txn_line_detail_query_rec.txn_line_detail_id, fnd_api.g_miss_num) <>
2680: fnd_api.g_miss_num
2681: THEN
2682: dbms_sql.bind_variable(p_dtl_qry_cur_id,'txn_line_detail_id',
2683: p_txn_line_detail_query_rec.txn_line_detail_id);
2684: END IF;
2685:
2686: IF nvl(p_txn_line_detail_query_rec.sub_type_id,fnd_api.g_miss_num) <>

Line 2688: dbms_sql.bind_variable(p_dtl_qry_cur_id,'sub_type_id',

2684: END IF;
2685:
2686: IF nvl(p_txn_line_detail_query_rec.sub_type_id,fnd_api.g_miss_num) <>
2687: fnd_api.g_miss_num THEN
2688: dbms_sql.bind_variable(p_dtl_qry_cur_id,'sub_type_id',
2689: p_txn_line_detail_query_rec.sub_type_id);
2690: END IF;
2691:
2692: IF nvl(p_txn_line_detail_query_rec.instance_exists_flag, fnd_api.g_miss_char) <>

Line 2695: dbms_sql.bind_variable(p_dtl_qry_cur_id,'instance_exists_flag',

2691:
2692: IF nvl(p_txn_line_detail_query_rec.instance_exists_flag, fnd_api.g_miss_char) <>
2693: fnd_api.g_miss_char
2694: THEN
2695: dbms_sql.bind_variable(p_dtl_qry_cur_id,'instance_exists_flag',
2696: p_txn_line_detail_query_rec.instance_exists_flag);
2697: END IF;
2698:
2699: IF nvl(p_txn_line_detail_query_rec.instance_id, fnd_api.g_miss_num) <>

Line 2702: dbms_sql.bind_variable(p_dtl_qry_cur_id,'instance_id',

2698:
2699: IF nvl(p_txn_line_detail_query_rec.instance_id, fnd_api.g_miss_num) <>
2700: fnd_api.g_miss_num
2701: THEN
2702: dbms_sql.bind_variable(p_dtl_qry_cur_id,'instance_id',
2703: p_txn_line_detail_query_rec.instance_id);
2704: END IF;
2705:
2706: IF nvl(p_txn_line_detail_query_rec.csi_transaction_id, fnd_api.g_miss_num) <>

Line 2709: dbms_sql.bind_variable(p_dtl_qry_cur_id,'csi_transaction_id',

2705:
2706: IF nvl(p_txn_line_detail_query_rec.csi_transaction_id, fnd_api.g_miss_num) <>
2707: fnd_api.g_miss_num
2708: THEN
2709: dbms_sql.bind_variable(p_dtl_qry_cur_id,'csi_transaction_id',
2710: p_txn_line_detail_query_rec.csi_transaction_id);
2711: END IF;
2712:
2713: IF nvl(p_txn_line_detail_query_rec.source_transaction_flag, fnd_api.g_miss_char) <>

Line 2716: dbms_sql.bind_variable(p_dtl_qry_cur_id,'source_transaction_flag',

2712:
2713: IF nvl(p_txn_line_detail_query_rec.source_transaction_flag, fnd_api.g_miss_char) <>
2714: fnd_api.g_miss_char
2715: THEN
2716: dbms_sql.bind_variable(p_dtl_qry_cur_id,'source_transaction_flag',
2717: p_txn_line_detail_query_rec.source_transaction_flag);
2718: END IF;
2719:
2720: IF nvl(p_txn_line_detail_query_rec.csi_system_id, fnd_api.g_miss_num) <>

Line 2723: dbms_sql.bind_variable(p_dtl_qry_cur_id,'csi_system_id',

2719:
2720: IF nvl(p_txn_line_detail_query_rec.csi_system_id, fnd_api.g_miss_num) <>
2721: fnd_api.g_miss_num
2722: THEN
2723: dbms_sql.bind_variable(p_dtl_qry_cur_id,'csi_system_id',
2724: p_txn_line_detail_query_rec.csi_system_id);
2725: END IF;
2726:
2727: IF nvl(p_txn_line_detail_query_rec.transaction_system_id, fnd_api.g_miss_num) <>

Line 2730: dbms_sql.bind_variable(p_dtl_qry_cur_id,'transaction_system_id',

2726:
2727: IF nvl(p_txn_line_detail_query_rec.transaction_system_id, fnd_api.g_miss_num) <>
2728: fnd_api.g_miss_num
2729: THEN
2730: dbms_sql.bind_variable(p_dtl_qry_cur_id,'transaction_system_id',
2731: p_txn_line_detail_query_rec.transaction_system_id);
2732: END IF;
2733:
2734: IF nvl(p_txn_line_detail_query_rec.inventory_item_id, fnd_api.g_miss_num) <>

Line 2737: dbms_sql.bind_variable(p_dtl_qry_cur_id,'inventory_item_id',

2733:
2734: IF nvl(p_txn_line_detail_query_rec.inventory_item_id, fnd_api.g_miss_num) <>
2735: fnd_api.g_miss_num
2736: THEN
2737: dbms_sql.bind_variable(p_dtl_qry_cur_id,'inventory_item_id',
2738: p_txn_line_detail_query_rec.inventory_item_id);
2739: END IF;
2740:
2741: IF nvl(p_txn_line_detail_query_rec.inventory_revision, fnd_api.g_miss_char) <>

Line 2744: dbms_sql.bind_variable(p_dtl_qry_cur_id,'inventory_revision',

2740:
2741: IF nvl(p_txn_line_detail_query_rec.inventory_revision, fnd_api.g_miss_char) <>
2742: fnd_api.g_miss_char
2743: THEN
2744: dbms_sql.bind_variable(p_dtl_qry_cur_id,'inventory_revision',
2745: p_txn_line_detail_query_rec.inventory_revision);
2746: END IF;
2747:
2748: IF nvl(p_txn_line_detail_query_rec.inv_organization_id, fnd_api.g_miss_num) <>

Line 2751: dbms_sql.bind_variable(p_dtl_qry_cur_id,'inv_organization_id',

2747:
2748: IF nvl(p_txn_line_detail_query_rec.inv_organization_id, fnd_api.g_miss_num) <>
2749: fnd_api.g_miss_num
2750: THEN
2751: dbms_sql.bind_variable(p_dtl_qry_cur_id,'inv_organization_id',
2752: p_txn_line_detail_query_rec.inv_organization_id);
2753: END IF;
2754:
2755: IF nvl(p_txn_line_detail_query_rec.serial_number, fnd_api.g_miss_char) <>

Line 2758: dbms_sql.bind_variable(p_dtl_qry_cur_id,'serial_number',

2754:
2755: IF nvl(p_txn_line_detail_query_rec.serial_number, fnd_api.g_miss_char) <>
2756: fnd_api.g_miss_char
2757: THEN
2758: dbms_sql.bind_variable(p_dtl_qry_cur_id,'serial_number',
2759: p_txn_line_detail_query_rec.serial_number);
2760: END IF;
2761:
2762: IF nvl(p_txn_line_detail_query_rec.mfg_serial_number_flag, fnd_api.g_miss_char) <>

Line 2765: dbms_sql.bind_variable(p_dtl_qry_cur_id,'mfg_serial_number_flag',

2761:
2762: IF nvl(p_txn_line_detail_query_rec.mfg_serial_number_flag, fnd_api.g_miss_char) <>
2763: fnd_api.g_miss_char
2764: THEN
2765: dbms_sql.bind_variable(p_dtl_qry_cur_id,'mfg_serial_number_flag',
2766: p_txn_line_detail_query_rec.mfg_serial_number_flag);
2767: END IF;
2768:
2769: IF nvl(p_txn_line_detail_query_rec.lot_number, fnd_api.g_miss_char) <>

Line 2772: dbms_sql.bind_variable(p_dtl_qry_cur_id,'lot_number',

2768:
2769: IF nvl(p_txn_line_detail_query_rec.lot_number, fnd_api.g_miss_char) <>
2770: fnd_api.g_miss_char
2771: THEN
2772: dbms_sql.bind_variable(p_dtl_qry_cur_id,'lot_number',
2773: p_txn_line_detail_query_rec.lot_number);
2774: END IF;
2775:
2776: IF nvl(p_txn_line_detail_query_rec.location_type_code, fnd_api.g_miss_char) <>

Line 2779: dbms_sql.bind_variable(p_dtl_qry_cur_id,'location_type_code',

2775:
2776: IF nvl(p_txn_line_detail_query_rec.location_type_code, fnd_api.g_miss_char) <>
2777: fnd_api.g_miss_char
2778: THEN
2779: dbms_sql.bind_variable(p_dtl_qry_cur_id,'location_type_code',
2780: p_txn_line_detail_query_rec.location_type_code);
2781: END IF;
2782:
2783: IF nvl(p_txn_line_detail_query_rec.external_reference, fnd_api.g_miss_char) <>

Line 2786: dbms_sql.bind_variable(p_dtl_qry_cur_id,'external_reference',

2782:
2783: IF nvl(p_txn_line_detail_query_rec.external_reference, fnd_api.g_miss_char) <>
2784: fnd_api.g_miss_char
2785: THEN
2786: dbms_sql.bind_variable(p_dtl_qry_cur_id,'external_reference',
2787: p_txn_line_detail_query_rec.external_reference);
2788: END IF;
2789:
2790: IF nvl(p_txn_line_detail_query_rec.error_code, fnd_api.g_miss_char) <>

Line 2793: dbms_sql.bind_variable(p_dtl_qry_cur_id,'dtl_error_code',

2789:
2790: IF nvl(p_txn_line_detail_query_rec.error_code, fnd_api.g_miss_char) <>
2791: fnd_api.g_miss_char
2792: THEN
2793: dbms_sql.bind_variable(p_dtl_qry_cur_id,'dtl_error_code',
2794: p_txn_line_detail_query_rec.error_code);
2795: END IF;
2796:
2797: IF nvl(p_txn_line_detail_query_rec.error_explanation, fnd_api.g_miss_char) <>

Line 2800: dbms_sql.bind_variable(p_dtl_qry_cur_id,'dtl_error_explanation',

2796:
2797: IF nvl(p_txn_line_detail_query_rec.error_explanation, fnd_api.g_miss_char) <>
2798: fnd_api.g_miss_char
2799: THEN
2800: dbms_sql.bind_variable(p_dtl_qry_cur_id,'dtl_error_explanation',
2801: p_txn_line_detail_query_rec.error_explanation);
2802: END IF;
2803:
2804: IF nvl(p_txn_line_detail_query_rec.return_by_date, fnd_api.g_miss_date) <>

Line 2807: dbms_sql.bind_variable(p_dtl_qry_cur_id,'return_by_date',

2803:
2804: IF nvl(p_txn_line_detail_query_rec.return_by_date, fnd_api.g_miss_date) <>
2805: fnd_api.g_miss_date
2806: THEN
2807: dbms_sql.bind_variable(p_dtl_qry_cur_id,'return_by_date',
2808: p_txn_line_detail_query_rec.return_by_date);
2809: END IF;
2810:
2811: EXCEPTION

Line 2839: l_dtl_qry_cur_id := dbms_sql.open_cursor;

2835: BEGIN
2836:
2837: api_log('get_dtls_dynamic');
2838:
2839: l_dtl_qry_cur_id := dbms_sql.open_cursor;
2840:
2841: dbms_sql.parse(l_dtl_qry_cur_id, p_dtl_select_stmt , dbms_sql.native);
2842:
2843: bind_query_variables(

Line 2841: dbms_sql.parse(l_dtl_qry_cur_id, p_dtl_select_stmt , dbms_sql.native);

2837: api_log('get_dtls_dynamic');
2838:
2839: l_dtl_qry_cur_id := dbms_sql.open_cursor;
2840:
2841: dbms_sql.parse(l_dtl_qry_cur_id, p_dtl_select_stmt , dbms_sql.native);
2842:
2843: bind_query_variables(
2844: p_dtl_qry_cur_id => l_dtl_qry_cur_id,
2845: p_txn_line_query_rec => p_txn_line_query_rec,

Line 2853: dbms_sql.define_column(l_dtl_qry_cur_id, 1, l_line_dtl_rec.txn_line_detail_id);

2849: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2850: RAISE fnd_api.g_exc_error;
2851: END IF;
2852:
2853: dbms_sql.define_column(l_dtl_qry_cur_id, 1, l_line_dtl_rec.txn_line_detail_id);
2854: dbms_sql.define_column(l_dtl_qry_cur_id, 2, l_line_dtl_rec.transaction_line_id);
2855: dbms_sql.define_column(l_dtl_qry_cur_id, 3, l_line_dtl_rec.sub_type_id);
2856: dbms_sql.define_column(l_dtl_qry_cur_id, 4, l_line_dtl_rec.instance_exists_flag, 1);
2857: dbms_sql.define_column(l_dtl_qry_cur_id, 5, l_line_dtl_rec.source_transaction_flag,1);

Line 2854: dbms_sql.define_column(l_dtl_qry_cur_id, 2, l_line_dtl_rec.transaction_line_id);

2850: RAISE fnd_api.g_exc_error;
2851: END IF;
2852:
2853: dbms_sql.define_column(l_dtl_qry_cur_id, 1, l_line_dtl_rec.txn_line_detail_id);
2854: dbms_sql.define_column(l_dtl_qry_cur_id, 2, l_line_dtl_rec.transaction_line_id);
2855: dbms_sql.define_column(l_dtl_qry_cur_id, 3, l_line_dtl_rec.sub_type_id);
2856: dbms_sql.define_column(l_dtl_qry_cur_id, 4, l_line_dtl_rec.instance_exists_flag, 1);
2857: dbms_sql.define_column(l_dtl_qry_cur_id, 5, l_line_dtl_rec.source_transaction_flag,1);
2858: dbms_sql.define_column(l_dtl_qry_cur_id, 6, l_line_dtl_rec.instance_id);

Line 2855: dbms_sql.define_column(l_dtl_qry_cur_id, 3, l_line_dtl_rec.sub_type_id);

2851: END IF;
2852:
2853: dbms_sql.define_column(l_dtl_qry_cur_id, 1, l_line_dtl_rec.txn_line_detail_id);
2854: dbms_sql.define_column(l_dtl_qry_cur_id, 2, l_line_dtl_rec.transaction_line_id);
2855: dbms_sql.define_column(l_dtl_qry_cur_id, 3, l_line_dtl_rec.sub_type_id);
2856: dbms_sql.define_column(l_dtl_qry_cur_id, 4, l_line_dtl_rec.instance_exists_flag, 1);
2857: dbms_sql.define_column(l_dtl_qry_cur_id, 5, l_line_dtl_rec.source_transaction_flag,1);
2858: dbms_sql.define_column(l_dtl_qry_cur_id, 6, l_line_dtl_rec.instance_id);
2859: dbms_sql.define_column(l_dtl_qry_cur_id, 7, l_line_dtl_rec.changed_instance_id);

Line 2856: dbms_sql.define_column(l_dtl_qry_cur_id, 4, l_line_dtl_rec.instance_exists_flag, 1);

2852:
2853: dbms_sql.define_column(l_dtl_qry_cur_id, 1, l_line_dtl_rec.txn_line_detail_id);
2854: dbms_sql.define_column(l_dtl_qry_cur_id, 2, l_line_dtl_rec.transaction_line_id);
2855: dbms_sql.define_column(l_dtl_qry_cur_id, 3, l_line_dtl_rec.sub_type_id);
2856: dbms_sql.define_column(l_dtl_qry_cur_id, 4, l_line_dtl_rec.instance_exists_flag, 1);
2857: dbms_sql.define_column(l_dtl_qry_cur_id, 5, l_line_dtl_rec.source_transaction_flag,1);
2858: dbms_sql.define_column(l_dtl_qry_cur_id, 6, l_line_dtl_rec.instance_id);
2859: dbms_sql.define_column(l_dtl_qry_cur_id, 7, l_line_dtl_rec.changed_instance_id);
2860: dbms_sql.define_column(l_dtl_qry_cur_id, 8, l_line_dtl_rec.csi_system_id);

Line 2857: dbms_sql.define_column(l_dtl_qry_cur_id, 5, l_line_dtl_rec.source_transaction_flag,1);

2853: dbms_sql.define_column(l_dtl_qry_cur_id, 1, l_line_dtl_rec.txn_line_detail_id);
2854: dbms_sql.define_column(l_dtl_qry_cur_id, 2, l_line_dtl_rec.transaction_line_id);
2855: dbms_sql.define_column(l_dtl_qry_cur_id, 3, l_line_dtl_rec.sub_type_id);
2856: dbms_sql.define_column(l_dtl_qry_cur_id, 4, l_line_dtl_rec.instance_exists_flag, 1);
2857: dbms_sql.define_column(l_dtl_qry_cur_id, 5, l_line_dtl_rec.source_transaction_flag,1);
2858: dbms_sql.define_column(l_dtl_qry_cur_id, 6, l_line_dtl_rec.instance_id);
2859: dbms_sql.define_column(l_dtl_qry_cur_id, 7, l_line_dtl_rec.changed_instance_id);
2860: dbms_sql.define_column(l_dtl_qry_cur_id, 8, l_line_dtl_rec.csi_system_id);
2861: dbms_sql.define_column(l_dtl_qry_cur_id, 9, l_line_dtl_rec.inventory_item_id);

Line 2858: dbms_sql.define_column(l_dtl_qry_cur_id, 6, l_line_dtl_rec.instance_id);

2854: dbms_sql.define_column(l_dtl_qry_cur_id, 2, l_line_dtl_rec.transaction_line_id);
2855: dbms_sql.define_column(l_dtl_qry_cur_id, 3, l_line_dtl_rec.sub_type_id);
2856: dbms_sql.define_column(l_dtl_qry_cur_id, 4, l_line_dtl_rec.instance_exists_flag, 1);
2857: dbms_sql.define_column(l_dtl_qry_cur_id, 5, l_line_dtl_rec.source_transaction_flag,1);
2858: dbms_sql.define_column(l_dtl_qry_cur_id, 6, l_line_dtl_rec.instance_id);
2859: dbms_sql.define_column(l_dtl_qry_cur_id, 7, l_line_dtl_rec.changed_instance_id);
2860: dbms_sql.define_column(l_dtl_qry_cur_id, 8, l_line_dtl_rec.csi_system_id);
2861: dbms_sql.define_column(l_dtl_qry_cur_id, 9, l_line_dtl_rec.inventory_item_id);
2862: dbms_sql.define_column(l_dtl_qry_cur_id, 10, l_line_dtl_rec.inventory_revision,3);

Line 2859: dbms_sql.define_column(l_dtl_qry_cur_id, 7, l_line_dtl_rec.changed_instance_id);

2855: dbms_sql.define_column(l_dtl_qry_cur_id, 3, l_line_dtl_rec.sub_type_id);
2856: dbms_sql.define_column(l_dtl_qry_cur_id, 4, l_line_dtl_rec.instance_exists_flag, 1);
2857: dbms_sql.define_column(l_dtl_qry_cur_id, 5, l_line_dtl_rec.source_transaction_flag,1);
2858: dbms_sql.define_column(l_dtl_qry_cur_id, 6, l_line_dtl_rec.instance_id);
2859: dbms_sql.define_column(l_dtl_qry_cur_id, 7, l_line_dtl_rec.changed_instance_id);
2860: dbms_sql.define_column(l_dtl_qry_cur_id, 8, l_line_dtl_rec.csi_system_id);
2861: dbms_sql.define_column(l_dtl_qry_cur_id, 9, l_line_dtl_rec.inventory_item_id);
2862: dbms_sql.define_column(l_dtl_qry_cur_id, 10, l_line_dtl_rec.inventory_revision,3);
2863: dbms_sql.define_column(l_dtl_qry_cur_id, 11, l_line_dtl_rec.inv_organization_id);

Line 2860: dbms_sql.define_column(l_dtl_qry_cur_id, 8, l_line_dtl_rec.csi_system_id);

2856: dbms_sql.define_column(l_dtl_qry_cur_id, 4, l_line_dtl_rec.instance_exists_flag, 1);
2857: dbms_sql.define_column(l_dtl_qry_cur_id, 5, l_line_dtl_rec.source_transaction_flag,1);
2858: dbms_sql.define_column(l_dtl_qry_cur_id, 6, l_line_dtl_rec.instance_id);
2859: dbms_sql.define_column(l_dtl_qry_cur_id, 7, l_line_dtl_rec.changed_instance_id);
2860: dbms_sql.define_column(l_dtl_qry_cur_id, 8, l_line_dtl_rec.csi_system_id);
2861: dbms_sql.define_column(l_dtl_qry_cur_id, 9, l_line_dtl_rec.inventory_item_id);
2862: dbms_sql.define_column(l_dtl_qry_cur_id, 10, l_line_dtl_rec.inventory_revision,3);
2863: dbms_sql.define_column(l_dtl_qry_cur_id, 11, l_line_dtl_rec.inv_organization_id);
2864: dbms_sql.define_column(l_dtl_qry_cur_id, 12, l_line_dtl_rec.item_condition_id);

Line 2861: dbms_sql.define_column(l_dtl_qry_cur_id, 9, l_line_dtl_rec.inventory_item_id);

2857: dbms_sql.define_column(l_dtl_qry_cur_id, 5, l_line_dtl_rec.source_transaction_flag,1);
2858: dbms_sql.define_column(l_dtl_qry_cur_id, 6, l_line_dtl_rec.instance_id);
2859: dbms_sql.define_column(l_dtl_qry_cur_id, 7, l_line_dtl_rec.changed_instance_id);
2860: dbms_sql.define_column(l_dtl_qry_cur_id, 8, l_line_dtl_rec.csi_system_id);
2861: dbms_sql.define_column(l_dtl_qry_cur_id, 9, l_line_dtl_rec.inventory_item_id);
2862: dbms_sql.define_column(l_dtl_qry_cur_id, 10, l_line_dtl_rec.inventory_revision,3);
2863: dbms_sql.define_column(l_dtl_qry_cur_id, 11, l_line_dtl_rec.inv_organization_id);
2864: dbms_sql.define_column(l_dtl_qry_cur_id, 12, l_line_dtl_rec.item_condition_id);
2865: dbms_sql.define_column(l_dtl_qry_cur_id, 13, l_line_dtl_rec.instance_type_code, 30);

Line 2862: dbms_sql.define_column(l_dtl_qry_cur_id, 10, l_line_dtl_rec.inventory_revision,3);

2858: dbms_sql.define_column(l_dtl_qry_cur_id, 6, l_line_dtl_rec.instance_id);
2859: dbms_sql.define_column(l_dtl_qry_cur_id, 7, l_line_dtl_rec.changed_instance_id);
2860: dbms_sql.define_column(l_dtl_qry_cur_id, 8, l_line_dtl_rec.csi_system_id);
2861: dbms_sql.define_column(l_dtl_qry_cur_id, 9, l_line_dtl_rec.inventory_item_id);
2862: dbms_sql.define_column(l_dtl_qry_cur_id, 10, l_line_dtl_rec.inventory_revision,3);
2863: dbms_sql.define_column(l_dtl_qry_cur_id, 11, l_line_dtl_rec.inv_organization_id);
2864: dbms_sql.define_column(l_dtl_qry_cur_id, 12, l_line_dtl_rec.item_condition_id);
2865: dbms_sql.define_column(l_dtl_qry_cur_id, 13, l_line_dtl_rec.instance_type_code, 30);
2866: dbms_sql.define_column(l_dtl_qry_cur_id, 14, l_line_dtl_rec.quantity);

Line 2863: dbms_sql.define_column(l_dtl_qry_cur_id, 11, l_line_dtl_rec.inv_organization_id);

2859: dbms_sql.define_column(l_dtl_qry_cur_id, 7, l_line_dtl_rec.changed_instance_id);
2860: dbms_sql.define_column(l_dtl_qry_cur_id, 8, l_line_dtl_rec.csi_system_id);
2861: dbms_sql.define_column(l_dtl_qry_cur_id, 9, l_line_dtl_rec.inventory_item_id);
2862: dbms_sql.define_column(l_dtl_qry_cur_id, 10, l_line_dtl_rec.inventory_revision,3);
2863: dbms_sql.define_column(l_dtl_qry_cur_id, 11, l_line_dtl_rec.inv_organization_id);
2864: dbms_sql.define_column(l_dtl_qry_cur_id, 12, l_line_dtl_rec.item_condition_id);
2865: dbms_sql.define_column(l_dtl_qry_cur_id, 13, l_line_dtl_rec.instance_type_code, 30);
2866: dbms_sql.define_column(l_dtl_qry_cur_id, 14, l_line_dtl_rec.quantity);
2867: dbms_sql.define_column(l_dtl_qry_cur_id, 15, l_line_dtl_rec.unit_of_measure,3);

Line 2864: dbms_sql.define_column(l_dtl_qry_cur_id, 12, l_line_dtl_rec.item_condition_id);

2860: dbms_sql.define_column(l_dtl_qry_cur_id, 8, l_line_dtl_rec.csi_system_id);
2861: dbms_sql.define_column(l_dtl_qry_cur_id, 9, l_line_dtl_rec.inventory_item_id);
2862: dbms_sql.define_column(l_dtl_qry_cur_id, 10, l_line_dtl_rec.inventory_revision,3);
2863: dbms_sql.define_column(l_dtl_qry_cur_id, 11, l_line_dtl_rec.inv_organization_id);
2864: dbms_sql.define_column(l_dtl_qry_cur_id, 12, l_line_dtl_rec.item_condition_id);
2865: dbms_sql.define_column(l_dtl_qry_cur_id, 13, l_line_dtl_rec.instance_type_code, 30);
2866: dbms_sql.define_column(l_dtl_qry_cur_id, 14, l_line_dtl_rec.quantity);
2867: dbms_sql.define_column(l_dtl_qry_cur_id, 15, l_line_dtl_rec.unit_of_measure,3);
2868: dbms_sql.define_column(l_dtl_qry_cur_id, 16, l_line_dtl_rec.qty_remaining);

Line 2865: dbms_sql.define_column(l_dtl_qry_cur_id, 13, l_line_dtl_rec.instance_type_code, 30);

2861: dbms_sql.define_column(l_dtl_qry_cur_id, 9, l_line_dtl_rec.inventory_item_id);
2862: dbms_sql.define_column(l_dtl_qry_cur_id, 10, l_line_dtl_rec.inventory_revision,3);
2863: dbms_sql.define_column(l_dtl_qry_cur_id, 11, l_line_dtl_rec.inv_organization_id);
2864: dbms_sql.define_column(l_dtl_qry_cur_id, 12, l_line_dtl_rec.item_condition_id);
2865: dbms_sql.define_column(l_dtl_qry_cur_id, 13, l_line_dtl_rec.instance_type_code, 30);
2866: dbms_sql.define_column(l_dtl_qry_cur_id, 14, l_line_dtl_rec.quantity);
2867: dbms_sql.define_column(l_dtl_qry_cur_id, 15, l_line_dtl_rec.unit_of_measure,3);
2868: dbms_sql.define_column(l_dtl_qry_cur_id, 16, l_line_dtl_rec.qty_remaining);
2869: dbms_sql.define_column(l_dtl_qry_cur_id, 17, l_line_dtl_rec.serial_number,30);

Line 2866: dbms_sql.define_column(l_dtl_qry_cur_id, 14, l_line_dtl_rec.quantity);

2862: dbms_sql.define_column(l_dtl_qry_cur_id, 10, l_line_dtl_rec.inventory_revision,3);
2863: dbms_sql.define_column(l_dtl_qry_cur_id, 11, l_line_dtl_rec.inv_organization_id);
2864: dbms_sql.define_column(l_dtl_qry_cur_id, 12, l_line_dtl_rec.item_condition_id);
2865: dbms_sql.define_column(l_dtl_qry_cur_id, 13, l_line_dtl_rec.instance_type_code, 30);
2866: dbms_sql.define_column(l_dtl_qry_cur_id, 14, l_line_dtl_rec.quantity);
2867: dbms_sql.define_column(l_dtl_qry_cur_id, 15, l_line_dtl_rec.unit_of_measure,3);
2868: dbms_sql.define_column(l_dtl_qry_cur_id, 16, l_line_dtl_rec.qty_remaining);
2869: dbms_sql.define_column(l_dtl_qry_cur_id, 17, l_line_dtl_rec.serial_number,30);
2870: dbms_sql.define_column(l_dtl_qry_cur_id, 18, l_line_dtl_rec.mfg_serial_number_flag,1);

Line 2867: dbms_sql.define_column(l_dtl_qry_cur_id, 15, l_line_dtl_rec.unit_of_measure,3);

2863: dbms_sql.define_column(l_dtl_qry_cur_id, 11, l_line_dtl_rec.inv_organization_id);
2864: dbms_sql.define_column(l_dtl_qry_cur_id, 12, l_line_dtl_rec.item_condition_id);
2865: dbms_sql.define_column(l_dtl_qry_cur_id, 13, l_line_dtl_rec.instance_type_code, 30);
2866: dbms_sql.define_column(l_dtl_qry_cur_id, 14, l_line_dtl_rec.quantity);
2867: dbms_sql.define_column(l_dtl_qry_cur_id, 15, l_line_dtl_rec.unit_of_measure,3);
2868: dbms_sql.define_column(l_dtl_qry_cur_id, 16, l_line_dtl_rec.qty_remaining);
2869: dbms_sql.define_column(l_dtl_qry_cur_id, 17, l_line_dtl_rec.serial_number,30);
2870: dbms_sql.define_column(l_dtl_qry_cur_id, 18, l_line_dtl_rec.mfg_serial_number_flag,1);
2871: dbms_sql.define_column(l_dtl_qry_cur_id, 19, l_line_dtl_rec.lot_number,80);

Line 2868: dbms_sql.define_column(l_dtl_qry_cur_id, 16, l_line_dtl_rec.qty_remaining);

2864: dbms_sql.define_column(l_dtl_qry_cur_id, 12, l_line_dtl_rec.item_condition_id);
2865: dbms_sql.define_column(l_dtl_qry_cur_id, 13, l_line_dtl_rec.instance_type_code, 30);
2866: dbms_sql.define_column(l_dtl_qry_cur_id, 14, l_line_dtl_rec.quantity);
2867: dbms_sql.define_column(l_dtl_qry_cur_id, 15, l_line_dtl_rec.unit_of_measure,3);
2868: dbms_sql.define_column(l_dtl_qry_cur_id, 16, l_line_dtl_rec.qty_remaining);
2869: dbms_sql.define_column(l_dtl_qry_cur_id, 17, l_line_dtl_rec.serial_number,30);
2870: dbms_sql.define_column(l_dtl_qry_cur_id, 18, l_line_dtl_rec.mfg_serial_number_flag,1);
2871: dbms_sql.define_column(l_dtl_qry_cur_id, 19, l_line_dtl_rec.lot_number,80);
2872: dbms_sql.define_column(l_dtl_qry_cur_id, 20, l_line_dtl_rec.location_type_code,30);

Line 2869: dbms_sql.define_column(l_dtl_qry_cur_id, 17, l_line_dtl_rec.serial_number,30);

2865: dbms_sql.define_column(l_dtl_qry_cur_id, 13, l_line_dtl_rec.instance_type_code, 30);
2866: dbms_sql.define_column(l_dtl_qry_cur_id, 14, l_line_dtl_rec.quantity);
2867: dbms_sql.define_column(l_dtl_qry_cur_id, 15, l_line_dtl_rec.unit_of_measure,3);
2868: dbms_sql.define_column(l_dtl_qry_cur_id, 16, l_line_dtl_rec.qty_remaining);
2869: dbms_sql.define_column(l_dtl_qry_cur_id, 17, l_line_dtl_rec.serial_number,30);
2870: dbms_sql.define_column(l_dtl_qry_cur_id, 18, l_line_dtl_rec.mfg_serial_number_flag,1);
2871: dbms_sql.define_column(l_dtl_qry_cur_id, 19, l_line_dtl_rec.lot_number,80);
2872: dbms_sql.define_column(l_dtl_qry_cur_id, 20, l_line_dtl_rec.location_type_code,30);
2873: dbms_sql.define_column(l_dtl_qry_cur_id, 21, l_line_dtl_rec.location_id);

Line 2870: dbms_sql.define_column(l_dtl_qry_cur_id, 18, l_line_dtl_rec.mfg_serial_number_flag,1);

2866: dbms_sql.define_column(l_dtl_qry_cur_id, 14, l_line_dtl_rec.quantity);
2867: dbms_sql.define_column(l_dtl_qry_cur_id, 15, l_line_dtl_rec.unit_of_measure,3);
2868: dbms_sql.define_column(l_dtl_qry_cur_id, 16, l_line_dtl_rec.qty_remaining);
2869: dbms_sql.define_column(l_dtl_qry_cur_id, 17, l_line_dtl_rec.serial_number,30);
2870: dbms_sql.define_column(l_dtl_qry_cur_id, 18, l_line_dtl_rec.mfg_serial_number_flag,1);
2871: dbms_sql.define_column(l_dtl_qry_cur_id, 19, l_line_dtl_rec.lot_number,80);
2872: dbms_sql.define_column(l_dtl_qry_cur_id, 20, l_line_dtl_rec.location_type_code,30);
2873: dbms_sql.define_column(l_dtl_qry_cur_id, 21, l_line_dtl_rec.location_id);
2874: dbms_sql.define_column(l_dtl_qry_cur_id, 22, l_line_dtl_rec.installation_date);

Line 2871: dbms_sql.define_column(l_dtl_qry_cur_id, 19, l_line_dtl_rec.lot_number,80);

2867: dbms_sql.define_column(l_dtl_qry_cur_id, 15, l_line_dtl_rec.unit_of_measure,3);
2868: dbms_sql.define_column(l_dtl_qry_cur_id, 16, l_line_dtl_rec.qty_remaining);
2869: dbms_sql.define_column(l_dtl_qry_cur_id, 17, l_line_dtl_rec.serial_number,30);
2870: dbms_sql.define_column(l_dtl_qry_cur_id, 18, l_line_dtl_rec.mfg_serial_number_flag,1);
2871: dbms_sql.define_column(l_dtl_qry_cur_id, 19, l_line_dtl_rec.lot_number,80);
2872: dbms_sql.define_column(l_dtl_qry_cur_id, 20, l_line_dtl_rec.location_type_code,30);
2873: dbms_sql.define_column(l_dtl_qry_cur_id, 21, l_line_dtl_rec.location_id);
2874: dbms_sql.define_column(l_dtl_qry_cur_id, 22, l_line_dtl_rec.installation_date);
2875: dbms_sql.define_column(l_dtl_qry_cur_id, 23, l_line_dtl_rec.in_service_date);

Line 2872: dbms_sql.define_column(l_dtl_qry_cur_id, 20, l_line_dtl_rec.location_type_code,30);

2868: dbms_sql.define_column(l_dtl_qry_cur_id, 16, l_line_dtl_rec.qty_remaining);
2869: dbms_sql.define_column(l_dtl_qry_cur_id, 17, l_line_dtl_rec.serial_number,30);
2870: dbms_sql.define_column(l_dtl_qry_cur_id, 18, l_line_dtl_rec.mfg_serial_number_flag,1);
2871: dbms_sql.define_column(l_dtl_qry_cur_id, 19, l_line_dtl_rec.lot_number,80);
2872: dbms_sql.define_column(l_dtl_qry_cur_id, 20, l_line_dtl_rec.location_type_code,30);
2873: dbms_sql.define_column(l_dtl_qry_cur_id, 21, l_line_dtl_rec.location_id);
2874: dbms_sql.define_column(l_dtl_qry_cur_id, 22, l_line_dtl_rec.installation_date);
2875: dbms_sql.define_column(l_dtl_qry_cur_id, 23, l_line_dtl_rec.in_service_date);
2876: dbms_sql.define_column(l_dtl_qry_cur_id, 24, l_line_dtl_rec.external_reference,30);

Line 2873: dbms_sql.define_column(l_dtl_qry_cur_id, 21, l_line_dtl_rec.location_id);

2869: dbms_sql.define_column(l_dtl_qry_cur_id, 17, l_line_dtl_rec.serial_number,30);
2870: dbms_sql.define_column(l_dtl_qry_cur_id, 18, l_line_dtl_rec.mfg_serial_number_flag,1);
2871: dbms_sql.define_column(l_dtl_qry_cur_id, 19, l_line_dtl_rec.lot_number,80);
2872: dbms_sql.define_column(l_dtl_qry_cur_id, 20, l_line_dtl_rec.location_type_code,30);
2873: dbms_sql.define_column(l_dtl_qry_cur_id, 21, l_line_dtl_rec.location_id);
2874: dbms_sql.define_column(l_dtl_qry_cur_id, 22, l_line_dtl_rec.installation_date);
2875: dbms_sql.define_column(l_dtl_qry_cur_id, 23, l_line_dtl_rec.in_service_date);
2876: dbms_sql.define_column(l_dtl_qry_cur_id, 24, l_line_dtl_rec.external_reference,30);
2877: dbms_sql.define_column(l_dtl_qry_cur_id, 25, l_line_dtl_rec.transaction_system_id);

Line 2874: dbms_sql.define_column(l_dtl_qry_cur_id, 22, l_line_dtl_rec.installation_date);

2870: dbms_sql.define_column(l_dtl_qry_cur_id, 18, l_line_dtl_rec.mfg_serial_number_flag,1);
2871: dbms_sql.define_column(l_dtl_qry_cur_id, 19, l_line_dtl_rec.lot_number,80);
2872: dbms_sql.define_column(l_dtl_qry_cur_id, 20, l_line_dtl_rec.location_type_code,30);
2873: dbms_sql.define_column(l_dtl_qry_cur_id, 21, l_line_dtl_rec.location_id);
2874: dbms_sql.define_column(l_dtl_qry_cur_id, 22, l_line_dtl_rec.installation_date);
2875: dbms_sql.define_column(l_dtl_qry_cur_id, 23, l_line_dtl_rec.in_service_date);
2876: dbms_sql.define_column(l_dtl_qry_cur_id, 24, l_line_dtl_rec.external_reference,30);
2877: dbms_sql.define_column(l_dtl_qry_cur_id, 25, l_line_dtl_rec.transaction_system_id);
2878: dbms_sql.define_column(l_dtl_qry_cur_id, 26, l_line_dtl_rec.sellable_flag, 1);

Line 2875: dbms_sql.define_column(l_dtl_qry_cur_id, 23, l_line_dtl_rec.in_service_date);

2871: dbms_sql.define_column(l_dtl_qry_cur_id, 19, l_line_dtl_rec.lot_number,80);
2872: dbms_sql.define_column(l_dtl_qry_cur_id, 20, l_line_dtl_rec.location_type_code,30);
2873: dbms_sql.define_column(l_dtl_qry_cur_id, 21, l_line_dtl_rec.location_id);
2874: dbms_sql.define_column(l_dtl_qry_cur_id, 22, l_line_dtl_rec.installation_date);
2875: dbms_sql.define_column(l_dtl_qry_cur_id, 23, l_line_dtl_rec.in_service_date);
2876: dbms_sql.define_column(l_dtl_qry_cur_id, 24, l_line_dtl_rec.external_reference,30);
2877: dbms_sql.define_column(l_dtl_qry_cur_id, 25, l_line_dtl_rec.transaction_system_id);
2878: dbms_sql.define_column(l_dtl_qry_cur_id, 26, l_line_dtl_rec.sellable_flag, 1);
2879: dbms_sql.define_column(l_dtl_qry_cur_id, 27, l_line_dtl_rec.version_label,240);

Line 2876: dbms_sql.define_column(l_dtl_qry_cur_id, 24, l_line_dtl_rec.external_reference,30);

2872: dbms_sql.define_column(l_dtl_qry_cur_id, 20, l_line_dtl_rec.location_type_code,30);
2873: dbms_sql.define_column(l_dtl_qry_cur_id, 21, l_line_dtl_rec.location_id);
2874: dbms_sql.define_column(l_dtl_qry_cur_id, 22, l_line_dtl_rec.installation_date);
2875: dbms_sql.define_column(l_dtl_qry_cur_id, 23, l_line_dtl_rec.in_service_date);
2876: dbms_sql.define_column(l_dtl_qry_cur_id, 24, l_line_dtl_rec.external_reference,30);
2877: dbms_sql.define_column(l_dtl_qry_cur_id, 25, l_line_dtl_rec.transaction_system_id);
2878: dbms_sql.define_column(l_dtl_qry_cur_id, 26, l_line_dtl_rec.sellable_flag, 1);
2879: dbms_sql.define_column(l_dtl_qry_cur_id, 27, l_line_dtl_rec.version_label,240);
2880: dbms_sql.define_column(l_dtl_qry_cur_id, 28, l_line_dtl_rec.return_by_date);

Line 2877: dbms_sql.define_column(l_dtl_qry_cur_id, 25, l_line_dtl_rec.transaction_system_id);

2873: dbms_sql.define_column(l_dtl_qry_cur_id, 21, l_line_dtl_rec.location_id);
2874: dbms_sql.define_column(l_dtl_qry_cur_id, 22, l_line_dtl_rec.installation_date);
2875: dbms_sql.define_column(l_dtl_qry_cur_id, 23, l_line_dtl_rec.in_service_date);
2876: dbms_sql.define_column(l_dtl_qry_cur_id, 24, l_line_dtl_rec.external_reference,30);
2877: dbms_sql.define_column(l_dtl_qry_cur_id, 25, l_line_dtl_rec.transaction_system_id);
2878: dbms_sql.define_column(l_dtl_qry_cur_id, 26, l_line_dtl_rec.sellable_flag, 1);
2879: dbms_sql.define_column(l_dtl_qry_cur_id, 27, l_line_dtl_rec.version_label,240);
2880: dbms_sql.define_column(l_dtl_qry_cur_id, 28, l_line_dtl_rec.return_by_date);
2881: dbms_sql.define_column(l_dtl_qry_cur_id, 29, l_line_dtl_rec.active_start_date);

Line 2878: dbms_sql.define_column(l_dtl_qry_cur_id, 26, l_line_dtl_rec.sellable_flag, 1);

2874: dbms_sql.define_column(l_dtl_qry_cur_id, 22, l_line_dtl_rec.installation_date);
2875: dbms_sql.define_column(l_dtl_qry_cur_id, 23, l_line_dtl_rec.in_service_date);
2876: dbms_sql.define_column(l_dtl_qry_cur_id, 24, l_line_dtl_rec.external_reference,30);
2877: dbms_sql.define_column(l_dtl_qry_cur_id, 25, l_line_dtl_rec.transaction_system_id);
2878: dbms_sql.define_column(l_dtl_qry_cur_id, 26, l_line_dtl_rec.sellable_flag, 1);
2879: dbms_sql.define_column(l_dtl_qry_cur_id, 27, l_line_dtl_rec.version_label,240);
2880: dbms_sql.define_column(l_dtl_qry_cur_id, 28, l_line_dtl_rec.return_by_date);
2881: dbms_sql.define_column(l_dtl_qry_cur_id, 29, l_line_dtl_rec.active_start_date);
2882: dbms_sql.define_column(l_dtl_qry_cur_id, 30, l_line_dtl_rec.active_end_date);

Line 2879: dbms_sql.define_column(l_dtl_qry_cur_id, 27, l_line_dtl_rec.version_label,240);

2875: dbms_sql.define_column(l_dtl_qry_cur_id, 23, l_line_dtl_rec.in_service_date);
2876: dbms_sql.define_column(l_dtl_qry_cur_id, 24, l_line_dtl_rec.external_reference,30);
2877: dbms_sql.define_column(l_dtl_qry_cur_id, 25, l_line_dtl_rec.transaction_system_id);
2878: dbms_sql.define_column(l_dtl_qry_cur_id, 26, l_line_dtl_rec.sellable_flag, 1);
2879: dbms_sql.define_column(l_dtl_qry_cur_id, 27, l_line_dtl_rec.version_label,240);
2880: dbms_sql.define_column(l_dtl_qry_cur_id, 28, l_line_dtl_rec.return_by_date);
2881: dbms_sql.define_column(l_dtl_qry_cur_id, 29, l_line_dtl_rec.active_start_date);
2882: dbms_sql.define_column(l_dtl_qry_cur_id, 30, l_line_dtl_rec.active_end_date);
2883: dbms_sql.define_column(l_dtl_qry_cur_id, 31, l_line_dtl_rec.preserve_detail_flag,1);

Line 2880: dbms_sql.define_column(l_dtl_qry_cur_id, 28, l_line_dtl_rec.return_by_date);

2876: dbms_sql.define_column(l_dtl_qry_cur_id, 24, l_line_dtl_rec.external_reference,30);
2877: dbms_sql.define_column(l_dtl_qry_cur_id, 25, l_line_dtl_rec.transaction_system_id);
2878: dbms_sql.define_column(l_dtl_qry_cur_id, 26, l_line_dtl_rec.sellable_flag, 1);
2879: dbms_sql.define_column(l_dtl_qry_cur_id, 27, l_line_dtl_rec.version_label,240);
2880: dbms_sql.define_column(l_dtl_qry_cur_id, 28, l_line_dtl_rec.return_by_date);
2881: dbms_sql.define_column(l_dtl_qry_cur_id, 29, l_line_dtl_rec.active_start_date);
2882: dbms_sql.define_column(l_dtl_qry_cur_id, 30, l_line_dtl_rec.active_end_date);
2883: dbms_sql.define_column(l_dtl_qry_cur_id, 31, l_line_dtl_rec.preserve_detail_flag,1);
2884: dbms_sql.define_column(l_dtl_qry_cur_id, 32, l_line_dtl_rec.reference_source_id);

Line 2881: dbms_sql.define_column(l_dtl_qry_cur_id, 29, l_line_dtl_rec.active_start_date);

2877: dbms_sql.define_column(l_dtl_qry_cur_id, 25, l_line_dtl_rec.transaction_system_id);
2878: dbms_sql.define_column(l_dtl_qry_cur_id, 26, l_line_dtl_rec.sellable_flag, 1);
2879: dbms_sql.define_column(l_dtl_qry_cur_id, 27, l_line_dtl_rec.version_label,240);
2880: dbms_sql.define_column(l_dtl_qry_cur_id, 28, l_line_dtl_rec.return_by_date);
2881: dbms_sql.define_column(l_dtl_qry_cur_id, 29, l_line_dtl_rec.active_start_date);
2882: dbms_sql.define_column(l_dtl_qry_cur_id, 30, l_line_dtl_rec.active_end_date);
2883: dbms_sql.define_column(l_dtl_qry_cur_id, 31, l_line_dtl_rec.preserve_detail_flag,1);
2884: dbms_sql.define_column(l_dtl_qry_cur_id, 32, l_line_dtl_rec.reference_source_id);
2885: dbms_sql.define_column(l_dtl_qry_cur_id, 33, l_line_dtl_rec.reference_source_date);

Line 2882: dbms_sql.define_column(l_dtl_qry_cur_id, 30, l_line_dtl_rec.active_end_date);

2878: dbms_sql.define_column(l_dtl_qry_cur_id, 26, l_line_dtl_rec.sellable_flag, 1);
2879: dbms_sql.define_column(l_dtl_qry_cur_id, 27, l_line_dtl_rec.version_label,240);
2880: dbms_sql.define_column(l_dtl_qry_cur_id, 28, l_line_dtl_rec.return_by_date);
2881: dbms_sql.define_column(l_dtl_qry_cur_id, 29, l_line_dtl_rec.active_start_date);
2882: dbms_sql.define_column(l_dtl_qry_cur_id, 30, l_line_dtl_rec.active_end_date);
2883: dbms_sql.define_column(l_dtl_qry_cur_id, 31, l_line_dtl_rec.preserve_detail_flag,1);
2884: dbms_sql.define_column(l_dtl_qry_cur_id, 32, l_line_dtl_rec.reference_source_id);
2885: dbms_sql.define_column(l_dtl_qry_cur_id, 33, l_line_dtl_rec.reference_source_date);
2886: dbms_sql.define_column(l_dtl_qry_cur_id, 34, l_line_dtl_rec.csi_transaction_id);

Line 2883: dbms_sql.define_column(l_dtl_qry_cur_id, 31, l_line_dtl_rec.preserve_detail_flag,1);

2879: dbms_sql.define_column(l_dtl_qry_cur_id, 27, l_line_dtl_rec.version_label,240);
2880: dbms_sql.define_column(l_dtl_qry_cur_id, 28, l_line_dtl_rec.return_by_date);
2881: dbms_sql.define_column(l_dtl_qry_cur_id, 29, l_line_dtl_rec.active_start_date);
2882: dbms_sql.define_column(l_dtl_qry_cur_id, 30, l_line_dtl_rec.active_end_date);
2883: dbms_sql.define_column(l_dtl_qry_cur_id, 31, l_line_dtl_rec.preserve_detail_flag,1);
2884: dbms_sql.define_column(l_dtl_qry_cur_id, 32, l_line_dtl_rec.reference_source_id);
2885: dbms_sql.define_column(l_dtl_qry_cur_id, 33, l_line_dtl_rec.reference_source_date);
2886: dbms_sql.define_column(l_dtl_qry_cur_id, 34, l_line_dtl_rec.csi_transaction_id);
2887: dbms_sql.define_column(l_dtl_qry_cur_id, 35, l_line_dtl_rec.processing_status,30);

Line 2884: dbms_sql.define_column(l_dtl_qry_cur_id, 32, l_line_dtl_rec.reference_source_id);

2880: dbms_sql.define_column(l_dtl_qry_cur_id, 28, l_line_dtl_rec.return_by_date);
2881: dbms_sql.define_column(l_dtl_qry_cur_id, 29, l_line_dtl_rec.active_start_date);
2882: dbms_sql.define_column(l_dtl_qry_cur_id, 30, l_line_dtl_rec.active_end_date);
2883: dbms_sql.define_column(l_dtl_qry_cur_id, 31, l_line_dtl_rec.preserve_detail_flag,1);
2884: dbms_sql.define_column(l_dtl_qry_cur_id, 32, l_line_dtl_rec.reference_source_id);
2885: dbms_sql.define_column(l_dtl_qry_cur_id, 33, l_line_dtl_rec.reference_source_date);
2886: dbms_sql.define_column(l_dtl_qry_cur_id, 34, l_line_dtl_rec.csi_transaction_id);
2887: dbms_sql.define_column(l_dtl_qry_cur_id, 35, l_line_dtl_rec.processing_status,30);
2888: dbms_sql.define_column(l_dtl_qry_cur_id, 36, l_line_dtl_rec.error_code,240);

Line 2885: dbms_sql.define_column(l_dtl_qry_cur_id, 33, l_line_dtl_rec.reference_source_date);

2881: dbms_sql.define_column(l_dtl_qry_cur_id, 29, l_line_dtl_rec.active_start_date);
2882: dbms_sql.define_column(l_dtl_qry_cur_id, 30, l_line_dtl_rec.active_end_date);
2883: dbms_sql.define_column(l_dtl_qry_cur_id, 31, l_line_dtl_rec.preserve_detail_flag,1);
2884: dbms_sql.define_column(l_dtl_qry_cur_id, 32, l_line_dtl_rec.reference_source_id);
2885: dbms_sql.define_column(l_dtl_qry_cur_id, 33, l_line_dtl_rec.reference_source_date);
2886: dbms_sql.define_column(l_dtl_qry_cur_id, 34, l_line_dtl_rec.csi_transaction_id);
2887: dbms_sql.define_column(l_dtl_qry_cur_id, 35, l_line_dtl_rec.processing_status,30);
2888: dbms_sql.define_column(l_dtl_qry_cur_id, 36, l_line_dtl_rec.error_code,240);
2889: dbms_sql.define_column(l_dtl_qry_cur_id, 37, l_line_dtl_rec.error_explanation,240);

Line 2886: dbms_sql.define_column(l_dtl_qry_cur_id, 34, l_line_dtl_rec.csi_transaction_id);

2882: dbms_sql.define_column(l_dtl_qry_cur_id, 30, l_line_dtl_rec.active_end_date);
2883: dbms_sql.define_column(l_dtl_qry_cur_id, 31, l_line_dtl_rec.preserve_detail_flag,1);
2884: dbms_sql.define_column(l_dtl_qry_cur_id, 32, l_line_dtl_rec.reference_source_id);
2885: dbms_sql.define_column(l_dtl_qry_cur_id, 33, l_line_dtl_rec.reference_source_date);
2886: dbms_sql.define_column(l_dtl_qry_cur_id, 34, l_line_dtl_rec.csi_transaction_id);
2887: dbms_sql.define_column(l_dtl_qry_cur_id, 35, l_line_dtl_rec.processing_status,30);
2888: dbms_sql.define_column(l_dtl_qry_cur_id, 36, l_line_dtl_rec.error_code,240);
2889: dbms_sql.define_column(l_dtl_qry_cur_id, 37, l_line_dtl_rec.error_explanation,240);
2890: dbms_sql.define_column(l_dtl_qry_cur_id, 38, l_line_dtl_rec.context,30);

Line 2887: dbms_sql.define_column(l_dtl_qry_cur_id, 35, l_line_dtl_rec.processing_status,30);

2883: dbms_sql.define_column(l_dtl_qry_cur_id, 31, l_line_dtl_rec.preserve_detail_flag,1);
2884: dbms_sql.define_column(l_dtl_qry_cur_id, 32, l_line_dtl_rec.reference_source_id);
2885: dbms_sql.define_column(l_dtl_qry_cur_id, 33, l_line_dtl_rec.reference_source_date);
2886: dbms_sql.define_column(l_dtl_qry_cur_id, 34, l_line_dtl_rec.csi_transaction_id);
2887: dbms_sql.define_column(l_dtl_qry_cur_id, 35, l_line_dtl_rec.processing_status,30);
2888: dbms_sql.define_column(l_dtl_qry_cur_id, 36, l_line_dtl_rec.error_code,240);
2889: dbms_sql.define_column(l_dtl_qry_cur_id, 37, l_line_dtl_rec.error_explanation,240);
2890: dbms_sql.define_column(l_dtl_qry_cur_id, 38, l_line_dtl_rec.context,30);
2891: dbms_sql.define_column(l_dtl_qry_cur_id, 39, l_line_dtl_rec.attribute1, 150);

Line 2888: dbms_sql.define_column(l_dtl_qry_cur_id, 36, l_line_dtl_rec.error_code,240);

2884: dbms_sql.define_column(l_dtl_qry_cur_id, 32, l_line_dtl_rec.reference_source_id);
2885: dbms_sql.define_column(l_dtl_qry_cur_id, 33, l_line_dtl_rec.reference_source_date);
2886: dbms_sql.define_column(l_dtl_qry_cur_id, 34, l_line_dtl_rec.csi_transaction_id);
2887: dbms_sql.define_column(l_dtl_qry_cur_id, 35, l_line_dtl_rec.processing_status,30);
2888: dbms_sql.define_column(l_dtl_qry_cur_id, 36, l_line_dtl_rec.error_code,240);
2889: dbms_sql.define_column(l_dtl_qry_cur_id, 37, l_line_dtl_rec.error_explanation,240);
2890: dbms_sql.define_column(l_dtl_qry_cur_id, 38, l_line_dtl_rec.context,30);
2891: dbms_sql.define_column(l_dtl_qry_cur_id, 39, l_line_dtl_rec.attribute1, 150);
2892: dbms_sql.define_column(l_dtl_qry_cur_id, 40, l_line_dtl_rec.attribute2, 150);

Line 2889: dbms_sql.define_column(l_dtl_qry_cur_id, 37, l_line_dtl_rec.error_explanation,240);

2885: dbms_sql.define_column(l_dtl_qry_cur_id, 33, l_line_dtl_rec.reference_source_date);
2886: dbms_sql.define_column(l_dtl_qry_cur_id, 34, l_line_dtl_rec.csi_transaction_id);
2887: dbms_sql.define_column(l_dtl_qry_cur_id, 35, l_line_dtl_rec.processing_status,30);
2888: dbms_sql.define_column(l_dtl_qry_cur_id, 36, l_line_dtl_rec.error_code,240);
2889: dbms_sql.define_column(l_dtl_qry_cur_id, 37, l_line_dtl_rec.error_explanation,240);
2890: dbms_sql.define_column(l_dtl_qry_cur_id, 38, l_line_dtl_rec.context,30);
2891: dbms_sql.define_column(l_dtl_qry_cur_id, 39, l_line_dtl_rec.attribute1, 150);
2892: dbms_sql.define_column(l_dtl_qry_cur_id, 40, l_line_dtl_rec.attribute2, 150);
2893: dbms_sql.define_column(l_dtl_qry_cur_id, 41, l_line_dtl_rec.attribute3, 150);

Line 2890: dbms_sql.define_column(l_dtl_qry_cur_id, 38, l_line_dtl_rec.context,30);

2886: dbms_sql.define_column(l_dtl_qry_cur_id, 34, l_line_dtl_rec.csi_transaction_id);
2887: dbms_sql.define_column(l_dtl_qry_cur_id, 35, l_line_dtl_rec.processing_status,30);
2888: dbms_sql.define_column(l_dtl_qry_cur_id, 36, l_line_dtl_rec.error_code,240);
2889: dbms_sql.define_column(l_dtl_qry_cur_id, 37, l_line_dtl_rec.error_explanation,240);
2890: dbms_sql.define_column(l_dtl_qry_cur_id, 38, l_line_dtl_rec.context,30);
2891: dbms_sql.define_column(l_dtl_qry_cur_id, 39, l_line_dtl_rec.attribute1, 150);
2892: dbms_sql.define_column(l_dtl_qry_cur_id, 40, l_line_dtl_rec.attribute2, 150);
2893: dbms_sql.define_column(l_dtl_qry_cur_id, 41, l_line_dtl_rec.attribute3, 150);
2894: dbms_sql.define_column(l_dtl_qry_cur_id, 42, l_line_dtl_rec.attribute4, 150);

Line 2891: dbms_sql.define_column(l_dtl_qry_cur_id, 39, l_line_dtl_rec.attribute1, 150);

2887: dbms_sql.define_column(l_dtl_qry_cur_id, 35, l_line_dtl_rec.processing_status,30);
2888: dbms_sql.define_column(l_dtl_qry_cur_id, 36, l_line_dtl_rec.error_code,240);
2889: dbms_sql.define_column(l_dtl_qry_cur_id, 37, l_line_dtl_rec.error_explanation,240);
2890: dbms_sql.define_column(l_dtl_qry_cur_id, 38, l_line_dtl_rec.context,30);
2891: dbms_sql.define_column(l_dtl_qry_cur_id, 39, l_line_dtl_rec.attribute1, 150);
2892: dbms_sql.define_column(l_dtl_qry_cur_id, 40, l_line_dtl_rec.attribute2, 150);
2893: dbms_sql.define_column(l_dtl_qry_cur_id, 41, l_line_dtl_rec.attribute3, 150);
2894: dbms_sql.define_column(l_dtl_qry_cur_id, 42, l_line_dtl_rec.attribute4, 150);
2895: dbms_sql.define_column(l_dtl_qry_cur_id, 43, l_line_dtl_rec.attribute5, 150);

Line 2892: dbms_sql.define_column(l_dtl_qry_cur_id, 40, l_line_dtl_rec.attribute2, 150);

2888: dbms_sql.define_column(l_dtl_qry_cur_id, 36, l_line_dtl_rec.error_code,240);
2889: dbms_sql.define_column(l_dtl_qry_cur_id, 37, l_line_dtl_rec.error_explanation,240);
2890: dbms_sql.define_column(l_dtl_qry_cur_id, 38, l_line_dtl_rec.context,30);
2891: dbms_sql.define_column(l_dtl_qry_cur_id, 39, l_line_dtl_rec.attribute1, 150);
2892: dbms_sql.define_column(l_dtl_qry_cur_id, 40, l_line_dtl_rec.attribute2, 150);
2893: dbms_sql.define_column(l_dtl_qry_cur_id, 41, l_line_dtl_rec.attribute3, 150);
2894: dbms_sql.define_column(l_dtl_qry_cur_id, 42, l_line_dtl_rec.attribute4, 150);
2895: dbms_sql.define_column(l_dtl_qry_cur_id, 43, l_line_dtl_rec.attribute5, 150);
2896: dbms_sql.define_column(l_dtl_qry_cur_id, 44, l_line_dtl_rec.attribute6, 150);

Line 2893: dbms_sql.define_column(l_dtl_qry_cur_id, 41, l_line_dtl_rec.attribute3, 150);

2889: dbms_sql.define_column(l_dtl_qry_cur_id, 37, l_line_dtl_rec.error_explanation,240);
2890: dbms_sql.define_column(l_dtl_qry_cur_id, 38, l_line_dtl_rec.context,30);
2891: dbms_sql.define_column(l_dtl_qry_cur_id, 39, l_line_dtl_rec.attribute1, 150);
2892: dbms_sql.define_column(l_dtl_qry_cur_id, 40, l_line_dtl_rec.attribute2, 150);
2893: dbms_sql.define_column(l_dtl_qry_cur_id, 41, l_line_dtl_rec.attribute3, 150);
2894: dbms_sql.define_column(l_dtl_qry_cur_id, 42, l_line_dtl_rec.attribute4, 150);
2895: dbms_sql.define_column(l_dtl_qry_cur_id, 43, l_line_dtl_rec.attribute5, 150);
2896: dbms_sql.define_column(l_dtl_qry_cur_id, 44, l_line_dtl_rec.attribute6, 150);
2897: dbms_sql.define_column(l_dtl_qry_cur_id, 45, l_line_dtl_rec.attribute7, 150);

Line 2894: dbms_sql.define_column(l_dtl_qry_cur_id, 42, l_line_dtl_rec.attribute4, 150);

2890: dbms_sql.define_column(l_dtl_qry_cur_id, 38, l_line_dtl_rec.context,30);
2891: dbms_sql.define_column(l_dtl_qry_cur_id, 39, l_line_dtl_rec.attribute1, 150);
2892: dbms_sql.define_column(l_dtl_qry_cur_id, 40, l_line_dtl_rec.attribute2, 150);
2893: dbms_sql.define_column(l_dtl_qry_cur_id, 41, l_line_dtl_rec.attribute3, 150);
2894: dbms_sql.define_column(l_dtl_qry_cur_id, 42, l_line_dtl_rec.attribute4, 150);
2895: dbms_sql.define_column(l_dtl_qry_cur_id, 43, l_line_dtl_rec.attribute5, 150);
2896: dbms_sql.define_column(l_dtl_qry_cur_id, 44, l_line_dtl_rec.attribute6, 150);
2897: dbms_sql.define_column(l_dtl_qry_cur_id, 45, l_line_dtl_rec.attribute7, 150);
2898: dbms_sql.define_column(l_dtl_qry_cur_id, 46, l_line_dtl_rec.attribute8, 150);

Line 2895: dbms_sql.define_column(l_dtl_qry_cur_id, 43, l_line_dtl_rec.attribute5, 150);

2891: dbms_sql.define_column(l_dtl_qry_cur_id, 39, l_line_dtl_rec.attribute1, 150);
2892: dbms_sql.define_column(l_dtl_qry_cur_id, 40, l_line_dtl_rec.attribute2, 150);
2893: dbms_sql.define_column(l_dtl_qry_cur_id, 41, l_line_dtl_rec.attribute3, 150);
2894: dbms_sql.define_column(l_dtl_qry_cur_id, 42, l_line_dtl_rec.attribute4, 150);
2895: dbms_sql.define_column(l_dtl_qry_cur_id, 43, l_line_dtl_rec.attribute5, 150);
2896: dbms_sql.define_column(l_dtl_qry_cur_id, 44, l_line_dtl_rec.attribute6, 150);
2897: dbms_sql.define_column(l_dtl_qry_cur_id, 45, l_line_dtl_rec.attribute7, 150);
2898: dbms_sql.define_column(l_dtl_qry_cur_id, 46, l_line_dtl_rec.attribute8, 150);
2899: dbms_sql.define_column(l_dtl_qry_cur_id, 47, l_line_dtl_rec.attribute9, 150);

Line 2896: dbms_sql.define_column(l_dtl_qry_cur_id, 44, l_line_dtl_rec.attribute6, 150);

2892: dbms_sql.define_column(l_dtl_qry_cur_id, 40, l_line_dtl_rec.attribute2, 150);
2893: dbms_sql.define_column(l_dtl_qry_cur_id, 41, l_line_dtl_rec.attribute3, 150);
2894: dbms_sql.define_column(l_dtl_qry_cur_id, 42, l_line_dtl_rec.attribute4, 150);
2895: dbms_sql.define_column(l_dtl_qry_cur_id, 43, l_line_dtl_rec.attribute5, 150);
2896: dbms_sql.define_column(l_dtl_qry_cur_id, 44, l_line_dtl_rec.attribute6, 150);
2897: dbms_sql.define_column(l_dtl_qry_cur_id, 45, l_line_dtl_rec.attribute7, 150);
2898: dbms_sql.define_column(l_dtl_qry_cur_id, 46, l_line_dtl_rec.attribute8, 150);
2899: dbms_sql.define_column(l_dtl_qry_cur_id, 47, l_line_dtl_rec.attribute9, 150);
2900: dbms_sql.define_column(l_dtl_qry_cur_id, 48, l_line_dtl_rec.attribute10, 150);

Line 2897: dbms_sql.define_column(l_dtl_qry_cur_id, 45, l_line_dtl_rec.attribute7, 150);

2893: dbms_sql.define_column(l_dtl_qry_cur_id, 41, l_line_dtl_rec.attribute3, 150);
2894: dbms_sql.define_column(l_dtl_qry_cur_id, 42, l_line_dtl_rec.attribute4, 150);
2895: dbms_sql.define_column(l_dtl_qry_cur_id, 43, l_line_dtl_rec.attribute5, 150);
2896: dbms_sql.define_column(l_dtl_qry_cur_id, 44, l_line_dtl_rec.attribute6, 150);
2897: dbms_sql.define_column(l_dtl_qry_cur_id, 45, l_line_dtl_rec.attribute7, 150);
2898: dbms_sql.define_column(l_dtl_qry_cur_id, 46, l_line_dtl_rec.attribute8, 150);
2899: dbms_sql.define_column(l_dtl_qry_cur_id, 47, l_line_dtl_rec.attribute9, 150);
2900: dbms_sql.define_column(l_dtl_qry_cur_id, 48, l_line_dtl_rec.attribute10, 150);
2901: dbms_sql.define_column(l_dtl_qry_cur_id, 49, l_line_dtl_rec.attribute11, 150);

Line 2898: dbms_sql.define_column(l_dtl_qry_cur_id, 46, l_line_dtl_rec.attribute8, 150);

2894: dbms_sql.define_column(l_dtl_qry_cur_id, 42, l_line_dtl_rec.attribute4, 150);
2895: dbms_sql.define_column(l_dtl_qry_cur_id, 43, l_line_dtl_rec.attribute5, 150);
2896: dbms_sql.define_column(l_dtl_qry_cur_id, 44, l_line_dtl_rec.attribute6, 150);
2897: dbms_sql.define_column(l_dtl_qry_cur_id, 45, l_line_dtl_rec.attribute7, 150);
2898: dbms_sql.define_column(l_dtl_qry_cur_id, 46, l_line_dtl_rec.attribute8, 150);
2899: dbms_sql.define_column(l_dtl_qry_cur_id, 47, l_line_dtl_rec.attribute9, 150);
2900: dbms_sql.define_column(l_dtl_qry_cur_id, 48, l_line_dtl_rec.attribute10, 150);
2901: dbms_sql.define_column(l_dtl_qry_cur_id, 49, l_line_dtl_rec.attribute11, 150);
2902: dbms_sql.define_column(l_dtl_qry_cur_id, 50, l_line_dtl_rec.attribute12, 150);

Line 2899: dbms_sql.define_column(l_dtl_qry_cur_id, 47, l_line_dtl_rec.attribute9, 150);

2895: dbms_sql.define_column(l_dtl_qry_cur_id, 43, l_line_dtl_rec.attribute5, 150);
2896: dbms_sql.define_column(l_dtl_qry_cur_id, 44, l_line_dtl_rec.attribute6, 150);
2897: dbms_sql.define_column(l_dtl_qry_cur_id, 45, l_line_dtl_rec.attribute7, 150);
2898: dbms_sql.define_column(l_dtl_qry_cur_id, 46, l_line_dtl_rec.attribute8, 150);
2899: dbms_sql.define_column(l_dtl_qry_cur_id, 47, l_line_dtl_rec.attribute9, 150);
2900: dbms_sql.define_column(l_dtl_qry_cur_id, 48, l_line_dtl_rec.attribute10, 150);
2901: dbms_sql.define_column(l_dtl_qry_cur_id, 49, l_line_dtl_rec.attribute11, 150);
2902: dbms_sql.define_column(l_dtl_qry_cur_id, 50, l_line_dtl_rec.attribute12, 150);
2903: dbms_sql.define_column(l_dtl_qry_cur_id, 51, l_line_dtl_rec.attribute13, 150);

Line 2900: dbms_sql.define_column(l_dtl_qry_cur_id, 48, l_line_dtl_rec.attribute10, 150);

2896: dbms_sql.define_column(l_dtl_qry_cur_id, 44, l_line_dtl_rec.attribute6, 150);
2897: dbms_sql.define_column(l_dtl_qry_cur_id, 45, l_line_dtl_rec.attribute7, 150);
2898: dbms_sql.define_column(l_dtl_qry_cur_id, 46, l_line_dtl_rec.attribute8, 150);
2899: dbms_sql.define_column(l_dtl_qry_cur_id, 47, l_line_dtl_rec.attribute9, 150);
2900: dbms_sql.define_column(l_dtl_qry_cur_id, 48, l_line_dtl_rec.attribute10, 150);
2901: dbms_sql.define_column(l_dtl_qry_cur_id, 49, l_line_dtl_rec.attribute11, 150);
2902: dbms_sql.define_column(l_dtl_qry_cur_id, 50, l_line_dtl_rec.attribute12, 150);
2903: dbms_sql.define_column(l_dtl_qry_cur_id, 51, l_line_dtl_rec.attribute13, 150);
2904: dbms_sql.define_column(l_dtl_qry_cur_id, 52, l_line_dtl_rec.attribute14, 150);

Line 2901: dbms_sql.define_column(l_dtl_qry_cur_id, 49, l_line_dtl_rec.attribute11, 150);

2897: dbms_sql.define_column(l_dtl_qry_cur_id, 45, l_line_dtl_rec.attribute7, 150);
2898: dbms_sql.define_column(l_dtl_qry_cur_id, 46, l_line_dtl_rec.attribute8, 150);
2899: dbms_sql.define_column(l_dtl_qry_cur_id, 47, l_line_dtl_rec.attribute9, 150);
2900: dbms_sql.define_column(l_dtl_qry_cur_id, 48, l_line_dtl_rec.attribute10, 150);
2901: dbms_sql.define_column(l_dtl_qry_cur_id, 49, l_line_dtl_rec.attribute11, 150);
2902: dbms_sql.define_column(l_dtl_qry_cur_id, 50, l_line_dtl_rec.attribute12, 150);
2903: dbms_sql.define_column(l_dtl_qry_cur_id, 51, l_line_dtl_rec.attribute13, 150);
2904: dbms_sql.define_column(l_dtl_qry_cur_id, 52, l_line_dtl_rec.attribute14, 150);
2905: dbms_sql.define_column(l_dtl_qry_cur_id, 53, l_line_dtl_rec.attribute15, 150);

Line 2902: dbms_sql.define_column(l_dtl_qry_cur_id, 50, l_line_dtl_rec.attribute12, 150);

2898: dbms_sql.define_column(l_dtl_qry_cur_id, 46, l_line_dtl_rec.attribute8, 150);
2899: dbms_sql.define_column(l_dtl_qry_cur_id, 47, l_line_dtl_rec.attribute9, 150);
2900: dbms_sql.define_column(l_dtl_qry_cur_id, 48, l_line_dtl_rec.attribute10, 150);
2901: dbms_sql.define_column(l_dtl_qry_cur_id, 49, l_line_dtl_rec.attribute11, 150);
2902: dbms_sql.define_column(l_dtl_qry_cur_id, 50, l_line_dtl_rec.attribute12, 150);
2903: dbms_sql.define_column(l_dtl_qry_cur_id, 51, l_line_dtl_rec.attribute13, 150);
2904: dbms_sql.define_column(l_dtl_qry_cur_id, 52, l_line_dtl_rec.attribute14, 150);
2905: dbms_sql.define_column(l_dtl_qry_cur_id, 53, l_line_dtl_rec.attribute15, 150);
2906: dbms_sql.define_column(l_dtl_qry_cur_id, 54, l_line_dtl_rec.object_version_number);

Line 2903: dbms_sql.define_column(l_dtl_qry_cur_id, 51, l_line_dtl_rec.attribute13, 150);

2899: dbms_sql.define_column(l_dtl_qry_cur_id, 47, l_line_dtl_rec.attribute9, 150);
2900: dbms_sql.define_column(l_dtl_qry_cur_id, 48, l_line_dtl_rec.attribute10, 150);
2901: dbms_sql.define_column(l_dtl_qry_cur_id, 49, l_line_dtl_rec.attribute11, 150);
2902: dbms_sql.define_column(l_dtl_qry_cur_id, 50, l_line_dtl_rec.attribute12, 150);
2903: dbms_sql.define_column(l_dtl_qry_cur_id, 51, l_line_dtl_rec.attribute13, 150);
2904: dbms_sql.define_column(l_dtl_qry_cur_id, 52, l_line_dtl_rec.attribute14, 150);
2905: dbms_sql.define_column(l_dtl_qry_cur_id, 53, l_line_dtl_rec.attribute15, 150);
2906: dbms_sql.define_column(l_dtl_qry_cur_id, 54, l_line_dtl_rec.object_version_number);
2907: dbms_sql.define_column(l_dtl_qry_cur_id, 55, l_line_dtl_rec.source_txn_line_detail_id);

Line 2904: dbms_sql.define_column(l_dtl_qry_cur_id, 52, l_line_dtl_rec.attribute14, 150);

2900: dbms_sql.define_column(l_dtl_qry_cur_id, 48, l_line_dtl_rec.attribute10, 150);
2901: dbms_sql.define_column(l_dtl_qry_cur_id, 49, l_line_dtl_rec.attribute11, 150);
2902: dbms_sql.define_column(l_dtl_qry_cur_id, 50, l_line_dtl_rec.attribute12, 150);
2903: dbms_sql.define_column(l_dtl_qry_cur_id, 51, l_line_dtl_rec.attribute13, 150);
2904: dbms_sql.define_column(l_dtl_qry_cur_id, 52, l_line_dtl_rec.attribute14, 150);
2905: dbms_sql.define_column(l_dtl_qry_cur_id, 53, l_line_dtl_rec.attribute15, 150);
2906: dbms_sql.define_column(l_dtl_qry_cur_id, 54, l_line_dtl_rec.object_version_number);
2907: dbms_sql.define_column(l_dtl_qry_cur_id, 55, l_line_dtl_rec.source_txn_line_detail_id);
2908: dbms_sql.define_column(l_dtl_qry_cur_id, 56, l_line_dtl_rec.inv_mtl_transaction_id);

Line 2905: dbms_sql.define_column(l_dtl_qry_cur_id, 53, l_line_dtl_rec.attribute15, 150);

2901: dbms_sql.define_column(l_dtl_qry_cur_id, 49, l_line_dtl_rec.attribute11, 150);
2902: dbms_sql.define_column(l_dtl_qry_cur_id, 50, l_line_dtl_rec.attribute12, 150);
2903: dbms_sql.define_column(l_dtl_qry_cur_id, 51, l_line_dtl_rec.attribute13, 150);
2904: dbms_sql.define_column(l_dtl_qry_cur_id, 52, l_line_dtl_rec.attribute14, 150);
2905: dbms_sql.define_column(l_dtl_qry_cur_id, 53, l_line_dtl_rec.attribute15, 150);
2906: dbms_sql.define_column(l_dtl_qry_cur_id, 54, l_line_dtl_rec.object_version_number);
2907: dbms_sql.define_column(l_dtl_qry_cur_id, 55, l_line_dtl_rec.source_txn_line_detail_id);
2908: dbms_sql.define_column(l_dtl_qry_cur_id, 56, l_line_dtl_rec.inv_mtl_transaction_id);
2909: dbms_sql.define_column(l_dtl_qry_cur_id, 57, l_line_dtl_rec.config_inst_hdr_id);

Line 2906: dbms_sql.define_column(l_dtl_qry_cur_id, 54, l_line_dtl_rec.object_version_number);

2902: dbms_sql.define_column(l_dtl_qry_cur_id, 50, l_line_dtl_rec.attribute12, 150);
2903: dbms_sql.define_column(l_dtl_qry_cur_id, 51, l_line_dtl_rec.attribute13, 150);
2904: dbms_sql.define_column(l_dtl_qry_cur_id, 52, l_line_dtl_rec.attribute14, 150);
2905: dbms_sql.define_column(l_dtl_qry_cur_id, 53, l_line_dtl_rec.attribute15, 150);
2906: dbms_sql.define_column(l_dtl_qry_cur_id, 54, l_line_dtl_rec.object_version_number);
2907: dbms_sql.define_column(l_dtl_qry_cur_id, 55, l_line_dtl_rec.source_txn_line_detail_id);
2908: dbms_sql.define_column(l_dtl_qry_cur_id, 56, l_line_dtl_rec.inv_mtl_transaction_id);
2909: dbms_sql.define_column(l_dtl_qry_cur_id, 57, l_line_dtl_rec.config_inst_hdr_id);
2910: dbms_sql.define_column(l_dtl_qry_cur_id, 58, l_line_dtl_rec.config_inst_rev_num);

Line 2907: dbms_sql.define_column(l_dtl_qry_cur_id, 55, l_line_dtl_rec.source_txn_line_detail_id);

2903: dbms_sql.define_column(l_dtl_qry_cur_id, 51, l_line_dtl_rec.attribute13, 150);
2904: dbms_sql.define_column(l_dtl_qry_cur_id, 52, l_line_dtl_rec.attribute14, 150);
2905: dbms_sql.define_column(l_dtl_qry_cur_id, 53, l_line_dtl_rec.attribute15, 150);
2906: dbms_sql.define_column(l_dtl_qry_cur_id, 54, l_line_dtl_rec.object_version_number);
2907: dbms_sql.define_column(l_dtl_qry_cur_id, 55, l_line_dtl_rec.source_txn_line_detail_id);
2908: dbms_sql.define_column(l_dtl_qry_cur_id, 56, l_line_dtl_rec.inv_mtl_transaction_id);
2909: dbms_sql.define_column(l_dtl_qry_cur_id, 57, l_line_dtl_rec.config_inst_hdr_id);
2910: dbms_sql.define_column(l_dtl_qry_cur_id, 58, l_line_dtl_rec.config_inst_rev_num);
2911: dbms_sql.define_column(l_dtl_qry_cur_id, 59, l_line_dtl_rec.config_inst_item_id);

Line 2908: dbms_sql.define_column(l_dtl_qry_cur_id, 56, l_line_dtl_rec.inv_mtl_transaction_id);

2904: dbms_sql.define_column(l_dtl_qry_cur_id, 52, l_line_dtl_rec.attribute14, 150);
2905: dbms_sql.define_column(l_dtl_qry_cur_id, 53, l_line_dtl_rec.attribute15, 150);
2906: dbms_sql.define_column(l_dtl_qry_cur_id, 54, l_line_dtl_rec.object_version_number);
2907: dbms_sql.define_column(l_dtl_qry_cur_id, 55, l_line_dtl_rec.source_txn_line_detail_id);
2908: dbms_sql.define_column(l_dtl_qry_cur_id, 56, l_line_dtl_rec.inv_mtl_transaction_id);
2909: dbms_sql.define_column(l_dtl_qry_cur_id, 57, l_line_dtl_rec.config_inst_hdr_id);
2910: dbms_sql.define_column(l_dtl_qry_cur_id, 58, l_line_dtl_rec.config_inst_rev_num);
2911: dbms_sql.define_column(l_dtl_qry_cur_id, 59, l_line_dtl_rec.config_inst_item_id);
2912: dbms_sql.define_column(l_dtl_qry_cur_id, 60, l_line_dtl_rec.target_commitment_date);

Line 2909: dbms_sql.define_column(l_dtl_qry_cur_id, 57, l_line_dtl_rec.config_inst_hdr_id);

2905: dbms_sql.define_column(l_dtl_qry_cur_id, 53, l_line_dtl_rec.attribute15, 150);
2906: dbms_sql.define_column(l_dtl_qry_cur_id, 54, l_line_dtl_rec.object_version_number);
2907: dbms_sql.define_column(l_dtl_qry_cur_id, 55, l_line_dtl_rec.source_txn_line_detail_id);
2908: dbms_sql.define_column(l_dtl_qry_cur_id, 56, l_line_dtl_rec.inv_mtl_transaction_id);
2909: dbms_sql.define_column(l_dtl_qry_cur_id, 57, l_line_dtl_rec.config_inst_hdr_id);
2910: dbms_sql.define_column(l_dtl_qry_cur_id, 58, l_line_dtl_rec.config_inst_rev_num);
2911: dbms_sql.define_column(l_dtl_qry_cur_id, 59, l_line_dtl_rec.config_inst_item_id);
2912: dbms_sql.define_column(l_dtl_qry_cur_id, 60, l_line_dtl_rec.target_commitment_date);
2913: dbms_sql.define_column(l_dtl_qry_cur_id, 61 , l_line_dtl_rec.instance_description,240);

Line 2910: dbms_sql.define_column(l_dtl_qry_cur_id, 58, l_line_dtl_rec.config_inst_rev_num);

2906: dbms_sql.define_column(l_dtl_qry_cur_id, 54, l_line_dtl_rec.object_version_number);
2907: dbms_sql.define_column(l_dtl_qry_cur_id, 55, l_line_dtl_rec.source_txn_line_detail_id);
2908: dbms_sql.define_column(l_dtl_qry_cur_id, 56, l_line_dtl_rec.inv_mtl_transaction_id);
2909: dbms_sql.define_column(l_dtl_qry_cur_id, 57, l_line_dtl_rec.config_inst_hdr_id);
2910: dbms_sql.define_column(l_dtl_qry_cur_id, 58, l_line_dtl_rec.config_inst_rev_num);
2911: dbms_sql.define_column(l_dtl_qry_cur_id, 59, l_line_dtl_rec.config_inst_item_id);
2912: dbms_sql.define_column(l_dtl_qry_cur_id, 60, l_line_dtl_rec.target_commitment_date);
2913: dbms_sql.define_column(l_dtl_qry_cur_id, 61 , l_line_dtl_rec.instance_description,240);
2914: dbms_sql.define_column(l_dtl_qry_cur_id, 62 , l_line_dtl_rec.config_inst_baseline_rev_num);

Line 2911: dbms_sql.define_column(l_dtl_qry_cur_id, 59, l_line_dtl_rec.config_inst_item_id);

2907: dbms_sql.define_column(l_dtl_qry_cur_id, 55, l_line_dtl_rec.source_txn_line_detail_id);
2908: dbms_sql.define_column(l_dtl_qry_cur_id, 56, l_line_dtl_rec.inv_mtl_transaction_id);
2909: dbms_sql.define_column(l_dtl_qry_cur_id, 57, l_line_dtl_rec.config_inst_hdr_id);
2910: dbms_sql.define_column(l_dtl_qry_cur_id, 58, l_line_dtl_rec.config_inst_rev_num);
2911: dbms_sql.define_column(l_dtl_qry_cur_id, 59, l_line_dtl_rec.config_inst_item_id);
2912: dbms_sql.define_column(l_dtl_qry_cur_id, 60, l_line_dtl_rec.target_commitment_date);
2913: dbms_sql.define_column(l_dtl_qry_cur_id, 61 , l_line_dtl_rec.instance_description,240);
2914: dbms_sql.define_column(l_dtl_qry_cur_id, 62 , l_line_dtl_rec.config_inst_baseline_rev_num);
2915: dbms_sql.define_column(l_dtl_qry_cur_id, 63, l_line_dtl_rec.reference_source_line_id);

Line 2912: dbms_sql.define_column(l_dtl_qry_cur_id, 60, l_line_dtl_rec.target_commitment_date);

2908: dbms_sql.define_column(l_dtl_qry_cur_id, 56, l_line_dtl_rec.inv_mtl_transaction_id);
2909: dbms_sql.define_column(l_dtl_qry_cur_id, 57, l_line_dtl_rec.config_inst_hdr_id);
2910: dbms_sql.define_column(l_dtl_qry_cur_id, 58, l_line_dtl_rec.config_inst_rev_num);
2911: dbms_sql.define_column(l_dtl_qry_cur_id, 59, l_line_dtl_rec.config_inst_item_id);
2912: dbms_sql.define_column(l_dtl_qry_cur_id, 60, l_line_dtl_rec.target_commitment_date);
2913: dbms_sql.define_column(l_dtl_qry_cur_id, 61 , l_line_dtl_rec.instance_description,240);
2914: dbms_sql.define_column(l_dtl_qry_cur_id, 62 , l_line_dtl_rec.config_inst_baseline_rev_num);
2915: dbms_sql.define_column(l_dtl_qry_cur_id, 63, l_line_dtl_rec.reference_source_line_id);
2916: dbms_sql.define_column(l_dtl_qry_cur_id, 64, l_line_dtl_rec.install_location_type_code,60);

Line 2913: dbms_sql.define_column(l_dtl_qry_cur_id, 61 , l_line_dtl_rec.instance_description,240);

2909: dbms_sql.define_column(l_dtl_qry_cur_id, 57, l_line_dtl_rec.config_inst_hdr_id);
2910: dbms_sql.define_column(l_dtl_qry_cur_id, 58, l_line_dtl_rec.config_inst_rev_num);
2911: dbms_sql.define_column(l_dtl_qry_cur_id, 59, l_line_dtl_rec.config_inst_item_id);
2912: dbms_sql.define_column(l_dtl_qry_cur_id, 60, l_line_dtl_rec.target_commitment_date);
2913: dbms_sql.define_column(l_dtl_qry_cur_id, 61 , l_line_dtl_rec.instance_description,240);
2914: dbms_sql.define_column(l_dtl_qry_cur_id, 62 , l_line_dtl_rec.config_inst_baseline_rev_num);
2915: dbms_sql.define_column(l_dtl_qry_cur_id, 63, l_line_dtl_rec.reference_source_line_id);
2916: dbms_sql.define_column(l_dtl_qry_cur_id, 64, l_line_dtl_rec.install_location_type_code,60);
2917: dbms_sql.define_column(l_dtl_qry_cur_id, 65, l_line_dtl_rec.install_location_id);

Line 2914: dbms_sql.define_column(l_dtl_qry_cur_id, 62 , l_line_dtl_rec.config_inst_baseline_rev_num);

2910: dbms_sql.define_column(l_dtl_qry_cur_id, 58, l_line_dtl_rec.config_inst_rev_num);
2911: dbms_sql.define_column(l_dtl_qry_cur_id, 59, l_line_dtl_rec.config_inst_item_id);
2912: dbms_sql.define_column(l_dtl_qry_cur_id, 60, l_line_dtl_rec.target_commitment_date);
2913: dbms_sql.define_column(l_dtl_qry_cur_id, 61 , l_line_dtl_rec.instance_description,240);
2914: dbms_sql.define_column(l_dtl_qry_cur_id, 62 , l_line_dtl_rec.config_inst_baseline_rev_num);
2915: dbms_sql.define_column(l_dtl_qry_cur_id, 63, l_line_dtl_rec.reference_source_line_id);
2916: dbms_sql.define_column(l_dtl_qry_cur_id, 64, l_line_dtl_rec.install_location_type_code,60);
2917: dbms_sql.define_column(l_dtl_qry_cur_id, 65, l_line_dtl_rec.install_location_id);
2918: dbms_sql.define_column(l_dtl_qry_cur_id, 66, l_line_dtl_rec.cascade_owner_flag,1);

Line 2915: dbms_sql.define_column(l_dtl_qry_cur_id, 63, l_line_dtl_rec.reference_source_line_id);

2911: dbms_sql.define_column(l_dtl_qry_cur_id, 59, l_line_dtl_rec.config_inst_item_id);
2912: dbms_sql.define_column(l_dtl_qry_cur_id, 60, l_line_dtl_rec.target_commitment_date);
2913: dbms_sql.define_column(l_dtl_qry_cur_id, 61 , l_line_dtl_rec.instance_description,240);
2914: dbms_sql.define_column(l_dtl_qry_cur_id, 62 , l_line_dtl_rec.config_inst_baseline_rev_num);
2915: dbms_sql.define_column(l_dtl_qry_cur_id, 63, l_line_dtl_rec.reference_source_line_id);
2916: dbms_sql.define_column(l_dtl_qry_cur_id, 64, l_line_dtl_rec.install_location_type_code,60);
2917: dbms_sql.define_column(l_dtl_qry_cur_id, 65, l_line_dtl_rec.install_location_id);
2918: dbms_sql.define_column(l_dtl_qry_cur_id, 66, l_line_dtl_rec.cascade_owner_flag,1);
2919: dbms_sql.define_column(l_dtl_qry_cur_id, 67, l_line_dtl_rec.parent_instance_id);

Line 2916: dbms_sql.define_column(l_dtl_qry_cur_id, 64, l_line_dtl_rec.install_location_type_code,60);

2912: dbms_sql.define_column(l_dtl_qry_cur_id, 60, l_line_dtl_rec.target_commitment_date);
2913: dbms_sql.define_column(l_dtl_qry_cur_id, 61 , l_line_dtl_rec.instance_description,240);
2914: dbms_sql.define_column(l_dtl_qry_cur_id, 62 , l_line_dtl_rec.config_inst_baseline_rev_num);
2915: dbms_sql.define_column(l_dtl_qry_cur_id, 63, l_line_dtl_rec.reference_source_line_id);
2916: dbms_sql.define_column(l_dtl_qry_cur_id, 64, l_line_dtl_rec.install_location_type_code,60);
2917: dbms_sql.define_column(l_dtl_qry_cur_id, 65, l_line_dtl_rec.install_location_id);
2918: dbms_sql.define_column(l_dtl_qry_cur_id, 66, l_line_dtl_rec.cascade_owner_flag,1);
2919: dbms_sql.define_column(l_dtl_qry_cur_id, 67, l_line_dtl_rec.parent_instance_id);
2920: dbms_sql.define_column(l_dtl_qry_cur_id, 68, l_line_dtl_rec.assc_txn_line_detail_id);

Line 2917: dbms_sql.define_column(l_dtl_qry_cur_id, 65, l_line_dtl_rec.install_location_id);

2913: dbms_sql.define_column(l_dtl_qry_cur_id, 61 , l_line_dtl_rec.instance_description,240);
2914: dbms_sql.define_column(l_dtl_qry_cur_id, 62 , l_line_dtl_rec.config_inst_baseline_rev_num);
2915: dbms_sql.define_column(l_dtl_qry_cur_id, 63, l_line_dtl_rec.reference_source_line_id);
2916: dbms_sql.define_column(l_dtl_qry_cur_id, 64, l_line_dtl_rec.install_location_type_code,60);
2917: dbms_sql.define_column(l_dtl_qry_cur_id, 65, l_line_dtl_rec.install_location_id);
2918: dbms_sql.define_column(l_dtl_qry_cur_id, 66, l_line_dtl_rec.cascade_owner_flag,1);
2919: dbms_sql.define_column(l_dtl_qry_cur_id, 67, l_line_dtl_rec.parent_instance_id);
2920: dbms_sql.define_column(l_dtl_qry_cur_id, 68, l_line_dtl_rec.assc_txn_line_detail_id);
2921: dbms_sql.define_column(l_dtl_qry_cur_id, 69, l_line_dtl_rec.overriding_csi_txn_id);

Line 2918: dbms_sql.define_column(l_dtl_qry_cur_id, 66, l_line_dtl_rec.cascade_owner_flag,1);

2914: dbms_sql.define_column(l_dtl_qry_cur_id, 62 , l_line_dtl_rec.config_inst_baseline_rev_num);
2915: dbms_sql.define_column(l_dtl_qry_cur_id, 63, l_line_dtl_rec.reference_source_line_id);
2916: dbms_sql.define_column(l_dtl_qry_cur_id, 64, l_line_dtl_rec.install_location_type_code,60);
2917: dbms_sql.define_column(l_dtl_qry_cur_id, 65, l_line_dtl_rec.install_location_id);
2918: dbms_sql.define_column(l_dtl_qry_cur_id, 66, l_line_dtl_rec.cascade_owner_flag,1);
2919: dbms_sql.define_column(l_dtl_qry_cur_id, 67, l_line_dtl_rec.parent_instance_id);
2920: dbms_sql.define_column(l_dtl_qry_cur_id, 68, l_line_dtl_rec.assc_txn_line_detail_id);
2921: dbms_sql.define_column(l_dtl_qry_cur_id, 69, l_line_dtl_rec.overriding_csi_txn_id);
2922: dbms_sql.define_column(l_dtl_qry_cur_id, 70, l_line_dtl_rec.instance_status_id);

Line 2919: dbms_sql.define_column(l_dtl_qry_cur_id, 67, l_line_dtl_rec.parent_instance_id);

2915: dbms_sql.define_column(l_dtl_qry_cur_id, 63, l_line_dtl_rec.reference_source_line_id);
2916: dbms_sql.define_column(l_dtl_qry_cur_id, 64, l_line_dtl_rec.install_location_type_code,60);
2917: dbms_sql.define_column(l_dtl_qry_cur_id, 65, l_line_dtl_rec.install_location_id);
2918: dbms_sql.define_column(l_dtl_qry_cur_id, 66, l_line_dtl_rec.cascade_owner_flag,1);
2919: dbms_sql.define_column(l_dtl_qry_cur_id, 67, l_line_dtl_rec.parent_instance_id);
2920: dbms_sql.define_column(l_dtl_qry_cur_id, 68, l_line_dtl_rec.assc_txn_line_detail_id);
2921: dbms_sql.define_column(l_dtl_qry_cur_id, 69, l_line_dtl_rec.overriding_csi_txn_id);
2922: dbms_sql.define_column(l_dtl_qry_cur_id, 70, l_line_dtl_rec.instance_status_id);
2923:

Line 2920: dbms_sql.define_column(l_dtl_qry_cur_id, 68, l_line_dtl_rec.assc_txn_line_detail_id);

2916: dbms_sql.define_column(l_dtl_qry_cur_id, 64, l_line_dtl_rec.install_location_type_code,60);
2917: dbms_sql.define_column(l_dtl_qry_cur_id, 65, l_line_dtl_rec.install_location_id);
2918: dbms_sql.define_column(l_dtl_qry_cur_id, 66, l_line_dtl_rec.cascade_owner_flag,1);
2919: dbms_sql.define_column(l_dtl_qry_cur_id, 67, l_line_dtl_rec.parent_instance_id);
2920: dbms_sql.define_column(l_dtl_qry_cur_id, 68, l_line_dtl_rec.assc_txn_line_detail_id);
2921: dbms_sql.define_column(l_dtl_qry_cur_id, 69, l_line_dtl_rec.overriding_csi_txn_id);
2922: dbms_sql.define_column(l_dtl_qry_cur_id, 70, l_line_dtl_rec.instance_status_id);
2923:
2924: l_ind := 0;

Line 2921: dbms_sql.define_column(l_dtl_qry_cur_id, 69, l_line_dtl_rec.overriding_csi_txn_id);

2917: dbms_sql.define_column(l_dtl_qry_cur_id, 65, l_line_dtl_rec.install_location_id);
2918: dbms_sql.define_column(l_dtl_qry_cur_id, 66, l_line_dtl_rec.cascade_owner_flag,1);
2919: dbms_sql.define_column(l_dtl_qry_cur_id, 67, l_line_dtl_rec.parent_instance_id);
2920: dbms_sql.define_column(l_dtl_qry_cur_id, 68, l_line_dtl_rec.assc_txn_line_detail_id);
2921: dbms_sql.define_column(l_dtl_qry_cur_id, 69, l_line_dtl_rec.overriding_csi_txn_id);
2922: dbms_sql.define_column(l_dtl_qry_cur_id, 70, l_line_dtl_rec.instance_status_id);
2923:
2924: l_ind := 0;
2925:

Line 2922: dbms_sql.define_column(l_dtl_qry_cur_id, 70, l_line_dtl_rec.instance_status_id);

2918: dbms_sql.define_column(l_dtl_qry_cur_id, 66, l_line_dtl_rec.cascade_owner_flag,1);
2919: dbms_sql.define_column(l_dtl_qry_cur_id, 67, l_line_dtl_rec.parent_instance_id);
2920: dbms_sql.define_column(l_dtl_qry_cur_id, 68, l_line_dtl_rec.assc_txn_line_detail_id);
2921: dbms_sql.define_column(l_dtl_qry_cur_id, 69, l_line_dtl_rec.overriding_csi_txn_id);
2922: dbms_sql.define_column(l_dtl_qry_cur_id, 70, l_line_dtl_rec.instance_status_id);
2923:
2924: l_ind := 0;
2925:
2926: l_processed_rows := dbms_sql.execute(l_dtl_qry_cur_id);

Line 2926: l_processed_rows := dbms_sql.execute(l_dtl_qry_cur_id);

2922: dbms_sql.define_column(l_dtl_qry_cur_id, 70, l_line_dtl_rec.instance_status_id);
2923:
2924: l_ind := 0;
2925:
2926: l_processed_rows := dbms_sql.execute(l_dtl_qry_cur_id);
2927: LOOP
2928: exit when dbms_sql.fetch_rows(l_dtl_qry_cur_id) = 0;
2929:
2930: l_ind := l_ind + 1;

Line 2928: exit when dbms_sql.fetch_rows(l_dtl_qry_cur_id) = 0;

2924: l_ind := 0;
2925:
2926: l_processed_rows := dbms_sql.execute(l_dtl_qry_cur_id);
2927: LOOP
2928: exit when dbms_sql.fetch_rows(l_dtl_qry_cur_id) = 0;
2929:
2930: l_ind := l_ind + 1;
2931:
2932: dbms_sql.column_value(l_dtl_qry_cur_id, 1, x_line_dtls_tbl(l_ind).txn_line_detail_id);

Line 2932: dbms_sql.column_value(l_dtl_qry_cur_id, 1, x_line_dtls_tbl(l_ind).txn_line_detail_id);

2928: exit when dbms_sql.fetch_rows(l_dtl_qry_cur_id) = 0;
2929:
2930: l_ind := l_ind + 1;
2931:
2932: dbms_sql.column_value(l_dtl_qry_cur_id, 1, x_line_dtls_tbl(l_ind).txn_line_detail_id);
2933: dbms_sql.column_value(l_dtl_qry_cur_id, 2, x_line_dtls_tbl(l_ind).transaction_line_id);
2934: dbms_sql.column_value(l_dtl_qry_cur_id, 3, x_line_dtls_tbl(l_ind).sub_type_id);
2935: dbms_sql.column_value(l_dtl_qry_cur_id, 4, x_line_dtls_tbl(l_ind).instance_exists_flag);
2936: dbms_sql.column_value(l_dtl_qry_cur_id, 5, x_line_dtls_tbl(l_ind).source_transaction_flag);

Line 2933: dbms_sql.column_value(l_dtl_qry_cur_id, 2, x_line_dtls_tbl(l_ind).transaction_line_id);

2929:
2930: l_ind := l_ind + 1;
2931:
2932: dbms_sql.column_value(l_dtl_qry_cur_id, 1, x_line_dtls_tbl(l_ind).txn_line_detail_id);
2933: dbms_sql.column_value(l_dtl_qry_cur_id, 2, x_line_dtls_tbl(l_ind).transaction_line_id);
2934: dbms_sql.column_value(l_dtl_qry_cur_id, 3, x_line_dtls_tbl(l_ind).sub_type_id);
2935: dbms_sql.column_value(l_dtl_qry_cur_id, 4, x_line_dtls_tbl(l_ind).instance_exists_flag);
2936: dbms_sql.column_value(l_dtl_qry_cur_id, 5, x_line_dtls_tbl(l_ind).source_transaction_flag);
2937: dbms_sql.column_value(l_dtl_qry_cur_id, 6, x_line_dtls_tbl(l_ind).instance_id);

Line 2934: dbms_sql.column_value(l_dtl_qry_cur_id, 3, x_line_dtls_tbl(l_ind).sub_type_id);

2930: l_ind := l_ind + 1;
2931:
2932: dbms_sql.column_value(l_dtl_qry_cur_id, 1, x_line_dtls_tbl(l_ind).txn_line_detail_id);
2933: dbms_sql.column_value(l_dtl_qry_cur_id, 2, x_line_dtls_tbl(l_ind).transaction_line_id);
2934: dbms_sql.column_value(l_dtl_qry_cur_id, 3, x_line_dtls_tbl(l_ind).sub_type_id);
2935: dbms_sql.column_value(l_dtl_qry_cur_id, 4, x_line_dtls_tbl(l_ind).instance_exists_flag);
2936: dbms_sql.column_value(l_dtl_qry_cur_id, 5, x_line_dtls_tbl(l_ind).source_transaction_flag);
2937: dbms_sql.column_value(l_dtl_qry_cur_id, 6, x_line_dtls_tbl(l_ind).instance_id);
2938: dbms_sql.column_value(l_dtl_qry_cur_id, 7, x_line_dtls_tbl(l_ind).changed_instance_id);

Line 2935: dbms_sql.column_value(l_dtl_qry_cur_id, 4, x_line_dtls_tbl(l_ind).instance_exists_flag);

2931:
2932: dbms_sql.column_value(l_dtl_qry_cur_id, 1, x_line_dtls_tbl(l_ind).txn_line_detail_id);
2933: dbms_sql.column_value(l_dtl_qry_cur_id, 2, x_line_dtls_tbl(l_ind).transaction_line_id);
2934: dbms_sql.column_value(l_dtl_qry_cur_id, 3, x_line_dtls_tbl(l_ind).sub_type_id);
2935: dbms_sql.column_value(l_dtl_qry_cur_id, 4, x_line_dtls_tbl(l_ind).instance_exists_flag);
2936: dbms_sql.column_value(l_dtl_qry_cur_id, 5, x_line_dtls_tbl(l_ind).source_transaction_flag);
2937: dbms_sql.column_value(l_dtl_qry_cur_id, 6, x_line_dtls_tbl(l_ind).instance_id);
2938: dbms_sql.column_value(l_dtl_qry_cur_id, 7, x_line_dtls_tbl(l_ind).changed_instance_id);
2939: dbms_sql.column_value(l_dtl_qry_cur_id, 8, x_line_dtls_tbl(l_ind).csi_system_id);

Line 2936: dbms_sql.column_value(l_dtl_qry_cur_id, 5, x_line_dtls_tbl(l_ind).source_transaction_flag);

2932: dbms_sql.column_value(l_dtl_qry_cur_id, 1, x_line_dtls_tbl(l_ind).txn_line_detail_id);
2933: dbms_sql.column_value(l_dtl_qry_cur_id, 2, x_line_dtls_tbl(l_ind).transaction_line_id);
2934: dbms_sql.column_value(l_dtl_qry_cur_id, 3, x_line_dtls_tbl(l_ind).sub_type_id);
2935: dbms_sql.column_value(l_dtl_qry_cur_id, 4, x_line_dtls_tbl(l_ind).instance_exists_flag);
2936: dbms_sql.column_value(l_dtl_qry_cur_id, 5, x_line_dtls_tbl(l_ind).source_transaction_flag);
2937: dbms_sql.column_value(l_dtl_qry_cur_id, 6, x_line_dtls_tbl(l_ind).instance_id);
2938: dbms_sql.column_value(l_dtl_qry_cur_id, 7, x_line_dtls_tbl(l_ind).changed_instance_id);
2939: dbms_sql.column_value(l_dtl_qry_cur_id, 8, x_line_dtls_tbl(l_ind).csi_system_id);
2940: dbms_sql.column_value(l_dtl_qry_cur_id, 9, x_line_dtls_tbl(l_ind).inventory_item_id);

Line 2937: dbms_sql.column_value(l_dtl_qry_cur_id, 6, x_line_dtls_tbl(l_ind).instance_id);

2933: dbms_sql.column_value(l_dtl_qry_cur_id, 2, x_line_dtls_tbl(l_ind).transaction_line_id);
2934: dbms_sql.column_value(l_dtl_qry_cur_id, 3, x_line_dtls_tbl(l_ind).sub_type_id);
2935: dbms_sql.column_value(l_dtl_qry_cur_id, 4, x_line_dtls_tbl(l_ind).instance_exists_flag);
2936: dbms_sql.column_value(l_dtl_qry_cur_id, 5, x_line_dtls_tbl(l_ind).source_transaction_flag);
2937: dbms_sql.column_value(l_dtl_qry_cur_id, 6, x_line_dtls_tbl(l_ind).instance_id);
2938: dbms_sql.column_value(l_dtl_qry_cur_id, 7, x_line_dtls_tbl(l_ind).changed_instance_id);
2939: dbms_sql.column_value(l_dtl_qry_cur_id, 8, x_line_dtls_tbl(l_ind).csi_system_id);
2940: dbms_sql.column_value(l_dtl_qry_cur_id, 9, x_line_dtls_tbl(l_ind).inventory_item_id);
2941: dbms_sql.column_value(l_dtl_qry_cur_id, 10, x_line_dtls_tbl(l_ind).inventory_revision);

Line 2938: dbms_sql.column_value(l_dtl_qry_cur_id, 7, x_line_dtls_tbl(l_ind).changed_instance_id);

2934: dbms_sql.column_value(l_dtl_qry_cur_id, 3, x_line_dtls_tbl(l_ind).sub_type_id);
2935: dbms_sql.column_value(l_dtl_qry_cur_id, 4, x_line_dtls_tbl(l_ind).instance_exists_flag);
2936: dbms_sql.column_value(l_dtl_qry_cur_id, 5, x_line_dtls_tbl(l_ind).source_transaction_flag);
2937: dbms_sql.column_value(l_dtl_qry_cur_id, 6, x_line_dtls_tbl(l_ind).instance_id);
2938: dbms_sql.column_value(l_dtl_qry_cur_id, 7, x_line_dtls_tbl(l_ind).changed_instance_id);
2939: dbms_sql.column_value(l_dtl_qry_cur_id, 8, x_line_dtls_tbl(l_ind).csi_system_id);
2940: dbms_sql.column_value(l_dtl_qry_cur_id, 9, x_line_dtls_tbl(l_ind).inventory_item_id);
2941: dbms_sql.column_value(l_dtl_qry_cur_id, 10, x_line_dtls_tbl(l_ind).inventory_revision);
2942: dbms_sql.column_value(l_dtl_qry_cur_id, 11, x_line_dtls_tbl(l_ind).inv_organization_id);

Line 2939: dbms_sql.column_value(l_dtl_qry_cur_id, 8, x_line_dtls_tbl(l_ind).csi_system_id);

2935: dbms_sql.column_value(l_dtl_qry_cur_id, 4, x_line_dtls_tbl(l_ind).instance_exists_flag);
2936: dbms_sql.column_value(l_dtl_qry_cur_id, 5, x_line_dtls_tbl(l_ind).source_transaction_flag);
2937: dbms_sql.column_value(l_dtl_qry_cur_id, 6, x_line_dtls_tbl(l_ind).instance_id);
2938: dbms_sql.column_value(l_dtl_qry_cur_id, 7, x_line_dtls_tbl(l_ind).changed_instance_id);
2939: dbms_sql.column_value(l_dtl_qry_cur_id, 8, x_line_dtls_tbl(l_ind).csi_system_id);
2940: dbms_sql.column_value(l_dtl_qry_cur_id, 9, x_line_dtls_tbl(l_ind).inventory_item_id);
2941: dbms_sql.column_value(l_dtl_qry_cur_id, 10, x_line_dtls_tbl(l_ind).inventory_revision);
2942: dbms_sql.column_value(l_dtl_qry_cur_id, 11, x_line_dtls_tbl(l_ind).inv_organization_id);
2943: dbms_sql.column_value(l_dtl_qry_cur_id, 12, x_line_dtls_tbl(l_ind).item_condition_id);

Line 2940: dbms_sql.column_value(l_dtl_qry_cur_id, 9, x_line_dtls_tbl(l_ind).inventory_item_id);

2936: dbms_sql.column_value(l_dtl_qry_cur_id, 5, x_line_dtls_tbl(l_ind).source_transaction_flag);
2937: dbms_sql.column_value(l_dtl_qry_cur_id, 6, x_line_dtls_tbl(l_ind).instance_id);
2938: dbms_sql.column_value(l_dtl_qry_cur_id, 7, x_line_dtls_tbl(l_ind).changed_instance_id);
2939: dbms_sql.column_value(l_dtl_qry_cur_id, 8, x_line_dtls_tbl(l_ind).csi_system_id);
2940: dbms_sql.column_value(l_dtl_qry_cur_id, 9, x_line_dtls_tbl(l_ind).inventory_item_id);
2941: dbms_sql.column_value(l_dtl_qry_cur_id, 10, x_line_dtls_tbl(l_ind).inventory_revision);
2942: dbms_sql.column_value(l_dtl_qry_cur_id, 11, x_line_dtls_tbl(l_ind).inv_organization_id);
2943: dbms_sql.column_value(l_dtl_qry_cur_id, 12, x_line_dtls_tbl(l_ind).item_condition_id);
2944: dbms_sql.column_value(l_dtl_qry_cur_id, 13, x_line_dtls_tbl(l_ind).instance_type_code);

Line 2941: dbms_sql.column_value(l_dtl_qry_cur_id, 10, x_line_dtls_tbl(l_ind).inventory_revision);

2937: dbms_sql.column_value(l_dtl_qry_cur_id, 6, x_line_dtls_tbl(l_ind).instance_id);
2938: dbms_sql.column_value(l_dtl_qry_cur_id, 7, x_line_dtls_tbl(l_ind).changed_instance_id);
2939: dbms_sql.column_value(l_dtl_qry_cur_id, 8, x_line_dtls_tbl(l_ind).csi_system_id);
2940: dbms_sql.column_value(l_dtl_qry_cur_id, 9, x_line_dtls_tbl(l_ind).inventory_item_id);
2941: dbms_sql.column_value(l_dtl_qry_cur_id, 10, x_line_dtls_tbl(l_ind).inventory_revision);
2942: dbms_sql.column_value(l_dtl_qry_cur_id, 11, x_line_dtls_tbl(l_ind).inv_organization_id);
2943: dbms_sql.column_value(l_dtl_qry_cur_id, 12, x_line_dtls_tbl(l_ind).item_condition_id);
2944: dbms_sql.column_value(l_dtl_qry_cur_id, 13, x_line_dtls_tbl(l_ind).instance_type_code);
2945: dbms_sql.column_value(l_dtl_qry_cur_id, 14, x_line_dtls_tbl(l_ind).quantity);

Line 2942: dbms_sql.column_value(l_dtl_qry_cur_id, 11, x_line_dtls_tbl(l_ind).inv_organization_id);

2938: dbms_sql.column_value(l_dtl_qry_cur_id, 7, x_line_dtls_tbl(l_ind).changed_instance_id);
2939: dbms_sql.column_value(l_dtl_qry_cur_id, 8, x_line_dtls_tbl(l_ind).csi_system_id);
2940: dbms_sql.column_value(l_dtl_qry_cur_id, 9, x_line_dtls_tbl(l_ind).inventory_item_id);
2941: dbms_sql.column_value(l_dtl_qry_cur_id, 10, x_line_dtls_tbl(l_ind).inventory_revision);
2942: dbms_sql.column_value(l_dtl_qry_cur_id, 11, x_line_dtls_tbl(l_ind).inv_organization_id);
2943: dbms_sql.column_value(l_dtl_qry_cur_id, 12, x_line_dtls_tbl(l_ind).item_condition_id);
2944: dbms_sql.column_value(l_dtl_qry_cur_id, 13, x_line_dtls_tbl(l_ind).instance_type_code);
2945: dbms_sql.column_value(l_dtl_qry_cur_id, 14, x_line_dtls_tbl(l_ind).quantity);
2946: dbms_sql.column_value(l_dtl_qry_cur_id, 15, x_line_dtls_tbl(l_ind).unit_of_measure);

Line 2943: dbms_sql.column_value(l_dtl_qry_cur_id, 12, x_line_dtls_tbl(l_ind).item_condition_id);

2939: dbms_sql.column_value(l_dtl_qry_cur_id, 8, x_line_dtls_tbl(l_ind).csi_system_id);
2940: dbms_sql.column_value(l_dtl_qry_cur_id, 9, x_line_dtls_tbl(l_ind).inventory_item_id);
2941: dbms_sql.column_value(l_dtl_qry_cur_id, 10, x_line_dtls_tbl(l_ind).inventory_revision);
2942: dbms_sql.column_value(l_dtl_qry_cur_id, 11, x_line_dtls_tbl(l_ind).inv_organization_id);
2943: dbms_sql.column_value(l_dtl_qry_cur_id, 12, x_line_dtls_tbl(l_ind).item_condition_id);
2944: dbms_sql.column_value(l_dtl_qry_cur_id, 13, x_line_dtls_tbl(l_ind).instance_type_code);
2945: dbms_sql.column_value(l_dtl_qry_cur_id, 14, x_line_dtls_tbl(l_ind).quantity);
2946: dbms_sql.column_value(l_dtl_qry_cur_id, 15, x_line_dtls_tbl(l_ind).unit_of_measure);
2947: dbms_sql.column_value(l_dtl_qry_cur_id, 16, x_line_dtls_tbl(l_ind).qty_remaining);

Line 2944: dbms_sql.column_value(l_dtl_qry_cur_id, 13, x_line_dtls_tbl(l_ind).instance_type_code);

2940: dbms_sql.column_value(l_dtl_qry_cur_id, 9, x_line_dtls_tbl(l_ind).inventory_item_id);
2941: dbms_sql.column_value(l_dtl_qry_cur_id, 10, x_line_dtls_tbl(l_ind).inventory_revision);
2942: dbms_sql.column_value(l_dtl_qry_cur_id, 11, x_line_dtls_tbl(l_ind).inv_organization_id);
2943: dbms_sql.column_value(l_dtl_qry_cur_id, 12, x_line_dtls_tbl(l_ind).item_condition_id);
2944: dbms_sql.column_value(l_dtl_qry_cur_id, 13, x_line_dtls_tbl(l_ind).instance_type_code);
2945: dbms_sql.column_value(l_dtl_qry_cur_id, 14, x_line_dtls_tbl(l_ind).quantity);
2946: dbms_sql.column_value(l_dtl_qry_cur_id, 15, x_line_dtls_tbl(l_ind).unit_of_measure);
2947: dbms_sql.column_value(l_dtl_qry_cur_id, 16, x_line_dtls_tbl(l_ind).qty_remaining);
2948: dbms_sql.column_value(l_dtl_qry_cur_id, 17, x_line_dtls_tbl(l_ind).serial_number);

Line 2945: dbms_sql.column_value(l_dtl_qry_cur_id, 14, x_line_dtls_tbl(l_ind).quantity);

2941: dbms_sql.column_value(l_dtl_qry_cur_id, 10, x_line_dtls_tbl(l_ind).inventory_revision);
2942: dbms_sql.column_value(l_dtl_qry_cur_id, 11, x_line_dtls_tbl(l_ind).inv_organization_id);
2943: dbms_sql.column_value(l_dtl_qry_cur_id, 12, x_line_dtls_tbl(l_ind).item_condition_id);
2944: dbms_sql.column_value(l_dtl_qry_cur_id, 13, x_line_dtls_tbl(l_ind).instance_type_code);
2945: dbms_sql.column_value(l_dtl_qry_cur_id, 14, x_line_dtls_tbl(l_ind).quantity);
2946: dbms_sql.column_value(l_dtl_qry_cur_id, 15, x_line_dtls_tbl(l_ind).unit_of_measure);
2947: dbms_sql.column_value(l_dtl_qry_cur_id, 16, x_line_dtls_tbl(l_ind).qty_remaining);
2948: dbms_sql.column_value(l_dtl_qry_cur_id, 17, x_line_dtls_tbl(l_ind).serial_number);
2949: dbms_sql.column_value(l_dtl_qry_cur_id, 18, x_line_dtls_tbl(l_ind).mfg_serial_number_flag);

Line 2946: dbms_sql.column_value(l_dtl_qry_cur_id, 15, x_line_dtls_tbl(l_ind).unit_of_measure);

2942: dbms_sql.column_value(l_dtl_qry_cur_id, 11, x_line_dtls_tbl(l_ind).inv_organization_id);
2943: dbms_sql.column_value(l_dtl_qry_cur_id, 12, x_line_dtls_tbl(l_ind).item_condition_id);
2944: dbms_sql.column_value(l_dtl_qry_cur_id, 13, x_line_dtls_tbl(l_ind).instance_type_code);
2945: dbms_sql.column_value(l_dtl_qry_cur_id, 14, x_line_dtls_tbl(l_ind).quantity);
2946: dbms_sql.column_value(l_dtl_qry_cur_id, 15, x_line_dtls_tbl(l_ind).unit_of_measure);
2947: dbms_sql.column_value(l_dtl_qry_cur_id, 16, x_line_dtls_tbl(l_ind).qty_remaining);
2948: dbms_sql.column_value(l_dtl_qry_cur_id, 17, x_line_dtls_tbl(l_ind).serial_number);
2949: dbms_sql.column_value(l_dtl_qry_cur_id, 18, x_line_dtls_tbl(l_ind).mfg_serial_number_flag);
2950: dbms_sql.column_value(l_dtl_qry_cur_id, 19, x_line_dtls_tbl(l_ind).lot_number);

Line 2947: dbms_sql.column_value(l_dtl_qry_cur_id, 16, x_line_dtls_tbl(l_ind).qty_remaining);

2943: dbms_sql.column_value(l_dtl_qry_cur_id, 12, x_line_dtls_tbl(l_ind).item_condition_id);
2944: dbms_sql.column_value(l_dtl_qry_cur_id, 13, x_line_dtls_tbl(l_ind).instance_type_code);
2945: dbms_sql.column_value(l_dtl_qry_cur_id, 14, x_line_dtls_tbl(l_ind).quantity);
2946: dbms_sql.column_value(l_dtl_qry_cur_id, 15, x_line_dtls_tbl(l_ind).unit_of_measure);
2947: dbms_sql.column_value(l_dtl_qry_cur_id, 16, x_line_dtls_tbl(l_ind).qty_remaining);
2948: dbms_sql.column_value(l_dtl_qry_cur_id, 17, x_line_dtls_tbl(l_ind).serial_number);
2949: dbms_sql.column_value(l_dtl_qry_cur_id, 18, x_line_dtls_tbl(l_ind).mfg_serial_number_flag);
2950: dbms_sql.column_value(l_dtl_qry_cur_id, 19, x_line_dtls_tbl(l_ind).lot_number);
2951: dbms_sql.column_value(l_dtl_qry_cur_id, 20, x_line_dtls_tbl(l_ind).location_type_code);

Line 2948: dbms_sql.column_value(l_dtl_qry_cur_id, 17, x_line_dtls_tbl(l_ind).serial_number);

2944: dbms_sql.column_value(l_dtl_qry_cur_id, 13, x_line_dtls_tbl(l_ind).instance_type_code);
2945: dbms_sql.column_value(l_dtl_qry_cur_id, 14, x_line_dtls_tbl(l_ind).quantity);
2946: dbms_sql.column_value(l_dtl_qry_cur_id, 15, x_line_dtls_tbl(l_ind).unit_of_measure);
2947: dbms_sql.column_value(l_dtl_qry_cur_id, 16, x_line_dtls_tbl(l_ind).qty_remaining);
2948: dbms_sql.column_value(l_dtl_qry_cur_id, 17, x_line_dtls_tbl(l_ind).serial_number);
2949: dbms_sql.column_value(l_dtl_qry_cur_id, 18, x_line_dtls_tbl(l_ind).mfg_serial_number_flag);
2950: dbms_sql.column_value(l_dtl_qry_cur_id, 19, x_line_dtls_tbl(l_ind).lot_number);
2951: dbms_sql.column_value(l_dtl_qry_cur_id, 20, x_line_dtls_tbl(l_ind).location_type_code);
2952: dbms_sql.column_value(l_dtl_qry_cur_id, 21, x_line_dtls_tbl(l_ind).location_id);

Line 2949: dbms_sql.column_value(l_dtl_qry_cur_id, 18, x_line_dtls_tbl(l_ind).mfg_serial_number_flag);

2945: dbms_sql.column_value(l_dtl_qry_cur_id, 14, x_line_dtls_tbl(l_ind).quantity);
2946: dbms_sql.column_value(l_dtl_qry_cur_id, 15, x_line_dtls_tbl(l_ind).unit_of_measure);
2947: dbms_sql.column_value(l_dtl_qry_cur_id, 16, x_line_dtls_tbl(l_ind).qty_remaining);
2948: dbms_sql.column_value(l_dtl_qry_cur_id, 17, x_line_dtls_tbl(l_ind).serial_number);
2949: dbms_sql.column_value(l_dtl_qry_cur_id, 18, x_line_dtls_tbl(l_ind).mfg_serial_number_flag);
2950: dbms_sql.column_value(l_dtl_qry_cur_id, 19, x_line_dtls_tbl(l_ind).lot_number);
2951: dbms_sql.column_value(l_dtl_qry_cur_id, 20, x_line_dtls_tbl(l_ind).location_type_code);
2952: dbms_sql.column_value(l_dtl_qry_cur_id, 21, x_line_dtls_tbl(l_ind).location_id);
2953: dbms_sql.column_value(l_dtl_qry_cur_id, 22, x_line_dtls_tbl(l_ind).installation_date);

Line 2950: dbms_sql.column_value(l_dtl_qry_cur_id, 19, x_line_dtls_tbl(l_ind).lot_number);

2946: dbms_sql.column_value(l_dtl_qry_cur_id, 15, x_line_dtls_tbl(l_ind).unit_of_measure);
2947: dbms_sql.column_value(l_dtl_qry_cur_id, 16, x_line_dtls_tbl(l_ind).qty_remaining);
2948: dbms_sql.column_value(l_dtl_qry_cur_id, 17, x_line_dtls_tbl(l_ind).serial_number);
2949: dbms_sql.column_value(l_dtl_qry_cur_id, 18, x_line_dtls_tbl(l_ind).mfg_serial_number_flag);
2950: dbms_sql.column_value(l_dtl_qry_cur_id, 19, x_line_dtls_tbl(l_ind).lot_number);
2951: dbms_sql.column_value(l_dtl_qry_cur_id, 20, x_line_dtls_tbl(l_ind).location_type_code);
2952: dbms_sql.column_value(l_dtl_qry_cur_id, 21, x_line_dtls_tbl(l_ind).location_id);
2953: dbms_sql.column_value(l_dtl_qry_cur_id, 22, x_line_dtls_tbl(l_ind).installation_date);
2954: dbms_sql.column_value(l_dtl_qry_cur_id, 23, x_line_dtls_tbl(l_ind).in_service_date);

Line 2951: dbms_sql.column_value(l_dtl_qry_cur_id, 20, x_line_dtls_tbl(l_ind).location_type_code);

2947: dbms_sql.column_value(l_dtl_qry_cur_id, 16, x_line_dtls_tbl(l_ind).qty_remaining);
2948: dbms_sql.column_value(l_dtl_qry_cur_id, 17, x_line_dtls_tbl(l_ind).serial_number);
2949: dbms_sql.column_value(l_dtl_qry_cur_id, 18, x_line_dtls_tbl(l_ind).mfg_serial_number_flag);
2950: dbms_sql.column_value(l_dtl_qry_cur_id, 19, x_line_dtls_tbl(l_ind).lot_number);
2951: dbms_sql.column_value(l_dtl_qry_cur_id, 20, x_line_dtls_tbl(l_ind).location_type_code);
2952: dbms_sql.column_value(l_dtl_qry_cur_id, 21, x_line_dtls_tbl(l_ind).location_id);
2953: dbms_sql.column_value(l_dtl_qry_cur_id, 22, x_line_dtls_tbl(l_ind).installation_date);
2954: dbms_sql.column_value(l_dtl_qry_cur_id, 23, x_line_dtls_tbl(l_ind).in_service_date);
2955: dbms_sql.column_value(l_dtl_qry_cur_id, 24, x_line_dtls_tbl(l_ind).external_reference);

Line 2952: dbms_sql.column_value(l_dtl_qry_cur_id, 21, x_line_dtls_tbl(l_ind).location_id);

2948: dbms_sql.column_value(l_dtl_qry_cur_id, 17, x_line_dtls_tbl(l_ind).serial_number);
2949: dbms_sql.column_value(l_dtl_qry_cur_id, 18, x_line_dtls_tbl(l_ind).mfg_serial_number_flag);
2950: dbms_sql.column_value(l_dtl_qry_cur_id, 19, x_line_dtls_tbl(l_ind).lot_number);
2951: dbms_sql.column_value(l_dtl_qry_cur_id, 20, x_line_dtls_tbl(l_ind).location_type_code);
2952: dbms_sql.column_value(l_dtl_qry_cur_id, 21, x_line_dtls_tbl(l_ind).location_id);
2953: dbms_sql.column_value(l_dtl_qry_cur_id, 22, x_line_dtls_tbl(l_ind).installation_date);
2954: dbms_sql.column_value(l_dtl_qry_cur_id, 23, x_line_dtls_tbl(l_ind).in_service_date);
2955: dbms_sql.column_value(l_dtl_qry_cur_id, 24, x_line_dtls_tbl(l_ind).external_reference);
2956: dbms_sql.column_value(l_dtl_qry_cur_id, 25, x_line_dtls_tbl(l_ind).transaction_system_id);

Line 2953: dbms_sql.column_value(l_dtl_qry_cur_id, 22, x_line_dtls_tbl(l_ind).installation_date);

2949: dbms_sql.column_value(l_dtl_qry_cur_id, 18, x_line_dtls_tbl(l_ind).mfg_serial_number_flag);
2950: dbms_sql.column_value(l_dtl_qry_cur_id, 19, x_line_dtls_tbl(l_ind).lot_number);
2951: dbms_sql.column_value(l_dtl_qry_cur_id, 20, x_line_dtls_tbl(l_ind).location_type_code);
2952: dbms_sql.column_value(l_dtl_qry_cur_id, 21, x_line_dtls_tbl(l_ind).location_id);
2953: dbms_sql.column_value(l_dtl_qry_cur_id, 22, x_line_dtls_tbl(l_ind).installation_date);
2954: dbms_sql.column_value(l_dtl_qry_cur_id, 23, x_line_dtls_tbl(l_ind).in_service_date);
2955: dbms_sql.column_value(l_dtl_qry_cur_id, 24, x_line_dtls_tbl(l_ind).external_reference);
2956: dbms_sql.column_value(l_dtl_qry_cur_id, 25, x_line_dtls_tbl(l_ind).transaction_system_id);
2957: dbms_sql.column_value(l_dtl_qry_cur_id, 26, x_line_dtls_tbl(l_ind).sellable_flag);

Line 2954: dbms_sql.column_value(l_dtl_qry_cur_id, 23, x_line_dtls_tbl(l_ind).in_service_date);

2950: dbms_sql.column_value(l_dtl_qry_cur_id, 19, x_line_dtls_tbl(l_ind).lot_number);
2951: dbms_sql.column_value(l_dtl_qry_cur_id, 20, x_line_dtls_tbl(l_ind).location_type_code);
2952: dbms_sql.column_value(l_dtl_qry_cur_id, 21, x_line_dtls_tbl(l_ind).location_id);
2953: dbms_sql.column_value(l_dtl_qry_cur_id, 22, x_line_dtls_tbl(l_ind).installation_date);
2954: dbms_sql.column_value(l_dtl_qry_cur_id, 23, x_line_dtls_tbl(l_ind).in_service_date);
2955: dbms_sql.column_value(l_dtl_qry_cur_id, 24, x_line_dtls_tbl(l_ind).external_reference);
2956: dbms_sql.column_value(l_dtl_qry_cur_id, 25, x_line_dtls_tbl(l_ind).transaction_system_id);
2957: dbms_sql.column_value(l_dtl_qry_cur_id, 26, x_line_dtls_tbl(l_ind).sellable_flag);
2958: dbms_sql.column_value(l_dtl_qry_cur_id, 27, x_line_dtls_tbl(l_ind).version_label);

Line 2955: dbms_sql.column_value(l_dtl_qry_cur_id, 24, x_line_dtls_tbl(l_ind).external_reference);

2951: dbms_sql.column_value(l_dtl_qry_cur_id, 20, x_line_dtls_tbl(l_ind).location_type_code);
2952: dbms_sql.column_value(l_dtl_qry_cur_id, 21, x_line_dtls_tbl(l_ind).location_id);
2953: dbms_sql.column_value(l_dtl_qry_cur_id, 22, x_line_dtls_tbl(l_ind).installation_date);
2954: dbms_sql.column_value(l_dtl_qry_cur_id, 23, x_line_dtls_tbl(l_ind).in_service_date);
2955: dbms_sql.column_value(l_dtl_qry_cur_id, 24, x_line_dtls_tbl(l_ind).external_reference);
2956: dbms_sql.column_value(l_dtl_qry_cur_id, 25, x_line_dtls_tbl(l_ind).transaction_system_id);
2957: dbms_sql.column_value(l_dtl_qry_cur_id, 26, x_line_dtls_tbl(l_ind).sellable_flag);
2958: dbms_sql.column_value(l_dtl_qry_cur_id, 27, x_line_dtls_tbl(l_ind).version_label);
2959: dbms_sql.column_value(l_dtl_qry_cur_id, 28, x_line_dtls_tbl(l_ind).return_by_date);

Line 2956: dbms_sql.column_value(l_dtl_qry_cur_id, 25, x_line_dtls_tbl(l_ind).transaction_system_id);

2952: dbms_sql.column_value(l_dtl_qry_cur_id, 21, x_line_dtls_tbl(l_ind).location_id);
2953: dbms_sql.column_value(l_dtl_qry_cur_id, 22, x_line_dtls_tbl(l_ind).installation_date);
2954: dbms_sql.column_value(l_dtl_qry_cur_id, 23, x_line_dtls_tbl(l_ind).in_service_date);
2955: dbms_sql.column_value(l_dtl_qry_cur_id, 24, x_line_dtls_tbl(l_ind).external_reference);
2956: dbms_sql.column_value(l_dtl_qry_cur_id, 25, x_line_dtls_tbl(l_ind).transaction_system_id);
2957: dbms_sql.column_value(l_dtl_qry_cur_id, 26, x_line_dtls_tbl(l_ind).sellable_flag);
2958: dbms_sql.column_value(l_dtl_qry_cur_id, 27, x_line_dtls_tbl(l_ind).version_label);
2959: dbms_sql.column_value(l_dtl_qry_cur_id, 28, x_line_dtls_tbl(l_ind).return_by_date);
2960: dbms_sql.column_value(l_dtl_qry_cur_id, 29, x_line_dtls_tbl(l_ind).active_start_date);

Line 2957: dbms_sql.column_value(l_dtl_qry_cur_id, 26, x_line_dtls_tbl(l_ind).sellable_flag);

2953: dbms_sql.column_value(l_dtl_qry_cur_id, 22, x_line_dtls_tbl(l_ind).installation_date);
2954: dbms_sql.column_value(l_dtl_qry_cur_id, 23, x_line_dtls_tbl(l_ind).in_service_date);
2955: dbms_sql.column_value(l_dtl_qry_cur_id, 24, x_line_dtls_tbl(l_ind).external_reference);
2956: dbms_sql.column_value(l_dtl_qry_cur_id, 25, x_line_dtls_tbl(l_ind).transaction_system_id);
2957: dbms_sql.column_value(l_dtl_qry_cur_id, 26, x_line_dtls_tbl(l_ind).sellable_flag);
2958: dbms_sql.column_value(l_dtl_qry_cur_id, 27, x_line_dtls_tbl(l_ind).version_label);
2959: dbms_sql.column_value(l_dtl_qry_cur_id, 28, x_line_dtls_tbl(l_ind).return_by_date);
2960: dbms_sql.column_value(l_dtl_qry_cur_id, 29, x_line_dtls_tbl(l_ind).active_start_date);
2961: dbms_sql.column_value(l_dtl_qry_cur_id, 30, x_line_dtls_tbl(l_ind).active_end_date);

Line 2958: dbms_sql.column_value(l_dtl_qry_cur_id, 27, x_line_dtls_tbl(l_ind).version_label);

2954: dbms_sql.column_value(l_dtl_qry_cur_id, 23, x_line_dtls_tbl(l_ind).in_service_date);
2955: dbms_sql.column_value(l_dtl_qry_cur_id, 24, x_line_dtls_tbl(l_ind).external_reference);
2956: dbms_sql.column_value(l_dtl_qry_cur_id, 25, x_line_dtls_tbl(l_ind).transaction_system_id);
2957: dbms_sql.column_value(l_dtl_qry_cur_id, 26, x_line_dtls_tbl(l_ind).sellable_flag);
2958: dbms_sql.column_value(l_dtl_qry_cur_id, 27, x_line_dtls_tbl(l_ind).version_label);
2959: dbms_sql.column_value(l_dtl_qry_cur_id, 28, x_line_dtls_tbl(l_ind).return_by_date);
2960: dbms_sql.column_value(l_dtl_qry_cur_id, 29, x_line_dtls_tbl(l_ind).active_start_date);
2961: dbms_sql.column_value(l_dtl_qry_cur_id, 30, x_line_dtls_tbl(l_ind).active_end_date);
2962: dbms_sql.column_value(l_dtl_qry_cur_id, 31, x_line_dtls_tbl(l_ind).preserve_detail_flag);

Line 2959: dbms_sql.column_value(l_dtl_qry_cur_id, 28, x_line_dtls_tbl(l_ind).return_by_date);

2955: dbms_sql.column_value(l_dtl_qry_cur_id, 24, x_line_dtls_tbl(l_ind).external_reference);
2956: dbms_sql.column_value(l_dtl_qry_cur_id, 25, x_line_dtls_tbl(l_ind).transaction_system_id);
2957: dbms_sql.column_value(l_dtl_qry_cur_id, 26, x_line_dtls_tbl(l_ind).sellable_flag);
2958: dbms_sql.column_value(l_dtl_qry_cur_id, 27, x_line_dtls_tbl(l_ind).version_label);
2959: dbms_sql.column_value(l_dtl_qry_cur_id, 28, x_line_dtls_tbl(l_ind).return_by_date);
2960: dbms_sql.column_value(l_dtl_qry_cur_id, 29, x_line_dtls_tbl(l_ind).active_start_date);
2961: dbms_sql.column_value(l_dtl_qry_cur_id, 30, x_line_dtls_tbl(l_ind).active_end_date);
2962: dbms_sql.column_value(l_dtl_qry_cur_id, 31, x_line_dtls_tbl(l_ind).preserve_detail_flag);
2963: dbms_sql.column_value(l_dtl_qry_cur_id, 32, x_line_dtls_tbl(l_ind).reference_source_id);

Line 2960: dbms_sql.column_value(l_dtl_qry_cur_id, 29, x_line_dtls_tbl(l_ind).active_start_date);

2956: dbms_sql.column_value(l_dtl_qry_cur_id, 25, x_line_dtls_tbl(l_ind).transaction_system_id);
2957: dbms_sql.column_value(l_dtl_qry_cur_id, 26, x_line_dtls_tbl(l_ind).sellable_flag);
2958: dbms_sql.column_value(l_dtl_qry_cur_id, 27, x_line_dtls_tbl(l_ind).version_label);
2959: dbms_sql.column_value(l_dtl_qry_cur_id, 28, x_line_dtls_tbl(l_ind).return_by_date);
2960: dbms_sql.column_value(l_dtl_qry_cur_id, 29, x_line_dtls_tbl(l_ind).active_start_date);
2961: dbms_sql.column_value(l_dtl_qry_cur_id, 30, x_line_dtls_tbl(l_ind).active_end_date);
2962: dbms_sql.column_value(l_dtl_qry_cur_id, 31, x_line_dtls_tbl(l_ind).preserve_detail_flag);
2963: dbms_sql.column_value(l_dtl_qry_cur_id, 32, x_line_dtls_tbl(l_ind).reference_source_id);
2964: dbms_sql.column_value(l_dtl_qry_cur_id, 33, x_line_dtls_tbl(l_ind).reference_source_date);

Line 2961: dbms_sql.column_value(l_dtl_qry_cur_id, 30, x_line_dtls_tbl(l_ind).active_end_date);

2957: dbms_sql.column_value(l_dtl_qry_cur_id, 26, x_line_dtls_tbl(l_ind).sellable_flag);
2958: dbms_sql.column_value(l_dtl_qry_cur_id, 27, x_line_dtls_tbl(l_ind).version_label);
2959: dbms_sql.column_value(l_dtl_qry_cur_id, 28, x_line_dtls_tbl(l_ind).return_by_date);
2960: dbms_sql.column_value(l_dtl_qry_cur_id, 29, x_line_dtls_tbl(l_ind).active_start_date);
2961: dbms_sql.column_value(l_dtl_qry_cur_id, 30, x_line_dtls_tbl(l_ind).active_end_date);
2962: dbms_sql.column_value(l_dtl_qry_cur_id, 31, x_line_dtls_tbl(l_ind).preserve_detail_flag);
2963: dbms_sql.column_value(l_dtl_qry_cur_id, 32, x_line_dtls_tbl(l_ind).reference_source_id);
2964: dbms_sql.column_value(l_dtl_qry_cur_id, 33, x_line_dtls_tbl(l_ind).reference_source_date);
2965: dbms_sql.column_value(l_dtl_qry_cur_id, 34, x_line_dtls_tbl(l_ind).csi_transaction_id);

Line 2962: dbms_sql.column_value(l_dtl_qry_cur_id, 31, x_line_dtls_tbl(l_ind).preserve_detail_flag);

2958: dbms_sql.column_value(l_dtl_qry_cur_id, 27, x_line_dtls_tbl(l_ind).version_label);
2959: dbms_sql.column_value(l_dtl_qry_cur_id, 28, x_line_dtls_tbl(l_ind).return_by_date);
2960: dbms_sql.column_value(l_dtl_qry_cur_id, 29, x_line_dtls_tbl(l_ind).active_start_date);
2961: dbms_sql.column_value(l_dtl_qry_cur_id, 30, x_line_dtls_tbl(l_ind).active_end_date);
2962: dbms_sql.column_value(l_dtl_qry_cur_id, 31, x_line_dtls_tbl(l_ind).preserve_detail_flag);
2963: dbms_sql.column_value(l_dtl_qry_cur_id, 32, x_line_dtls_tbl(l_ind).reference_source_id);
2964: dbms_sql.column_value(l_dtl_qry_cur_id, 33, x_line_dtls_tbl(l_ind).reference_source_date);
2965: dbms_sql.column_value(l_dtl_qry_cur_id, 34, x_line_dtls_tbl(l_ind).csi_transaction_id);
2966: dbms_sql.column_value(l_dtl_qry_cur_id, 35, x_line_dtls_tbl(l_ind).processing_status);

Line 2963: dbms_sql.column_value(l_dtl_qry_cur_id, 32, x_line_dtls_tbl(l_ind).reference_source_id);

2959: dbms_sql.column_value(l_dtl_qry_cur_id, 28, x_line_dtls_tbl(l_ind).return_by_date);
2960: dbms_sql.column_value(l_dtl_qry_cur_id, 29, x_line_dtls_tbl(l_ind).active_start_date);
2961: dbms_sql.column_value(l_dtl_qry_cur_id, 30, x_line_dtls_tbl(l_ind).active_end_date);
2962: dbms_sql.column_value(l_dtl_qry_cur_id, 31, x_line_dtls_tbl(l_ind).preserve_detail_flag);
2963: dbms_sql.column_value(l_dtl_qry_cur_id, 32, x_line_dtls_tbl(l_ind).reference_source_id);
2964: dbms_sql.column_value(l_dtl_qry_cur_id, 33, x_line_dtls_tbl(l_ind).reference_source_date);
2965: dbms_sql.column_value(l_dtl_qry_cur_id, 34, x_line_dtls_tbl(l_ind).csi_transaction_id);
2966: dbms_sql.column_value(l_dtl_qry_cur_id, 35, x_line_dtls_tbl(l_ind).processing_status);
2967: dbms_sql.column_value(l_dtl_qry_cur_id, 36, x_line_dtls_tbl(l_ind).error_code);

Line 2964: dbms_sql.column_value(l_dtl_qry_cur_id, 33, x_line_dtls_tbl(l_ind).reference_source_date);

2960: dbms_sql.column_value(l_dtl_qry_cur_id, 29, x_line_dtls_tbl(l_ind).active_start_date);
2961: dbms_sql.column_value(l_dtl_qry_cur_id, 30, x_line_dtls_tbl(l_ind).active_end_date);
2962: dbms_sql.column_value(l_dtl_qry_cur_id, 31, x_line_dtls_tbl(l_ind).preserve_detail_flag);
2963: dbms_sql.column_value(l_dtl_qry_cur_id, 32, x_line_dtls_tbl(l_ind).reference_source_id);
2964: dbms_sql.column_value(l_dtl_qry_cur_id, 33, x_line_dtls_tbl(l_ind).reference_source_date);
2965: dbms_sql.column_value(l_dtl_qry_cur_id, 34, x_line_dtls_tbl(l_ind).csi_transaction_id);
2966: dbms_sql.column_value(l_dtl_qry_cur_id, 35, x_line_dtls_tbl(l_ind).processing_status);
2967: dbms_sql.column_value(l_dtl_qry_cur_id, 36, x_line_dtls_tbl(l_ind).error_code);
2968: dbms_sql.column_value(l_dtl_qry_cur_id, 37, x_line_dtls_tbl(l_ind).error_explanation);

Line 2965: dbms_sql.column_value(l_dtl_qry_cur_id, 34, x_line_dtls_tbl(l_ind).csi_transaction_id);

2961: dbms_sql.column_value(l_dtl_qry_cur_id, 30, x_line_dtls_tbl(l_ind).active_end_date);
2962: dbms_sql.column_value(l_dtl_qry_cur_id, 31, x_line_dtls_tbl(l_ind).preserve_detail_flag);
2963: dbms_sql.column_value(l_dtl_qry_cur_id, 32, x_line_dtls_tbl(l_ind).reference_source_id);
2964: dbms_sql.column_value(l_dtl_qry_cur_id, 33, x_line_dtls_tbl(l_ind).reference_source_date);
2965: dbms_sql.column_value(l_dtl_qry_cur_id, 34, x_line_dtls_tbl(l_ind).csi_transaction_id);
2966: dbms_sql.column_value(l_dtl_qry_cur_id, 35, x_line_dtls_tbl(l_ind).processing_status);
2967: dbms_sql.column_value(l_dtl_qry_cur_id, 36, x_line_dtls_tbl(l_ind).error_code);
2968: dbms_sql.column_value(l_dtl_qry_cur_id, 37, x_line_dtls_tbl(l_ind).error_explanation);
2969: dbms_sql.column_value(l_dtl_qry_cur_id, 38, x_line_dtls_tbl(l_ind).context);

Line 2966: dbms_sql.column_value(l_dtl_qry_cur_id, 35, x_line_dtls_tbl(l_ind).processing_status);

2962: dbms_sql.column_value(l_dtl_qry_cur_id, 31, x_line_dtls_tbl(l_ind).preserve_detail_flag);
2963: dbms_sql.column_value(l_dtl_qry_cur_id, 32, x_line_dtls_tbl(l_ind).reference_source_id);
2964: dbms_sql.column_value(l_dtl_qry_cur_id, 33, x_line_dtls_tbl(l_ind).reference_source_date);
2965: dbms_sql.column_value(l_dtl_qry_cur_id, 34, x_line_dtls_tbl(l_ind).csi_transaction_id);
2966: dbms_sql.column_value(l_dtl_qry_cur_id, 35, x_line_dtls_tbl(l_ind).processing_status);
2967: dbms_sql.column_value(l_dtl_qry_cur_id, 36, x_line_dtls_tbl(l_ind).error_code);
2968: dbms_sql.column_value(l_dtl_qry_cur_id, 37, x_line_dtls_tbl(l_ind).error_explanation);
2969: dbms_sql.column_value(l_dtl_qry_cur_id, 38, x_line_dtls_tbl(l_ind).context);
2970: dbms_sql.column_value(l_dtl_qry_cur_id, 39, x_line_dtls_tbl(l_ind).attribute1);

Line 2967: dbms_sql.column_value(l_dtl_qry_cur_id, 36, x_line_dtls_tbl(l_ind).error_code);

2963: dbms_sql.column_value(l_dtl_qry_cur_id, 32, x_line_dtls_tbl(l_ind).reference_source_id);
2964: dbms_sql.column_value(l_dtl_qry_cur_id, 33, x_line_dtls_tbl(l_ind).reference_source_date);
2965: dbms_sql.column_value(l_dtl_qry_cur_id, 34, x_line_dtls_tbl(l_ind).csi_transaction_id);
2966: dbms_sql.column_value(l_dtl_qry_cur_id, 35, x_line_dtls_tbl(l_ind).processing_status);
2967: dbms_sql.column_value(l_dtl_qry_cur_id, 36, x_line_dtls_tbl(l_ind).error_code);
2968: dbms_sql.column_value(l_dtl_qry_cur_id, 37, x_line_dtls_tbl(l_ind).error_explanation);
2969: dbms_sql.column_value(l_dtl_qry_cur_id, 38, x_line_dtls_tbl(l_ind).context);
2970: dbms_sql.column_value(l_dtl_qry_cur_id, 39, x_line_dtls_tbl(l_ind).attribute1);
2971: dbms_sql.column_value(l_dtl_qry_cur_id, 40, x_line_dtls_tbl(l_ind).attribute2);

Line 2968: dbms_sql.column_value(l_dtl_qry_cur_id, 37, x_line_dtls_tbl(l_ind).error_explanation);

2964: dbms_sql.column_value(l_dtl_qry_cur_id, 33, x_line_dtls_tbl(l_ind).reference_source_date);
2965: dbms_sql.column_value(l_dtl_qry_cur_id, 34, x_line_dtls_tbl(l_ind).csi_transaction_id);
2966: dbms_sql.column_value(l_dtl_qry_cur_id, 35, x_line_dtls_tbl(l_ind).processing_status);
2967: dbms_sql.column_value(l_dtl_qry_cur_id, 36, x_line_dtls_tbl(l_ind).error_code);
2968: dbms_sql.column_value(l_dtl_qry_cur_id, 37, x_line_dtls_tbl(l_ind).error_explanation);
2969: dbms_sql.column_value(l_dtl_qry_cur_id, 38, x_line_dtls_tbl(l_ind).context);
2970: dbms_sql.column_value(l_dtl_qry_cur_id, 39, x_line_dtls_tbl(l_ind).attribute1);
2971: dbms_sql.column_value(l_dtl_qry_cur_id, 40, x_line_dtls_tbl(l_ind).attribute2);
2972: dbms_sql.column_value(l_dtl_qry_cur_id, 41, x_line_dtls_tbl(l_ind).attribute3);

Line 2969: dbms_sql.column_value(l_dtl_qry_cur_id, 38, x_line_dtls_tbl(l_ind).context);

2965: dbms_sql.column_value(l_dtl_qry_cur_id, 34, x_line_dtls_tbl(l_ind).csi_transaction_id);
2966: dbms_sql.column_value(l_dtl_qry_cur_id, 35, x_line_dtls_tbl(l_ind).processing_status);
2967: dbms_sql.column_value(l_dtl_qry_cur_id, 36, x_line_dtls_tbl(l_ind).error_code);
2968: dbms_sql.column_value(l_dtl_qry_cur_id, 37, x_line_dtls_tbl(l_ind).error_explanation);
2969: dbms_sql.column_value(l_dtl_qry_cur_id, 38, x_line_dtls_tbl(l_ind).context);
2970: dbms_sql.column_value(l_dtl_qry_cur_id, 39, x_line_dtls_tbl(l_ind).attribute1);
2971: dbms_sql.column_value(l_dtl_qry_cur_id, 40, x_line_dtls_tbl(l_ind).attribute2);
2972: dbms_sql.column_value(l_dtl_qry_cur_id, 41, x_line_dtls_tbl(l_ind).attribute3);
2973: dbms_sql.column_value(l_dtl_qry_cur_id, 42, x_line_dtls_tbl(l_ind).attribute4);

Line 2970: dbms_sql.column_value(l_dtl_qry_cur_id, 39, x_line_dtls_tbl(l_ind).attribute1);

2966: dbms_sql.column_value(l_dtl_qry_cur_id, 35, x_line_dtls_tbl(l_ind).processing_status);
2967: dbms_sql.column_value(l_dtl_qry_cur_id, 36, x_line_dtls_tbl(l_ind).error_code);
2968: dbms_sql.column_value(l_dtl_qry_cur_id, 37, x_line_dtls_tbl(l_ind).error_explanation);
2969: dbms_sql.column_value(l_dtl_qry_cur_id, 38, x_line_dtls_tbl(l_ind).context);
2970: dbms_sql.column_value(l_dtl_qry_cur_id, 39, x_line_dtls_tbl(l_ind).attribute1);
2971: dbms_sql.column_value(l_dtl_qry_cur_id, 40, x_line_dtls_tbl(l_ind).attribute2);
2972: dbms_sql.column_value(l_dtl_qry_cur_id, 41, x_line_dtls_tbl(l_ind).attribute3);
2973: dbms_sql.column_value(l_dtl_qry_cur_id, 42, x_line_dtls_tbl(l_ind).attribute4);
2974: dbms_sql.column_value(l_dtl_qry_cur_id, 43, x_line_dtls_tbl(l_ind).attribute5);

Line 2971: dbms_sql.column_value(l_dtl_qry_cur_id, 40, x_line_dtls_tbl(l_ind).attribute2);

2967: dbms_sql.column_value(l_dtl_qry_cur_id, 36, x_line_dtls_tbl(l_ind).error_code);
2968: dbms_sql.column_value(l_dtl_qry_cur_id, 37, x_line_dtls_tbl(l_ind).error_explanation);
2969: dbms_sql.column_value(l_dtl_qry_cur_id, 38, x_line_dtls_tbl(l_ind).context);
2970: dbms_sql.column_value(l_dtl_qry_cur_id, 39, x_line_dtls_tbl(l_ind).attribute1);
2971: dbms_sql.column_value(l_dtl_qry_cur_id, 40, x_line_dtls_tbl(l_ind).attribute2);
2972: dbms_sql.column_value(l_dtl_qry_cur_id, 41, x_line_dtls_tbl(l_ind).attribute3);
2973: dbms_sql.column_value(l_dtl_qry_cur_id, 42, x_line_dtls_tbl(l_ind).attribute4);
2974: dbms_sql.column_value(l_dtl_qry_cur_id, 43, x_line_dtls_tbl(l_ind).attribute5);
2975: dbms_sql.column_value(l_dtl_qry_cur_id, 44, x_line_dtls_tbl(l_ind).attribute6);

Line 2972: dbms_sql.column_value(l_dtl_qry_cur_id, 41, x_line_dtls_tbl(l_ind).attribute3);

2968: dbms_sql.column_value(l_dtl_qry_cur_id, 37, x_line_dtls_tbl(l_ind).error_explanation);
2969: dbms_sql.column_value(l_dtl_qry_cur_id, 38, x_line_dtls_tbl(l_ind).context);
2970: dbms_sql.column_value(l_dtl_qry_cur_id, 39, x_line_dtls_tbl(l_ind).attribute1);
2971: dbms_sql.column_value(l_dtl_qry_cur_id, 40, x_line_dtls_tbl(l_ind).attribute2);
2972: dbms_sql.column_value(l_dtl_qry_cur_id, 41, x_line_dtls_tbl(l_ind).attribute3);
2973: dbms_sql.column_value(l_dtl_qry_cur_id, 42, x_line_dtls_tbl(l_ind).attribute4);
2974: dbms_sql.column_value(l_dtl_qry_cur_id, 43, x_line_dtls_tbl(l_ind).attribute5);
2975: dbms_sql.column_value(l_dtl_qry_cur_id, 44, x_line_dtls_tbl(l_ind).attribute6);
2976: dbms_sql.column_value(l_dtl_qry_cur_id, 45, x_line_dtls_tbl(l_ind).attribute7);

Line 2973: dbms_sql.column_value(l_dtl_qry_cur_id, 42, x_line_dtls_tbl(l_ind).attribute4);

2969: dbms_sql.column_value(l_dtl_qry_cur_id, 38, x_line_dtls_tbl(l_ind).context);
2970: dbms_sql.column_value(l_dtl_qry_cur_id, 39, x_line_dtls_tbl(l_ind).attribute1);
2971: dbms_sql.column_value(l_dtl_qry_cur_id, 40, x_line_dtls_tbl(l_ind).attribute2);
2972: dbms_sql.column_value(l_dtl_qry_cur_id, 41, x_line_dtls_tbl(l_ind).attribute3);
2973: dbms_sql.column_value(l_dtl_qry_cur_id, 42, x_line_dtls_tbl(l_ind).attribute4);
2974: dbms_sql.column_value(l_dtl_qry_cur_id, 43, x_line_dtls_tbl(l_ind).attribute5);
2975: dbms_sql.column_value(l_dtl_qry_cur_id, 44, x_line_dtls_tbl(l_ind).attribute6);
2976: dbms_sql.column_value(l_dtl_qry_cur_id, 45, x_line_dtls_tbl(l_ind).attribute7);
2977: dbms_sql.column_value(l_dtl_qry_cur_id, 46, x_line_dtls_tbl(l_ind).attribute8);

Line 2974: dbms_sql.column_value(l_dtl_qry_cur_id, 43, x_line_dtls_tbl(l_ind).attribute5);

2970: dbms_sql.column_value(l_dtl_qry_cur_id, 39, x_line_dtls_tbl(l_ind).attribute1);
2971: dbms_sql.column_value(l_dtl_qry_cur_id, 40, x_line_dtls_tbl(l_ind).attribute2);
2972: dbms_sql.column_value(l_dtl_qry_cur_id, 41, x_line_dtls_tbl(l_ind).attribute3);
2973: dbms_sql.column_value(l_dtl_qry_cur_id, 42, x_line_dtls_tbl(l_ind).attribute4);
2974: dbms_sql.column_value(l_dtl_qry_cur_id, 43, x_line_dtls_tbl(l_ind).attribute5);
2975: dbms_sql.column_value(l_dtl_qry_cur_id, 44, x_line_dtls_tbl(l_ind).attribute6);
2976: dbms_sql.column_value(l_dtl_qry_cur_id, 45, x_line_dtls_tbl(l_ind).attribute7);
2977: dbms_sql.column_value(l_dtl_qry_cur_id, 46, x_line_dtls_tbl(l_ind).attribute8);
2978: dbms_sql.column_value(l_dtl_qry_cur_id, 47, x_line_dtls_tbl(l_ind).attribute9);

Line 2975: dbms_sql.column_value(l_dtl_qry_cur_id, 44, x_line_dtls_tbl(l_ind).attribute6);

2971: dbms_sql.column_value(l_dtl_qry_cur_id, 40, x_line_dtls_tbl(l_ind).attribute2);
2972: dbms_sql.column_value(l_dtl_qry_cur_id, 41, x_line_dtls_tbl(l_ind).attribute3);
2973: dbms_sql.column_value(l_dtl_qry_cur_id, 42, x_line_dtls_tbl(l_ind).attribute4);
2974: dbms_sql.column_value(l_dtl_qry_cur_id, 43, x_line_dtls_tbl(l_ind).attribute5);
2975: dbms_sql.column_value(l_dtl_qry_cur_id, 44, x_line_dtls_tbl(l_ind).attribute6);
2976: dbms_sql.column_value(l_dtl_qry_cur_id, 45, x_line_dtls_tbl(l_ind).attribute7);
2977: dbms_sql.column_value(l_dtl_qry_cur_id, 46, x_line_dtls_tbl(l_ind).attribute8);
2978: dbms_sql.column_value(l_dtl_qry_cur_id, 47, x_line_dtls_tbl(l_ind).attribute9);
2979: dbms_sql.column_value(l_dtl_qry_cur_id, 48, x_line_dtls_tbl(l_ind).attribute10);

Line 2976: dbms_sql.column_value(l_dtl_qry_cur_id, 45, x_line_dtls_tbl(l_ind).attribute7);

2972: dbms_sql.column_value(l_dtl_qry_cur_id, 41, x_line_dtls_tbl(l_ind).attribute3);
2973: dbms_sql.column_value(l_dtl_qry_cur_id, 42, x_line_dtls_tbl(l_ind).attribute4);
2974: dbms_sql.column_value(l_dtl_qry_cur_id, 43, x_line_dtls_tbl(l_ind).attribute5);
2975: dbms_sql.column_value(l_dtl_qry_cur_id, 44, x_line_dtls_tbl(l_ind).attribute6);
2976: dbms_sql.column_value(l_dtl_qry_cur_id, 45, x_line_dtls_tbl(l_ind).attribute7);
2977: dbms_sql.column_value(l_dtl_qry_cur_id, 46, x_line_dtls_tbl(l_ind).attribute8);
2978: dbms_sql.column_value(l_dtl_qry_cur_id, 47, x_line_dtls_tbl(l_ind).attribute9);
2979: dbms_sql.column_value(l_dtl_qry_cur_id, 48, x_line_dtls_tbl(l_ind).attribute10);
2980: dbms_sql.column_value(l_dtl_qry_cur_id, 49, x_line_dtls_tbl(l_ind).attribute11);

Line 2977: dbms_sql.column_value(l_dtl_qry_cur_id, 46, x_line_dtls_tbl(l_ind).attribute8);

2973: dbms_sql.column_value(l_dtl_qry_cur_id, 42, x_line_dtls_tbl(l_ind).attribute4);
2974: dbms_sql.column_value(l_dtl_qry_cur_id, 43, x_line_dtls_tbl(l_ind).attribute5);
2975: dbms_sql.column_value(l_dtl_qry_cur_id, 44, x_line_dtls_tbl(l_ind).attribute6);
2976: dbms_sql.column_value(l_dtl_qry_cur_id, 45, x_line_dtls_tbl(l_ind).attribute7);
2977: dbms_sql.column_value(l_dtl_qry_cur_id, 46, x_line_dtls_tbl(l_ind).attribute8);
2978: dbms_sql.column_value(l_dtl_qry_cur_id, 47, x_line_dtls_tbl(l_ind).attribute9);
2979: dbms_sql.column_value(l_dtl_qry_cur_id, 48, x_line_dtls_tbl(l_ind).attribute10);
2980: dbms_sql.column_value(l_dtl_qry_cur_id, 49, x_line_dtls_tbl(l_ind).attribute11);
2981: dbms_sql.column_value(l_dtl_qry_cur_id, 50, x_line_dtls_tbl(l_ind).attribute12);

Line 2978: dbms_sql.column_value(l_dtl_qry_cur_id, 47, x_line_dtls_tbl(l_ind).attribute9);

2974: dbms_sql.column_value(l_dtl_qry_cur_id, 43, x_line_dtls_tbl(l_ind).attribute5);
2975: dbms_sql.column_value(l_dtl_qry_cur_id, 44, x_line_dtls_tbl(l_ind).attribute6);
2976: dbms_sql.column_value(l_dtl_qry_cur_id, 45, x_line_dtls_tbl(l_ind).attribute7);
2977: dbms_sql.column_value(l_dtl_qry_cur_id, 46, x_line_dtls_tbl(l_ind).attribute8);
2978: dbms_sql.column_value(l_dtl_qry_cur_id, 47, x_line_dtls_tbl(l_ind).attribute9);
2979: dbms_sql.column_value(l_dtl_qry_cur_id, 48, x_line_dtls_tbl(l_ind).attribute10);
2980: dbms_sql.column_value(l_dtl_qry_cur_id, 49, x_line_dtls_tbl(l_ind).attribute11);
2981: dbms_sql.column_value(l_dtl_qry_cur_id, 50, x_line_dtls_tbl(l_ind).attribute12);
2982: dbms_sql.column_value(l_dtl_qry_cur_id, 51, x_line_dtls_tbl(l_ind).attribute13);

Line 2979: dbms_sql.column_value(l_dtl_qry_cur_id, 48, x_line_dtls_tbl(l_ind).attribute10);

2975: dbms_sql.column_value(l_dtl_qry_cur_id, 44, x_line_dtls_tbl(l_ind).attribute6);
2976: dbms_sql.column_value(l_dtl_qry_cur_id, 45, x_line_dtls_tbl(l_ind).attribute7);
2977: dbms_sql.column_value(l_dtl_qry_cur_id, 46, x_line_dtls_tbl(l_ind).attribute8);
2978: dbms_sql.column_value(l_dtl_qry_cur_id, 47, x_line_dtls_tbl(l_ind).attribute9);
2979: dbms_sql.column_value(l_dtl_qry_cur_id, 48, x_line_dtls_tbl(l_ind).attribute10);
2980: dbms_sql.column_value(l_dtl_qry_cur_id, 49, x_line_dtls_tbl(l_ind).attribute11);
2981: dbms_sql.column_value(l_dtl_qry_cur_id, 50, x_line_dtls_tbl(l_ind).attribute12);
2982: dbms_sql.column_value(l_dtl_qry_cur_id, 51, x_line_dtls_tbl(l_ind).attribute13);
2983: dbms_sql.column_value(l_dtl_qry_cur_id, 52, x_line_dtls_tbl(l_ind).attribute14);

Line 2980: dbms_sql.column_value(l_dtl_qry_cur_id, 49, x_line_dtls_tbl(l_ind).attribute11);

2976: dbms_sql.column_value(l_dtl_qry_cur_id, 45, x_line_dtls_tbl(l_ind).attribute7);
2977: dbms_sql.column_value(l_dtl_qry_cur_id, 46, x_line_dtls_tbl(l_ind).attribute8);
2978: dbms_sql.column_value(l_dtl_qry_cur_id, 47, x_line_dtls_tbl(l_ind).attribute9);
2979: dbms_sql.column_value(l_dtl_qry_cur_id, 48, x_line_dtls_tbl(l_ind).attribute10);
2980: dbms_sql.column_value(l_dtl_qry_cur_id, 49, x_line_dtls_tbl(l_ind).attribute11);
2981: dbms_sql.column_value(l_dtl_qry_cur_id, 50, x_line_dtls_tbl(l_ind).attribute12);
2982: dbms_sql.column_value(l_dtl_qry_cur_id, 51, x_line_dtls_tbl(l_ind).attribute13);
2983: dbms_sql.column_value(l_dtl_qry_cur_id, 52, x_line_dtls_tbl(l_ind).attribute14);
2984: dbms_sql.column_value(l_dtl_qry_cur_id, 53, x_line_dtls_tbl(l_ind).attribute15);

Line 2981: dbms_sql.column_value(l_dtl_qry_cur_id, 50, x_line_dtls_tbl(l_ind).attribute12);

2977: dbms_sql.column_value(l_dtl_qry_cur_id, 46, x_line_dtls_tbl(l_ind).attribute8);
2978: dbms_sql.column_value(l_dtl_qry_cur_id, 47, x_line_dtls_tbl(l_ind).attribute9);
2979: dbms_sql.column_value(l_dtl_qry_cur_id, 48, x_line_dtls_tbl(l_ind).attribute10);
2980: dbms_sql.column_value(l_dtl_qry_cur_id, 49, x_line_dtls_tbl(l_ind).attribute11);
2981: dbms_sql.column_value(l_dtl_qry_cur_id, 50, x_line_dtls_tbl(l_ind).attribute12);
2982: dbms_sql.column_value(l_dtl_qry_cur_id, 51, x_line_dtls_tbl(l_ind).attribute13);
2983: dbms_sql.column_value(l_dtl_qry_cur_id, 52, x_line_dtls_tbl(l_ind).attribute14);
2984: dbms_sql.column_value(l_dtl_qry_cur_id, 53, x_line_dtls_tbl(l_ind).attribute15);
2985: dbms_sql.column_value(l_dtl_qry_cur_id, 54, x_line_dtls_tbl(l_ind).object_version_number);

Line 2982: dbms_sql.column_value(l_dtl_qry_cur_id, 51, x_line_dtls_tbl(l_ind).attribute13);

2978: dbms_sql.column_value(l_dtl_qry_cur_id, 47, x_line_dtls_tbl(l_ind).attribute9);
2979: dbms_sql.column_value(l_dtl_qry_cur_id, 48, x_line_dtls_tbl(l_ind).attribute10);
2980: dbms_sql.column_value(l_dtl_qry_cur_id, 49, x_line_dtls_tbl(l_ind).attribute11);
2981: dbms_sql.column_value(l_dtl_qry_cur_id, 50, x_line_dtls_tbl(l_ind).attribute12);
2982: dbms_sql.column_value(l_dtl_qry_cur_id, 51, x_line_dtls_tbl(l_ind).attribute13);
2983: dbms_sql.column_value(l_dtl_qry_cur_id, 52, x_line_dtls_tbl(l_ind).attribute14);
2984: dbms_sql.column_value(l_dtl_qry_cur_id, 53, x_line_dtls_tbl(l_ind).attribute15);
2985: dbms_sql.column_value(l_dtl_qry_cur_id, 54, x_line_dtls_tbl(l_ind).object_version_number);
2986: dbms_sql.column_value(l_dtl_qry_cur_id, 55, x_line_dtls_tbl(l_ind).source_txn_line_detail_id);

Line 2983: dbms_sql.column_value(l_dtl_qry_cur_id, 52, x_line_dtls_tbl(l_ind).attribute14);

2979: dbms_sql.column_value(l_dtl_qry_cur_id, 48, x_line_dtls_tbl(l_ind).attribute10);
2980: dbms_sql.column_value(l_dtl_qry_cur_id, 49, x_line_dtls_tbl(l_ind).attribute11);
2981: dbms_sql.column_value(l_dtl_qry_cur_id, 50, x_line_dtls_tbl(l_ind).attribute12);
2982: dbms_sql.column_value(l_dtl_qry_cur_id, 51, x_line_dtls_tbl(l_ind).attribute13);
2983: dbms_sql.column_value(l_dtl_qry_cur_id, 52, x_line_dtls_tbl(l_ind).attribute14);
2984: dbms_sql.column_value(l_dtl_qry_cur_id, 53, x_line_dtls_tbl(l_ind).attribute15);
2985: dbms_sql.column_value(l_dtl_qry_cur_id, 54, x_line_dtls_tbl(l_ind).object_version_number);
2986: dbms_sql.column_value(l_dtl_qry_cur_id, 55, x_line_dtls_tbl(l_ind).source_txn_line_detail_id);
2987: dbms_sql.column_value(l_dtl_qry_cur_id, 56, x_line_dtls_tbl(l_ind).inv_mtl_transaction_id);

Line 2984: dbms_sql.column_value(l_dtl_qry_cur_id, 53, x_line_dtls_tbl(l_ind).attribute15);

2980: dbms_sql.column_value(l_dtl_qry_cur_id, 49, x_line_dtls_tbl(l_ind).attribute11);
2981: dbms_sql.column_value(l_dtl_qry_cur_id, 50, x_line_dtls_tbl(l_ind).attribute12);
2982: dbms_sql.column_value(l_dtl_qry_cur_id, 51, x_line_dtls_tbl(l_ind).attribute13);
2983: dbms_sql.column_value(l_dtl_qry_cur_id, 52, x_line_dtls_tbl(l_ind).attribute14);
2984: dbms_sql.column_value(l_dtl_qry_cur_id, 53, x_line_dtls_tbl(l_ind).attribute15);
2985: dbms_sql.column_value(l_dtl_qry_cur_id, 54, x_line_dtls_tbl(l_ind).object_version_number);
2986: dbms_sql.column_value(l_dtl_qry_cur_id, 55, x_line_dtls_tbl(l_ind).source_txn_line_detail_id);
2987: dbms_sql.column_value(l_dtl_qry_cur_id, 56, x_line_dtls_tbl(l_ind).inv_mtl_transaction_id);
2988: dbms_sql.column_value(l_dtl_qry_cur_id, 57, x_line_dtls_tbl(l_ind).config_inst_hdr_id);

Line 2985: dbms_sql.column_value(l_dtl_qry_cur_id, 54, x_line_dtls_tbl(l_ind).object_version_number);

2981: dbms_sql.column_value(l_dtl_qry_cur_id, 50, x_line_dtls_tbl(l_ind).attribute12);
2982: dbms_sql.column_value(l_dtl_qry_cur_id, 51, x_line_dtls_tbl(l_ind).attribute13);
2983: dbms_sql.column_value(l_dtl_qry_cur_id, 52, x_line_dtls_tbl(l_ind).attribute14);
2984: dbms_sql.column_value(l_dtl_qry_cur_id, 53, x_line_dtls_tbl(l_ind).attribute15);
2985: dbms_sql.column_value(l_dtl_qry_cur_id, 54, x_line_dtls_tbl(l_ind).object_version_number);
2986: dbms_sql.column_value(l_dtl_qry_cur_id, 55, x_line_dtls_tbl(l_ind).source_txn_line_detail_id);
2987: dbms_sql.column_value(l_dtl_qry_cur_id, 56, x_line_dtls_tbl(l_ind).inv_mtl_transaction_id);
2988: dbms_sql.column_value(l_dtl_qry_cur_id, 57, x_line_dtls_tbl(l_ind).config_inst_hdr_id);
2989: dbms_sql.column_value(l_dtl_qry_cur_id, 58, x_line_dtls_tbl(l_ind).config_inst_rev_num);

Line 2986: dbms_sql.column_value(l_dtl_qry_cur_id, 55, x_line_dtls_tbl(l_ind).source_txn_line_detail_id);

2982: dbms_sql.column_value(l_dtl_qry_cur_id, 51, x_line_dtls_tbl(l_ind).attribute13);
2983: dbms_sql.column_value(l_dtl_qry_cur_id, 52, x_line_dtls_tbl(l_ind).attribute14);
2984: dbms_sql.column_value(l_dtl_qry_cur_id, 53, x_line_dtls_tbl(l_ind).attribute15);
2985: dbms_sql.column_value(l_dtl_qry_cur_id, 54, x_line_dtls_tbl(l_ind).object_version_number);
2986: dbms_sql.column_value(l_dtl_qry_cur_id, 55, x_line_dtls_tbl(l_ind).source_txn_line_detail_id);
2987: dbms_sql.column_value(l_dtl_qry_cur_id, 56, x_line_dtls_tbl(l_ind).inv_mtl_transaction_id);
2988: dbms_sql.column_value(l_dtl_qry_cur_id, 57, x_line_dtls_tbl(l_ind).config_inst_hdr_id);
2989: dbms_sql.column_value(l_dtl_qry_cur_id, 58, x_line_dtls_tbl(l_ind).config_inst_rev_num);
2990: dbms_sql.column_value(l_dtl_qry_cur_id, 59, x_line_dtls_tbl(l_ind).config_inst_item_id);

Line 2987: dbms_sql.column_value(l_dtl_qry_cur_id, 56, x_line_dtls_tbl(l_ind).inv_mtl_transaction_id);

2983: dbms_sql.column_value(l_dtl_qry_cur_id, 52, x_line_dtls_tbl(l_ind).attribute14);
2984: dbms_sql.column_value(l_dtl_qry_cur_id, 53, x_line_dtls_tbl(l_ind).attribute15);
2985: dbms_sql.column_value(l_dtl_qry_cur_id, 54, x_line_dtls_tbl(l_ind).object_version_number);
2986: dbms_sql.column_value(l_dtl_qry_cur_id, 55, x_line_dtls_tbl(l_ind).source_txn_line_detail_id);
2987: dbms_sql.column_value(l_dtl_qry_cur_id, 56, x_line_dtls_tbl(l_ind).inv_mtl_transaction_id);
2988: dbms_sql.column_value(l_dtl_qry_cur_id, 57, x_line_dtls_tbl(l_ind).config_inst_hdr_id);
2989: dbms_sql.column_value(l_dtl_qry_cur_id, 58, x_line_dtls_tbl(l_ind).config_inst_rev_num);
2990: dbms_sql.column_value(l_dtl_qry_cur_id, 59, x_line_dtls_tbl(l_ind).config_inst_item_id);
2991: dbms_sql.column_value(l_dtl_qry_cur_id, 60, x_line_dtls_tbl(l_ind).target_commitment_date);

Line 2988: dbms_sql.column_value(l_dtl_qry_cur_id, 57, x_line_dtls_tbl(l_ind).config_inst_hdr_id);

2984: dbms_sql.column_value(l_dtl_qry_cur_id, 53, x_line_dtls_tbl(l_ind).attribute15);
2985: dbms_sql.column_value(l_dtl_qry_cur_id, 54, x_line_dtls_tbl(l_ind).object_version_number);
2986: dbms_sql.column_value(l_dtl_qry_cur_id, 55, x_line_dtls_tbl(l_ind).source_txn_line_detail_id);
2987: dbms_sql.column_value(l_dtl_qry_cur_id, 56, x_line_dtls_tbl(l_ind).inv_mtl_transaction_id);
2988: dbms_sql.column_value(l_dtl_qry_cur_id, 57, x_line_dtls_tbl(l_ind).config_inst_hdr_id);
2989: dbms_sql.column_value(l_dtl_qry_cur_id, 58, x_line_dtls_tbl(l_ind).config_inst_rev_num);
2990: dbms_sql.column_value(l_dtl_qry_cur_id, 59, x_line_dtls_tbl(l_ind).config_inst_item_id);
2991: dbms_sql.column_value(l_dtl_qry_cur_id, 60, x_line_dtls_tbl(l_ind).target_commitment_date);
2992: dbms_sql.column_value(l_dtl_qry_cur_id, 61, x_line_dtls_tbl(l_ind).instance_description);

Line 2989: dbms_sql.column_value(l_dtl_qry_cur_id, 58, x_line_dtls_tbl(l_ind).config_inst_rev_num);

2985: dbms_sql.column_value(l_dtl_qry_cur_id, 54, x_line_dtls_tbl(l_ind).object_version_number);
2986: dbms_sql.column_value(l_dtl_qry_cur_id, 55, x_line_dtls_tbl(l_ind).source_txn_line_detail_id);
2987: dbms_sql.column_value(l_dtl_qry_cur_id, 56, x_line_dtls_tbl(l_ind).inv_mtl_transaction_id);
2988: dbms_sql.column_value(l_dtl_qry_cur_id, 57, x_line_dtls_tbl(l_ind).config_inst_hdr_id);
2989: dbms_sql.column_value(l_dtl_qry_cur_id, 58, x_line_dtls_tbl(l_ind).config_inst_rev_num);
2990: dbms_sql.column_value(l_dtl_qry_cur_id, 59, x_line_dtls_tbl(l_ind).config_inst_item_id);
2991: dbms_sql.column_value(l_dtl_qry_cur_id, 60, x_line_dtls_tbl(l_ind).target_commitment_date);
2992: dbms_sql.column_value(l_dtl_qry_cur_id, 61, x_line_dtls_tbl(l_ind).instance_description);
2993: dbms_sql.column_value(l_dtl_qry_cur_id, 62 , l_line_dtl_rec.config_inst_baseline_rev_num);

Line 2990: dbms_sql.column_value(l_dtl_qry_cur_id, 59, x_line_dtls_tbl(l_ind).config_inst_item_id);

2986: dbms_sql.column_value(l_dtl_qry_cur_id, 55, x_line_dtls_tbl(l_ind).source_txn_line_detail_id);
2987: dbms_sql.column_value(l_dtl_qry_cur_id, 56, x_line_dtls_tbl(l_ind).inv_mtl_transaction_id);
2988: dbms_sql.column_value(l_dtl_qry_cur_id, 57, x_line_dtls_tbl(l_ind).config_inst_hdr_id);
2989: dbms_sql.column_value(l_dtl_qry_cur_id, 58, x_line_dtls_tbl(l_ind).config_inst_rev_num);
2990: dbms_sql.column_value(l_dtl_qry_cur_id, 59, x_line_dtls_tbl(l_ind).config_inst_item_id);
2991: dbms_sql.column_value(l_dtl_qry_cur_id, 60, x_line_dtls_tbl(l_ind).target_commitment_date);
2992: dbms_sql.column_value(l_dtl_qry_cur_id, 61, x_line_dtls_tbl(l_ind).instance_description);
2993: dbms_sql.column_value(l_dtl_qry_cur_id, 62 , l_line_dtl_rec.config_inst_baseline_rev_num);
2994: dbms_sql.column_value(l_dtl_qry_cur_id, 63, x_line_dtls_tbl(l_ind).reference_source_line_id);

Line 2991: dbms_sql.column_value(l_dtl_qry_cur_id, 60, x_line_dtls_tbl(l_ind).target_commitment_date);

2987: dbms_sql.column_value(l_dtl_qry_cur_id, 56, x_line_dtls_tbl(l_ind).inv_mtl_transaction_id);
2988: dbms_sql.column_value(l_dtl_qry_cur_id, 57, x_line_dtls_tbl(l_ind).config_inst_hdr_id);
2989: dbms_sql.column_value(l_dtl_qry_cur_id, 58, x_line_dtls_tbl(l_ind).config_inst_rev_num);
2990: dbms_sql.column_value(l_dtl_qry_cur_id, 59, x_line_dtls_tbl(l_ind).config_inst_item_id);
2991: dbms_sql.column_value(l_dtl_qry_cur_id, 60, x_line_dtls_tbl(l_ind).target_commitment_date);
2992: dbms_sql.column_value(l_dtl_qry_cur_id, 61, x_line_dtls_tbl(l_ind).instance_description);
2993: dbms_sql.column_value(l_dtl_qry_cur_id, 62 , l_line_dtl_rec.config_inst_baseline_rev_num);
2994: dbms_sql.column_value(l_dtl_qry_cur_id, 63, x_line_dtls_tbl(l_ind).reference_source_line_id);
2995: dbms_sql.column_value(l_dtl_qry_cur_id, 64, x_line_dtls_tbl(l_ind).install_location_type_code);

Line 2992: dbms_sql.column_value(l_dtl_qry_cur_id, 61, x_line_dtls_tbl(l_ind).instance_description);

2988: dbms_sql.column_value(l_dtl_qry_cur_id, 57, x_line_dtls_tbl(l_ind).config_inst_hdr_id);
2989: dbms_sql.column_value(l_dtl_qry_cur_id, 58, x_line_dtls_tbl(l_ind).config_inst_rev_num);
2990: dbms_sql.column_value(l_dtl_qry_cur_id, 59, x_line_dtls_tbl(l_ind).config_inst_item_id);
2991: dbms_sql.column_value(l_dtl_qry_cur_id, 60, x_line_dtls_tbl(l_ind).target_commitment_date);
2992: dbms_sql.column_value(l_dtl_qry_cur_id, 61, x_line_dtls_tbl(l_ind).instance_description);
2993: dbms_sql.column_value(l_dtl_qry_cur_id, 62 , l_line_dtl_rec.config_inst_baseline_rev_num);
2994: dbms_sql.column_value(l_dtl_qry_cur_id, 63, x_line_dtls_tbl(l_ind).reference_source_line_id);
2995: dbms_sql.column_value(l_dtl_qry_cur_id, 64, x_line_dtls_tbl(l_ind).install_location_type_code);
2996: dbms_sql.column_value(l_dtl_qry_cur_id, 65, x_line_dtls_tbl(l_ind).install_location_id);

Line 2993: dbms_sql.column_value(l_dtl_qry_cur_id, 62 , l_line_dtl_rec.config_inst_baseline_rev_num);

2989: dbms_sql.column_value(l_dtl_qry_cur_id, 58, x_line_dtls_tbl(l_ind).config_inst_rev_num);
2990: dbms_sql.column_value(l_dtl_qry_cur_id, 59, x_line_dtls_tbl(l_ind).config_inst_item_id);
2991: dbms_sql.column_value(l_dtl_qry_cur_id, 60, x_line_dtls_tbl(l_ind).target_commitment_date);
2992: dbms_sql.column_value(l_dtl_qry_cur_id, 61, x_line_dtls_tbl(l_ind).instance_description);
2993: dbms_sql.column_value(l_dtl_qry_cur_id, 62 , l_line_dtl_rec.config_inst_baseline_rev_num);
2994: dbms_sql.column_value(l_dtl_qry_cur_id, 63, x_line_dtls_tbl(l_ind).reference_source_line_id);
2995: dbms_sql.column_value(l_dtl_qry_cur_id, 64, x_line_dtls_tbl(l_ind).install_location_type_code);
2996: dbms_sql.column_value(l_dtl_qry_cur_id, 65, x_line_dtls_tbl(l_ind).install_location_id);
2997: dbms_sql.column_value(l_dtl_qry_cur_id, 66, x_line_dtls_tbl(l_ind).cascade_owner_flag);

Line 2994: dbms_sql.column_value(l_dtl_qry_cur_id, 63, x_line_dtls_tbl(l_ind).reference_source_line_id);

2990: dbms_sql.column_value(l_dtl_qry_cur_id, 59, x_line_dtls_tbl(l_ind).config_inst_item_id);
2991: dbms_sql.column_value(l_dtl_qry_cur_id, 60, x_line_dtls_tbl(l_ind).target_commitment_date);
2992: dbms_sql.column_value(l_dtl_qry_cur_id, 61, x_line_dtls_tbl(l_ind).instance_description);
2993: dbms_sql.column_value(l_dtl_qry_cur_id, 62 , l_line_dtl_rec.config_inst_baseline_rev_num);
2994: dbms_sql.column_value(l_dtl_qry_cur_id, 63, x_line_dtls_tbl(l_ind).reference_source_line_id);
2995: dbms_sql.column_value(l_dtl_qry_cur_id, 64, x_line_dtls_tbl(l_ind).install_location_type_code);
2996: dbms_sql.column_value(l_dtl_qry_cur_id, 65, x_line_dtls_tbl(l_ind).install_location_id);
2997: dbms_sql.column_value(l_dtl_qry_cur_id, 66, x_line_dtls_tbl(l_ind).cascade_owner_flag);
2998: dbms_sql.column_value(l_dtl_qry_cur_id, 67, x_line_dtls_tbl(l_ind).parent_instance_id);

Line 2995: dbms_sql.column_value(l_dtl_qry_cur_id, 64, x_line_dtls_tbl(l_ind).install_location_type_code);

2991: dbms_sql.column_value(l_dtl_qry_cur_id, 60, x_line_dtls_tbl(l_ind).target_commitment_date);
2992: dbms_sql.column_value(l_dtl_qry_cur_id, 61, x_line_dtls_tbl(l_ind).instance_description);
2993: dbms_sql.column_value(l_dtl_qry_cur_id, 62 , l_line_dtl_rec.config_inst_baseline_rev_num);
2994: dbms_sql.column_value(l_dtl_qry_cur_id, 63, x_line_dtls_tbl(l_ind).reference_source_line_id);
2995: dbms_sql.column_value(l_dtl_qry_cur_id, 64, x_line_dtls_tbl(l_ind).install_location_type_code);
2996: dbms_sql.column_value(l_dtl_qry_cur_id, 65, x_line_dtls_tbl(l_ind).install_location_id);
2997: dbms_sql.column_value(l_dtl_qry_cur_id, 66, x_line_dtls_tbl(l_ind).cascade_owner_flag);
2998: dbms_sql.column_value(l_dtl_qry_cur_id, 67, x_line_dtls_tbl(l_ind).parent_instance_id);
2999: dbms_sql.column_value(l_dtl_qry_cur_id, 68, x_line_dtls_tbl(l_ind).assc_txn_line_detail_id);

Line 2996: dbms_sql.column_value(l_dtl_qry_cur_id, 65, x_line_dtls_tbl(l_ind).install_location_id);

2992: dbms_sql.column_value(l_dtl_qry_cur_id, 61, x_line_dtls_tbl(l_ind).instance_description);
2993: dbms_sql.column_value(l_dtl_qry_cur_id, 62 , l_line_dtl_rec.config_inst_baseline_rev_num);
2994: dbms_sql.column_value(l_dtl_qry_cur_id, 63, x_line_dtls_tbl(l_ind).reference_source_line_id);
2995: dbms_sql.column_value(l_dtl_qry_cur_id, 64, x_line_dtls_tbl(l_ind).install_location_type_code);
2996: dbms_sql.column_value(l_dtl_qry_cur_id, 65, x_line_dtls_tbl(l_ind).install_location_id);
2997: dbms_sql.column_value(l_dtl_qry_cur_id, 66, x_line_dtls_tbl(l_ind).cascade_owner_flag);
2998: dbms_sql.column_value(l_dtl_qry_cur_id, 67, x_line_dtls_tbl(l_ind).parent_instance_id);
2999: dbms_sql.column_value(l_dtl_qry_cur_id, 68, x_line_dtls_tbl(l_ind).assc_txn_line_detail_id);
3000: dbms_sql.column_value(l_dtl_qry_cur_id, 69, x_line_dtls_tbl(l_ind).overriding_csi_txn_id);

Line 2997: dbms_sql.column_value(l_dtl_qry_cur_id, 66, x_line_dtls_tbl(l_ind).cascade_owner_flag);

2993: dbms_sql.column_value(l_dtl_qry_cur_id, 62 , l_line_dtl_rec.config_inst_baseline_rev_num);
2994: dbms_sql.column_value(l_dtl_qry_cur_id, 63, x_line_dtls_tbl(l_ind).reference_source_line_id);
2995: dbms_sql.column_value(l_dtl_qry_cur_id, 64, x_line_dtls_tbl(l_ind).install_location_type_code);
2996: dbms_sql.column_value(l_dtl_qry_cur_id, 65, x_line_dtls_tbl(l_ind).install_location_id);
2997: dbms_sql.column_value(l_dtl_qry_cur_id, 66, x_line_dtls_tbl(l_ind).cascade_owner_flag);
2998: dbms_sql.column_value(l_dtl_qry_cur_id, 67, x_line_dtls_tbl(l_ind).parent_instance_id);
2999: dbms_sql.column_value(l_dtl_qry_cur_id, 68, x_line_dtls_tbl(l_ind).assc_txn_line_detail_id);
3000: dbms_sql.column_value(l_dtl_qry_cur_id, 69, x_line_dtls_tbl(l_ind).overriding_csi_txn_id);
3001: dbms_sql.column_value(l_dtl_qry_cur_id, 70, x_line_dtls_tbl(l_ind).instance_status_id);

Line 2998: dbms_sql.column_value(l_dtl_qry_cur_id, 67, x_line_dtls_tbl(l_ind).parent_instance_id);

2994: dbms_sql.column_value(l_dtl_qry_cur_id, 63, x_line_dtls_tbl(l_ind).reference_source_line_id);
2995: dbms_sql.column_value(l_dtl_qry_cur_id, 64, x_line_dtls_tbl(l_ind).install_location_type_code);
2996: dbms_sql.column_value(l_dtl_qry_cur_id, 65, x_line_dtls_tbl(l_ind).install_location_id);
2997: dbms_sql.column_value(l_dtl_qry_cur_id, 66, x_line_dtls_tbl(l_ind).cascade_owner_flag);
2998: dbms_sql.column_value(l_dtl_qry_cur_id, 67, x_line_dtls_tbl(l_ind).parent_instance_id);
2999: dbms_sql.column_value(l_dtl_qry_cur_id, 68, x_line_dtls_tbl(l_ind).assc_txn_line_detail_id);
3000: dbms_sql.column_value(l_dtl_qry_cur_id, 69, x_line_dtls_tbl(l_ind).overriding_csi_txn_id);
3001: dbms_sql.column_value(l_dtl_qry_cur_id, 70, x_line_dtls_tbl(l_ind).instance_status_id);
3002: END LOOP;

Line 2999: dbms_sql.column_value(l_dtl_qry_cur_id, 68, x_line_dtls_tbl(l_ind).assc_txn_line_detail_id);

2995: dbms_sql.column_value(l_dtl_qry_cur_id, 64, x_line_dtls_tbl(l_ind).install_location_type_code);
2996: dbms_sql.column_value(l_dtl_qry_cur_id, 65, x_line_dtls_tbl(l_ind).install_location_id);
2997: dbms_sql.column_value(l_dtl_qry_cur_id, 66, x_line_dtls_tbl(l_ind).cascade_owner_flag);
2998: dbms_sql.column_value(l_dtl_qry_cur_id, 67, x_line_dtls_tbl(l_ind).parent_instance_id);
2999: dbms_sql.column_value(l_dtl_qry_cur_id, 68, x_line_dtls_tbl(l_ind).assc_txn_line_detail_id);
3000: dbms_sql.column_value(l_dtl_qry_cur_id, 69, x_line_dtls_tbl(l_ind).overriding_csi_txn_id);
3001: dbms_sql.column_value(l_dtl_qry_cur_id, 70, x_line_dtls_tbl(l_ind).instance_status_id);
3002: END LOOP;
3003:

Line 3000: dbms_sql.column_value(l_dtl_qry_cur_id, 69, x_line_dtls_tbl(l_ind).overriding_csi_txn_id);

2996: dbms_sql.column_value(l_dtl_qry_cur_id, 65, x_line_dtls_tbl(l_ind).install_location_id);
2997: dbms_sql.column_value(l_dtl_qry_cur_id, 66, x_line_dtls_tbl(l_ind).cascade_owner_flag);
2998: dbms_sql.column_value(l_dtl_qry_cur_id, 67, x_line_dtls_tbl(l_ind).parent_instance_id);
2999: dbms_sql.column_value(l_dtl_qry_cur_id, 68, x_line_dtls_tbl(l_ind).assc_txn_line_detail_id);
3000: dbms_sql.column_value(l_dtl_qry_cur_id, 69, x_line_dtls_tbl(l_ind).overriding_csi_txn_id);
3001: dbms_sql.column_value(l_dtl_qry_cur_id, 70, x_line_dtls_tbl(l_ind).instance_status_id);
3002: END LOOP;
3003:
3004: dbms_sql.close_cursor(l_dtl_qry_cur_id);

Line 3001: dbms_sql.column_value(l_dtl_qry_cur_id, 70, x_line_dtls_tbl(l_ind).instance_status_id);

2997: dbms_sql.column_value(l_dtl_qry_cur_id, 66, x_line_dtls_tbl(l_ind).cascade_owner_flag);
2998: dbms_sql.column_value(l_dtl_qry_cur_id, 67, x_line_dtls_tbl(l_ind).parent_instance_id);
2999: dbms_sql.column_value(l_dtl_qry_cur_id, 68, x_line_dtls_tbl(l_ind).assc_txn_line_detail_id);
3000: dbms_sql.column_value(l_dtl_qry_cur_id, 69, x_line_dtls_tbl(l_ind).overriding_csi_txn_id);
3001: dbms_sql.column_value(l_dtl_qry_cur_id, 70, x_line_dtls_tbl(l_ind).instance_status_id);
3002: END LOOP;
3003:
3004: dbms_sql.close_cursor(l_dtl_qry_cur_id);
3005:

Line 3004: dbms_sql.close_cursor(l_dtl_qry_cur_id);

3000: dbms_sql.column_value(l_dtl_qry_cur_id, 69, x_line_dtls_tbl(l_ind).overriding_csi_txn_id);
3001: dbms_sql.column_value(l_dtl_qry_cur_id, 70, x_line_dtls_tbl(l_ind).instance_status_id);
3002: END LOOP;
3003:
3004: dbms_sql.close_cursor(l_dtl_qry_cur_id);
3005:
3006: EXCEPTION
3007:
3008: WHEN fnd_api.g_exc_error THEN

Line 3010: IF dbms_sql.is_open(l_dtl_qry_cur_id) THEN

3006: EXCEPTION
3007:
3008: WHEN fnd_api.g_exc_error THEN
3009:
3010: IF dbms_sql.is_open(l_dtl_qry_cur_id) THEN
3011: dbms_sql.close_cursor(l_dtl_qry_cur_id);
3012: END IF;
3013:
3014: x_return_status := fnd_api.g_ret_sts_error;

Line 3011: dbms_sql.close_cursor(l_dtl_qry_cur_id);

3007:
3008: WHEN fnd_api.g_exc_error THEN
3009:
3010: IF dbms_sql.is_open(l_dtl_qry_cur_id) THEN
3011: dbms_sql.close_cursor(l_dtl_qry_cur_id);
3012: END IF;
3013:
3014: x_return_status := fnd_api.g_ret_sts_error;
3015:

Line 3018: IF dbms_sql.is_open(l_dtl_qry_cur_id) THEN

3014: x_return_status := fnd_api.g_ret_sts_error;
3015:
3016: WHEN others THEN
3017:
3018: IF dbms_sql.is_open(l_dtl_qry_cur_id) THEN
3019: dbms_sql.close_cursor(l_dtl_qry_cur_id);
3020: END IF;
3021:
3022: debug('Error : '|| SQLERRM);

Line 3019: dbms_sql.close_cursor(l_dtl_qry_cur_id);

3015:
3016: WHEN others THEN
3017:
3018: IF dbms_sql.is_open(l_dtl_qry_cur_id) THEN
3019: dbms_sql.close_cursor(l_dtl_qry_cur_id);
3020: END IF;
3021:
3022: debug('Error : '|| SQLERRM);
3023: x_return_status := fnd_api.g_ret_sts_unexp_error;