APPS.PER_ES_SS_REP_DYN_TRG dependencies on PER_ES_SS_REP_DYN_TRG

Line 1: PACKAGE BODY PER_ES_SS_REP_DYN_TRG AS

1: PACKAGE BODY PER_ES_SS_REP_DYN_TRG AS
2: /* $Header: peesssdy.pkb 115.3 2004/03/16 23:12:42 srjanard noship $ */
3:
4: -----------------------------------------------------
5: --GET_ASSIGNMENT_ID

Line 340: l_assg_id := PER_ES_SS_REP_DYN_TRG.get_assignment_id(p_element_entry_id);

336: FETCH csr_input_value_id INTO l_input_value_id;
337: CLOSE csr_input_value_id;
338:
339: IF p_input_value_id = l_input_value_id THEN
340: l_assg_id := PER_ES_SS_REP_DYN_TRG.get_assignment_id(p_element_entry_id);
341: OPEN csr_primary_flag_value(l_assg_id,p_effective_start_date);
342: FETCH csr_primary_flag_value INTO l_primary_flag,l_assignment_type ;
343: CLOSE csr_primary_flag_value;
344: IF l_assignment_type = 'E' AND l_primary_flag = 'Y' THEN

Line 460: l_assignment_id := PER_ES_SS_REP_DYN_TRG.get_assignment_id(P_ELEMENT_ENTRY_ID);

456: OPEN csr_input_value_id('SS Epigraph Code');
457: FETCH csr_input_value_id INTO l_input_value_id;
458: CLOSE csr_input_value_id;
459: IF p_input_value_id = l_input_value_id THEN
460: l_assignment_id := PER_ES_SS_REP_DYN_TRG.get_assignment_id(P_ELEMENT_ENTRY_ID);
461: OPEN csr_primary_flag_value(l_assignment_id,p_effective_start_date);
462: FETCH csr_primary_flag_value INTO l_primary_flag,l_assignment_type ;
463: CLOSE csr_primary_flag_value;
464: IF l_assignment_type = 'E' AND l_primary_flag = 'Y' THEN

Line 486: l_assignment_id := PER_ES_SS_REP_DYN_TRG.get_assignment_id(P_ELEMENT_ENTRY_ID);

482: OPEN csr_input_value_id('Contract Key');
483: FETCH csr_input_value_id INTO l_input_value_id;
484: CLOSE csr_input_value_id;
485: IF p_input_value_id = l_input_value_id THEN
486: l_assignment_id := PER_ES_SS_REP_DYN_TRG.get_assignment_id(P_ELEMENT_ENTRY_ID);
487: OPEN csr_primary_flag_value(l_assignment_id,p_effective_start_date);
488: FETCH csr_primary_flag_value INTO l_primary_flag,l_assignment_type ;
489: CLOSE csr_primary_flag_value;
490: IF l_assignment_type = 'E' AND l_primary_flag = 'Y' THEN

Line 508: END PER_ES_SS_REP_DYN_TRG;

504: END LOOP;
505: END IF;
506: END IF;
507: END element_check_update;
508: END PER_ES_SS_REP_DYN_TRG;