APPS.PN_CC_SYNC_PKG dependencies on PN_LOCATIONS

Line 49: p_locn_type IN pn_locations.location_type_lookup_code%TYPE,

45: PROCEDURE cc_sync_with_hr (
46: errbuf OUT NOCOPY VARCHAR2,
47: retcode OUT NOCOPY VARCHAR2,
48: p_as_of_date IN VARCHAR2,
49: p_locn_type IN pn_locations.location_type_lookup_code%TYPE,
50: p_locn_code_from IN pn_locations.location_code%TYPE,
51: p_locn_code_to IN pn_locations.location_code%TYPE,
52: p_emp_cost_center IN pn_space_assign_emp.cost_center_code%TYPE
53: ) IS

Line 50: p_locn_code_from IN pn_locations.location_code%TYPE,

46: errbuf OUT NOCOPY VARCHAR2,
47: retcode OUT NOCOPY VARCHAR2,
48: p_as_of_date IN VARCHAR2,
49: p_locn_type IN pn_locations.location_type_lookup_code%TYPE,
50: p_locn_code_from IN pn_locations.location_code%TYPE,
51: p_locn_code_to IN pn_locations.location_code%TYPE,
52: p_emp_cost_center IN pn_space_assign_emp.cost_center_code%TYPE
53: ) IS
54:

Line 51: p_locn_code_to IN pn_locations.location_code%TYPE,

47: retcode OUT NOCOPY VARCHAR2,
48: p_as_of_date IN VARCHAR2,
49: p_locn_type IN pn_locations.location_type_lookup_code%TYPE,
50: p_locn_code_from IN pn_locations.location_code%TYPE,
51: p_locn_code_to IN pn_locations.location_code%TYPE,
52: p_emp_cost_center IN pn_space_assign_emp.cost_center_code%TYPE
53: ) IS
54:
55:

Line 77: l_location_code pn_locations.location_code%TYPE;

73: l_err_msg1 VARCHAR2(2000);
74: l_source_id VARCHAR2(30) := 'PNCCSYNC';
75: l_batch_size NUMBER := 5000 ;
76: l_emp_name per_people_f.full_name%TYPE;
77: l_location_code pn_locations.location_code%TYPE;
78: l_success_msg VARCHAR2(1000) := NULL;
79: l_failure_msg VARCHAR2(1000) := NULL;
80: i NUMBER := 0;
81: l_errbuf VARCHAR2(200) := NULL ;

Line 252: l_where_clause := l_where_clause || ' AND location_id IN (SELECT location_id FROM pn_locations ' ;

248: ' AND cost_center_code = :l_emp_cost_center ';
249:
250: END IF;
251:
252: l_where_clause := l_where_clause || ' AND location_id IN (SELECT location_id FROM pn_locations ' ;
253: l_where_clause := l_where_clause || l_where_clause_loc;
254: l_where_clause := l_where_clause|| ' )';
255: l_where_clause := l_where_clause || ' ORDER BY person_id ';
256: l_query := l_query || l_where_clause ;