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 1577: x_org_id => pn_mo_cache_utils.get_current_org_id,

1573: x_last_update_login => nvl(fnd_profile.value('USER_ID'), -1)
1574: );
1575: ELSE
1576: pn_rec_arcl_dtl_pkg.insert_row(
1577: x_org_id => pn_mo_cache_utils.get_current_org_id,
1578: x_area_class_id => p_area_class_id,
1579: x_area_class_dtl_id => l_area_class_dtl_id,
1580: x_as_of_date => fnd_date.canonical_to_date(p_as_of_date),
1581: x_from_date => fnd_date.canonical_to_date(p_from_date),

Line 1785: extract_rec.org_id = pn_mo_cache_utils.get_current_org_id THEN

1781: (extract_rec.property_id IS NULL AND p_prop_id IS NULL)) AND
1782: TRUNC(extract_rec.from_date)= TRUNC(p_from_date) AND
1783: TRUNC(extract_rec.to_date) = TRUNC(p_to_date) AND
1784: extract_rec.currency_code = p_currency AND
1785: extract_rec.org_id = pn_mo_cache_utils.get_current_org_id THEN
1786: l_same := TRUE;
1787: END IF;
1788: END LOOP;
1789:

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

1927: l_info:= ' inserting expense line header';
1928: pnp_debug_pkg.log(l_info);
1929:
1930: pn_rec_exp_line_pkg.insert_row(
1931: x_org_id => to_number(pn_mo_cache_utils.get_current_org_id),
1932: x_expense_line_id => p_expense_line_id,
1933: x_expense_extract_code => p_extract_code,
1934: x_currency_code => p_currency_code,
1935: x_as_of_date => p_as_of_date,

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

1949: l_info:= ' inserting expense line detail for header id: '||p_expense_line_id;
1950: pnp_debug_pkg.log(l_info);
1951:
1952: pn_rec_exp_line_dtl_pkg.insert_row(
1953: x_org_id => to_number(pn_mo_cache_utils.get_current_org_id),
1954: x_expense_line_id => p_expense_line_id,
1955: x_expense_line_dtl_id => p_expense_line_dtl_id,
1956: x_parent_expense_line_id => null,
1957: x_property_id => p_property_id,

Line 2080: AND org_id = pn_mo_cache_utils.get_current_org_id

2076: (property_id = p_property_id AND p_location_id IS NULL))
2077: CONNECT BY PRIOR location_id = parent_location_id)
2078: OR
2079: (property_id = p_property_id AND p_location_id IS NULL))
2080: AND org_id = pn_mo_cache_utils.get_current_org_id
2081: FOR UPDATE OF transfer_flag, expense_line_dtl_id NOWAIT;
2082:
2083: CURSOR is_reextract IS
2084: SELECT expense_line_id

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

2469: l_info:= ' inserting data into class lines master table';
2470: pnp_debug_pkg.log(l_info);
2471:
2472: pn_rec_expcl_dtlln_pkg.insert_row(
2473: x_org_id => to_number(pn_mo_cache_utils.get_current_org_id),
2474: x_expense_class_dtl_id => p_master_data(i).expense_class_dtl_id,
2475: x_expense_class_line_id => l_expense_class_line_id,
2476: x_location_id => p_master_data(i).location_id,
2477: x_cust_space_assign_id => p_master_data(i).cust_space_assign_id,

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

2550: p_master_data(p_detail_data(i).expense_class_line_id).expense_class_line_id;
2551: pnp_debug_pkg.log(l_info);
2552:
2553: pn_rec_expcl_dtlacc_pkg.insert_row(
2554: x_org_id => to_number(pn_mo_cache_utils.get_current_org_id),
2555: x_expense_class_line_id => p_master_data(p_detail_data(i).expense_class_line_id).expense_class_line_id,
2556: x_expense_class_line_dtl_id => l_expense_class_line_dtl_id,
2557: x_expense_line_dtl_id => p_detail_data(i).expense_line_dtl_id,
2558: x_expense_account_id => p_detail_data(i).expense_account_id,

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

3551: l_fee_af_contr := expense_class_rec.class_fee_after_contr;
3552: l_portion_pct := expense_class_rec.portion_pct;
3553:
3554: pn_rec_expcl_dtl_pkg.insert_row(
3555: x_org_id => to_number(pn_mo_cache_utils.get_current_org_id),
3556: x_expense_class_id => p_expense_class_id,
3557: x_expense_line_id => p_expense_line_id,
3558: x_expense_class_dtl_id => l_expense_class_dtl_id,
3559: x_status => 'OPEN',

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

3807:
3808: CURSOR get_functional_currency_code IS
3809: SELECT currency_code
3810: FROM gl_sets_of_books
3811: WHERE set_of_books_id = TO_NUMBER(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
3812: pn_mo_cache_utils.get_current_org_id));
3813:
3814: BEGIN
3815:

Line 3812: pn_mo_cache_utils.get_current_org_id));

3808: CURSOR get_functional_currency_code IS
3809: SELECT currency_code
3810: FROM gl_sets_of_books
3811: WHERE set_of_books_id = TO_NUMBER(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
3812: pn_mo_cache_utils.get_current_org_id));
3813:
3814: BEGIN
3815:
3816: pnp_debug_pkg.log(l_desc ||' (+)');

Line 3860: pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_REC_EXPENSE_NUM',

3856: fnd_message.set_token('NUMBER', p_extract_code);
3857: raise bad_input_exception;
3858:
3859: ELSIF p_extract_code IS NULL AND
3860: pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_REC_EXPENSE_NUM',
3861: pn_mo_cache_utils.get_current_org_id) = 'N'
3862: THEN
3863:
3864: fnd_message.set_name('PN','PN_REC_EXP_NUM_REQ');

Line 3861: pn_mo_cache_utils.get_current_org_id) = 'N'

3857: raise bad_input_exception;
3858:
3859: ELSIF p_extract_code IS NULL AND
3860: pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_REC_EXPENSE_NUM',
3861: pn_mo_cache_utils.get_current_org_id) = 'N'
3862: THEN
3863:
3864: fnd_message.set_name('PN','PN_REC_EXP_NUM_REQ');
3865: raise bad_input_exception;