APPS.PQP_GB_PSI_FUNCTIONS dependencies on PQP_GB_PSI_ALLOWANCE_HISTORY

Line 6854: OPEN PQP_GB_PSI_ALLOWANCE_HISTORY.csr_get_entry_value

6850:
6851: debug('now fetch the claim date for this element',75);
6852:
6853: IF l_is_spread_bonus_yn = 'Y' THEN
6854: OPEN PQP_GB_PSI_ALLOWANCE_HISTORY.csr_get_entry_value
6855: (c_effective_date => g_effective_date
6856: ,c_element_entry_id => p_ext_pay_element_entry
6857: ,c_input_value => 'CLAIM DATE' -- DEFAULT 'PAY VALUE'
6858: );

Line 6859: FETCH PQP_GB_PSI_ALLOWANCE_HISTORY.csr_get_entry_value INTO l_claim_date;

6855: (c_effective_date => g_effective_date
6856: ,c_element_entry_id => p_ext_pay_element_entry
6857: ,c_input_value => 'CLAIM DATE' -- DEFAULT 'PAY VALUE'
6858: );
6859: FETCH PQP_GB_PSI_ALLOWANCE_HISTORY.csr_get_entry_value INTO l_claim_date;
6860: IF PQP_GB_PSI_ALLOWANCE_HISTORY.csr_get_entry_value%NOTFOUND
6861: OR l_claim_date IS NULL
6862: THEN
6863: l_return := raise_extract_error

Line 6860: IF PQP_GB_PSI_ALLOWANCE_HISTORY.csr_get_entry_value%NOTFOUND

6856: ,c_element_entry_id => p_ext_pay_element_entry
6857: ,c_input_value => 'CLAIM DATE' -- DEFAULT 'PAY VALUE'
6858: );
6859: FETCH PQP_GB_PSI_ALLOWANCE_HISTORY.csr_get_entry_value INTO l_claim_date;
6860: IF PQP_GB_PSI_ALLOWANCE_HISTORY.csr_get_entry_value%NOTFOUND
6861: OR l_claim_date IS NULL
6862: THEN
6863: l_return := raise_extract_error
6864: (p_error_number => 94532

Line 6879: ,p_assg_start_date => PQP_GB_PSI_ALLOWANCE_HISTORY.g_assg_start_date

6875: IF is_proper_claim_date -- function to check valid claim date
6876: (p_claim_date => fnd_date.canonical_to_date(l_claim_date)
6877: ,p_element_name => g_elements_of_info_type(p_ext_pay_element_type).element_name
6878: ,p_element_entry_id => p_ext_pay_element_entry
6879: ,p_assg_start_date => PQP_GB_PSI_ALLOWANCE_HISTORY.g_assg_start_date
6880: )
6881: THEN
6882: g_curr_element_type_id := p_ext_pay_element_type;
6883: g_curr_element_entry_id := p_ext_pay_element_entry;

Line 6892: CLOSE PQP_GB_PSI_ALLOWANCE_HISTORY.csr_get_entry_value;

6888: p_output := 'N'; -- either not a spread bonus, or claim date didnt qualify
6889: debug('either not a spread bonus, or claim date didnt qualify',110);
6890: END IF;
6891: END IF;
6892: CLOSE PQP_GB_PSI_ALLOWANCE_HISTORY.csr_get_entry_value;
6893:
6894: END IF;
6895:
6896: ELSE -- IF g_is_terminated = 'N' and not a spread bonus