eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_EDA_DATATEMPLATE_PKG dependencies on PO_EDA_DATATEMPLATE_PKG

Line 1: PACKAGE BODY po_eda_datatemplate_pkg AS

1: PACKAGE BODY po_eda_datatemplate_pkg AS
2: /* $Header: POEDADTB.pls 120.19.12020000.3 2013/02/11 00:56:27 vegajula ship $ */
3:
4: FUNCTION DocFilter(p_draft_id NUMBER) RETURN BOOLEAN AS
5: BEGIN

Line 1053: PO_EDA_DATATEMPLATE_PKG.get_charge_acc_comp_val(flv.APPLICATION_COLUMN_NAME,pda.CODE_COMBINATION_ID) ComponentValue

1049:
1050: CURSOR c_obligatedAmountcomponents(p_dist_id number,p_draft_id NUMBER) IS
1051: SELECT NVL((select eda from po_eda_mapping where GROUPING = 'LOA' and attribute = 'ComponentTitle' and
1052: ebs = flv.SEGMENT_NAME),flv.SEGMENT_NAME) ComponentTitle,
1053: PO_EDA_DATATEMPLATE_PKG.get_charge_acc_comp_val(flv.APPLICATION_COLUMN_NAME,pda.CODE_COMBINATION_ID) ComponentValue
1054: FROM fnd_id_flex_segments_vl flv, gl_code_combinations glc, po_distributions_merge_v pda
1055: WHERE po_distribution_id = p_dist_id and draft_id = p_draft_id
1056: AND glc.CODE_COMBINATION_ID = pda.CODE_COMBINATION_ID
1057: AND flv.ID_FLEX_CODE = 'GL#' AND flv.ID_FLEX_NUM = glc.CHART_OF_ACCOUNTS_ID ;

Line 1236: l_prev1 := po_eda_datatemplate_pkg.get_AwardFee('N');

1232: RETURN l_clob;
1233:
1234: ELSIF p_element = 'PRICINGARRANGEMENT' THEN -- ORDERINGINFORMATION_LIMITS
1235:
1236: l_prev1 := po_eda_datatemplate_pkg.get_AwardFee('N');
1237: l_prev2 := po_eda_datatemplate_pkg.get_PerformanceIncentive('N');
1238: select PO_EDA_DATATEMPLATE_PKG.get_PricingArrangementBase(contract_type) PricingArrangementBase
1239: INTO l_prev3
1240: from (

Line 1237: l_prev2 := po_eda_datatemplate_pkg.get_PerformanceIncentive('N');

1233:
1234: ELSIF p_element = 'PRICINGARRANGEMENT' THEN -- ORDERINGINFORMATION_LIMITS
1235:
1236: l_prev1 := po_eda_datatemplate_pkg.get_AwardFee('N');
1237: l_prev2 := po_eda_datatemplate_pkg.get_PerformanceIncentive('N');
1238: select PO_EDA_DATATEMPLATE_PKG.get_PricingArrangementBase(contract_type) PricingArrangementBase
1239: INTO l_prev3
1240: from (
1241: SELECT CASE

Line 1238: select PO_EDA_DATATEMPLATE_PKG.get_PricingArrangementBase(contract_type) PricingArrangementBase

1234: ELSIF p_element = 'PRICINGARRANGEMENT' THEN -- ORDERINGINFORMATION_LIMITS
1235:
1236: l_prev1 := po_eda_datatemplate_pkg.get_AwardFee('N');
1237: l_prev2 := po_eda_datatemplate_pkg.get_PerformanceIncentive('N');
1238: select PO_EDA_DATATEMPLATE_PKG.get_PricingArrangementBase(contract_type) PricingArrangementBase
1239: INTO l_prev3
1240: from (
1241: SELECT CASE
1242: WHEN cnt = 1 THEN

Line 1253: l_mod1 := po_eda_datatemplate_pkg.get_AwardFee('Y');

1249: SELECT Count(distinct contract_type) AS cnt FROM po_lines_merge_v
1250: WHERE po_header_id = DOCUMENTID AND draft_id = -1 AND change_status is NULL AND contract_type is not null )
1251: );
1252:
1253: l_mod1 := po_eda_datatemplate_pkg.get_AwardFee('Y');
1254: l_mod2 := po_eda_datatemplate_pkg.get_PerformanceIncentive('Y');
1255: select PO_EDA_DATATEMPLATE_PKG.get_PricingArrangementBase(contract_type) PricingArrangementBase
1256: INTO l_mod3
1257: from (

Line 1254: l_mod2 := po_eda_datatemplate_pkg.get_PerformanceIncentive('Y');

1250: WHERE po_header_id = DOCUMENTID AND draft_id = -1 AND change_status is NULL AND contract_type is not null )
1251: );
1252:
1253: l_mod1 := po_eda_datatemplate_pkg.get_AwardFee('Y');
1254: l_mod2 := po_eda_datatemplate_pkg.get_PerformanceIncentive('Y');
1255: select PO_EDA_DATATEMPLATE_PKG.get_PricingArrangementBase(contract_type) PricingArrangementBase
1256: INTO l_mod3
1257: from (
1258: SELECT CASE

Line 1255: select PO_EDA_DATATEMPLATE_PKG.get_PricingArrangementBase(contract_type) PricingArrangementBase

1251: );
1252:
1253: l_mod1 := po_eda_datatemplate_pkg.get_AwardFee('Y');
1254: l_mod2 := po_eda_datatemplate_pkg.get_PerformanceIncentive('Y');
1255: select PO_EDA_DATATEMPLATE_PKG.get_PricingArrangementBase(contract_type) PricingArrangementBase
1256: INTO l_mod3
1257: from (
1258: SELECT CASE
1259: WHEN cnt = 1 THEN

Line 1304: l_prev1 := PO_EDA_DATATEMPLATE_PKG.getGovtSharePerc('N');

1300: RETURN l_clob;
1301:
1302: ELSIF p_element = 'SHARERATIO' THEN
1303:
1304: l_prev1 := PO_EDA_DATATEMPLATE_PKG.getGovtSharePerc('N');
1305: l_prev2 := PO_EDA_DATATEMPLATE_PKG.getMonetaryAmount('N');
1306: l_prev3 := PO_EDA_DATATEMPLATE_PKG.getCtMonetaryAmount('N');
1307: l_mod1 := PO_EDA_DATATEMPLATE_PKG.getGovtSharePerc('Y');
1308: l_mod2 := PO_EDA_DATATEMPLATE_PKG.getMonetaryAmount('Y');

Line 1305: l_prev2 := PO_EDA_DATATEMPLATE_PKG.getMonetaryAmount('N');

1301:
1302: ELSIF p_element = 'SHARERATIO' THEN
1303:
1304: l_prev1 := PO_EDA_DATATEMPLATE_PKG.getGovtSharePerc('N');
1305: l_prev2 := PO_EDA_DATATEMPLATE_PKG.getMonetaryAmount('N');
1306: l_prev3 := PO_EDA_DATATEMPLATE_PKG.getCtMonetaryAmount('N');
1307: l_mod1 := PO_EDA_DATATEMPLATE_PKG.getGovtSharePerc('Y');
1308: l_mod2 := PO_EDA_DATATEMPLATE_PKG.getMonetaryAmount('Y');
1309: l_mod3 := PO_EDA_DATATEMPLATE_PKG.getCtMonetaryAmount('Y');

Line 1306: l_prev3 := PO_EDA_DATATEMPLATE_PKG.getCtMonetaryAmount('N');

1302: ELSIF p_element = 'SHARERATIO' THEN
1303:
1304: l_prev1 := PO_EDA_DATATEMPLATE_PKG.getGovtSharePerc('N');
1305: l_prev2 := PO_EDA_DATATEMPLATE_PKG.getMonetaryAmount('N');
1306: l_prev3 := PO_EDA_DATATEMPLATE_PKG.getCtMonetaryAmount('N');
1307: l_mod1 := PO_EDA_DATATEMPLATE_PKG.getGovtSharePerc('Y');
1308: l_mod2 := PO_EDA_DATATEMPLATE_PKG.getMonetaryAmount('Y');
1309: l_mod3 := PO_EDA_DATATEMPLATE_PKG.getCtMonetaryAmount('Y');
1310:

Line 1307: l_mod1 := PO_EDA_DATATEMPLATE_PKG.getGovtSharePerc('Y');

1303:
1304: l_prev1 := PO_EDA_DATATEMPLATE_PKG.getGovtSharePerc('N');
1305: l_prev2 := PO_EDA_DATATEMPLATE_PKG.getMonetaryAmount('N');
1306: l_prev3 := PO_EDA_DATATEMPLATE_PKG.getCtMonetaryAmount('N');
1307: l_mod1 := PO_EDA_DATATEMPLATE_PKG.getGovtSharePerc('Y');
1308: l_mod2 := PO_EDA_DATATEMPLATE_PKG.getMonetaryAmount('Y');
1309: l_mod3 := PO_EDA_DATATEMPLATE_PKG.getCtMonetaryAmount('Y');
1310:
1311: IF l_prev1 IS NULL AND l_mod1 IS NOT NULL THEN l_chg1:= 'Added'; l_chgtxt1:= 'Value '||l_mod1||' added';

Line 1308: l_mod2 := PO_EDA_DATATEMPLATE_PKG.getMonetaryAmount('Y');

1304: l_prev1 := PO_EDA_DATATEMPLATE_PKG.getGovtSharePerc('N');
1305: l_prev2 := PO_EDA_DATATEMPLATE_PKG.getMonetaryAmount('N');
1306: l_prev3 := PO_EDA_DATATEMPLATE_PKG.getCtMonetaryAmount('N');
1307: l_mod1 := PO_EDA_DATATEMPLATE_PKG.getGovtSharePerc('Y');
1308: l_mod2 := PO_EDA_DATATEMPLATE_PKG.getMonetaryAmount('Y');
1309: l_mod3 := PO_EDA_DATATEMPLATE_PKG.getCtMonetaryAmount('Y');
1310:
1311: IF l_prev1 IS NULL AND l_mod1 IS NOT NULL THEN l_chg1:= 'Added'; l_chgtxt1:= 'Value '||l_mod1||' added';
1312: ELSIF l_prev1 IS NOT NULL AND l_mod1 IS NULL THEN l_chg1:= 'Deleted'; l_chgtxt1:= 'Value '||l_prev1||' deleted';

Line 1309: l_mod3 := PO_EDA_DATATEMPLATE_PKG.getCtMonetaryAmount('Y');

1305: l_prev2 := PO_EDA_DATATEMPLATE_PKG.getMonetaryAmount('N');
1306: l_prev3 := PO_EDA_DATATEMPLATE_PKG.getCtMonetaryAmount('N');
1307: l_mod1 := PO_EDA_DATATEMPLATE_PKG.getGovtSharePerc('Y');
1308: l_mod2 := PO_EDA_DATATEMPLATE_PKG.getMonetaryAmount('Y');
1309: l_mod3 := PO_EDA_DATATEMPLATE_PKG.getCtMonetaryAmount('Y');
1310:
1311: IF l_prev1 IS NULL AND l_mod1 IS NOT NULL THEN l_chg1:= 'Added'; l_chgtxt1:= 'Value '||l_mod1||' added';
1312: ELSIF l_prev1 IS NOT NULL AND l_mod1 IS NULL THEN l_chg1:= 'Deleted'; l_chgtxt1:= 'Value '||l_prev1||' deleted';
1313: ELSIF l_prev1 <> l_mod1 THEN l_chg1 := 'Modified' ; l_chgtxt1:= 'Value modified from '||l_prev1||' to '||l_mod1;

Line 3038: l_var_value := PO_EDA_DATATEMPLATE_PKG.GetVariableValue(p_kart_id,l_var_code,NULL,null);

3034: IF l_var_value IS NULL AND l_var_value_id IS NOT NULL THEN
3035: SELECT FLEX_VALUE INTO l_var_value FROM FND_FLEX_VALUES WHERE FLEX_VALUE_ID = l_var_value_id;
3036: END IF;
3037: ELSE
3038: l_var_value := PO_EDA_DATATEMPLATE_PKG.GetVariableValue(p_kart_id,l_var_code,NULL,null);
3039: END IF;
3040:
3041: l_var_value := Nvl(l_var_value,'______');
3042:

Line 3175: END PO_EDA_DATATEMPLATE_PKG;

3171: end loop;
3172: return l_flag;
3173: end containsNumber;
3174:
3175: END PO_EDA_DATATEMPLATE_PKG;