DBA Data[Home] [Help]

APPS.HR_JP_ID_PKG dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 698: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ORG_PAYMENT_METHODS_F%ROWTYPE

694: FUNCTION org_payment_method_rec(
695: p_org_payment_method_name IN VARCHAR2,
696: p_business_group_id IN NUMBER,
697: p_effective_date IN DATE DEFAULT hr_api.g_sys,
698: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ORG_PAYMENT_METHODS_F%ROWTYPE
699: --------------------------------------------------------------------------------
700: IS
701: l_csr RefCsr;
702: l_rec PAY_ORG_PAYMENT_METHODS_F%ROWTYPE;

Line 702: l_rec PAY_ORG_PAYMENT_METHODS_F%ROWTYPE;

698: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ORG_PAYMENT_METHODS_F%ROWTYPE
699: --------------------------------------------------------------------------------
700: IS
701: l_csr RefCsr;
702: l_rec PAY_ORG_PAYMENT_METHODS_F%ROWTYPE;
703: BEGIN
704: l_csr := csr_with_bus('PAY_ORG_PAYMENT_METHODS_F','ORG_PAYMENT_METHOD_NAME','T',p_org_payment_method_name,p_business_group_id,'DATETRACKED',p_effective_date);
705: fetch l_csr into l_rec;
706: if not csr_found_and_close(l_csr,p_error_when_not_exist) then

Line 704: l_csr := csr_with_bus('PAY_ORG_PAYMENT_METHODS_F','ORG_PAYMENT_METHOD_NAME','T',p_org_payment_method_name,p_business_group_id,'DATETRACKED',p_effective_date);

700: IS
701: l_csr RefCsr;
702: l_rec PAY_ORG_PAYMENT_METHODS_F%ROWTYPE;
703: BEGIN
704: l_csr := csr_with_bus('PAY_ORG_PAYMENT_METHODS_F','ORG_PAYMENT_METHOD_NAME','T',p_org_payment_method_name,p_business_group_id,'DATETRACKED',p_effective_date);
705: fetch l_csr into l_rec;
706: if not csr_found_and_close(l_csr,p_error_when_not_exist) then
707: l_rec := NULL;
708: end if;