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 461: -- 01-DEC-05 Hareesha o Passed pn_mo_cache_utils.get_current_org_id

457: -- PROCEDURE : CREATE_AR_ACC_R12
458: -- DESCRIPTION: Create accounting for normalize billing items in R12
459: -- HISTORY
460: -- 20-JUL-05 ftanudja o Created for SLA uptake. #4527233
461: -- 01-DEC-05 Hareesha o Passed pn_mo_cache_utils.get_current_org_id
462: -- while inserting
463: -- 01-DEC-05 Hareesha o Changes for Lazy upgrade for LE uptake.
464: -- 12-MAY-06 sdmahesh o Bug # 5219481
465: -- Set transferred_to_ar_flag in PN_PAYMENT_ITEMS

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

729: -- PURPOSE :
730: -- HISTORY :
731: -- 14-jul-05 sdmahesh o Bug 4284035 - Replaced pn_ae_headers,pn_ae_lines pnl
732: -- with _ALL table.
733: -- 01-DEC-05 Hareesha o passed pn_mo_cache_utils.get_current_org_id to
734: -- get_profile_value.
735: -- 01-DEC-05 Hareesha o Added check to call c_default_gl_period only
736: -- incase of R12 only.
737: -------------------------------------------------------------------------------

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

765: CURSOR c_default_gl_period IS
766: SELECT period_name
767: FROM gl_period_statuses
768: WHERE closing_status IN ('O', 'F')
769: AND set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
770: pn_mo_cache_utils.get_current_org_id)
771: AND application_id = 101
772: AND adjustment_period_flag = 'N'
773: AND fnd_date.canonical_to_date(p_default_gl_date) BETWEEN start_date AND end_date;

Line 770: pn_mo_cache_utils.get_current_org_id)

766: SELECT period_name
767: FROM gl_period_statuses
768: WHERE closing_status IN ('O', 'F')
769: AND set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
770: pn_mo_cache_utils.get_current_org_id)
771: AND application_id = 101
772: AND adjustment_period_flag = 'N'
773: AND fnd_date.canonical_to_date(p_default_gl_date) BETWEEN start_date AND end_date;
774:

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

1034: -- o indented code - bug # 3446951
1035: -- 14-jul-2005 SatyaDeep o replaced pn_distributions,pn_payment_terms,
1036: -- pn_leases,pn__payment_items,pn_payment_schedules
1037: -- with their respective _ALL tables
1038: -- 01-DEC-05 Hareesha o Passed pn_mo_cache_utils.get_current_org_id
1039: -- to get_profile_value.
1040: -- Inserted pn_mo_cache_utils.get_current_org_id as
1041: -- org_id into interface tables.
1042: -- 25-DEC-06 acprakas o Bug#5739873. Modified procedure to form

Line 1040: -- Inserted pn_mo_cache_utils.get_current_org_id as

1036: -- pn_leases,pn__payment_items,pn_payment_schedules
1037: -- with their respective _ALL tables
1038: -- 01-DEC-05 Hareesha o Passed pn_mo_cache_utils.get_current_org_id
1039: -- to get_profile_value.
1040: -- Inserted pn_mo_cache_utils.get_current_org_id as
1041: -- org_id into interface tables.
1042: -- 25-DEC-06 acprakas o Bug#5739873. Modified procedure to form
1043: -- header and line description with lease number
1044: -- instead of lease id.

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

1091: l_err_msg4 VARCHAR2(2000);
1092: l_total_rev_amt NUMBER := 0;
1093: l_total_rev_percent NUMBER := 0;
1094: l_diff_amt NUMBER := 0;
1095: l_set_of_books_id NUMBER := TO_NUMBER(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID'
1096: ,pn_mo_cache_utils.get_current_org_id));
1097: l_func_curr_code gl_sets_of_books.currency_code%TYPE;
1098: l_conv_rate_type pn_currencies.conversion_type%TYPE;
1099: v_pn_EVENT_TYPE_CODE pn_payment_terms.EVENT_TYPE_CODE%TYPE;

Line 1096: ,pn_mo_cache_utils.get_current_org_id));

1092: l_total_rev_amt NUMBER := 0;
1093: l_total_rev_percent NUMBER := 0;
1094: l_diff_amt NUMBER := 0;
1095: l_set_of_books_id NUMBER := TO_NUMBER(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID'
1096: ,pn_mo_cache_utils.get_current_org_id));
1097: l_func_curr_code gl_sets_of_books.currency_code%TYPE;
1098: l_conv_rate_type pn_currencies.conversion_type%TYPE;
1099: v_pn_EVENT_TYPE_CODE pn_payment_terms.EVENT_TYPE_CODE%TYPE;
1100: l_header_ID PN_AE_HEADERS.AE_HEADER_ID%TYPE;

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

1192: CURSOR C_VALID_PERIOD IS
1193: SELECT 1
1194: FROM gl_period_statuses
1195: WHERE closing_status IN ('O', 'F')
1196: AND set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
1197: pn_mo_cache_utils.get_current_org_id)
1198: AND application_id = 101
1199: AND adjustment_period_flag = 'N'
1200: AND period_name = v_pn_period_name;

Line 1197: pn_mo_cache_utils.get_current_org_id)

1193: SELECT 1
1194: FROM gl_period_statuses
1195: WHERE closing_status IN ('O', 'F')
1196: AND set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
1197: pn_mo_cache_utils.get_current_org_id)
1198: AND application_id = 101
1199: AND adjustment_period_flag = 'N'
1200: AND period_name = v_pn_period_name;
1201:

Line 1313: ,pn_mo_cache_utils.get_current_org_id);

1309:
1310: l_conv_rate_type
1311: := PNP_UTIL_FUNC.check_conversion_type
1312: ( l_func_curr_code
1313: ,pn_mo_cache_utils.get_current_org_id);
1314:
1315: fnd_message.set_name ('PN','PN_CRACC_CV_TYPE');
1316: fnd_message.set_token ('CT', l_conv_rate_type);
1317: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 1355: ,pn_mo_cache_utils.get_current_org_id);

1351: ELSE
1352: l_start_date
1353: := PNP_UTIL_FUNC.Get_Start_Date
1354: ( V_PN_PERIOD_NAME
1355: ,pn_mo_cache_utils.get_current_org_id);
1356: l_period_name := v_pn_period_name;
1357: END IF;
1358: CLOSE c_valid_period;
1359:

Line 1438: pn_mo_cache_utils.get_current_org_id,

1434: SYSDATE,
1435: FND_GLOBAL.conc_program_id,
1436: FND_GLOBAL.prog_appl_id,
1437: FND_GLOBAL.conc_request_id,
1438: pn_mo_cache_utils.get_current_org_id,
1439: NULL
1440: )
1441: RETURNING ACCOUNTING_EVENT_ID INTO l_EVENT_id ;
1442:

Line 1488: pn_mo_cache_utils.get_current_org_id,

1484: l_start_date,
1485: 'N',
1486: -1,
1487: l_header_desc,
1488: pn_mo_cache_utils.get_current_org_id,
1489: l_creation_date,
1490: l_created_by,
1491: l_last_update_date,
1492: l_last_updated_by,

Line 1598: pn_mo_cache_utils.get_current_org_id,

1594: 'PN_PAYMENT_ITEMS',
1595: V_PN_PAYMENT_ITEM_ID,
1596: l_line_desc,
1597: NULL,
1598: pn_mo_cache_utils.get_current_org_id,
1599: l_creation_date,
1600: l_created_by,
1601: l_last_update_date,
1602: l_last_updated_by,

Line 1711: pn_mo_cache_utils.get_current_org_id,

1707: 'PN_PAYMENT_ITEMS',
1708: V_PN_PAYMENT_ITEM_ID,
1709: l_line_desc,
1710: null,
1711: pn_mo_cache_utils.get_current_org_id,
1712: l_creation_date,
1713: l_created_by,
1714: l_last_update_date,
1715: l_last_updated_by,

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

1786: -- o indented code - bug # 3446951
1787: -- 14-jul-2005 SatyaDeep o replaced pn_distributions,pn_payment_terms,
1788: -- pn_leases,pn__payment_items,pn_payment_schedules
1789: -- with their respective _ALL tables
1790: -- 01-DEC-05 Hareesha o Passed pn_mo_cache_utils.get_current_org_id to
1791: -- get_profile_value.
1792: -- Inserted pn_mo_cache_utils.get_current_org_id
1793: -- as org_id into interface tables.
1794: -- 25-DEC-06 acprakas o Bug#5739873. Modified procedure to form

Line 1792: -- Inserted pn_mo_cache_utils.get_current_org_id

1788: -- pn_leases,pn__payment_items,pn_payment_schedules
1789: -- with their respective _ALL tables
1790: -- 01-DEC-05 Hareesha o Passed pn_mo_cache_utils.get_current_org_id to
1791: -- get_profile_value.
1792: -- Inserted pn_mo_cache_utils.get_current_org_id
1793: -- as org_id into interface tables.
1794: -- 25-DEC-06 acprakas o Bug#5739873. Modified procedure to form
1795: -- header and line description with lease number
1796: -- instead of lease id.

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

1844: l_err_msg4 VARCHAR2(2000);
1845: l_total_exp_amt number := 0;
1846: l_total_exp_percent number := 0;
1847: l_diff_amt number := 0;
1848: l_set_of_books_id NUMBER := TO_NUMBER(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
1849: pn_mo_cache_utils.get_current_org_id));
1850: l_func_curr_code gl_sets_of_books.currency_code%TYPE;
1851: l_conv_rate_type pn_currencies.conversion_type%TYPE;
1852: v_pn_EVENT_TYPE_CODE pn_payment_terms.EVENT_TYPE_CODE%type;

Line 1849: pn_mo_cache_utils.get_current_org_id));

1845: l_total_exp_amt number := 0;
1846: l_total_exp_percent number := 0;
1847: l_diff_amt number := 0;
1848: l_set_of_books_id NUMBER := TO_NUMBER(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
1849: pn_mo_cache_utils.get_current_org_id));
1850: l_func_curr_code gl_sets_of_books.currency_code%TYPE;
1851: l_conv_rate_type pn_currencies.conversion_type%TYPE;
1852: v_pn_EVENT_TYPE_CODE pn_payment_terms.EVENT_TYPE_CODE%type;
1853: l_header_ID PN_AE_HEADERS.AE_HEADER_ID%type;

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

1946: CURSOR C_VALID_PERIOD IS
1947: SELECT 1
1948: FROM gl_period_statuses
1949: WHERE closing_status IN ('O', 'F')
1950: AND set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
1951: pn_mo_cache_utils.get_current_org_id)
1952: AND application_id = 101
1953: AND adjustment_period_flag = 'N'
1954: AND period_name = v_pn_period_name;

Line 1951: pn_mo_cache_utils.get_current_org_id)

1947: SELECT 1
1948: FROM gl_period_statuses
1949: WHERE closing_status IN ('O', 'F')
1950: AND set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
1951: pn_mo_cache_utils.get_current_org_id)
1952: AND application_id = 101
1953: AND adjustment_period_flag = 'N'
1954: AND period_name = v_pn_period_name;
1955:

Line 2067: ,pn_mo_cache_utils.get_current_org_id);

2063:
2064: l_conv_rate_type
2065: := PNP_UTIL_FUNC.check_conversion_type
2066: ( l_func_curr_code
2067: ,pn_mo_cache_utils.get_current_org_id);
2068:
2069: fnd_message.set_name ('PN','PN_CRACC_CV_TYPE');
2070: fnd_message.set_token ('CT', l_conv_rate_type);
2071: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 2108: ,pn_mo_cache_utils.get_current_org_id);

2104: ELSE
2105: l_start_date
2106: := PNP_UTIL_FUNC.Get_Start_Date
2107: ( V_PN_PERIOD_NAME
2108: ,pn_mo_cache_utils.get_current_org_id);
2109: l_period_name := v_pn_period_name;
2110: END IF;
2111: CLOSE C_VALID_PERIOD;
2112:

Line 2196: pn_mo_cache_utils.get_current_org_id,

2192: SYSDATE,
2193: FND_GLOBAL.conc_program_id,
2194: FND_GLOBAL.prog_appl_id,
2195: FND_GLOBAL.conc_request_id,
2196: pn_mo_cache_utils.get_current_org_id,
2197: NULL
2198: )
2199: RETURNING ACCOUNTING_EVENT_ID INTO l_EVENT_id ;
2200:

Line 2248: pn_mo_cache_utils.get_current_org_id,

2244: l_start_date,
2245: 'N',
2246: -1,
2247: l_header_desc,
2248: pn_mo_cache_utils.get_current_org_id,
2249: l_creation_date,
2250: l_created_by,
2251: l_last_update_date,
2252: l_last_updated_by,

Line 2358: pn_mo_cache_utils.get_current_org_id,

2354: 'PN_PAYMENT_ITEMS',
2355: V_PN_PAYMENT_ITEM_ID,
2356: l_line_desc,
2357: NULL,
2358: pn_mo_cache_utils.get_current_org_id,
2359: l_creation_date,
2360: l_created_by,
2361: l_last_update_date,
2362: l_last_updated_by,

Line 2473: pn_mo_cache_utils.get_current_org_id,

2469: 'PN_PAYMENT_ITEMS',
2470: V_PN_PAYMENT_ITEM_ID,
2471: l_line_desc,
2472: NULL,
2473: pn_mo_cache_utils.get_current_org_id,
2474: l_creation_date,
2475: l_created_by,
2476: l_last_update_date,
2477: l_last_updated_by,