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 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:
19: ---------------------------------------------------------------------------
20: --Procedure to contract pricing 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_pricing (
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

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
34: -- this PL/SQL table has quote (or order) lines against contract lines

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

41: ----------------------------------------------------------------------------
42: -- Procedure creates price attribute information in OKC from
43: -- ASO or ONT pricing
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

Line 49: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE

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,
53: p_line_inf_tab IN OKC_OC_INT_CONFIG_PVT.line_inf_tbl_type

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

58:
59: --------------------------------------------------------------------------
60: --------get price adjustments from ASO or ONT and put in OKC pricing tables
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

Line 66: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE

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,
70: p_line_inf_tab IN OKC_OC_INT_CONFIG_PVT.line_inf_tbl_type

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

73:
74:
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,

Line 82: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE

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

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

88:
89:
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,

Line 97: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE

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

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

101: ----------------------------------------------------------------------------
102: -- PROCEDURE to get PRICE ADJUSTMENTS information from ASO or ONT tables
103: -- get_patv_tab stores it's output in global PL/SQL table g_patv_tbl
104: ----------------------------------------------------------------------------
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,

Line 114: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE

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

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

121: -- PROCEDURE to get PRICE ADJUSTMENT RELATIONSHIP information
122: -- from ASO or ONT tables
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,

Line 133: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE

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

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

153: ----------------------------------------------------------------------
154: -- PROCEDURE to get PRICE ATTRIBUTES information from ASO or ONT tables
155: -- get_pavv_tab stores it's output in global PL/SQL table g_pavv_tbl
156: ----------------------------------------------------------------------
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,

Line 168: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE

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

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,