DBA Data[Home] [Help]

APPS.OKC_OC_INT_SALESCDT_PVT dependencies on OKX_QUOTE_HEADERS_V

Line 22: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1

18: G_SALESREP_CTROL CONSTANT fnd_lookups.lookup_code%TYPE := 'SALESPERSON';
19: ---------------------------------------------------------------------------
20: --Procedure to create contract sales credit information at the header and line levels
21: ----------------------------------------------------------------------------
22: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
23: PROCEDURE create_k_sales_credit (
24: x_return_status OUT NOCOPY VARCHAR2,
25:
26: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

Line 30: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE DEFAULT OKC_API.G_MISS_NUM,

26: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
27: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
28: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
29: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
30: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE DEFAULT OKC_API.G_MISS_NUM,
31: p_line_inf_tab IN OKC_OC_INT_CONFIG_PVT.line_inf_tbl_type
32: DEFAULT OKC_OC_INT_SALESCDT_PVT.G_MISS_LINE_INF_TAB
33: -- this PL/SQL table has quote (or order) lines against contract lines
34:

Line 43: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1

39: ----------------------------------------------------------------------------
40: -- Procedure creates sales credit information in OKC from
41: -- ASO or ONT sales credit
42: ----------------------------------------------------------------------------
43: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
44: PROCEDURE get_sales_credit(
45: p_chr_id IN NUMBER,
46: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
47: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE DEFAULT OKC_API.G_MISS_NUM,

Line 47: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE DEFAULT OKC_API.G_MISS_NUM,

43: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
44: PROCEDURE get_sales_credit(
45: p_chr_id IN NUMBER,
46: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
47: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE DEFAULT OKC_API.G_MISS_NUM,
48: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
49: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
50: p_line_inf_tab IN OKC_OC_INT_CONFIG_PVT.line_inf_tbl_type
51: DEFAULT OKC_OC_INT_SALESCDT_PVT.G_MISS_LINE_INF_TAB

Line 59: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1

55: ----------------------------------------------------------------------
56: -- PROCEDURE to get SALES CREDITS information from ASO or ONT tables
57: -- get_sales_credit_tab stores it's output in global PL/SQL table g_sales_credit_tab
58: ----------------------------------------------------------------------
59: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
60: -- ASO_QUOTE_LINES_ALL.LINE_HEADER_ID to OKX_QUOTE_LINES_V.ID1
61: PROCEDURE get_sales_credit_tab(
62: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
63: p_cle_id IN OKC_K_LINES_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM,

Line 70: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE DEFAULT OKC_API.G_MISS_NUM,

66: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
67: p_ole_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
68:
69: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE, --quote flag
70: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE DEFAULT OKC_API.G_MISS_NUM,
71: p_qle_id IN OKX_QUOTE_LINES_V.ID1%TYPE DEFAULT OKC_API.G_MISS_NUM);
72:
73:
74: -- ========================================================================

Line 110: p_qhr_id IN OKX_QUOTE_HEADERS_V.id1%TYPE DEFAULT OKC_API.g_miss_num,

106: p_chr_id IN OKC_K_HEADERS_B.id%TYPE,
107: p_kl_rel_tab IN okc_oc_int_config_pvt.line_rel_tab_type DEFAULT okc_oc_int_config_pvt.g_miss_kl_rel_tab,
108: --
109: p_q_flag IN VARCHAR2 DEFAULT OKC_API.g_miss_char,
110: p_qhr_id IN OKX_QUOTE_HEADERS_V.id1%TYPE DEFAULT OKC_API.g_miss_num,
111: p_qle_tab IN ASO_QUOTE_PUB.qte_line_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_qte_line_tbl,
112: --
113: p_o_flag IN VARCHAR2 DEFAULT OKC_API.g_miss_char,
114: p_ohr_id IN OKX_ORDER_HEADERS_V.id1%TYPE DEFAULT OKC_API.g_miss_num,