APPS.PN_CC_SYNC_PKG dependencies on PN_SPACE_ASSIGN_EMP

Line 17: | pn_space_assign_emp_pkg.update_row

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
21: | p_locn_type

Line 35: | PN_SPACE_ASSIGN_EMP_PKG.Update_Row to pass

31: | 13-NOV-03 Vikas Mehta Created
32: | 26-OCT-05 Hareesha o ATG mandated changes for SQL literals using
33: | dbms_sql.
34: | 04-APR-06 Hareesha o Bug 5119241 Modified call to
35: | PN_SPACE_ASSIGN_EMP_PKG.Update_Row to pass
36: | new CC.
37: | 30-JUN-06 Hareesha o Bug #5262982 Select org_id too in the query
38: | along with all other columns.The new record
39: | created was not being populated with org_id.

Line 52: p_emp_cost_center IN pn_space_assign_emp.cost_center_code%TYPE

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:
56: asg_rec pn_space_assign_emp_ALL%ROWTYPE;

Line 56: asg_rec pn_space_assign_emp_ALL%ROWTYPE;

52: p_emp_cost_center IN pn_space_assign_emp.cost_center_code%TYPE
53: ) IS
54:
55:
56: asg_rec pn_space_assign_emp_ALL%ROWTYPE;
57: l_query VARCHAR2(2000);
58: l_where_clause VARCHAR2(2000);
59: l_where_clause_loc VARCHAR2(2000) := NULL;
60: l_count_total NUMBER := 0;

Line 68: l_person_id pn_space_assign_emp.person_id%TYPE := 0 ;

64: l_log_context VARCHAR2(2000);
65: l_desc VARCHAR2(100) := 'pn_cc_sync_pkg.cc_sync_with_hr';
66: l_as_of_date DATE;
67: l_cost_center VARCHAR2(30) := NULL;
68: l_person_id pn_space_assign_emp.person_id%TYPE := 0 ;
69: l_column_name VARCHAR2(30) := NULL;
70: l_last_person_processed pn_space_assign_emp.person_id%TYPE := 0 ;
71: l_last_updated_by pn_space_assign_emp.last_updated_by%TYPE ;
72: l_last_update_login pn_space_assign_emp.last_update_login%TYPE ;

Line 70: l_last_person_processed pn_space_assign_emp.person_id%TYPE := 0 ;

66: l_as_of_date DATE;
67: l_cost_center VARCHAR2(30) := NULL;
68: l_person_id pn_space_assign_emp.person_id%TYPE := 0 ;
69: l_column_name VARCHAR2(30) := NULL;
70: l_last_person_processed pn_space_assign_emp.person_id%TYPE := 0 ;
71: l_last_updated_by pn_space_assign_emp.last_updated_by%TYPE ;
72: l_last_update_login pn_space_assign_emp.last_update_login%TYPE ;
73: l_err_msg1 VARCHAR2(2000);
74: l_source_id VARCHAR2(30) := 'PNCCSYNC';

Line 71: l_last_updated_by pn_space_assign_emp.last_updated_by%TYPE ;

67: l_cost_center VARCHAR2(30) := NULL;
68: l_person_id pn_space_assign_emp.person_id%TYPE := 0 ;
69: l_column_name VARCHAR2(30) := NULL;
70: l_last_person_processed pn_space_assign_emp.person_id%TYPE := 0 ;
71: l_last_updated_by pn_space_assign_emp.last_updated_by%TYPE ;
72: l_last_update_login pn_space_assign_emp.last_update_login%TYPE ;
73: l_err_msg1 VARCHAR2(2000);
74: l_source_id VARCHAR2(30) := 'PNCCSYNC';
75: l_batch_size NUMBER := 5000 ;

Line 72: l_last_update_login pn_space_assign_emp.last_update_login%TYPE ;

68: l_person_id pn_space_assign_emp.person_id%TYPE := 0 ;
69: l_column_name VARCHAR2(30) := NULL;
70: l_last_person_processed pn_space_assign_emp.person_id%TYPE := 0 ;
71: l_last_updated_by pn_space_assign_emp.last_updated_by%TYPE ;
72: l_last_update_login pn_space_assign_emp.last_update_login%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;

Line 92: x_last_person_processed pn_space_assign_emp.person_id%TYPE := 0 ;

88: l_locn_code_from VARCHAR2(90);
89: l_locn_code_to VARCHAR2(90);
90: l_locn_type VARCHAR2(30);
91: l_emp_cost_center VARCHAR2(30);
92: x_last_person_processed pn_space_assign_emp.person_id%TYPE := 0 ;
93:
94:
95: CURSOR get_emp_name (p_employee_id IN NUMBER, p_as_of_date DATE) IS
96: SELECT

Line 238: FROM PN_SPACE_ASSIGN_EMP ';

234: ,ATTRIBUTE13
235: ,ATTRIBUTE14
236: ,ATTRIBUTE15
237: ,ORG_ID
238: FROM PN_SPACE_ASSIGN_EMP ';
239:
240: x_last_person_processed := l_last_person_processed ;
241: l_where_clause := ' WHERE :x_as_of_date BETWEEN trunc(emp_assign_start_date) AND
242: trunc(NVL(emp_assign_end_date, TO_DATE(''12/31/4712'', ''MM/DD/YYYY'')))

Line 386: PN_SPACE_ASSIGN_EMP_PKG.tlempinfo := asg_rec;

382: dbms_sql.column_value (l_cursor, 33,asg_rec.ATTRIBUTE15);
383: dbms_sql.column_value (l_cursor, 34,asg_rec.ORG_ID);
384: l_log_context := 'opening cursor ';
385:
386: PN_SPACE_ASSIGN_EMP_PKG.tlempinfo := asg_rec;
387:
388:
389: /* Get cost center from HR */
390: IF l_person_id <> asg_rec.person_id THEN

Line 429: PN_SPACE_ASSIGN_EMP_PKG.tlempinfo := asg_rec;

425:
426:
427: BEGIN
428:
429: PN_SPACE_ASSIGN_EMP_PKG.tlempinfo := asg_rec;
430:
431: /* Check if assignmnet start date is same as as_of_date.
432: We do not need to insert new record but only need to update cost ceneter in this case. */
433:

Line 438: PN_SPACE_ASSIGN_EMP_PKG.Update_Row(

434: IF l_as_of_date = trunc(asg_rec.emp_assign_start_date) THEN
435:
436: /* Call Update_Row in CORRECT mode */
437:
438: PN_SPACE_ASSIGN_EMP_PKG.Update_Row(
439: asg_rec.emp_space_assign_id,
440: asg_rec.attribute1,
441: asg_rec.attribute2,
442: asg_rec.attribute3,

Line 480: PN_SPACE_ASSIGN_EMP_PKG.tlempinfo.source := l_source_id || '_' || asg_rec.emp_space_assign_id ;

476: ELSE
477: /* Need to update current record and insert new record
478: Call Update_Row in UPDATE mode */
479:
480: PN_SPACE_ASSIGN_EMP_PKG.tlempinfo.source := l_source_id || '_' || asg_rec.emp_space_assign_id ;
481:
482: PN_SPACE_ASSIGN_EMP_PKG.Update_Row(
483: asg_rec.emp_space_assign_id,
484: asg_rec.attribute1,

Line 482: PN_SPACE_ASSIGN_EMP_PKG.Update_Row(

478: Call Update_Row in UPDATE mode */
479:
480: PN_SPACE_ASSIGN_EMP_PKG.tlempinfo.source := l_source_id || '_' || asg_rec.emp_space_assign_id ;
481:
482: PN_SPACE_ASSIGN_EMP_PKG.Update_Row(
483: asg_rec.emp_space_assign_id,
484: asg_rec.attribute1,
485: asg_rec.attribute2,
486: asg_rec.attribute3,