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_RECOVERY_EXTRACT_PKG dependencies on FND_DATE

Line 953: AND active_start_date < fnd_date.canonical_to_date(p_to_date)

949: active_end_date,
950: assignable_area
951: FROM pn_locations_all
952: WHERE location_type_lookup_code IN ('SECTION','OFFICE')
953: AND active_start_date < fnd_date.canonical_to_date(p_to_date)
954: AND active_end_date > fnd_date.canonical_to_date(p_from_date)
955: AND location_id IN
956: (SELECT location_id FROM pn_locations_all
957: START WITH (location_id = p_location_id OR

Line 954: AND active_end_date > fnd_date.canonical_to_date(p_from_date)

950: assignable_area
951: FROM pn_locations_all
952: WHERE location_type_lookup_code IN ('SECTION','OFFICE')
953: AND active_start_date < fnd_date.canonical_to_date(p_to_date)
954: AND active_end_date > fnd_date.canonical_to_date(p_from_date)
955: AND location_id IN
956: (SELECT location_id FROM pn_locations_all
957: START WITH (location_id = p_location_id OR
958: (property_id = p_property_id AND p_location_id IS NULL))

Line 973: AND cust.cust_assign_start_date < fnd_date.canonical_to_date(p_to_date)

969: recovery_type_code,
970: recovery_space_std_code
971: FROM pn_space_assign_cust_all cust
972: WHERE cust.location_id = p_location_id
973: AND cust.cust_assign_start_date < fnd_date.canonical_to_date(p_to_date)
974: AND cust.fin_oblig_end_date > fnd_date.canonical_to_date(p_from_date);
975:
976: CURSOR get_uom_info_from_prop(p_property_id pn_locations.property_id%TYPE) IS
977: SELECT uom_code

Line 974: AND cust.fin_oblig_end_date > fnd_date.canonical_to_date(p_from_date);

970: recovery_space_std_code
971: FROM pn_space_assign_cust_all cust
972: WHERE cust.location_id = p_location_id
973: AND cust.cust_assign_start_date < fnd_date.canonical_to_date(p_to_date)
974: AND cust.fin_oblig_end_date > fnd_date.canonical_to_date(p_from_date);
975:
976: CURSOR get_uom_info_from_prop(p_property_id pn_locations.property_id%TYPE) IS
977: SELECT uom_code
978: FROM pn_locations_all

Line 980: AND active_start_date < fnd_date.canonical_to_date(p_to_date)

976: CURSOR get_uom_info_from_prop(p_property_id pn_locations.property_id%TYPE) IS
977: SELECT uom_code
978: FROM pn_locations_all
979: WHERE property_id = p_property_id
980: AND active_start_date < fnd_date.canonical_to_date(p_to_date)
981: AND active_end_date > fnd_date.canonical_to_date(p_from_date);
982:
983: CURSOR get_uom_info_from_locn(p_location_id pn_locations.location_id%TYPE) IS
984: SELECT uom_code

Line 981: AND active_end_date > fnd_date.canonical_to_date(p_from_date);

977: SELECT uom_code
978: FROM pn_locations_all
979: WHERE property_id = p_property_id
980: AND active_start_date < fnd_date.canonical_to_date(p_to_date)
981: AND active_end_date > fnd_date.canonical_to_date(p_from_date);
982:
983: CURSOR get_uom_info_from_locn(p_location_id pn_locations.location_id%TYPE) IS
984: SELECT uom_code
985: FROM pn_locations_all

Line 991: AND active_start_date < fnd_date.canonical_to_date(p_to_date)

987: (SELECT location_id FROM pn_locations_all
988: START WITH location_id = p_location_id
989: CONNECT BY location_id = PRIOR parent_location_id)
990: AND parent_location_id IS NULL
991: AND active_start_date < fnd_date.canonical_to_date(p_to_date)
992: AND active_end_date > fnd_date.canonical_to_date(p_from_date);
993:
994: CURSOR get_ovr_from_curnt IS
995: SELECT dtl.location_id,

Line 992: AND active_end_date > fnd_date.canonical_to_date(p_from_date);

988: START WITH location_id = p_location_id
989: CONNECT BY location_id = PRIOR parent_location_id)
990: AND parent_location_id IS NULL
991: AND active_start_date < fnd_date.canonical_to_date(p_to_date)
992: AND active_end_date > fnd_date.canonical_to_date(p_from_date);
993:
994: CURSOR get_ovr_from_curnt IS
995: SELECT dtl.location_id,
996: dtl.from_date,

Line 1017: AND TRUNC(hdr.as_of_date) = TRUNC(fnd_date.canonical_to_date(p_as_of_date))

1013: pn_rec_arcl_dtl_all hdr,
1014: pn_rec_arcl_all setup
1015: WHERE dtl.area_class_dtl_id (+) = hdr.area_class_dtl_id
1016: AND hdr.area_class_id = p_area_class_id
1017: AND TRUNC(hdr.as_of_date) = TRUNC(fnd_date.canonical_to_date(p_as_of_date))
1018: AND TRUNC(hdr.from_date) = TRUNC(fnd_date.canonical_to_date(p_from_date))
1019: AND TRUNC(hdr.to_date) = TRUNC(fnd_date.canonical_to_date(p_to_date))
1020: AND setup.area_class_id = hdr.area_class_id;
1021:

Line 1018: AND TRUNC(hdr.from_date) = TRUNC(fnd_date.canonical_to_date(p_from_date))

1014: pn_rec_arcl_all setup
1015: WHERE dtl.area_class_dtl_id (+) = hdr.area_class_dtl_id
1016: AND hdr.area_class_id = p_area_class_id
1017: AND TRUNC(hdr.as_of_date) = TRUNC(fnd_date.canonical_to_date(p_as_of_date))
1018: AND TRUNC(hdr.from_date) = TRUNC(fnd_date.canonical_to_date(p_from_date))
1019: AND TRUNC(hdr.to_date) = TRUNC(fnd_date.canonical_to_date(p_to_date))
1020: AND setup.area_class_id = hdr.area_class_id;
1021:
1022: CURSOR get_prior_cls_dtl_id IS

Line 1019: AND TRUNC(hdr.to_date) = TRUNC(fnd_date.canonical_to_date(p_to_date))

1015: WHERE dtl.area_class_dtl_id (+) = hdr.area_class_dtl_id
1016: AND hdr.area_class_id = p_area_class_id
1017: AND TRUNC(hdr.as_of_date) = TRUNC(fnd_date.canonical_to_date(p_as_of_date))
1018: AND TRUNC(hdr.from_date) = TRUNC(fnd_date.canonical_to_date(p_from_date))
1019: AND TRUNC(hdr.to_date) = TRUNC(fnd_date.canonical_to_date(p_to_date))
1020: AND setup.area_class_id = hdr.area_class_id;
1021:
1022: CURSOR get_prior_cls_dtl_id IS
1023: SELECT area_class_dtl_id

Line 1025: WHERE from_date < fnd_date.canonical_to_date(p_to_date)

1021:
1022: CURSOR get_prior_cls_dtl_id IS
1023: SELECT area_class_dtl_id
1024: FROM pn_rec_arcl_dtl_all
1025: WHERE from_date < fnd_date.canonical_to_date(p_to_date)
1026: AND to_date <= fnd_date.canonical_to_date(p_to_date)
1027: AND as_of_date < fnd_date.canonical_to_date(p_as_of_date)
1028: AND area_class_id = p_area_class_id
1029: ORDER BY as_of_date DESC, to_date DESC , from_date DESC;

Line 1026: AND to_date <= fnd_date.canonical_to_date(p_to_date)

1022: CURSOR get_prior_cls_dtl_id IS
1023: SELECT area_class_dtl_id
1024: FROM pn_rec_arcl_dtl_all
1025: WHERE from_date < fnd_date.canonical_to_date(p_to_date)
1026: AND to_date <= fnd_date.canonical_to_date(p_to_date)
1027: AND as_of_date < fnd_date.canonical_to_date(p_as_of_date)
1028: AND area_class_id = p_area_class_id
1029: ORDER BY as_of_date DESC, to_date DESC , from_date DESC;
1030:

Line 1027: AND as_of_date < fnd_date.canonical_to_date(p_as_of_date)

1023: SELECT area_class_dtl_id
1024: FROM pn_rec_arcl_dtl_all
1025: WHERE from_date < fnd_date.canonical_to_date(p_to_date)
1026: AND to_date <= fnd_date.canonical_to_date(p_to_date)
1027: AND as_of_date < fnd_date.canonical_to_date(p_as_of_date)
1028: AND area_class_id = p_area_class_id
1029: ORDER BY as_of_date DESC, to_date DESC , from_date DESC;
1030:
1031: CURSOR get_ovr_from_prior(p_prior_cls_dtl_id pn_rec_arcl_dtl.area_class_dtl_id%TYPE) IS

Line 1263: p_from_date => fnd_date.canonical_to_date(p_from_date),

1259: p_date_table => l_vacancy_date_table,
1260: p_num_table => l_vacancy_num_table,
1261: p_ref_date_table => l_ref_vacancy_date_table,
1262: p_ref_num_table => l_ref_vacancy_num_table,
1263: p_from_date => fnd_date.canonical_to_date(p_from_date),
1264: p_to_date => fnd_date.canonical_to_date(p_to_date),
1265: p_as_of_date => fnd_date.canonical_to_date(p_as_of_date),
1266: p_assignable_area => l_temp_assignable_area,
1267: p_curnt_ovr => l_area_cls_ln_curnt_ovr,

Line 1264: p_to_date => fnd_date.canonical_to_date(p_to_date),

1260: p_num_table => l_vacancy_num_table,
1261: p_ref_date_table => l_ref_vacancy_date_table,
1262: p_ref_num_table => l_ref_vacancy_num_table,
1263: p_from_date => fnd_date.canonical_to_date(p_from_date),
1264: p_to_date => fnd_date.canonical_to_date(p_to_date),
1265: p_as_of_date => fnd_date.canonical_to_date(p_as_of_date),
1266: p_assignable_area => l_temp_assignable_area,
1267: p_curnt_ovr => l_area_cls_ln_curnt_ovr,
1268: p_prior_ovr => l_area_cls_ln_prior_ovr,

Line 1265: p_as_of_date => fnd_date.canonical_to_date(p_as_of_date),

1261: p_ref_date_table => l_ref_vacancy_date_table,
1262: p_ref_num_table => l_ref_vacancy_num_table,
1263: p_from_date => fnd_date.canonical_to_date(p_from_date),
1264: p_to_date => fnd_date.canonical_to_date(p_to_date),
1265: p_as_of_date => fnd_date.canonical_to_date(p_as_of_date),
1266: p_assignable_area => l_temp_assignable_area,
1267: p_curnt_ovr => l_area_cls_ln_curnt_ovr,
1268: p_prior_ovr => l_area_cls_ln_prior_ovr,
1269: p_data_tbl => l_area_cls_ln_data_tbl,

Line 1333: p_from_date => fnd_date.canonical_to_date(p_from_date),

1329:
1330: IF NOT l_meets_criteria THEN l_excl_type := null; END IF;
1331:
1332: get_area_cls_dtl_calc(
1333: p_from_date => fnd_date.canonical_to_date(p_from_date),
1334: p_to_date => fnd_date.canonical_to_date(p_to_date),
1335: p_rec_from_date => l_from_date,
1336: p_rec_to_date => l_to_date,
1337: p_as_of_date => fnd_date.canonical_to_date(p_as_of_date),

Line 1334: p_to_date => fnd_date.canonical_to_date(p_to_date),

1330: IF NOT l_meets_criteria THEN l_excl_type := null; END IF;
1331:
1332: get_area_cls_dtl_calc(
1333: p_from_date => fnd_date.canonical_to_date(p_from_date),
1334: p_to_date => fnd_date.canonical_to_date(p_to_date),
1335: p_rec_from_date => l_from_date,
1336: p_rec_to_date => l_to_date,
1337: p_as_of_date => fnd_date.canonical_to_date(p_as_of_date),
1338: p_assigned_area => space_assign_rec.allocated_area,

Line 1337: p_as_of_date => fnd_date.canonical_to_date(p_as_of_date),

1333: p_from_date => fnd_date.canonical_to_date(p_from_date),
1334: p_to_date => fnd_date.canonical_to_date(p_to_date),
1335: p_rec_from_date => l_from_date,
1336: p_rec_to_date => l_to_date,
1337: p_as_of_date => fnd_date.canonical_to_date(p_as_of_date),
1338: p_assigned_area => space_assign_rec.allocated_area,
1339: p_exc_type_code => l_excl_type,
1340: p_occup_pct => l_occup_pct,
1341: p_weighted_avg => l_weighted_avg,

Line 1516: p_from_date => fnd_date.canonical_to_date(p_from_date),

1512: p_date_table => l_vacancy_date_table,
1513: p_num_table => l_vacancy_num_table,
1514: p_ref_date_table => l_ref_vacancy_date_table,
1515: p_ref_num_table => l_ref_vacancy_num_table,
1516: p_from_date => fnd_date.canonical_to_date(p_from_date),
1517: p_to_date => fnd_date.canonical_to_date(p_to_date),
1518: p_as_of_date => fnd_date.canonical_to_date(p_as_of_date),
1519: p_assignable_area => l_temp_assignable_area,
1520: p_curnt_ovr => l_area_cls_ln_curnt_ovr,

Line 1517: p_to_date => fnd_date.canonical_to_date(p_to_date),

1513: p_num_table => l_vacancy_num_table,
1514: p_ref_date_table => l_ref_vacancy_date_table,
1515: p_ref_num_table => l_ref_vacancy_num_table,
1516: p_from_date => fnd_date.canonical_to_date(p_from_date),
1517: p_to_date => fnd_date.canonical_to_date(p_to_date),
1518: p_as_of_date => fnd_date.canonical_to_date(p_as_of_date),
1519: p_assignable_area => l_temp_assignable_area,
1520: p_curnt_ovr => l_area_cls_ln_curnt_ovr,
1521: p_prior_ovr => l_area_cls_ln_prior_ovr,

Line 1518: p_as_of_date => fnd_date.canonical_to_date(p_as_of_date),

1514: p_ref_date_table => l_ref_vacancy_date_table,
1515: p_ref_num_table => l_ref_vacancy_num_table,
1516: p_from_date => fnd_date.canonical_to_date(p_from_date),
1517: p_to_date => fnd_date.canonical_to_date(p_to_date),
1518: p_as_of_date => fnd_date.canonical_to_date(p_as_of_date),
1519: p_assignable_area => l_temp_assignable_area,
1520: p_curnt_ovr => l_area_cls_ln_curnt_ovr,
1521: p_prior_ovr => l_area_cls_ln_prior_ovr,
1522: p_data_tbl => l_area_cls_ln_data_tbl,

Line 1543: x_as_of_date => fnd_date.canonical_to_date(p_as_of_date),

1539:
1540: pn_rec_arcl_dtl_pkg.update_row(
1541: x_area_class_id => p_area_class_id,
1542: x_area_class_dtl_id => l_area_class_dtl_id,
1543: x_as_of_date => fnd_date.canonical_to_date(p_as_of_date),
1544: x_from_date => fnd_date.canonical_to_date(p_from_date),
1545: x_to_date => fnd_date.canonical_to_date(p_to_date),
1546: x_status => 'OPEN',
1547: x_ttl_assignable_area => l_area_total_tbl(0).total_assignable_area,

Line 1544: x_from_date => fnd_date.canonical_to_date(p_from_date),

1540: pn_rec_arcl_dtl_pkg.update_row(
1541: x_area_class_id => p_area_class_id,
1542: x_area_class_dtl_id => l_area_class_dtl_id,
1543: x_as_of_date => fnd_date.canonical_to_date(p_as_of_date),
1544: x_from_date => fnd_date.canonical_to_date(p_from_date),
1545: x_to_date => fnd_date.canonical_to_date(p_to_date),
1546: x_status => 'OPEN',
1547: x_ttl_assignable_area => l_area_total_tbl(0).total_assignable_area,
1548: x_ttl_occupied_area => l_area_total_tbl(0).total_occupied_area,

Line 1545: x_to_date => fnd_date.canonical_to_date(p_to_date),

1541: x_area_class_id => p_area_class_id,
1542: x_area_class_dtl_id => l_area_class_dtl_id,
1543: x_as_of_date => fnd_date.canonical_to_date(p_as_of_date),
1544: x_from_date => fnd_date.canonical_to_date(p_from_date),
1545: x_to_date => fnd_date.canonical_to_date(p_to_date),
1546: x_status => 'OPEN',
1547: x_ttl_assignable_area => l_area_total_tbl(0).total_assignable_area,
1548: x_ttl_occupied_area => l_area_total_tbl(0).total_occupied_area,
1549: x_ttl_occupied_area_ovr => l_area_total_tbl(0).total_occupied_area_ovr,

Line 1568: x_as_of_date => fnd_date.canonical_to_date(p_as_of_date),

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),
1570: x_to_date => fnd_date.canonical_to_date(p_to_date),
1571: x_status => 'OPEN',
1572: x_ttl_assignable_area => l_area_total_tbl(0).total_assignable_area,

Line 1569: x_from_date => fnd_date.canonical_to_date(p_from_date),

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),
1570: x_to_date => fnd_date.canonical_to_date(p_to_date),
1571: x_status => 'OPEN',
1572: x_ttl_assignable_area => l_area_total_tbl(0).total_assignable_area,
1573: x_ttl_occupied_area => l_area_total_tbl(0).total_occupied_area,

Line 1570: x_to_date => fnd_date.canonical_to_date(p_to_date),

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),
1570: x_to_date => fnd_date.canonical_to_date(p_to_date),
1571: x_status => 'OPEN',
1572: x_ttl_assignable_area => l_area_total_tbl(0).total_assignable_area,
1573: x_ttl_occupied_area => l_area_total_tbl(0).total_occupied_area,
1574: x_ttl_occupied_area_ovr => l_area_total_tbl(0).total_occupied_area_ovr,

Line 2820: WHERE active_start_date < fnd_date.canonical_to_date(p_to_date)

2816: CURSOR get_locn_prop_id IS
2817: SELECT property_id,
2818: location_id
2819: FROM pn_locations_all
2820: WHERE active_start_date < fnd_date.canonical_to_date(p_to_date)
2821: AND active_end_date > fnd_date.canonical_to_date(p_from_date)
2822: START WITH location_id = p_location_id
2823: CONNECT BY location_id = PRIOR parent_location_id;
2824:

Line 2821: AND active_end_date > fnd_date.canonical_to_date(p_from_date)

2817: SELECT property_id,
2818: location_id
2819: FROM pn_locations_all
2820: WHERE active_start_date < fnd_date.canonical_to_date(p_to_date)
2821: AND active_end_date > fnd_date.canonical_to_date(p_from_date)
2822: START WITH location_id = p_location_id
2823: CONNECT BY location_id = PRIOR parent_location_id;
2824:
2825: l_propid pn_rec_exp_line.property_id%TYPE;

Line 2966: WHERE active_start_date < fnd_date.canonical_to_date(p_to_date)

2962: CURSOR get_locn_prop_id IS
2963: SELECT property_id,
2964: location_id
2965: FROM pn_locations_all
2966: WHERE active_start_date < fnd_date.canonical_to_date(p_to_date)
2967: AND active_end_date > fnd_date.canonical_to_date(p_from_date)
2968: START WITH location_id = p_location_id
2969: CONNECT BY location_id = PRIOR parent_location_id;
2970:

Line 2967: AND active_end_date > fnd_date.canonical_to_date(p_from_date)

2963: SELECT property_id,
2964: location_id
2965: FROM pn_locations_all
2966: WHERE active_start_date < fnd_date.canonical_to_date(p_to_date)
2967: AND active_end_date > fnd_date.canonical_to_date(p_from_date)
2968: START WITH location_id = p_location_id
2969: CONNECT BY location_id = PRIOR parent_location_id;
2970:
2971: l_propid pn_rec_exp_line.property_id%TYPE;

Line 3256: WHERE locn.active_start_date < fnd_date.canonical_to_date(p_to_date)

3252: cust.recovery_type_code
3253: FROM pn_space_assign_cust_all cust
3254: WHERE cust.location_id IN
3255: (SELECT location_id FROM pn_locations_all locn
3256: WHERE locn.active_start_date < fnd_date.canonical_to_date(p_to_date)
3257: AND locn.active_end_date > fnd_date.canonical_to_date(p_from_date))
3258: AND cust.cust_assign_start_date < fnd_date.canonical_to_date(p_to_date)
3259: AND cust.fin_oblig_end_date > fnd_date.canonical_to_date(p_from_date)
3260: AND cust.recovery_space_std_code = p_rec_spc_std_code

Line 3257: AND locn.active_end_date > fnd_date.canonical_to_date(p_from_date))

3253: FROM pn_space_assign_cust_all cust
3254: WHERE cust.location_id IN
3255: (SELECT location_id FROM pn_locations_all locn
3256: WHERE locn.active_start_date < fnd_date.canonical_to_date(p_to_date)
3257: AND locn.active_end_date > fnd_date.canonical_to_date(p_from_date))
3258: AND cust.cust_assign_start_date < fnd_date.canonical_to_date(p_to_date)
3259: AND cust.fin_oblig_end_date > fnd_date.canonical_to_date(p_from_date)
3260: AND cust.recovery_space_std_code = p_rec_spc_std_code
3261: AND cust.recovery_type_code = p_rec_type_code

Line 3258: AND cust.cust_assign_start_date < fnd_date.canonical_to_date(p_to_date)

3254: WHERE cust.location_id IN
3255: (SELECT location_id FROM pn_locations_all locn
3256: WHERE locn.active_start_date < fnd_date.canonical_to_date(p_to_date)
3257: AND locn.active_end_date > fnd_date.canonical_to_date(p_from_date))
3258: AND cust.cust_assign_start_date < fnd_date.canonical_to_date(p_to_date)
3259: AND cust.fin_oblig_end_date > fnd_date.canonical_to_date(p_from_date)
3260: AND cust.recovery_space_std_code = p_rec_spc_std_code
3261: AND cust.recovery_type_code = p_rec_type_code
3262: AND cust.location_id IN

Line 3259: AND cust.fin_oblig_end_date > fnd_date.canonical_to_date(p_from_date)

3255: (SELECT location_id FROM pn_locations_all locn
3256: WHERE locn.active_start_date < fnd_date.canonical_to_date(p_to_date)
3257: AND locn.active_end_date > fnd_date.canonical_to_date(p_from_date))
3258: AND cust.cust_assign_start_date < fnd_date.canonical_to_date(p_to_date)
3259: AND cust.fin_oblig_end_date > fnd_date.canonical_to_date(p_from_date)
3260: AND cust.recovery_space_std_code = p_rec_spc_std_code
3261: AND cust.recovery_type_code = p_rec_type_code
3262: AND cust.location_id IN
3263: (SELECT location_id FROM pn_locations_all

Line 3809: l_from_date := fnd_date.canonical_to_date(p_from_date);

3805:
3806: l_info := ' validating inputs ';
3807: pnp_debug_pkg.log(l_info);
3808:
3809: l_from_date := fnd_date.canonical_to_date(p_from_date);
3810: l_to_date := fnd_date.canonical_to_date(p_to_date);
3811: l_as_of_date:= fnd_date.canonical_to_date(p_as_of_date);
3812: l_extract_code := p_extract_code;
3813:

Line 3810: l_to_date := fnd_date.canonical_to_date(p_to_date);

3806: l_info := ' validating inputs ';
3807: pnp_debug_pkg.log(l_info);
3808:
3809: l_from_date := fnd_date.canonical_to_date(p_from_date);
3810: l_to_date := fnd_date.canonical_to_date(p_to_date);
3811: l_as_of_date:= fnd_date.canonical_to_date(p_as_of_date);
3812: l_extract_code := p_extract_code;
3813:
3814: IF p_location_code IS NOT NULL THEN

Line 3811: l_as_of_date:= fnd_date.canonical_to_date(p_as_of_date);

3807: pnp_debug_pkg.log(l_info);
3808:
3809: l_from_date := fnd_date.canonical_to_date(p_from_date);
3810: l_to_date := fnd_date.canonical_to_date(p_to_date);
3811: l_as_of_date:= fnd_date.canonical_to_date(p_as_of_date);
3812: l_extract_code := p_extract_code;
3813:
3814: IF p_location_code IS NOT NULL THEN
3815: FOR loc_rec IN derive_loc_id_from_loc_code LOOP

Line 3986: l_from_date := fnd_date.canonical_to_date(p_from_date);

3982: l_info := ' figuring expense extract code';
3983: pnp_debug_pkg.log(l_info);
3984: l_extract_code := p_extract_code;
3985: l_transfer_flag := p_transfer_flag;
3986: l_from_date := fnd_date.canonical_to_date(p_from_date);
3987: l_to_date := fnd_date.canonical_to_date(p_to_date);
3988:
3989:
3990: IF p_extract_code IS NOT NULL THEN

Line 3987: l_to_date := fnd_date.canonical_to_date(p_to_date);

3983: pnp_debug_pkg.log(l_info);
3984: l_extract_code := p_extract_code;
3985: l_transfer_flag := p_transfer_flag;
3986: l_from_date := fnd_date.canonical_to_date(p_from_date);
3987: l_to_date := fnd_date.canonical_to_date(p_to_date);
3988:
3989:
3990: IF p_extract_code IS NOT NULL THEN
3991: