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.PN_CREATE_ACC dependencies on PN_MO_CACHE_UTILS

Line 223: l_ledger_id := pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',pn_mo_cache_utils.get_current_org_id);

219: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_period_info (+)');
220: l_ledger_id := p_ledger_id;
221: IF l_ledger_id IS NULL
222: THEN
223: l_ledger_id := pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',pn_mo_cache_utils.get_current_org_id);
224: END IF;
225:
226: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_period_info l_ledger_id ' || l_ledger_id);
227:

Line 265: l_ledger_id := pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',pn_mo_cache_utils.get_current_org_id);

261: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_pn_period_status (+)');
262: l_ledger_id := p_ledger_id;
263: IF l_ledger_id IS NULL
264: THEN
265: l_ledger_id := pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',pn_mo_cache_utils.get_current_org_id);
266: END IF;
267:
268: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_pn_period_status p_period_name '|| p_period_name);
269: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_pn_period_status l_ledger_id '|| l_ledger_id);

Line 328: l_ledger_id := pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',pn_mo_cache_utils.get_current_org_id);

324: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_valid_gl_date (+)');
325: l_ledger_id := p_ledger_id;
326: IF l_ledger_id IS NULL
327: THEN
328: l_ledger_id := pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',pn_mo_cache_utils.get_current_org_id);
329: END IF;
330:
331: get_period_info
332: (p_date => p_gl_date,

Line 394: l_set_of_books_id NUMBER := TO_NUMBER(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',

390:
391: l_exp_cnt NUMBER :=0;
392: l_acc_cnt NUMBER :=0;
393:
394: l_set_of_books_id NUMBER := TO_NUMBER(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
395: pn_mo_cache_utils.get_current_org_id));
396: l_func_curr_code gl_sets_of_books.currency_code%TYPE;
397: l_chart_of_id NUMBER;
398: l_conv_rate_type pn_currencies.conversion_type%TYPE;

Line 395: pn_mo_cache_utils.get_current_org_id));

391: l_exp_cnt NUMBER :=0;
392: l_acc_cnt NUMBER :=0;
393:
394: l_set_of_books_id NUMBER := TO_NUMBER(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
395: pn_mo_cache_utils.get_current_org_id));
396: l_func_curr_code gl_sets_of_books.currency_code%TYPE;
397: l_chart_of_id NUMBER;
398: l_conv_rate_type pn_currencies.conversion_type%TYPE;
399:

Line 427: l_conv_rate_type := PNP_UTIL_FUNC.check_conversion_type( l_func_curr_code,pn_mo_cache_utils.get_current_org_id);

423: OPEN get_func_curr_code(l_set_of_books_id);
424: FETCH get_func_curr_code INTO l_func_curr_code,l_chart_of_id;
425: CLOSE get_func_curr_code;
426:
427: l_conv_rate_type := PNP_UTIL_FUNC.check_conversion_type( l_func_curr_code,pn_mo_cache_utils.get_current_org_id);
428:
429: fnd_currency.get_info(p_export_currency_code, l_precision, l_ext_precision, l_min_acct_unit);
430:
431: IF l_prev_payment_term_id <> p_payment_term_id THEN

Line 907: -- 01-DEC-05 Hareesha o Passed pn_mo_cache_utils.get_current_org_id

903: -- PROCEDURE : CREATE_AR_ACC_R12
904: -- DESCRIPTION: Create accounting for normalize billing items in R12
905: -- HISTORY
906: -- 20-JUL-05 ftanudja o Created for SLA uptake. #4527233
907: -- 01-DEC-05 Hareesha o Passed pn_mo_cache_utils.get_current_org_id
908: -- while inserting
909: -- 01-DEC-05 Hareesha o Changes for Lazy upgrade for LE uptake.
910: -- 12-MAY-06 sdmahesh o Bug # 5219481
911: -- Set transferred_to_ar_flag in PN_PAYMENT_ITEMS

Line 1201: -- 01-DEC-05 Hareesha o passed pn_mo_cache_utils.get_current_org_id to

1197: -- PURPOSE :
1198: -- HISTORY :
1199: -- 14-jul-05 sdmahesh o Bug 4284035 - Replaced pn_ae_headers,pn_ae_lines pnl
1200: -- with _ALL table.
1201: -- 01-DEC-05 Hareesha o passed pn_mo_cache_utils.get_current_org_id to
1202: -- get_profile_value.
1203: -- 01-DEC-05 Hareesha o Added check to call c_default_gl_period only
1204: -- incase of R12 only.
1205: -------------------------------------------------------------------------------

Line 1237: AND set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',

1233: CURSOR c_default_gl_period IS
1234: SELECT period_name
1235: FROM gl_period_statuses
1236: WHERE closing_status IN ('O', 'F')
1237: AND set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
1238: pn_mo_cache_utils.get_current_org_id)
1239: AND application_id = 101
1240: AND adjustment_period_flag = 'N'
1241: AND fnd_date.canonical_to_date(p_default_gl_date) BETWEEN start_date AND end_date;

Line 1238: pn_mo_cache_utils.get_current_org_id)

1234: SELECT period_name
1235: FROM gl_period_statuses
1236: WHERE closing_status IN ('O', 'F')
1237: AND set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
1238: pn_mo_cache_utils.get_current_org_id)
1239: AND application_id = 101
1240: AND adjustment_period_flag = 'N'
1241: AND fnd_date.canonical_to_date(p_default_gl_date) BETWEEN start_date AND end_date;
1242:

Line 1506: -- 01-DEC-05 Hareesha o Passed pn_mo_cache_utils.get_current_org_id

1502: -- o indented code - bug # 3446951
1503: -- 14-jul-2005 SatyaDeep o replaced pn_distributions,pn_payment_terms,
1504: -- pn_leases,pn__payment_items,pn_payment_schedules
1505: -- with their respective _ALL tables
1506: -- 01-DEC-05 Hareesha o Passed pn_mo_cache_utils.get_current_org_id
1507: -- to get_profile_value.
1508: -- Inserted pn_mo_cache_utils.get_current_org_id as
1509: -- org_id into interface tables.
1510: -- 25-DEC-06 acprakas o Bug#5739873. Modified procedure to form

Line 1508: -- Inserted pn_mo_cache_utils.get_current_org_id as

1504: -- pn_leases,pn__payment_items,pn_payment_schedules
1505: -- with their respective _ALL tables
1506: -- 01-DEC-05 Hareesha o Passed pn_mo_cache_utils.get_current_org_id
1507: -- to get_profile_value.
1508: -- Inserted pn_mo_cache_utils.get_current_org_id as
1509: -- org_id into interface tables.
1510: -- 25-DEC-06 acprakas o Bug#5739873. Modified procedure to form
1511: -- header and line description with lease number
1512: -- instead of lease id.

Line 1563: l_set_of_books_id NUMBER := TO_NUMBER(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID'

1559: l_err_msg4 VARCHAR2(2000);
1560: l_total_rev_amt NUMBER := 0;
1561: l_total_rev_percent NUMBER := 0;
1562: l_diff_amt NUMBER := 0;
1563: l_set_of_books_id NUMBER := TO_NUMBER(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID'
1564: ,pn_mo_cache_utils.get_current_org_id));
1565: l_func_curr_code gl_sets_of_books.currency_code%TYPE;
1566: l_conv_rate_type pn_currencies.conversion_type%TYPE;
1567: v_pn_EVENT_TYPE_CODE pn_payment_terms.EVENT_TYPE_CODE%TYPE;

Line 1564: ,pn_mo_cache_utils.get_current_org_id));

1560: l_total_rev_amt NUMBER := 0;
1561: l_total_rev_percent NUMBER := 0;
1562: l_diff_amt NUMBER := 0;
1563: l_set_of_books_id NUMBER := TO_NUMBER(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID'
1564: ,pn_mo_cache_utils.get_current_org_id));
1565: l_func_curr_code gl_sets_of_books.currency_code%TYPE;
1566: l_conv_rate_type pn_currencies.conversion_type%TYPE;
1567: v_pn_EVENT_TYPE_CODE pn_payment_terms.EVENT_TYPE_CODE%TYPE;
1568: l_header_ID PN_AE_HEADERS.AE_HEADER_ID%TYPE;

Line 1664: AND set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',

1660: CURSOR C_VALID_PERIOD IS
1661: SELECT 1
1662: FROM gl_period_statuses
1663: WHERE closing_status IN ('O', 'F')
1664: AND set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
1665: pn_mo_cache_utils.get_current_org_id)
1666: AND application_id = 101
1667: AND adjustment_period_flag = 'N'
1668: AND period_name = v_pn_period_name;

Line 1665: pn_mo_cache_utils.get_current_org_id)

1661: SELECT 1
1662: FROM gl_period_statuses
1663: WHERE closing_status IN ('O', 'F')
1664: AND set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
1665: pn_mo_cache_utils.get_current_org_id)
1666: AND application_id = 101
1667: AND adjustment_period_flag = 'N'
1668: AND period_name = v_pn_period_name;
1669:

Line 1781: ,pn_mo_cache_utils.get_current_org_id);

1777:
1778: l_conv_rate_type
1779: := PNP_UTIL_FUNC.check_conversion_type
1780: ( l_func_curr_code
1781: ,pn_mo_cache_utils.get_current_org_id);
1782:
1783: fnd_message.set_name ('PN','PN_CRACC_CV_TYPE');
1784: fnd_message.set_token ('CT', l_conv_rate_type);
1785: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 1823: ,pn_mo_cache_utils.get_current_org_id);

1819: ELSE
1820: l_start_date
1821: := PNP_UTIL_FUNC.Get_Start_Date
1822: ( V_PN_PERIOD_NAME
1823: ,pn_mo_cache_utils.get_current_org_id);
1824: l_period_name := v_pn_period_name;
1825: END IF;
1826: CLOSE c_valid_period;
1827:

Line 1906: pn_mo_cache_utils.get_current_org_id,

1902: SYSDATE,
1903: FND_GLOBAL.conc_program_id,
1904: FND_GLOBAL.prog_appl_id,
1905: FND_GLOBAL.conc_request_id,
1906: pn_mo_cache_utils.get_current_org_id,
1907: NULL
1908: )
1909: RETURNING ACCOUNTING_EVENT_ID INTO l_EVENT_id ;
1910:

Line 1956: pn_mo_cache_utils.get_current_org_id,

1952: l_start_date,
1953: 'N',
1954: -1,
1955: l_header_desc,
1956: pn_mo_cache_utils.get_current_org_id,
1957: l_creation_date,
1958: l_created_by,
1959: l_last_update_date,
1960: l_last_updated_by,

Line 2066: pn_mo_cache_utils.get_current_org_id,

2062: 'PN_PAYMENT_ITEMS',
2063: V_PN_PAYMENT_ITEM_ID,
2064: l_line_desc,
2065: NULL,
2066: pn_mo_cache_utils.get_current_org_id,
2067: l_creation_date,
2068: l_created_by,
2069: l_last_update_date,
2070: l_last_updated_by,

Line 2179: pn_mo_cache_utils.get_current_org_id,

2175: 'PN_PAYMENT_ITEMS',
2176: V_PN_PAYMENT_ITEM_ID,
2177: l_line_desc,
2178: null,
2179: pn_mo_cache_utils.get_current_org_id,
2180: l_creation_date,
2181: l_created_by,
2182: l_last_update_date,
2183: l_last_updated_by,

Line 2258: -- 01-DEC-05 Hareesha o Passed pn_mo_cache_utils.get_current_org_id to

2254: -- o indented code - bug # 3446951
2255: -- 14-jul-2005 SatyaDeep o replaced pn_distributions,pn_payment_terms,
2256: -- pn_leases,pn__payment_items,pn_payment_schedules
2257: -- with their respective _ALL tables
2258: -- 01-DEC-05 Hareesha o Passed pn_mo_cache_utils.get_current_org_id to
2259: -- get_profile_value.
2260: -- Inserted pn_mo_cache_utils.get_current_org_id
2261: -- as org_id into interface tables.
2262: -- 25-DEC-06 acprakas o Bug#5739873. Modified procedure to form

Line 2260: -- Inserted pn_mo_cache_utils.get_current_org_id

2256: -- pn_leases,pn__payment_items,pn_payment_schedules
2257: -- with their respective _ALL tables
2258: -- 01-DEC-05 Hareesha o Passed pn_mo_cache_utils.get_current_org_id to
2259: -- get_profile_value.
2260: -- Inserted pn_mo_cache_utils.get_current_org_id
2261: -- as org_id into interface tables.
2262: -- 25-DEC-06 acprakas o Bug#5739873. Modified procedure to form
2263: -- header and line description with lease number
2264: -- instead of lease id.

Line 2316: l_set_of_books_id NUMBER := TO_NUMBER(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',

2312: l_err_msg4 VARCHAR2(2000);
2313: l_total_exp_amt number := 0;
2314: l_total_exp_percent number := 0;
2315: l_diff_amt number := 0;
2316: l_set_of_books_id NUMBER := TO_NUMBER(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
2317: pn_mo_cache_utils.get_current_org_id));
2318: l_func_curr_code gl_sets_of_books.currency_code%TYPE;
2319: l_conv_rate_type pn_currencies.conversion_type%TYPE;
2320: v_pn_EVENT_TYPE_CODE pn_payment_terms.EVENT_TYPE_CODE%type;

Line 2317: pn_mo_cache_utils.get_current_org_id));

2313: l_total_exp_amt number := 0;
2314: l_total_exp_percent number := 0;
2315: l_diff_amt number := 0;
2316: l_set_of_books_id NUMBER := TO_NUMBER(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
2317: pn_mo_cache_utils.get_current_org_id));
2318: l_func_curr_code gl_sets_of_books.currency_code%TYPE;
2319: l_conv_rate_type pn_currencies.conversion_type%TYPE;
2320: v_pn_EVENT_TYPE_CODE pn_payment_terms.EVENT_TYPE_CODE%type;
2321: l_header_ID PN_AE_HEADERS.AE_HEADER_ID%type;

Line 2418: AND set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',

2414: CURSOR C_VALID_PERIOD IS
2415: SELECT 1
2416: FROM gl_period_statuses
2417: WHERE closing_status IN ('O', 'F')
2418: AND set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
2419: pn_mo_cache_utils.get_current_org_id)
2420: AND application_id = 101
2421: AND adjustment_period_flag = 'N'
2422: AND period_name = v_pn_period_name;

Line 2419: pn_mo_cache_utils.get_current_org_id)

2415: SELECT 1
2416: FROM gl_period_statuses
2417: WHERE closing_status IN ('O', 'F')
2418: AND set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
2419: pn_mo_cache_utils.get_current_org_id)
2420: AND application_id = 101
2421: AND adjustment_period_flag = 'N'
2422: AND period_name = v_pn_period_name;
2423:

Line 2535: ,pn_mo_cache_utils.get_current_org_id);

2531:
2532: l_conv_rate_type
2533: := PNP_UTIL_FUNC.check_conversion_type
2534: ( l_func_curr_code
2535: ,pn_mo_cache_utils.get_current_org_id);
2536:
2537: fnd_message.set_name ('PN','PN_CRACC_CV_TYPE');
2538: fnd_message.set_token ('CT', l_conv_rate_type);
2539: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 2576: ,pn_mo_cache_utils.get_current_org_id);

2572: ELSE
2573: l_start_date
2574: := PNP_UTIL_FUNC.Get_Start_Date
2575: ( V_PN_PERIOD_NAME
2576: ,pn_mo_cache_utils.get_current_org_id);
2577: l_period_name := v_pn_period_name;
2578: END IF;
2579: CLOSE C_VALID_PERIOD;
2580:

Line 2664: pn_mo_cache_utils.get_current_org_id,

2660: SYSDATE,
2661: FND_GLOBAL.conc_program_id,
2662: FND_GLOBAL.prog_appl_id,
2663: FND_GLOBAL.conc_request_id,
2664: pn_mo_cache_utils.get_current_org_id,
2665: NULL
2666: )
2667: RETURNING ACCOUNTING_EVENT_ID INTO l_EVENT_id ;
2668:

Line 2716: pn_mo_cache_utils.get_current_org_id,

2712: l_start_date,
2713: 'N',
2714: -1,
2715: l_header_desc,
2716: pn_mo_cache_utils.get_current_org_id,
2717: l_creation_date,
2718: l_created_by,
2719: l_last_update_date,
2720: l_last_updated_by,

Line 2826: pn_mo_cache_utils.get_current_org_id,

2822: 'PN_PAYMENT_ITEMS',
2823: V_PN_PAYMENT_ITEM_ID,
2824: l_line_desc,
2825: NULL,
2826: pn_mo_cache_utils.get_current_org_id,
2827: l_creation_date,
2828: l_created_by,
2829: l_last_update_date,
2830: l_last_updated_by,

Line 2941: pn_mo_cache_utils.get_current_org_id,

2937: 'PN_PAYMENT_ITEMS',
2938: V_PN_PAYMENT_ITEM_ID,
2939: l_line_desc,
2940: NULL,
2941: pn_mo_cache_utils.get_current_org_id,
2942: l_creation_date,
2943: l_created_by,
2944: l_last_update_date,
2945: l_last_updated_by,