APPS.HR_JP_ID_PKG dependencies on PER_JP_BANK_LOOKUPS

Line 2129: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_JP_BANK_LOOKUPS%ROWTYPE

2125: --------------------------------------------------------------------------------
2126: FUNCTION JP_BANK_REC(
2127: P_BANK_CODE IN VARCHAR2,
2128: P_BRANCH_CODE IN VARCHAR2,
2129: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_JP_BANK_LOOKUPS%ROWTYPE
2130: --------------------------------------------------------------------------------
2131: IS
2132: l_unique_column_tbl UniColTbl;
2133: l_csr RefCsr;

Line 2134: l_rec PER_JP_BANK_LOOKUPS%ROWTYPE;

2130: --------------------------------------------------------------------------------
2131: IS
2132: l_unique_column_tbl UniColTbl;
2133: l_csr RefCsr;
2134: l_rec PER_JP_BANK_LOOKUPS%ROWTYPE;
2135: BEGIN
2136: unique_tbl_constructor('BANK_CODE','T',p_bank_code,l_unique_column_tbl);
2137: unique_tbl_constructor('BRANCH_CODE','T',p_branch_code,l_unique_column_tbl);
2138: l_csr := csr('PER_JP_BANK_LOOKUPS',l_unique_column_tbl);

Line 2138: l_csr := csr('PER_JP_BANK_LOOKUPS',l_unique_column_tbl);

2134: l_rec PER_JP_BANK_LOOKUPS%ROWTYPE;
2135: BEGIN
2136: unique_tbl_constructor('BANK_CODE','T',p_bank_code,l_unique_column_tbl);
2137: unique_tbl_constructor('BRANCH_CODE','T',p_branch_code,l_unique_column_tbl);
2138: l_csr := csr('PER_JP_BANK_LOOKUPS',l_unique_column_tbl);
2139: fetch l_csr into l_rec;
2140: if l_csr%NOTFOUND then
2141: if p_error_when_not_exist = 'TRUE' then
2142: close l_csr;