DBA Data[Home] [Help]

APPS.PQP_GB_PSI_FUNCTIONS dependencies on PQP_ASSIGNMENT_ATTRIBUTES_F

Line 7260: OR (l_chg_table = 'PQP_ASSIGNMENT_ATTRIBUTES_F'

7256: END IF;
7257:
7258: IF (l_chg_table = 'PER_ALL_ASSIGNMENTS_F'
7259: AND (l_chg_column_name IN ('GRADE_ID','NORMAL_HOURS') OR l_chg_type = 'I'))
7260: OR (l_chg_table = 'PQP_ASSIGNMENT_ATTRIBUTES_F'
7261: AND (l_chg_column_name = 'CONTRACT_TYPE' OR l_chg_type = 'I'))
7262: OR (l_chg_table = 'PAY_ELEMENT_ENTRIES_F'
7263: AND l_chg_type <> 'E')
7264: OR (l_chg_table = 'PAY_ELEMENT_ENTRY_VALUES_F') THEN

Line 7614: OR (l_chg_table = 'PQP_ASSIGNMENT_ATTRIBUTES_F'

7610: --Bug 7611963: End
7611:
7612: ELSIF (l_chg_table = 'PER_ALL_ASSIGNMENTS_F'
7613: AND (l_chg_column_name IN ('GRADE_ID','NORMAL_HOURS') OR l_update_type = 'I'))
7614: OR (l_chg_table = 'PQP_ASSIGNMENT_ATTRIBUTES_F'
7615: AND (l_chg_column_name = 'CONTRACT_TYPE' OR l_update_type = 'I'))
7616: OR (l_chg_table = 'PAY_ELEMENT_ENTRY_VALUES_F') THEN
7617:
7618: l_other_event_exist := 'Y';

Line 7807: OR (l_chg_table = 'PQP_ASSIGNMENT_ATTRIBUTES_F'

7803: AND l_chg_type <> 'E')
7804: OR (l_chg_table = 'PAY_ELEMENT_ENTRY_VALUES_F')
7805: OR (l_chg_table = 'PER_ALL_ASSIGNMENTS_F'
7806: AND (l_chg_column_name IN ('GRADE_ID','NORMAL_HOURS','EMPLOYMENT_CATEGORY',l_configured_dff_segment) OR l_chg_type = 'I'))
7807: OR (l_chg_table = 'PQP_ASSIGNMENT_ATTRIBUTES_F'
7808: AND (l_chg_column_name = 'CONTRACT_TYPE' OR l_chg_type = 'I'))THEN
7809:
7810: debug('Returning Y');
7811: debug_exit(l_proc);

Line 8079: l_contract_type pqp_assignment_attributes_f.contract_type%type;

8075: ,p_contract_type OUT NOCOPY VARCHAR2
8076: ) RETURN NUMBER
8077: IS
8078: l_proc varchar2(72) := g_proc_name||'.get_contract_type';
8079: l_contract_type pqp_assignment_attributes_f.contract_type%type;
8080: l_work_pattern pqp_assignment_attributes_f.work_pattern%type;
8081: l_period_divisor VARCHAR2(10);
8082: l_error_msg VARCHAR2(100);
8083: l_err_no NUMBER;

Line 8080: l_work_pattern pqp_assignment_attributes_f.work_pattern%type;

8076: ) RETURN NUMBER
8077: IS
8078: l_proc varchar2(72) := g_proc_name||'.get_contract_type';
8079: l_contract_type pqp_assignment_attributes_f.contract_type%type;
8080: l_work_pattern pqp_assignment_attributes_f.work_pattern%type;
8081: l_period_divisor VARCHAR2(10);
8082: l_error_msg VARCHAR2(100);
8083: l_err_no NUMBER;
8084: l_error NUMBER;