DBA Data[Home] [Help]

APPS.CSI_COUNTER_READINGS_PVT dependencies on FND_PROFILE

Line 1136: l_date_format VARCHAR2(50) := nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-YYYY HH24:MI:SS');

1132: l_counter_id NUMBER;
1133: l_debug_level NUMBER; -- 8214848 - dsingire
1134: l_user_id NUMBER := fnd_global.user_id; -- 8214848 - dsingire
1135: l_conc_login_id NUMBER := fnd_global.conc_login_id; -- 8214848 - dsingire
1136: l_date_format VARCHAR2(50) := nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-YYYY HH24:MI:SS');
1137: -- Bug 9148094
1138: l_update_net_flag VARCHAR2(1) := NVL(fnd_profile.value('CSI_UPDATE_NET_READINGS_ON_RESET'), 'Y');
1139:
1140: CURSOR PREV_READING_CUR(p_counter_id IN NUMBER,p_value_timestamp IN DATE) IS

Line 1138: l_update_net_flag VARCHAR2(1) := NVL(fnd_profile.value('CSI_UPDATE_NET_READINGS_ON_RESET'), 'Y');

1134: l_user_id NUMBER := fnd_global.user_id; -- 8214848 - dsingire
1135: l_conc_login_id NUMBER := fnd_global.conc_login_id; -- 8214848 - dsingire
1136: l_date_format VARCHAR2(50) := nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-YYYY HH24:MI:SS');
1137: -- Bug 9148094
1138: l_update_net_flag VARCHAR2(1) := NVL(fnd_profile.value('CSI_UPDATE_NET_READINGS_ON_RESET'), 'Y');
1139:
1140: CURSOR PREV_READING_CUR(p_counter_id IN NUMBER,p_value_timestamp IN DATE) IS
1141: select counter_reading,net_reading,life_to_date_reading,
1142: value_timestamp

Line 5084: l_date_format VARCHAR2(50) := nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-YYYY HH24:MI:SS');

5080: l_prev_max_comments VARCHAR2(240);
5081: l_debug_level NUMBER; -- 8214848 - dsingire
5082: l_user_id NUMBER := fnd_global.user_id; -- 8214848 - dsingire
5083: l_conc_login_id NUMBER := fnd_global.conc_login_id; -- 8214848 - dsingire
5084: l_date_format VARCHAR2(50) := nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-YYYY HH24:MI:SS');
5085: --
5086: -- Bug 9148094
5087: l_update_net_flag VARCHAR2(1) := NVL(fnd_profile.value('CSI_UPDATE_NET_READINGS_ON_RESET'), 'Y');
5088: --

Line 5087: l_update_net_flag VARCHAR2(1) := NVL(fnd_profile.value('CSI_UPDATE_NET_READINGS_ON_RESET'), 'Y');

5083: l_conc_login_id NUMBER := fnd_global.conc_login_id; -- 8214848 - dsingire
5084: l_date_format VARCHAR2(50) := nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-YYYY HH24:MI:SS');
5085: --
5086: -- Bug 9148094
5087: l_update_net_flag VARCHAR2(1) := NVL(fnd_profile.value('CSI_UPDATE_NET_READINGS_ON_RESET'), 'Y');
5088: --
5089: CURSOR CURRENT_READING_CUR(p_counter_value_id IN NUMBER) IS
5090: select * from
5091: CSI_COUNTER_READINGS

Line 7335: l_date_format VARCHAR2(50) := nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-YYYY HH24:MI:SS');

7331: l_ctr_val_id NUMBER;
7332: l_debug_level NUMBER; -- 8214848 - dsingire
7333: l_user_id NUMBER := fnd_global.user_id; -- 8214848 - dsingire
7334: l_conc_login_id NUMBER := fnd_global.conc_login_id; -- 8214848 - dsingire
7335: l_date_format VARCHAR2(50) := nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-YYYY HH24:MI:SS');
7336: BEGIN
7337: SAVEPOINT ESTIMATE_COUNTER_READING;
7338: -- Initialize message list if p_init_msg_list is set to TRUE.
7339: IF FND_API.to_Boolean( p_init_msg_list ) THEN