APPS.HR_JP_ID_PKG dependencies on PAY_PAYMENT_TYPES

Line 1730: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_PAYMENT_TYPES%ROWTYPE

1726: --------------------------------------------------------------------------------
1727: FUNCTION payment_type_rec(
1728: p_payment_type_name IN VARCHAR2,
1729: p_territory_code IN VARCHAR2 DEFAULT NULL,
1730: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_PAYMENT_TYPES%ROWTYPE
1731: --------------------------------------------------------------------------------
1732: IS
1733: l_unique_column_tbl UniColTbl;
1734: l_csr RefCsr;

Line 1735: l_rec PAY_PAYMENT_TYPES%ROWTYPE;

1731: --------------------------------------------------------------------------------
1732: IS
1733: l_unique_column_tbl UniColTbl;
1734: l_csr RefCsr;
1735: l_rec PAY_PAYMENT_TYPES%ROWTYPE;
1736: BEGIN
1737: unique_tbl_constructor('PAYMENT_TYPE_NAME','T',p_payment_type_name,l_unique_column_tbl);
1738: if p_territory_code = C_DEFAULT_LEG then
1739: NULL;

Line 1744: l_csr := csr('PAY_PAYMENT_TYPES',l_unique_column_tbl);

1740: else
1741: unique_tbl_constructor('nvl(TERRITORY_CODE,''' || p_territory_code || ''')','T',p_territory_code,l_unique_column_tbl);
1742: end if;
1743:
1744: l_csr := csr('PAY_PAYMENT_TYPES',l_unique_column_tbl);
1745: fetch l_csr into l_rec;
1746: if not csr_found_and_close(l_csr,p_error_when_not_exist) then
1747: l_rec := NULL;
1748: end if;