eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_OC_INT_SALESCDT_PVT dependencies on OKC_API

Line 27: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,
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

Line 28: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

24: x_return_status OUT NOCOPY VARCHAR2,
25:
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

Line 29: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

25:
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

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 46: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,
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

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 48: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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
52: );

Line 49: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

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
52: );
53:

Line 63: p_cle_id IN OKC_K_LINES_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM,

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,
64:
65: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE, --order flag
66: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
67: p_ole_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

Line 65: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE, --order flag

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,
64:
65: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE, --order flag
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

Line 66: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

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,
64:
65: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE, --order flag
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,

Line 67: p_ole_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

63: p_cle_id IN OKC_K_LINES_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM,
64:
65: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE, --order flag
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);

Line 69: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE, --quote flag

65: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE, --order flag
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:

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 71: p_qle_id IN OKX_QUOTE_LINES_V.ID1%TYPE 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: -- ========================================================================
75: -- START OF KTQ or KTO SALES CREDIT INFORMATION CREATION

Line 109: p_q_flag IN VARCHAR2 DEFAULT OKC_API.g_miss_char,

105: PROCEDURE build_sales_credit_from_k(
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,

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,

Line 113: p_o_flag IN VARCHAR2 DEFAULT OKC_API.g_miss_char,

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,
115: p_ole_tab IN ASO_QUOTE_PUB.qte_line_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_qte_line_tbl,
116: --
117: x_hd_sales_credit_tab OUT NOCOPY ASO_QUOTE_PUB.sales_credit_tbl_type,

Line 114: p_ohr_id IN OKX_ORDER_HEADERS_V.id1%TYPE DEFAULT OKC_API.g_miss_num,

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,
115: p_ole_tab IN ASO_QUOTE_PUB.qte_line_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_qte_line_tbl,
116: --
117: x_hd_sales_credit_tab OUT NOCOPY ASO_QUOTE_PUB.sales_credit_tbl_type,
118: x_ln_sales_credit_tab OUT NOCOPY ASO_QUOTE_PUB.sales_credit_tbl_type,