APPS.PN_CC_SYNC_PKG dependencies on PNP_UTIL_FUNC

Line 15: | pnp_util_func.get_segment_column_name

11: |
12: | SCOPE - PUBLIC
13: |
14: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
15: | pnp_util_func.get_segment_column_name
16: | pnp_util_func.get_location_code
17: | pn_space_assign_emp_pkg.update_row
18: |
19: | ARGUMENTS : IN:

Line 16: | pnp_util_func.get_location_code

12: | SCOPE - PUBLIC
13: |
14: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
15: | pnp_util_func.get_segment_column_name
16: | pnp_util_func.get_location_code
17: | pn_space_assign_emp_pkg.update_row
18: |
19: | ARGUMENTS : IN:
20: | p_as_of_date

Line 137: l_column_name := pnp_util_func.get_segment_column_name(pn_mo_cache_utils.get_current_org_id);

133: l_last_updated_by := nvl(fnd_profile.VALUE ('USER_ID'), 0);
134: l_last_update_login := nvl(fnd_profile.value('LOGIN_ID'),0);
135:
136: l_log_context := ' Getting segment column ' ;
137: l_column_name := pnp_util_func.get_segment_column_name(pn_mo_cache_utils.get_current_org_id);
138:
139: l_log_context := ' Defining sub-query for location ';
140:
141: l_cursor := dbms_sql.open_cursor;

Line 414: rpad(pnp_util_func.get_location_code(asg_rec.location_id, l_as_of_date), 30, ' ') ||

410: l_err_msg1 := fnd_message.get;
411: l_failure_msg := rpad(nvl(l_emp_name,' '), 50, ' ') ||
412: rpad(asg_rec.emp_assign_start_date, 15, ' ') ||
413: rpad(nvl(to_char(asg_rec.emp_assign_end_date),' '), 15, ' ') ||
414: rpad(pnp_util_func.get_location_code(asg_rec.location_id, l_as_of_date), 30, ' ') ||
415: rpad(asg_rec.cost_center_code, 30, ' ') ||
416: l_err_msg1 ;
417: failure_table(failure_table.COUNT) := l_failure_msg;
418: l_count_failure := l_count_failure + 1;

Line 526: rpad(pnp_util_func.get_location_code(asg_rec.location_id, l_as_of_date), 30, ' ') ||

522:
523: l_success_msg := rpad(nvl(l_emp_name, ' '), 50, ' ') ||
524: rpad(l_as_of_date, 15, ' ') ||
525: rpad(nvl(to_char(asg_rec.emp_assign_end_date),' '), 15, ' ') ||
526: rpad(pnp_util_func.get_location_code(asg_rec.location_id, l_as_of_date), 30, ' ') ||
527: rpad(asg_rec.cost_center_code, 30, ' ') ||
528: rpad(l_cost_center, 30, ' ') ;
529:
530: success_table(success_table.COUNT) := l_success_msg;

Line 555: rpad(pnp_util_func.get_location_code(asg_rec.location_id, l_as_of_date), 30, ' ') ||

551: l_err_msg1 := SQLERRM || ' : ' || SQLCODE ;
552: l_failure_msg := rpad(nvl(l_emp_name, ' '), 50, ' ') ||
553: rpad(asg_rec.emp_assign_start_date, 15, ' ') ||
554: rpad(nvl(to_char(asg_rec.emp_assign_end_date),' '), 15, ' ') ||
555: rpad(pnp_util_func.get_location_code(asg_rec.location_id, l_as_of_date), 30, ' ') ||
556: rpad(asg_rec.cost_center_code, 30, ' ')
557: || l_err_msg1 ;
558: failure_table(failure_table.COUNT) := l_failure_msg;
559: l_count_failure := l_count_failure + 1;

Line 709: | pnp_util_func.get_segment_column_name

705: |
706: | SCOPE - PUBLIC
707: |
708: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
709: | pnp_util_func.get_segment_column_name
710: |
711: | ARGUMENTS : IN:
712: | p_employee_id
713: | p_column_name

Line 779: l_column_name := pnp_util_func.get_segment_column_name(pn_mo_cache_utils.get_current_org_id);

775:
776: BEGIN
777:
778: IF p_column_name IS NULL THEN
779: l_column_name := pnp_util_func.get_segment_column_name(pn_mo_cache_utils.get_current_org_id);
780: ELSE
781: l_column_name := p_column_name;
782: END IF;
783: