APPS.CTO_CONFIG_COST_PK dependencies on CTO_COST_ROLLUP_CONC_PK

Line 1062: FUNCTION Cost_Roll_Up_ML( p_cfg_itm_tbl in CTO_COST_ROLLUP_CONC_PK.t_cfg_item

1058:
1059: /* fp-J : This procedure has been added for optional processing for cost rollup (ksarkar)
1060: */
1061:
1062: FUNCTION Cost_Roll_Up_ML( p_cfg_itm_tbl in CTO_COST_ROLLUP_CONC_PK.t_cfg_item
1063: , x_msg_count out NOCOPY number
1064: , x_msg_data out NOCOPY varchar2
1065: )
1066: RETURN integer

Line 1229: CTO_COST_ROLLUP_CONC_PK.g_error_cache.delete;

1225: BEGIN
1226: lStmtNumber := 10;
1227:
1228: --Bugfix 12957444: Cleaning the global collection.
1229: CTO_COST_ROLLUP_CONC_PK.g_error_cache.delete;
1230:
1231: if p_cfg_itm_tbl.COUNT = 0 then
1232: oe_debug_pub.add ('Cost_Roll_Up_ML: '|| 'Array p_cfg_itm_tbl does not contain any rows to process.');
1233: return(1);

Line 1480: CTO_COST_ROLLUP_CONC_PK.g_error_cache(p_cfg_itm_tbl(i).cfg_item_id || '-' || p_cfg_itm_tbl(i).cfg_org_id) := i;

1476: oe_debug_pub.add('Cost_Roll_Up_ML:' || 'c_oper_unit is null for this config. Skipping this config..');
1477: END IF;
1478:
1479: lStmtNumber := 29.1;
1480: CTO_COST_ROLLUP_CONC_PK.g_error_cache(p_cfg_itm_tbl(i).cfg_item_id || '-' || p_cfg_itm_tbl(i).cfg_org_id) := i;
1481: goto endloop;
1482: end if;
1483:
1484: -- Added by Renga Kannan on 03/15/20067 to get the po validation org

Line 1886: if CTO_COST_ROLLUP_CONC_PK.g_error_cache.exists(p_cfg_itm_tbl(i).cfg_item_id || '-' || p_cfg_itm_tbl(i).cfg_org_id)

1882:
1883: LOOP
1884:
1885: --Bugfix 12957444: Skipping the configs that are in error cache.
1886: if CTO_COST_ROLLUP_CONC_PK.g_error_cache.exists(p_cfg_itm_tbl(i).cfg_item_id || '-' || p_cfg_itm_tbl(i).cfg_org_id)
1887: then
1888: IF PG_DEBUG <> 0 THEN
1889: oe_debug_pub.add('Config::' || p_cfg_itm_tbl(i).cfg_item_id || ' in org::' || p_cfg_itm_tbl(i).cfg_org_id ||
1890: 'is in error. Skipping it.');

Line 2003: oe_debug_pub.add('Cost_Roll_Up_ML:' || 'No. of configs in error::' || CTO_COST_ROLLUP_CONC_PK.g_error_cache.count);

1999:
2000: --Bugfix 12957444: Adding some debugging.
2001: IF PG_DEBUG <> 0 THEN
2002: oe_debug_pub.add('populate_buy_cost: ' || 'At end of cost rollup', 2);
2003: oe_debug_pub.add('Cost_Roll_Up_ML:' || 'No. of configs in error::' || CTO_COST_ROLLUP_CONC_PK.g_error_cache.count);
2004: oe_debug_pub.add('Cost_Roll_Up_ML:' || '===========Printing configs in error============');
2005: l_error_cache_val := CTO_COST_ROLLUP_CONC_PK.g_error_cache.first;
2006: while l_error_cache_val is not null loop
2007: oe_debug_pub.add('Config-Org::' || l_error_cache_val);

Line 2005: l_error_cache_val := CTO_COST_ROLLUP_CONC_PK.g_error_cache.first;

2001: IF PG_DEBUG <> 0 THEN
2002: oe_debug_pub.add('populate_buy_cost: ' || 'At end of cost rollup', 2);
2003: oe_debug_pub.add('Cost_Roll_Up_ML:' || 'No. of configs in error::' || CTO_COST_ROLLUP_CONC_PK.g_error_cache.count);
2004: oe_debug_pub.add('Cost_Roll_Up_ML:' || '===========Printing configs in error============');
2005: l_error_cache_val := CTO_COST_ROLLUP_CONC_PK.g_error_cache.first;
2006: while l_error_cache_val is not null loop
2007: oe_debug_pub.add('Config-Org::' || l_error_cache_val);
2008: l_error_cache_val := CTO_COST_ROLLUP_CONC_PK.g_error_cache.next(l_error_cache_val);
2009: end loop;

Line 2008: l_error_cache_val := CTO_COST_ROLLUP_CONC_PK.g_error_cache.next(l_error_cache_val);

2004: oe_debug_pub.add('Cost_Roll_Up_ML:' || '===========Printing configs in error============');
2005: l_error_cache_val := CTO_COST_ROLLUP_CONC_PK.g_error_cache.first;
2006: while l_error_cache_val is not null loop
2007: oe_debug_pub.add('Config-Org::' || l_error_cache_val);
2008: l_error_cache_val := CTO_COST_ROLLUP_CONC_PK.g_error_cache.next(l_error_cache_val);
2009: end loop;
2010: oe_debug_pub.add('Cost_Roll_Up_ML:' || '===========End printing configs in error============');
2011: END IF;
2012:

Line 2013: if CTO_COST_ROLLUP_CONC_PK.g_error_cache.count <> 0 then

2009: end loop;
2010: oe_debug_pub.add('Cost_Roll_Up_ML:' || '===========End printing configs in error============');
2011: END IF;
2012:
2013: if CTO_COST_ROLLUP_CONC_PK.g_error_cache.count <> 0 then
2014: l_ret_val := 0;
2015: else
2016: l_ret_val := 1;
2017: end if;