APPS.HR_JP_ID_PKG dependencies on PAY_ORG_PAY_METHOD_USAGES_F

Line 2264: P_ERROR_WHEN_NOT_EXIST IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ORG_PAY_METHOD_USAGES_F%ROWTYPE

2260: FUNCTION org_pay_method_usage_rec(
2261: P_PAYROLL_ID IN NUMBER,
2262: P_ORG_PAYMENT_METHOD_ID IN NUMBER,
2263: P_EFFECTIVE_DATE IN DATE DEFAULT hr_api.g_sys,
2264: P_ERROR_WHEN_NOT_EXIST IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ORG_PAY_METHOD_USAGES_F%ROWTYPE
2265: --------------------------------------------------------------------------------
2266: IS
2267: l_unique_column_tbl UniColTbl;
2268: l_csr RefCsr;

Line 2269: l_rec PAY_ORG_PAY_METHOD_USAGES_F%ROWTYPE;

2265: --------------------------------------------------------------------------------
2266: IS
2267: l_unique_column_tbl UniColTbl;
2268: l_csr RefCsr;
2269: l_rec PAY_ORG_PAY_METHOD_USAGES_F%ROWTYPE;
2270: BEGIN
2271: unique_tbl_constructor('PAYROLL_ID','N',to_char(p_payroll_id),l_unique_column_tbl);
2272: unique_tbl_constructor('ORG_PAYMENT_METHOD_ID','N',to_char(p_org_payment_method_id),l_unique_column_tbl);
2273: l_csr := csr('PAY_ORG_PAY_METHOD_USAGES_F',l_unique_column_tbl,'DATETRACKED',p_effective_date);

Line 2273: l_csr := csr('PAY_ORG_PAY_METHOD_USAGES_F',l_unique_column_tbl,'DATETRACKED',p_effective_date);

2269: l_rec PAY_ORG_PAY_METHOD_USAGES_F%ROWTYPE;
2270: BEGIN
2271: unique_tbl_constructor('PAYROLL_ID','N',to_char(p_payroll_id),l_unique_column_tbl);
2272: unique_tbl_constructor('ORG_PAYMENT_METHOD_ID','N',to_char(p_org_payment_method_id),l_unique_column_tbl);
2273: l_csr := csr('PAY_ORG_PAY_METHOD_USAGES_F',l_unique_column_tbl,'DATETRACKED',p_effective_date);
2274: fetch l_csr into l_rec;
2275: if l_csr%NOTFOUND then
2276: if p_error_when_not_exist = 'TRUE' then
2277: close l_csr;