APPS.PN_RECOVERY_EXTRACT_PKG dependencies on PN_MO_CACHE_UTILS

Line 751: x_org_id => pn_mo_cache_utils.get_current_org_id,

747: l_info := ' inserting row into area cls dtl line table ';
748: pnp_debug_pkg.log(l_info);
749:
750: pn_rec_arcl_dtlln_pkg.insert_row(
751: x_org_id => pn_mo_cache_utils.get_current_org_id,
752: x_area_class_dtl_id => p_hdr_id,
753: x_area_class_dtl_line_id => l_area_cls_dtl_line_id,
754: x_from_date => p_new_data(i).from_date,
755: x_to_date => p_new_data(i).to_date,

Line 1565: x_org_id => pn_mo_cache_utils.get_current_org_id,

1561: x_last_update_login => nvl(fnd_profile.value('USER_ID'), -1)
1562: );
1563: ELSE
1564: pn_rec_arcl_dtl_pkg.insert_row(
1565: x_org_id => pn_mo_cache_utils.get_current_org_id,
1566: x_area_class_id => p_area_class_id,
1567: x_area_class_dtl_id => l_area_class_dtl_id,
1568: x_as_of_date => fnd_date.canonical_to_date(p_as_of_date),
1569: x_from_date => fnd_date.canonical_to_date(p_from_date),

Line 1773: extract_rec.org_id = pn_mo_cache_utils.get_current_org_id THEN

1769: (extract_rec.property_id IS NULL AND p_prop_id IS NULL)) AND
1770: TRUNC(extract_rec.from_date)= TRUNC(p_from_date) AND
1771: TRUNC(extract_rec.to_date) = TRUNC(p_to_date) AND
1772: extract_rec.currency_code = p_currency AND
1773: extract_rec.org_id = pn_mo_cache_utils.get_current_org_id THEN
1774: l_same := TRUE;
1775: END IF;
1776: END LOOP;
1777:

Line 1919: x_org_id => to_number(pn_mo_cache_utils.get_current_org_id),

1915: l_info:= ' inserting expense line header';
1916: pnp_debug_pkg.log(l_info);
1917:
1918: pn_rec_exp_line_pkg.insert_row(
1919: x_org_id => to_number(pn_mo_cache_utils.get_current_org_id),
1920: x_expense_line_id => p_expense_line_id,
1921: x_expense_extract_code => p_extract_code,
1922: x_currency_code => p_currency_code,
1923: x_as_of_date => p_as_of_date,

Line 1941: x_org_id => to_number(pn_mo_cache_utils.get_current_org_id),

1937: l_info:= ' inserting expense line detail for header id: '||p_expense_line_id;
1938: pnp_debug_pkg.log(l_info);
1939:
1940: pn_rec_exp_line_dtl_pkg.insert_row(
1941: x_org_id => to_number(pn_mo_cache_utils.get_current_org_id),
1942: x_expense_line_id => p_expense_line_id,
1943: x_expense_line_dtl_id => p_expense_line_dtl_id,
1944: x_parent_expense_line_id => null,
1945: x_property_id => p_property_id,

Line 2068: AND org_id = pn_mo_cache_utils.get_current_org_id

2064: (property_id = p_property_id AND p_location_id IS NULL))
2065: CONNECT BY PRIOR location_id = parent_location_id)
2066: OR
2067: (property_id = p_property_id AND p_location_id IS NULL))
2068: AND org_id = pn_mo_cache_utils.get_current_org_id
2069: FOR UPDATE OF transfer_flag, expense_line_dtl_id NOWAIT;
2070:
2071: CURSOR is_reextract IS
2072: SELECT expense_line_id

Line 2461: x_org_id => to_number(pn_mo_cache_utils.get_current_org_id),

2457: l_info:= ' inserting data into class lines master table';
2458: pnp_debug_pkg.log(l_info);
2459:
2460: pn_rec_expcl_dtlln_pkg.insert_row(
2461: x_org_id => to_number(pn_mo_cache_utils.get_current_org_id),
2462: x_expense_class_dtl_id => p_master_data(i).expense_class_dtl_id,
2463: x_expense_class_line_id => l_expense_class_line_id,
2464: x_location_id => p_master_data(i).location_id,
2465: x_cust_space_assign_id => p_master_data(i).cust_space_assign_id,

Line 2542: x_org_id => to_number(pn_mo_cache_utils.get_current_org_id),

2538: p_master_data(p_detail_data(i).expense_class_line_id).expense_class_line_id;
2539: pnp_debug_pkg.log(l_info);
2540:
2541: pn_rec_expcl_dtlacc_pkg.insert_row(
2542: x_org_id => to_number(pn_mo_cache_utils.get_current_org_id),
2543: x_expense_class_line_id => p_master_data(p_detail_data(i).expense_class_line_id).expense_class_line_id,
2544: x_expense_class_line_dtl_id => l_expense_class_line_dtl_id,
2545: x_expense_line_dtl_id => p_detail_data(i).expense_line_dtl_id,
2546: x_expense_account_id => p_detail_data(i).expense_account_id,

Line 3543: x_org_id => to_number(pn_mo_cache_utils.get_current_org_id),

3539: l_fee_af_contr := expense_class_rec.class_fee_after_contr;
3540: l_portion_pct := expense_class_rec.portion_pct;
3541:
3542: pn_rec_expcl_dtl_pkg.insert_row(
3543: x_org_id => to_number(pn_mo_cache_utils.get_current_org_id),
3544: x_expense_class_id => p_expense_class_id,
3545: x_expense_line_id => p_expense_line_id,
3546: x_expense_class_dtl_id => l_expense_class_dtl_id,
3547: x_status => 'OPEN',

Line 3799: WHERE set_of_books_id = TO_NUMBER(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',

3795:
3796: CURSOR get_functional_currency_code IS
3797: SELECT currency_code
3798: FROM gl_sets_of_books
3799: WHERE set_of_books_id = TO_NUMBER(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
3800: pn_mo_cache_utils.get_current_org_id));
3801:
3802: BEGIN
3803:

Line 3800: pn_mo_cache_utils.get_current_org_id));

3796: CURSOR get_functional_currency_code IS
3797: SELECT currency_code
3798: FROM gl_sets_of_books
3799: WHERE set_of_books_id = TO_NUMBER(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
3800: pn_mo_cache_utils.get_current_org_id));
3801:
3802: BEGIN
3803:
3804: pnp_debug_pkg.log(l_desc ||' (+)');

Line 3848: pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_REC_EXPENSE_NUM',

3844: fnd_message.set_token('NUMBER', p_extract_code);
3845: raise bad_input_exception;
3846:
3847: ELSIF p_extract_code IS NULL AND
3848: pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_REC_EXPENSE_NUM',
3849: pn_mo_cache_utils.get_current_org_id) = 'N'
3850: THEN
3851:
3852: fnd_message.set_name('PN','PN_REC_EXP_NUM_REQ');

Line 3849: pn_mo_cache_utils.get_current_org_id) = 'N'

3845: raise bad_input_exception;
3846:
3847: ELSIF p_extract_code IS NULL AND
3848: pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_REC_EXPENSE_NUM',
3849: pn_mo_cache_utils.get_current_org_id) = 'N'
3850: THEN
3851:
3852: fnd_message.set_name('PN','PN_REC_EXP_NUM_REQ');
3853: raise bad_input_exception;