APPS.OKC_OC_INT_PRICING_PVT dependencies on OKC_OC_INT_CONFIG_PVT

Line 266: p_line_inf_tab IN OKC_OC_INT_CONFIG_PVT.line_inf_tbl_type

262: p_ohr_id IN NUMBER ,
263: p_q_flag IN VARCHAR2 ,
264: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
265: ,
266: p_line_inf_tab IN OKC_OC_INT_CONFIG_PVT.line_inf_tbl_type
267: -- this PL/SQL table has quote (or order) lines against contract lines
268:
269:
270: ) IS

Line 818: p_line_inf_tab IN OKC_OC_INT_CONFIG_PVT.line_inf_tbl_type

814: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
815: ,
816: p_o_flag IN VARCHAR2 ,
817: p_ohr_id IN NUMBER,
818: p_line_inf_tab IN OKC_OC_INT_CONFIG_PVT.line_inf_tbl_type
819: ) IS
820:
821: i BINARY_INTEGER := 0;
822:

Line 879: NVL(p_line_inf_tab(i).line_type,OKC_API.G_MISS_CHAR) <> OKC_OC_INT_CONFIG_PVT.G_MODEL_LINE THEN

875:
876: i := p_line_inf_tab.FIRST;
877: WHILE i IS NOT NULL LOOP
878: IF p_q_flag = OKC_API.G_TRUE AND p_qhr_id IS NOT NULL AND p_qhr_id <> OKC_API.G_MISS_NUM AND
879: NVL(p_line_inf_tab(i).line_type,OKC_API.G_MISS_CHAR) <> OKC_OC_INT_CONFIG_PVT.G_MODEL_LINE THEN
880:
881: -- get PRICE ATTRIBUTES information from ASO tables
882: -- get_pavv_tab stores it's output in g_pavv_tab
883: get_pavv_tab(p_chr_id => p_chr_id,

Line 890: NVL(p_line_inf_tab(i).line_type,OKC_API.G_MISS_CHAR) <> OKC_OC_INT_CONFIG_PVT.G_MODEL_LINE THEN

886: p_cle_id => p_line_inf_tab(i).cle_id,
887: p_qle_id => p_line_inf_tab(i).object1_id1
888: );
889: ELSIF p_o_flag = OKC_API.G_TRUE AND p_ohr_id IS NOT NULL AND p_ohr_id <> OKC_API.G_MISS_NUM AND
890: NVL(p_line_inf_tab(i).line_type,OKC_API.G_MISS_CHAR) <> OKC_OC_INT_CONFIG_PVT.G_MODEL_LINE THEN
891: -- get PRICE ATTRIBUTES information from ONT tables
892: -- get_pavv_tab stores it's output in g_pavv_tab
893: get_pavv_tab(p_chr_id => p_chr_id,
894: p_o_flag => p_o_flag,

Line 938: p_line_inf_tab IN OKC_OC_INT_CONFIG_PVT.line_inf_tbl_type

934: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
935: ,
936: p_o_flag IN VARCHAR2 ,
937: p_ohr_id IN NUMBER ,
938: p_line_inf_tab IN OKC_OC_INT_CONFIG_PVT.line_inf_tbl_type
939: ) IS
940:
941: i BINARY_INTEGER := 0;
942:

Line 998: NVL(p_line_inf_tab(i).line_type, OKC_API.G_MISS_CHAR) <> OKC_OC_INT_CONFIG_PVT.G_MODEL_LINE THEN

994:
995: i := p_line_inf_tab.FIRST;
996: WHILE i IS NOT NULL LOOP
997: IF p_q_flag = OKC_API.G_TRUE AND p_qhr_id IS NOT NULL AND p_qhr_id <> OKC_API.G_MISS_NUM AND
998: NVL(p_line_inf_tab(i).line_type, OKC_API.G_MISS_CHAR) <> OKC_OC_INT_CONFIG_PVT.G_MODEL_LINE THEN
999: -- get PRICE ADJUSTMENTS information from ASO tables
1000: --get_patv_tab stores it's output in g_patv_tab
1001: get_patv_tab(p_chr_id => p_chr_id,
1002: p_q_flag => p_q_flag,

Line 1008: NVL(p_line_inf_tab(i).line_type, OKC_API.G_MISS_CHAR) <> OKC_OC_INT_CONFIG_PVT.G_MODEL_LINE THEN

1004: p_cle_id => p_line_inf_tab(i).cle_id,
1005: p_qle_id => p_line_inf_tab(i).object1_id1
1006: );
1007: ELSIF p_o_flag = OKC_API.G_TRUE AND p_ohr_id IS NOT NULL AND p_ohr_id <> OKC_API.G_MISS_NUM AND
1008: NVL(p_line_inf_tab(i).line_type, OKC_API.G_MISS_CHAR) <> OKC_OC_INT_CONFIG_PVT.G_MODEL_LINE THEN
1009: --get PRICE ADJUSTMENTS information from ONT tables
1010: --get_patv_tab stores it's output in g_patv_tab
1011: get_patv_tab(p_chr_id => p_chr_id,
1012: p_o_flag => p_o_flag,

Line 1055: p_line_inf_tab IN OKC_OC_INT_CONFIG_PVT.line_inf_tbl_type

1051: p_ohr_id IN NUMBER ,
1052: p_q_flag IN VARCHAR2 ,
1053: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
1054: ,
1055: p_line_inf_tab IN OKC_OC_INT_CONFIG_PVT.line_inf_tbl_type
1056: ) IS
1057:
1058:
1059: l_pacv_tbl OKC_PRICE_ADJUSTMENT_PUB.pacv_tbl_type;

Line 1513: p_line_inf_tab IN OKC_OC_INT_CONFIG_PVT.line_inf_tbl_type

1509: ,
1510: p_q_flag IN VARCHAR2 ,
1511: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
1512: ,
1513: p_line_inf_tab IN OKC_OC_INT_CONFIG_PVT.line_inf_tbl_type
1514: )
1515: IS
1516:
1517: l_no_data_found BOOLEAN := TRUE;

Line 4248: p_kl_rel_tab IN okc_oc_int_config_pvt.line_rel_tab_type,

4244: PROCEDURE get_price_adj_rltship ( p_price_adj_tab IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
4245: p_k_price_adj_tab IN k_price_adj_tab_type,
4246: --
4247: p_line_tab IN ASO_QUOTE_PUB.qte_line_tbl_type,
4248: p_kl_rel_tab IN okc_oc_int_config_pvt.line_rel_tab_type,
4249: p_line_shipment_tab IN ASO_QUOTE_PUB.shipment_tbl_type,
4250: --
4251: p_q_flag IN VARCHAR2,
4252: p_o_flag IN VARCHAR2,

Line 4835: p_kl_rel_tab IN okc_oc_int_config_pvt.line_rel_tab_type ,

4831:
4832:
4833: PROCEDURE build_pricing_from_k(
4834: p_chr_id IN OKC_K_HEADERS_B.id%TYPE,
4835: p_kl_rel_tab IN okc_oc_int_config_pvt.line_rel_tab_type ,
4836: --
4837: p_q_flag IN VARCHAR2 ,
4838: p_qhr_id IN OKX_QUOTE_HEADERS_V.id1%TYPE ,
4839: p_qle_tab IN ASO_QUOTE_PUB.qte_line_tbl_type ,