DBA Data[Home] [Help]

APPS.OKC_OC_INT_CONFIG_PVT dependencies on OKC_K_LINES_B

Line 10: G_MODEL_LINE CONSTANT OKC_K_LINES_B.CONFIG_ITEM_TYPE%TYPE := 'TOP_MODEL_LINE';

6: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
7: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_OC_INT_CONFIG_PVT';
8: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
9:
10: G_MODEL_LINE CONSTANT OKC_K_LINES_B.CONFIG_ITEM_TYPE%TYPE := 'TOP_MODEL_LINE';
11: G_BASE_LINE CONSTANT OKC_K_LINES_B.CONFIG_ITEM_TYPE%TYPE := 'TOP_BASE_LINE';
12: G_NORMAL_LINE CONSTANT OKC_K_LINES_B.CONFIG_ITEM_TYPE%TYPE := 'CONFIG';
13: rolledup_line_list_price NUMBER :=0;
14: rolledup_price_negotiated NUMBER :=0;

Line 11: G_BASE_LINE CONSTANT OKC_K_LINES_B.CONFIG_ITEM_TYPE%TYPE := 'TOP_BASE_LINE';

7: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_OC_INT_CONFIG_PVT';
8: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
9:
10: G_MODEL_LINE CONSTANT OKC_K_LINES_B.CONFIG_ITEM_TYPE%TYPE := 'TOP_MODEL_LINE';
11: G_BASE_LINE CONSTANT OKC_K_LINES_B.CONFIG_ITEM_TYPE%TYPE := 'TOP_BASE_LINE';
12: G_NORMAL_LINE CONSTANT OKC_K_LINES_B.CONFIG_ITEM_TYPE%TYPE := 'CONFIG';
13: rolledup_line_list_price NUMBER :=0;
14: rolledup_price_negotiated NUMBER :=0;
15:

Line 12: G_NORMAL_LINE CONSTANT OKC_K_LINES_B.CONFIG_ITEM_TYPE%TYPE := 'CONFIG';

8: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
9:
10: G_MODEL_LINE CONSTANT OKC_K_LINES_B.CONFIG_ITEM_TYPE%TYPE := 'TOP_MODEL_LINE';
11: G_BASE_LINE CONSTANT OKC_K_LINES_B.CONFIG_ITEM_TYPE%TYPE := 'TOP_BASE_LINE';
12: G_NORMAL_LINE CONSTANT OKC_K_LINES_B.CONFIG_ITEM_TYPE%TYPE := 'CONFIG';
13: rolledup_line_list_price NUMBER :=0;
14: rolledup_price_negotiated NUMBER :=0;
15:
16: -- Bug : 1686001 Changed references aso_quote_lines_all to okx_quote_lines_v

Line 17: TYPE line_inf_rec_type IS RECORD(cle_id okc_k_lines_b.id%TYPE

13: rolledup_line_list_price NUMBER :=0;
14: rolledup_price_negotiated NUMBER :=0;
15:
16: -- Bug : 1686001 Changed references aso_quote_lines_all to okx_quote_lines_v
17: TYPE line_inf_rec_type IS RECORD(cle_id okc_k_lines_b.id%TYPE
18: ,lse_id okc_k_lines_b.lse_id%TYPE
19: ,lty_code okc_line_styles_b.lty_code%TYPE
20: ,object1_id1 okx_order_headers_v.id1%TYPE
21: ,line_num NUMBER

Line 18: ,lse_id okc_k_lines_b.lse_id%TYPE

14: rolledup_price_negotiated NUMBER :=0;
15:
16: -- Bug : 1686001 Changed references aso_quote_lines_all to okx_quote_lines_v
17: TYPE line_inf_rec_type IS RECORD(cle_id okc_k_lines_b.id%TYPE
18: ,lse_id okc_k_lines_b.lse_id%TYPE
19: ,lty_code okc_line_styles_b.lty_code%TYPE
20: ,object1_id1 okx_order_headers_v.id1%TYPE
21: ,line_num NUMBER
22: ,subline NUMBER

Line 25: ,line_type OKC_K_LINES_B.CONFIG_ITEM_TYPE%TYPE

21: ,line_num NUMBER
22: ,subline NUMBER
23: ,line_qty okx_quote_lines_v.quantity%TYPE
24: ,line_uom okx_quote_lines_v.uom_code%TYPE
25: ,line_type OKC_K_LINES_B.CONFIG_ITEM_TYPE%TYPE
26: );
27:
28: TYPE line_inf_tbl_type IS TABLE OF line_inf_rec_type INDEX BY BINARY_INTEGER;
29:

Line 38: TYPE line_rel_rec_type IS RECORD (k_line_id okc_k_lines_b.id%TYPE

34: ,Object_number OKX_ORDER_HEADERS_V.ORDER_NUMBER%TYPE
35: );
36:
37:
38: TYPE line_rel_rec_type IS RECORD (k_line_id okc_k_lines_b.id%TYPE
39: ,k_parent_line_id okc_k_lines_b.id%TYPE
40: ,q_line_idx NUMBER
41: ,q_item_type_code okx_quote_lines_v.item_type_code%TYPE
42: );

Line 39: ,k_parent_line_id okc_k_lines_b.id%TYPE

35: );
36:
37:
38: TYPE line_rel_rec_type IS RECORD (k_line_id okc_k_lines_b.id%TYPE
39: ,k_parent_line_id okc_k_lines_b.id%TYPE
40: ,q_line_idx NUMBER
41: ,q_item_type_code okx_quote_lines_v.item_type_code%TYPE
42: );
43: