APPS.OKC_PRICE_PUB dependencies on OKC_CONTRACT_PUB

Line 452: Procedure Get_Price_List(p_clev_tbl OKC_CONTRACT_PUB.clev_tbl_type,

448: End If;
449: Return (l_return_status);
450: End Product_Installed;
451: --
452: Procedure Get_Price_List(p_clev_tbl OKC_CONTRACT_PUB.clev_tbl_type,
453: x_price_list OUT NOCOPY Varchar2,
454: x_return_status OUT NOCOPY Varchar2) Is
455: l_row_notfound Boolean := True;
456: l_price_list Varchar2(30);

Line 570: Procedure Get_Inventory_Item(p_clev_tbl OKC_CONTRACT_PUB.clev_tbl_type,

566: SQLCODE, G_SQLERRM_TOKEN, SQLERRM);
567: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
568: End Get_Price_List;
569: --
570: Procedure Get_Inventory_Item(p_clev_tbl OKC_CONTRACT_PUB.clev_tbl_type,
571: p_cimv_tbl OKC_CONTRACT_ITEM_PUB.cimv_tbl_type,
572: x_inventory_item_id OUT NOCOPY Number,
573: x_uom_code OUT NOCOPY Varchar2,
574: x_qty OUT NOCOPY Number,

Line 630: Procedure Get_Currency_Code(p_clev_tbl OKC_CONTRACT_PUB.clev_tbl_type,

626: SQLCODE, G_SQLERRM_TOKEN, SQLERRM);
627: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
628: END Get_Inventory_Item;
629: --
630: Procedure Get_Currency_Code(p_clev_tbl OKC_CONTRACT_PUB.clev_tbl_type,
631: x_cur_code OUT NOCOPY Varchar2,
632: x_return_status OUT NOCOPY Varchar2) Is
633: cursor c1(p_chr_id Number) is
634: select currency_code

Line 1744: Procedure Calculate_Price(p_clev_tbl OKC_CONTRACT_PUB.clev_tbl_type,

1740: --
1741:
1742: /*** For OKC we need to call this API..... ***/
1743:
1744: Procedure Calculate_Price(p_clev_tbl OKC_CONTRACT_PUB.clev_tbl_type,
1745: p_cimv_tbl OKC_CONTRACT_ITEM_PUB.cimv_tbl_type,
1746: px_message OUT NOCOPY VARCHAR2,
1747: px_contract_cp_tbl IN OUT NOCOPY OKC_PRICE_PUB.G_SLINE_TBL_TYPE,
1748: x_return_status OUT NOCOPY VARCHAR2,

Line 1845: Procedure Calculate_Price(p_clev_tbl OKC_CONTRACT_PUB.clev_tbl_type,

1841: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR, G_SQLCODE_TOKEN,
1842: SQLCODE, G_SQLERRM_TOKEN, SQLERRM);
1843: End Calculate_Price;
1844: --
1845: Procedure Calculate_Price(p_clev_tbl OKC_CONTRACT_PUB.clev_tbl_type,
1846: p_cimv_tbl OKC_CONTRACT_ITEM_PUB.cimv_tbl_type,
1847: px_unit_price OUT NOCOPY Number,
1848: px_extended_amount OUT NOCOPY Number,
1849: px_message OUT NOCOPY Varchar2,