APPS.IEX_STRATEGY_PUB dependencies on IEX_APP_PREFERENCES_B

Line 137: from iex_app_preferences_b

133: if (p_Strategy_temp_id is null) or (p_Strategy_temp_id = 0) then
134: begin
135: select decode(preference_value, 'CUSTOMER', 10, 'ACCOUNT', 20, 'BILL_TO', 30, 'DELINQUENCY', 40, 40)
136: into l_DefaultStrategyLevel
137: from iex_app_preferences_b
138: where preference_name = 'COLLECTIONS STRATEGY LEVEL' and enabled_flag = 'Y' and org_id is null; -- Changed for bug 8708271 multi level strategy
139: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
140: IEX_DEBUG_PUB.LogMessage( 'Default StrategyLevel ' || l_DefaultStrategyLevel);
141: END IF;

Line 593: from iex_app_preferences_b

589: if l_ObjectType in ('LITIGATION', 'REPOSSESSION', 'BANKRUPTCY', 'WRITEOFF') then
590: BEGIN
591: select preference_value
592: into l_StrategyLevel
593: from iex_app_preferences_b
594: where preference_name = 'COLLECTIONS STRATEGY LEVEL' and enabled_flag = 'Y' and org_id is null; -- Changed for bug 8708271 multi level strategy
595: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
596: IEX_DEBUG_PUB.LogMessage( 'StrategyLevel ' || l_StrategyLevel);
597: END IF;

Line 1030: from iex_app_preferences_b

1026: --Start adding for bug 8834310 gnramasa 26th Aug 09
1027: begin
1028: select decode(preference_value, 'CUSTOMER', 10, 'ACCOUNT', 20, 'BILL_TO', 30, 'DELINQUENCY', 40, 40)
1029: into l_DefaultStrategyLevel
1030: from iex_app_preferences_b
1031: where preference_name = 'COLLECTIONS STRATEGY LEVEL' and enabled_flag = 'Y' and org_id is null; -- Changed for bug 8708271 multi level strategy
1032: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1033: IEX_DEBUG_PUB.LogMessage( 'Default StrategyLevel ' || l_DefaultStrategyLevel);
1034: END IF;

Line 1315: from iex_app_preferences_b

1311: --Start adding for bug 8834310 gnramasa 26th Aug 09
1312: begin
1313: select decode(preference_value, 'CUSTOMER', 10, 'ACCOUNT', 20, 'BILL_TO', 30, 'DELINQUENCY', 40, 40)
1314: into l_DefaultStrategyLevel
1315: from iex_app_preferences_b
1316: where preference_name = 'COLLECTIONS STRATEGY LEVEL' and enabled_flag = 'Y' and org_id is null; -- Changed for bug 8708271 multi level strategy
1317: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1318: IEX_DEBUG_PUB.LogMessage( 'Default StrategyLevel ' || l_DefaultStrategyLevel);
1319: END IF;

Line 1805: from iex_app_preferences_b

1801: --Start adding for bug 8834310 gnramasa 26th Aug 09
1802: begin
1803: select decode(preference_value, 'CUSTOMER', 10, 'ACCOUNT', 20, 'BILL_TO', 30, 'DELINQUENCY', 40, 40)
1804: into l_DefaultStrategyLevel
1805: from iex_app_preferences_b
1806: where preference_name = 'COLLECTIONS STRATEGY LEVEL' and enabled_flag = 'Y' and org_id is null; -- Changed for bug 8708271 multi level strategy
1807: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1808: IEX_DEBUG_PUB.LogMessage( 'Default StrategyLevel ' || l_DefaultStrategyLevel);
1809: END IF;

Line 1988: from iex_app_preferences_b

1984: /*
1985: begin
1986: select decode(preference_value, 'CUSTOMER', 10, 'ACCOUNT', 20, 'BILL_TO', 30, 'DELINQUENCY', 40, 40)
1987: into l_DefaultStrategyLevel
1988: from iex_app_preferences_b
1989: where preference_name = 'COLLECTIONS STRATEGY LEVEL' and enabled_flag = 'Y' and org_id is null; -- Changed for bug 8708271 multi level strategy
1990: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1991: IEX_DEBUG_PUB.LogMessage( 'Default StrategyLevel ' || l_DefaultStrategyLevel);
1992: END IF;