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_PRICING_PVT dependencies on OKC_API

Line 27: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

23: PROCEDURE create_k_pricing (
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
31: DEFAULT OKC_API.G_MISS_NUM,

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
31: DEFAULT OKC_API.G_MISS_NUM,
32: p_line_inf_tab IN OKC_OC_INT_CONFIG_PVT.line_inf_tbl_type

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
31: DEFAULT OKC_API.G_MISS_NUM,
32: p_line_inf_tab IN OKC_OC_INT_CONFIG_PVT.line_inf_tbl_type
33: DEFAULT OKC_OC_INT_PRICING_PVT.G_MISS_LINE_INF_TAB

Line 31: DEFAULT OKC_API.G_MISS_NUM,

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
31: DEFAULT OKC_API.G_MISS_NUM,
32: p_line_inf_tab IN OKC_OC_INT_CONFIG_PVT.line_inf_tbl_type
33: DEFAULT OKC_OC_INT_PRICING_PVT.G_MISS_LINE_INF_TAB
34: -- this PL/SQL table has quote (or order) lines against contract lines
35:

Line 48: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 50: DEFAULT OKC_API.G_MISS_NUM,

46: PROCEDURE get_price_attr(
47: p_chr_id IN NUMBER,
48: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
49: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
50: DEFAULT OKC_API.G_MISS_NUM,
51: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
52: p_ohr_id IN NUMBER,
53: p_line_inf_tab IN OKC_OC_INT_CONFIG_PVT.line_inf_tbl_type
54: DEFAULT OKC_OC_INT_PRICING_PVT.G_MISS_LINE_INF_TAB

Line 51: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

47: p_chr_id IN NUMBER,
48: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
49: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
50: DEFAULT OKC_API.G_MISS_NUM,
51: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
52: p_ohr_id IN NUMBER,
53: p_line_inf_tab IN OKC_OC_INT_CONFIG_PVT.line_inf_tbl_type
54: DEFAULT OKC_OC_INT_PRICING_PVT.G_MISS_LINE_INF_TAB
55: );

Line 65: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

61: --------------------------------------------------------------------------
62: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
63: PROCEDURE get_price_adj(
64: p_chr_id IN NUMBER,
65: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
66: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
67: DEFAULT OKC_API.G_MISS_NUM,
68: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
69: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

Line 67: DEFAULT OKC_API.G_MISS_NUM,

63: PROCEDURE get_price_adj(
64: p_chr_id IN NUMBER,
65: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
66: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
67: DEFAULT OKC_API.G_MISS_NUM,
68: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
69: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
70: p_line_inf_tab IN OKC_OC_INT_CONFIG_PVT.line_inf_tbl_type
71: DEFAULT OKC_OC_INT_PRICING_PVT.G_MISS_LINE_INF_TAB

Line 68: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

64: p_chr_id IN NUMBER,
65: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
66: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
67: DEFAULT OKC_API.G_MISS_NUM,
68: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
69: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
70: p_line_inf_tab IN OKC_OC_INT_CONFIG_PVT.line_inf_tbl_type
71: DEFAULT OKC_OC_INT_PRICING_PVT.G_MISS_LINE_INF_TAB
72: );

Line 69: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

65: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
66: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
67: DEFAULT OKC_API.G_MISS_NUM,
68: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
69: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
70: p_line_inf_tab IN OKC_OC_INT_CONFIG_PVT.line_inf_tbl_type
71: DEFAULT OKC_OC_INT_PRICING_PVT.G_MISS_LINE_INF_TAB
72: );
73:

Line 79: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

75:
76: --put PRICE ADJUSTMENT RELATIONSHIPS FROM ASO (or ONT) into OKC
77: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
78: PROCEDURE get_price_adj_rltship(
79: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
80: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
81: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
82: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
83: DEFAULT OKC_API.G_MISS_NUM,

Line 80: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

76: --put PRICE ADJUSTMENT RELATIONSHIPS FROM ASO (or ONT) into OKC
77: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
78: PROCEDURE get_price_adj_rltship(
79: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
80: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
81: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
82: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
83: DEFAULT OKC_API.G_MISS_NUM,
84: p_line_inf_tab IN OKC_OC_INT_CONFIG_PVT.line_inf_tbl_type

Line 81: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

77: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
78: PROCEDURE get_price_adj_rltship(
79: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
80: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
81: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
82: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
83: DEFAULT OKC_API.G_MISS_NUM,
84: p_line_inf_tab IN OKC_OC_INT_CONFIG_PVT.line_inf_tbl_type
85: DEFAULT OKC_OC_INT_PRICING_PVT.G_MISS_LINE_INF_TAB

Line 83: DEFAULT OKC_API.G_MISS_NUM,

79: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
80: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
81: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
82: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
83: DEFAULT OKC_API.G_MISS_NUM,
84: p_line_inf_tab IN OKC_OC_INT_CONFIG_PVT.line_inf_tbl_type
85: DEFAULT OKC_OC_INT_PRICING_PVT.G_MISS_LINE_INF_TAB
86: );
87:

Line 94: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

90: ----------------------------------------------------------------
91: --put PRICE ADJUSTMENT ATTRIBUTES FROM ASO or ONT into OKC
92: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
93: PROCEDURE get_price_adj_attr(
94: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
95: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
96: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
97: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
98: DEFAULT OKC_API.G_MISS_NUM

Line 95: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

91: --put PRICE ADJUSTMENT ATTRIBUTES FROM ASO or ONT into OKC
92: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
93: PROCEDURE get_price_adj_attr(
94: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
95: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
96: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
97: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
98: DEFAULT OKC_API.G_MISS_NUM
99: );

Line 96: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

92: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
93: PROCEDURE get_price_adj_attr(
94: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
95: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
96: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
97: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
98: DEFAULT OKC_API.G_MISS_NUM
99: );
100:

Line 98: DEFAULT OKC_API.G_MISS_NUM

94: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
95: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
96: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
97: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
98: DEFAULT OKC_API.G_MISS_NUM
99: );
100:
101: ----------------------------------------------------------------------------
102: -- PROCEDURE to get PRICE ADJUSTMENTS information from ASO or ONT tables

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

105: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
106: -- ASO_QUOTE_LINES_ALL.LINE_HEADER_ID to OKX_QUOTE_LINES_V.ID1
107: PROCEDURE get_patv_tab(
108: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
109: p_cle_id IN OKC_K_LINES_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM,
110: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
111: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
112: p_ole_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
113: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 110: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

106: -- ASO_QUOTE_LINES_ALL.LINE_HEADER_ID to OKX_QUOTE_LINES_V.ID1
107: PROCEDURE get_patv_tab(
108: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
109: p_cle_id IN OKC_K_LINES_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM,
110: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
111: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
112: p_ole_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
113: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
114: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE

Line 111: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

107: PROCEDURE get_patv_tab(
108: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
109: p_cle_id IN OKC_K_LINES_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM,
110: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
111: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
112: p_ole_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
113: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
114: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
115: DEFAULT OKC_API.G_MISS_NUM,

Line 112: p_ole_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

108: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
109: p_cle_id IN OKC_K_LINES_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM,
110: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
111: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
112: p_ole_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
113: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
114: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
115: DEFAULT OKC_API.G_MISS_NUM,
116: p_qle_id IN OKX_QUOTE_LINES_V.ID1%TYPE

Line 113: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

109: p_cle_id IN OKC_K_LINES_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM,
110: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
111: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
112: p_ole_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
113: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
114: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
115: DEFAULT OKC_API.G_MISS_NUM,
116: p_qle_id IN OKX_QUOTE_LINES_V.ID1%TYPE
117: DEFAULT OKC_API.G_MISS_NUM);

Line 115: DEFAULT OKC_API.G_MISS_NUM,

111: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
112: p_ole_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
113: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
114: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
115: DEFAULT OKC_API.G_MISS_NUM,
116: p_qle_id IN OKX_QUOTE_LINES_V.ID1%TYPE
117: DEFAULT OKC_API.G_MISS_NUM);
118:
119:

Line 117: DEFAULT OKC_API.G_MISS_NUM);

113: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
114: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
115: DEFAULT OKC_API.G_MISS_NUM,
116: p_qle_id IN OKX_QUOTE_LINES_V.ID1%TYPE
117: DEFAULT OKC_API.G_MISS_NUM);
118:
119:
120: ---------------------------------------------------------------
121: -- PROCEDURE to get PRICE ADJUSTMENT RELATIONSHIP information

Line 127: p_old_pat_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

123: -- get_pacv_tab stores all the price adjustment relationships in
124: -- global PL/SQL table g_pacv_tbl
125: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
126: PROCEDURE get_pacv_tab(
127: p_old_pat_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
128: p_new_pat_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
129: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
130: p_ohr_id IN NUMBER
131: DEFAULT OKC_API.G_MISS_NUM,

Line 128: p_new_pat_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

124: -- global PL/SQL table g_pacv_tbl
125: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
126: PROCEDURE get_pacv_tab(
127: p_old_pat_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
128: p_new_pat_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
129: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
130: p_ohr_id IN NUMBER
131: DEFAULT OKC_API.G_MISS_NUM,
132: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 129: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

125: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
126: PROCEDURE get_pacv_tab(
127: p_old_pat_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
128: p_new_pat_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
129: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
130: p_ohr_id IN NUMBER
131: DEFAULT OKC_API.G_MISS_NUM,
132: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
133: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE

Line 131: DEFAULT OKC_API.G_MISS_NUM,

127: p_old_pat_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
128: p_new_pat_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
129: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
130: p_ohr_id IN NUMBER
131: DEFAULT OKC_API.G_MISS_NUM,
132: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
133: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
134: DEFAULT OKC_API.G_MISS_NUM,
135: p_line_inf_tab IN OKC_OC_INT_CONFIG_PVT.line_inf_tbl_type

Line 132: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

128: p_new_pat_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
129: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
130: p_ohr_id IN NUMBER
131: DEFAULT OKC_API.G_MISS_NUM,
132: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
133: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
134: DEFAULT OKC_API.G_MISS_NUM,
135: p_line_inf_tab IN OKC_OC_INT_CONFIG_PVT.line_inf_tbl_type
136: DEFAULT OKC_OC_INT_PRICING_PVT.G_MISS_LINE_INF_TAB);

Line 134: DEFAULT OKC_API.G_MISS_NUM,

130: p_ohr_id IN NUMBER
131: DEFAULT OKC_API.G_MISS_NUM,
132: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
133: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
134: DEFAULT OKC_API.G_MISS_NUM,
135: p_line_inf_tab IN OKC_OC_INT_CONFIG_PVT.line_inf_tbl_type
136: DEFAULT OKC_OC_INT_PRICING_PVT.G_MISS_LINE_INF_TAB);
137:
138:

Line 144: PROCEDURE get_paav_tab(p_old_pat_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

140: -- to get PRICE ADJUSTMENT ATTRIBUTES information from ASO or ONT tables
141: -- get_paav_tab stores all the price adjustment attributes in global
142: -- PL/SQL table g_paav_tbl
143: -----------------------------------------------------------------------------
144: PROCEDURE get_paav_tab(p_old_pat_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
145: p_new_pat_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
146: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
147: p_qhr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
148: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 145: p_new_pat_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

141: -- get_paav_tab stores all the price adjustment attributes in global
142: -- PL/SQL table g_paav_tbl
143: -----------------------------------------------------------------------------
144: PROCEDURE get_paav_tab(p_old_pat_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
145: p_new_pat_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
146: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
147: p_qhr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
148: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
149: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM);

Line 146: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

142: -- PL/SQL table g_paav_tbl
143: -----------------------------------------------------------------------------
144: PROCEDURE get_paav_tab(p_old_pat_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
145: p_new_pat_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
146: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
147: p_qhr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
148: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
149: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM);
150: -- x_paav_tbl OUT NOCOPY paav_tbl_type)

Line 147: p_qhr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

143: -----------------------------------------------------------------------------
144: PROCEDURE get_paav_tab(p_old_pat_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
145: p_new_pat_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
146: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
147: p_qhr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
148: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
149: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM);
150: -- x_paav_tbl OUT NOCOPY paav_tbl_type)
151:

Line 148: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

144: PROCEDURE get_paav_tab(p_old_pat_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
145: p_new_pat_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
146: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
147: p_qhr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
148: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
149: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM);
150: -- x_paav_tbl OUT NOCOPY paav_tbl_type)
151:
152:

Line 149: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM);

145: p_new_pat_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
146: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
147: p_qhr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
148: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
149: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM);
150: -- x_paav_tbl OUT NOCOPY paav_tbl_type)
151:
152:
153: ----------------------------------------------------------------------

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

157: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
158: -- ASO_QUOTE_LINES_ALL.LINE_HEADER_ID to OKX_QUOTE_LINES_V.ID1
159: PROCEDURE get_pavv_tab(
160: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
161: p_cle_id IN OKC_K_LINES_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM,
162:
163: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE, --order flag
164: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
165: p_ole_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

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

159: PROCEDURE get_pavv_tab(
160: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
161: p_cle_id IN OKC_K_LINES_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM,
162:
163: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE, --order flag
164: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
165: p_ole_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
166:
167: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE, --quote flag

Line 164: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

160: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
161: p_cle_id IN OKC_K_LINES_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM,
162:
163: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE, --order flag
164: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
165: p_ole_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
166:
167: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE, --quote flag
168: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE

Line 165: p_ole_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

161: p_cle_id IN OKC_K_LINES_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM,
162:
163: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE, --order flag
164: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
165: p_ole_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
166:
167: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE, --quote flag
168: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
169: DEFAULT OKC_API.G_MISS_NUM,

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

163: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE, --order flag
164: p_ohr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
165: p_ole_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
166:
167: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE, --quote flag
168: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
169: DEFAULT OKC_API.G_MISS_NUM,
170: p_qle_id IN OKX_QUOTE_LINES_V.ID1%TYPE
171: DEFAULT OKC_API.G_MISS_NUM);

Line 169: DEFAULT OKC_API.G_MISS_NUM,

165: p_ole_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
166:
167: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE, --quote flag
168: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
169: DEFAULT OKC_API.G_MISS_NUM,
170: p_qle_id IN OKX_QUOTE_LINES_V.ID1%TYPE
171: DEFAULT OKC_API.G_MISS_NUM);
172:
173:

Line 171: DEFAULT OKC_API.G_MISS_NUM);

167: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE, --quote flag
168: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
169: DEFAULT OKC_API.G_MISS_NUM,
170: p_qle_id IN OKX_QUOTE_LINES_V.ID1%TYPE
171: DEFAULT OKC_API.G_MISS_NUM);
172:
173:
174:
175: -- =========================================================================

Line 238: p_q_flag IN VARCHAR2 DEFAULT OKC_API.g_miss_char,

234: PROCEDURE build_pricing_from_k(
235: p_chr_id IN OKC_K_HEADERS_B.id%TYPE,
236: 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,
237: --
238: p_q_flag IN VARCHAR2 DEFAULT OKC_API.g_miss_char,
239: p_qhr_id IN OKX_QUOTE_HEADERS_V.id1%TYPE DEFAULT OKC_API.g_miss_num,
240: p_qle_tab IN ASO_QUOTE_PUB.qte_line_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_qte_line_tbl,
241: p_qle_shipment_tab IN ASO_QUOTE_PUB.shipment_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_shipment_tbl,
242: --

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

235: p_chr_id IN OKC_K_HEADERS_B.id%TYPE,
236: 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,
237: --
238: p_q_flag IN VARCHAR2 DEFAULT OKC_API.g_miss_char,
239: p_qhr_id IN OKX_QUOTE_HEADERS_V.id1%TYPE DEFAULT OKC_API.g_miss_num,
240: p_qle_tab IN ASO_QUOTE_PUB.qte_line_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_qte_line_tbl,
241: p_qle_shipment_tab IN ASO_QUOTE_PUB.shipment_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_shipment_tbl,
242: --
243: p_o_flag IN VARCHAR2 DEFAULT OKC_API.g_miss_char,

Line 243: p_o_flag IN VARCHAR2 DEFAULT OKC_API.g_miss_char,

239: p_qhr_id IN OKX_QUOTE_HEADERS_V.id1%TYPE DEFAULT OKC_API.g_miss_num,
240: p_qle_tab IN ASO_QUOTE_PUB.qte_line_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_qte_line_tbl,
241: p_qle_shipment_tab IN ASO_QUOTE_PUB.shipment_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_shipment_tbl,
242: --
243: p_o_flag IN VARCHAR2 DEFAULT OKC_API.g_miss_char,
244: p_ohr_id IN OKX_ORDER_HEADERS_V.id1%TYPE DEFAULT OKC_API.g_miss_num,
245: p_ole_tab IN ASO_QUOTE_PUB.qte_line_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_qte_line_tbl,
246: p_ole_shipment_tab IN ASO_QUOTE_PUB.shipment_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_shipment_tbl,
247: --

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

240: p_qle_tab IN ASO_QUOTE_PUB.qte_line_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_qte_line_tbl,
241: p_qle_shipment_tab IN ASO_QUOTE_PUB.shipment_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_shipment_tbl,
242: --
243: p_o_flag IN VARCHAR2 DEFAULT OKC_API.g_miss_char,
244: p_ohr_id IN OKX_ORDER_HEADERS_V.id1%TYPE DEFAULT OKC_API.g_miss_num,
245: p_ole_tab IN ASO_QUOTE_PUB.qte_line_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_qte_line_tbl,
246: p_ole_shipment_tab IN ASO_QUOTE_PUB.shipment_tbl_type DEFAULT ASO_QUOTE_PUB.g_miss_shipment_tbl,
247: --
248: x_hd_price_adj_tab OUT NOCOPY ASO_QUOTE_PUB.price_adj_tbl_type,