DBA Data[Home] [Help]

APPS.PJI_PJP_FP_CURR_WRAP dependencies on PJI_UTILS

Line 19: RETURN PJI_UTILS.GET_GLOBAL_PRIMARY_CURRENCY;

15: -----------------------------------------------------------------------
16:
17: function GET_GLOBAL1_CURR_CODE RETURN VARCHAR2 IS
18: BEGIN
19: RETURN PJI_UTILS.GET_GLOBAL_PRIMARY_CURRENCY;
20: END;
21:
22:
23: function GET_GLOBAL2_CURR_CODE RETURN VARCHAR2 IS

Line 25: RETURN PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY;

21:
22:
23: function GET_GLOBAL2_CURR_CODE RETURN VARCHAR2 IS
24: BEGIN
25: RETURN PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY;
26: END;
27:
28:
29: function GET_GLOBAL_RATE_PRIMARY(p_FROM_currency_code VARCHAR2, p_exchange_date date)

Line 32: RETURN PJI_UTILS.get_global_rate_primary(

28:
29: function GET_GLOBAL_RATE_PRIMARY(p_FROM_currency_code VARCHAR2, p_exchange_date date)
30: return NUMBER IS
31: BEGIN
32: RETURN PJI_UTILS.get_global_rate_primary(
33: p_from_currency_code => p_FROM_currency_code,
34: p_exchange_date => p_exchange_date
35: );
36: END;

Line 41: RETURN PJI_UTILS.GET_MAU_PRIMARY;

37:
38:
39: function GET_MAU_PRIMARY return NUMBER IS
40: BEGIN
41: RETURN PJI_UTILS.GET_MAU_PRIMARY;
42: END;
43:
44:
45: function GET_GLOBAL_RATE_SECONDARY (p_FROM_currency_code VARCHAR2, p_exchange_date DATE)

Line 48: RETURN PJI_UTILS.get_global_rate_secondary(

44:
45: function GET_GLOBAL_RATE_SECONDARY (p_FROM_currency_code VARCHAR2, p_exchange_date DATE)
46: return NUMBER IS
47: BEGIN
48: RETURN PJI_UTILS.get_global_rate_secondary(
49: p_from_currency_code => p_FROM_currency_code,
50: p_exchange_date => p_exchange_date
51: );
52: END;

Line 57: RETURN PJI_UTILS.GET_MAU_SECONDARY;

53:
54:
55: function GET_MAU_SECONDARY return NUMBER IS
56: BEGIN
57: RETURN PJI_UTILS.GET_MAU_SECONDARY;
58: END;
59:
60:
61: function GET_RATE(p_FROM_currency_code VARCHAR2, p_to_currency_code VARCHAR2, p_exchange_date date) return NUMBER IS

Line 119: x_global_start_date := pji_utils.GET_EXTRACTION_START_DATE;

115: INIT_ERR_STACK
116: ( p_package_name => g_package_name
117: , x_return_status => l_return_status );
118:
119: x_global_start_date := pji_utils.GET_EXTRACTION_START_DATE;
120: -- TO_DATE(PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE') , PJI_FM_SUM_MAIN.g_date_mask);
121:
122: BEGIN
123: SELECT ent_period_id,name,start_date,END_date

Line 120: -- TO_DATE(PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE') , PJI_FM_SUM_MAIN.g_date_mask);

116: ( p_package_name => g_package_name
117: , x_return_status => l_return_status );
118:
119: x_global_start_date := pji_utils.GET_EXTRACTION_START_DATE;
120: -- TO_DATE(PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE') , PJI_FM_SUM_MAIN.g_date_mask);
121:
122: BEGIN
123: SELECT ent_period_id,name,start_date,END_date
124: INTO x_ent_start_period_id, x_ent_start_period_name, x_ent_start_date, x_ent_END_date

Line 221: x_global1_currency_code := PJI_UTILS.GET_GLOBAL_PRIMARY_CURRENCY;

217: END;
218:
219:
220: BEGIN
221: x_global1_currency_code := PJI_UTILS.GET_GLOBAL_PRIMARY_CURRENCY;
222: x_global2_currency_code := PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY;
223: EXCEPTION
224: WHEN OTHERS THEN RAISE;
225: END;

Line 222: x_global2_currency_code := PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY;

218:
219:
220: BEGIN
221: x_global1_currency_code := PJI_UTILS.GET_GLOBAL_PRIMARY_CURRENCY;
222: x_global2_currency_code := PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY;
223: EXCEPTION
224: WHEN OTHERS THEN RAISE;
225: END;
226:

Line 243: PJI_UTILS.WRITE2LOG(p_msg => l_tag);

239: l_tag VARCHAR2(500) := p_tag || ' ' || to_char(sysdate, 'HH:MI:SS' ) || ' sid ' || userenv('SESSIONID') ;
240: BEGIN
241: -- dbms_output.put_line(l_tag);
242: -- hr_utility.trace(l_tag);
243: PJI_UTILS.WRITE2LOG(p_msg => l_tag);
244: EXCEPTION
245: WHEN OTHERS THEN
246: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
247: p_procedure_name => 'PRINT_TIME');

Line 318: SELECT NVL(p_own_name, PJI_UTILS.GET_PJI_SCHEMA_NAME)

314: print_time('p_num_blks ' || p_num_blks);
315: print_time('p_avg_r_len ' || p_avg_r_len);
316: */
317:
318: SELECT NVL(p_own_name, PJI_UTILS.GET_PJI_SCHEMA_NAME)
319: INTO l_own_name
320: FROM DUAL;
321:
322: -- print_time('l_own_name ' || l_own_name);