[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;
9894: *
9895: ************************************************************************/
9896: FUNCTION Populate_Tolerances( p_itemtype IN VARCHAR2,
9897: p_itemkey IN VARCHAR2,
9898: p_organization_id IN NUMBER ) RETURN po_co_tolerances_grp.tolerances_tbl_type
9899: IS
9900: l_tolerances_tbl po_co_tolerances_grp.tolerances_tbl_type;
9901: l_return_status VARCHAR2(1);
9902: l_msg_count NUMBER;
9896: FUNCTION Populate_Tolerances( p_itemtype IN VARCHAR2,
9897: p_itemkey IN VARCHAR2,
9898: p_organization_id IN NUMBER ) RETURN po_co_tolerances_grp.tolerances_tbl_type
9899: IS
9900: l_tolerances_tbl po_co_tolerances_grp.tolerances_tbl_type;
9901: l_return_status VARCHAR2(1);
9902: l_msg_count NUMBER;
9903: l_msg_data VARCHAR2(100);
9904: BEGIN
9902: l_msg_count NUMBER;
9903: l_msg_data VARCHAR2(100);
9904: BEGIN
9905:
9906: PO_CO_Tolerances_Grp.get_tolerances(
9907: p_api_version => 1.0,
9908: p_init_msg_list => FND_API.G_TRUE,
9909: p_organization_id => p_organization_id,
9910: p_change_order_type => po_co_tolerances_grp.g_rco_buy_app,
9906: PO_CO_Tolerances_Grp.get_tolerances(
9907: p_api_version => 1.0,
9908: p_init_msg_list => FND_API.G_TRUE,
9909: p_organization_id => p_organization_id,
9910: p_change_order_type => po_co_tolerances_grp.g_rco_buy_app,
9911: x_tolerances_tbl => l_tolerances_tbl,
9912: x_return_status => l_return_status,
9913: x_msg_count => l_msg_count,
9914: x_msg_data => l_msg_data);
9914: x_msg_data => l_msg_data);
9915:
9916: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9917: IF (g_po_wf_debug = 'Y') THEN
9918: PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,'PO_CO_Tolerances_Grp.get_tolerances API failed:' || l_return_status || ' ' || l_msg_data);
9919: END IF;
9920: END IF;
9921:
9922: RETURN l_tolerances_tbl;
10380: ************************************************************************/
10381: FUNCTION Shipmnt_Level_Changes_Wthn_Tol(
10382: p_item_type IN varchar2,
10383: p_item_key IN varchar2,
10384: p_tolerances_tab IN po_co_tolerances_grp.tolerances_tbl_type,
10385: p_pochggrp_id IN NUMBER) RETURN VARCHAR2
10386: IS
10387: l_return_val VARCHAR2(1) := 'Y';
10388: l_api_name varchar2(30) := 'Shipmnt_Level_Changes_Wthn_Tol';
10457: ************************************************************************/
10458: FUNCTION Line_Level_Changes_Wthn_Tol (
10459: p_item_type varchar2,
10460: p_item_key varchar2,
10461: p_tolerances_tab IN po_co_tolerances_grp.tolerances_tbl_type,
10462: p_pochggrp_id IN NUMBER ) RETURN varchar2
10463: IS
10464: l_return_val varchar2(1) := 'Y';
10465: l_api_name varchar2(30) := 'Line_Level_Changes_Wthn_Tol';
10640: ************************************************************************/
10641: FUNCTION Doc_Level_Changes_Wthn_Tol(
10642: p_item_type varchar2,
10643: p_item_key varchar2,
10644: p_tolerances_tab IN po_co_tolerances_grp.tolerances_tbl_type,
10645: p_pochggrp_id IN NUMBER,
10646: p_poheader_id IN NUMBER) RETURN VARCHAR2
10647: IS
10648: l_return_val varchar2(1) := 'Y';
10771: resultout OUT NOCOPY VARCHAR2 ) IS
10772: l_return_val VARCHAR2(1) := 'Y';
10773: l_pochggrp_id NUMBER;
10774: l_poheader_id NUMBER;
10775: l_tolerances_tab po_co_tolerances_grp.tolerances_tbl_type;
10776: l_api_name varchar2(30) := 'Changes_Wthn_Buyer_Tol_Values';
10777: l_progress VARCHAR2(100) := '000';
10778:
10779: l_po_currency_code PO_HEADERS_ALL.currency_code%type;