APPS.OKC_OC_INT_KTQ_PVT dependencies on OKX_QUOTE_LINE_DETAIL_V

Line 613: ,svc_duration okx_quote_line_detail_v.service_duration%TYPE

609: ,prod_name okx_system_items_v.name%TYPE
610: ,item_source_code jtf_objects_b.object_code%TYPE
611: ,item_source_table jtf_objects_b.from_table%TYPE
612: --
613: ,svc_duration okx_quote_line_detail_v.service_duration%TYPE
614: ,svc_period okx_quote_line_detail_v.service_period%TYPE
615: );
616:
617: TYPE covlvl_info_tab_typ IS TABLE OF covlvl_info_rec_typ INDEX BY BINARY_INTEGER;

Line 614: ,svc_period okx_quote_line_detail_v.service_period%TYPE

610: ,item_source_code jtf_objects_b.object_code%TYPE
611: ,item_source_table jtf_objects_b.from_table%TYPE
612: --
613: ,svc_duration okx_quote_line_detail_v.service_duration%TYPE
614: ,svc_period okx_quote_line_detail_v.service_period%TYPE
615: );
616:
617: TYPE covlvl_info_tab_typ IS TABLE OF covlvl_info_rec_typ INDEX BY BINARY_INTEGER;
618:

Line 1596: l_svc_duration okx_quote_line_detail_v.service_duration%TYPE;

1592: e_exit exception;
1593: l_idx binary_integer; -- generic table index
1594: l_cp_idx binary_integer; -- index for cust prod cov lvl table
1595: l_cp_ctr integer; -- NUMBER of cp lines per service line
1596: l_svc_duration okx_quote_line_detail_v.service_duration%TYPE;
1597: l_svc_period okx_quote_line_detail_v.service_period%TYPE;
1598: l_party NUMBER;
1599: l_lines NUMBER;
1600: l_nb_parties NUMBER;

Line 1597: l_svc_period okx_quote_line_detail_v.service_period%TYPE;

1593: l_idx binary_integer; -- generic table index
1594: l_cp_idx binary_integer; -- index for cust prod cov lvl table
1595: l_cp_ctr integer; -- NUMBER of cp lines per service line
1596: l_svc_duration okx_quote_line_detail_v.service_duration%TYPE;
1597: l_svc_period okx_quote_line_detail_v.service_period%TYPE;
1598: l_party NUMBER;
1599: l_lines NUMBER;
1600: l_nb_parties NUMBER;
1601: l_nb_roles NUMBER;

Line 2818: l_id1 okx_quote_line_detail_v.id1%TYPE;

2814: --
2815: l_previous_line_id okc_k_lines_b.id%TYPE;
2816: l_cur_tl NUMBER;
2817: l_cur_cl NUMBER;
2818: l_id1 okx_quote_line_detail_v.id1%TYPE;
2819: --
2820: l_k_ship_found VARCHAR2(1) := 'N';
2821: l_value VARCHAR2(1) := 'N';
2822: l_quote_line_id okc_k_rel_objs.object1_id1%TYPE;

Line 2843: FROM okx_quote_line_detail_v

2839: x_msg_data VARCHAR2(1000);
2840:
2841: CURSOR c_quot_detl_line (p_qte_line_id IN NUMBER) IS
2842: SELECT ID1
2843: FROM okx_quote_line_detail_v
2844: WHERE QUOTE_LINE_ID = p_qte_line_id;
2845:
2846:
2847: CURSOR c_ql (g_quote_id IN okx_quote_lines_v.quote_header_id%TYPE ) IS

Line 2860: FROM okx_quote_line_detail_v

2856:
2857:
2858: CURSOR c_qdl(id1 IN okx_quote_lines_v.ID1%TYPE ) IS
2859: SELECT id1
2860: FROM okx_quote_line_detail_v
2861: WHERE quote_line_id = id1;
2862:
2863: -- Cursor to select all existing shipment lines at the quote header level
2864: -- and decide on the operation code.

Line 3459: okc_util.print_trace(2,'Case of qdl not found in okx_quote_line_detail_v but found in the PL/SQL table');

3455: IF px_qte_line_dtl_tbl(k).quote_line_id = px_qte_line_tbl(l_ql).quote_line_id THEN
3456: l_qdl_a_found := 'Y';
3457: l_dql := k;
3458: IF (l_debug = 'Y') THEN
3459: okc_util.print_trace(2,'Case of qdl not found in okx_quote_line_detail_v but found in the PL/SQL table');
3460: END IF;
3461: EXIT;
3462: END IF;
3463: END LOOP;

Line 3469: okc_util.print_trace(2,'Case of qdl not found in neither okx_quote_line_detail_v nor the PL/SQL table');

3465: IF l_qdl_a_found = 'N' THEN -- The previous check did'nt find any entry in the PL/SQLtable
3466: i_l_dql := l_dql + 1;
3467: l_dql := i_l_dql;
3468: IF (l_debug = 'Y') THEN
3469: okc_util.print_trace(2,'Case of qdl not found in neither okx_quote_line_detail_v nor the PL/SQL table');
3470: END IF;
3471: END IF;
3472:
3473: px_qte_line_dtl_tbl(l_dql).operation_code := g_aso_op_code_create;