[Home] [Help]
12: --g_currency_format_mask declared to pass in as the second parameter
13: --in FND_CURRENCY.GET_FORMAT_MASK
14: g_currency_format_mask NUMBER := 60;
15:
16: g_tolerances_tbl po_co_tolerances_grp.tolerances_tbl_type;
17:
18: -- Logging Static Variables
19: G_CURRENT_RUNTIME_LEVEL NUMBER;
20: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
10281: *
10282: ************************************************************************/
10283: FUNCTION Populate_Tolerances( p_itemtype IN VARCHAR2,
10284: p_itemkey IN VARCHAR2,
10285: p_organization_id IN NUMBER ) RETURN po_co_tolerances_grp.tolerances_tbl_type
10286: IS
10287: l_tolerances_tbl po_co_tolerances_grp.tolerances_tbl_type;
10288: l_return_status VARCHAR2(1);
10289: l_msg_count NUMBER;
10283: FUNCTION Populate_Tolerances( p_itemtype IN VARCHAR2,
10284: p_itemkey IN VARCHAR2,
10285: p_organization_id IN NUMBER ) RETURN po_co_tolerances_grp.tolerances_tbl_type
10286: IS
10287: l_tolerances_tbl po_co_tolerances_grp.tolerances_tbl_type;
10288: l_return_status VARCHAR2(1);
10289: l_msg_count NUMBER;
10290: l_msg_data VARCHAR2(100);
10291: BEGIN
10289: l_msg_count NUMBER;
10290: l_msg_data VARCHAR2(100);
10291: BEGIN
10292:
10293: PO_CO_Tolerances_Grp.get_tolerances(
10294: p_api_version => 1.0,
10295: p_init_msg_list => FND_API.G_TRUE,
10296: p_organization_id => p_organization_id,
10297: p_change_order_type => po_co_tolerances_grp.g_rco_buy_app,
10293: PO_CO_Tolerances_Grp.get_tolerances(
10294: p_api_version => 1.0,
10295: p_init_msg_list => FND_API.G_TRUE,
10296: p_organization_id => p_organization_id,
10297: p_change_order_type => po_co_tolerances_grp.g_rco_buy_app,
10298: x_tolerances_tbl => l_tolerances_tbl,
10299: x_return_status => l_return_status,
10300: x_msg_count => l_msg_count,
10301: x_msg_data => l_msg_data);
10301: x_msg_data => l_msg_data);
10302:
10303: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
10304: IF (g_po_wf_debug = 'Y') THEN
10305: PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,'PO_CO_Tolerances_Grp.get_tolerances API failed:' || l_return_status || ' ' || l_msg_data);
10306: END IF;
10307: END IF;
10308:
10309: RETURN l_tolerances_tbl;
10770: ************************************************************************/
10771: FUNCTION Shipmnt_Level_Changes_Wthn_Tol(
10772: p_item_type IN varchar2,
10773: p_item_key IN varchar2,
10774: p_tolerances_tab IN po_co_tolerances_grp.tolerances_tbl_type,
10775: p_pochggrp_id IN NUMBER) RETURN VARCHAR2
10776: IS
10777: l_return_val VARCHAR2(1) := 'Y';
10778: l_api_name varchar2(30) := 'Shipmnt_Level_Changes_Wthn_Tol';
10847: ************************************************************************/
10848: FUNCTION Line_Level_Changes_Wthn_Tol (
10849: p_item_type varchar2,
10850: p_item_key varchar2,
10851: p_tolerances_tab IN po_co_tolerances_grp.tolerances_tbl_type,
10852: p_pochggrp_id IN NUMBER ) RETURN varchar2
10853: IS
10854: l_return_val varchar2(1) := 'Y';
10855: l_api_name varchar2(30) := 'Line_Level_Changes_Wthn_Tol';
11030: ************************************************************************/
11031: FUNCTION Doc_Level_Changes_Wthn_Tol(
11032: p_item_type varchar2,
11033: p_item_key varchar2,
11034: p_tolerances_tab IN po_co_tolerances_grp.tolerances_tbl_type,
11035: p_pochggrp_id IN NUMBER,
11036: p_poheader_id IN NUMBER) RETURN VARCHAR2
11037: IS
11038: l_return_val varchar2(1) := 'Y';
11161: resultout OUT NOCOPY VARCHAR2 ) IS
11162: l_return_val VARCHAR2(1) := 'Y';
11163: l_pochggrp_id NUMBER;
11164: l_poheader_id NUMBER;
11165: l_tolerances_tab po_co_tolerances_grp.tolerances_tbl_type;
11166: l_api_name varchar2(30) := 'Changes_Wthn_Buyer_Tol_Values';
11167: l_progress VARCHAR2(100) := '000';
11168:
11169: l_po_currency_code PO_HEADERS_ALL.currency_code%type;