DBA Data[Home] [Help]

APPS.OKC_OC_INT_SALESCDT_PVT dependencies on ASO_QUOTE_PUB

Line 760: x_sales_credit_tab OUT NOCOPY ASO_QUOTE_PUB.sales_credit_tbl_type) IS

756: p_nqhr_id IN NUMBER,
757: p_nqle_idx IN NUMBER,
758: --
759: x_k_sales_credit_tab OUT NOCOPY k_sales_credit_tab_type,
760: x_sales_credit_tab OUT NOCOPY ASO_QUOTE_PUB.sales_credit_tbl_type) IS
761:
762: --
763: -- CURSOR to identify the sales credits which have to be deleted taking
764: -- into account those marked as to be updated or created: any quote sales

Line 877: l_sales_credit_rec ASO_QUOTE_PUB.sales_credit_rec_type;

873: g_miss_sls_crdt_rec c_k_sales_credit%ROWTYPE;
874: l_prec_sls_crdt_rec c_k_sales_credit%ROWTYPE := g_miss_sls_crdt_rec;
875: l_sales_credit_insert VARCHAR2(1) := OKC_API.G_TRUE;
876:
877: l_sales_credit_rec ASO_QUOTE_PUB.sales_credit_rec_type;
878: l_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;
879: l_k_sales_credit_tab k_sales_credit_tab_type;
880:
881: x BINARY_INTEGER;

Line 878: l_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;

874: l_prec_sls_crdt_rec c_k_sales_credit%ROWTYPE := g_miss_sls_crdt_rec;
875: l_sales_credit_insert VARCHAR2(1) := OKC_API.G_TRUE;
876:
877: l_sales_credit_rec ASO_QUOTE_PUB.sales_credit_rec_type;
878: l_sales_credit_tab ASO_QUOTE_PUB.sales_credit_tbl_type;
879: l_k_sales_credit_tab k_sales_credit_tab_type;
880:
881: x BINARY_INTEGER;
882: y BINARY_INTEGER;

Line 1315: p_qle_tab IN ASO_QUOTE_PUB.qte_line_tbl_type ,

1311: ,
1312: --
1313: p_q_flag IN VARCHAR2 ,
1314: p_qhr_id IN OKX_QUOTE_HEADERS_V.id1%TYPE ,
1315: p_qle_tab IN ASO_QUOTE_PUB.qte_line_tbl_type ,
1316: --
1317: p_o_flag IN VARCHAR2 ,
1318: p_ohr_id IN OKX_ORDER_HEADERS_V.id1%TYPE ,
1319: p_ole_tab IN ASO_QUOTE_PUB.qte_line_tbl_type ,

Line 1319: p_ole_tab IN ASO_QUOTE_PUB.qte_line_tbl_type ,

1315: p_qle_tab IN ASO_QUOTE_PUB.qte_line_tbl_type ,
1316: --
1317: p_o_flag IN VARCHAR2 ,
1318: p_ohr_id IN OKX_ORDER_HEADERS_V.id1%TYPE ,
1319: p_ole_tab IN ASO_QUOTE_PUB.qte_line_tbl_type ,
1320: --
1321: x_hd_sales_credit_tab OUT NOCOPY ASO_QUOTE_PUB.sales_credit_tbl_type,
1322: x_ln_sales_credit_tab OUT NOCOPY ASO_QUOTE_PUB.sales_credit_tbl_type,
1323: --

Line 1321: x_hd_sales_credit_tab OUT NOCOPY ASO_QUOTE_PUB.sales_credit_tbl_type,

1317: p_o_flag IN VARCHAR2 ,
1318: p_ohr_id IN OKX_ORDER_HEADERS_V.id1%TYPE ,
1319: p_ole_tab IN ASO_QUOTE_PUB.qte_line_tbl_type ,
1320: --
1321: x_hd_sales_credit_tab OUT NOCOPY ASO_QUOTE_PUB.sales_credit_tbl_type,
1322: x_ln_sales_credit_tab OUT NOCOPY ASO_QUOTE_PUB.sales_credit_tbl_type,
1323: --
1324: x_return_status OUT NOCOPY VARCHAR2 ) IS
1325:

Line 1322: x_ln_sales_credit_tab OUT NOCOPY ASO_QUOTE_PUB.sales_credit_tbl_type,

1318: p_ohr_id IN OKX_ORDER_HEADERS_V.id1%TYPE ,
1319: p_ole_tab IN ASO_QUOTE_PUB.qte_line_tbl_type ,
1320: --
1321: x_hd_sales_credit_tab OUT NOCOPY ASO_QUOTE_PUB.sales_credit_tbl_type,
1322: x_ln_sales_credit_tab OUT NOCOPY ASO_QUOTE_PUB.sales_credit_tbl_type,
1323: --
1324: x_return_status OUT NOCOPY VARCHAR2 ) IS
1325:
1326: k BINARY_INTEGER;

Line 1327: x_ln_temp_sls_crdt_tab ASO_QUOTE_PUB.sales_credit_tbl_type;

1323: --
1324: x_return_status OUT NOCOPY VARCHAR2 ) IS
1325:
1326: k BINARY_INTEGER;
1327: x_ln_temp_sls_crdt_tab ASO_QUOTE_PUB.sales_credit_tbl_type;
1328: l_cle_id okc_k_lines_b.id%TYPE;
1329:
1330: BEGIN
1331: