eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_JP_ID_PKG dependencies on PER_BUSINESS_GROUPS

Line 9: g_bg_rec_cache PER_BUSINESS_GROUPS%ROWTYPE;

5: value VARCHAR2(255));
6: TYPE UniColTbl IS TABLE OF UnqColRecTyp INDEX BY BINARY_INTEGER;
7: TYPE RefCsr IS REF CURSOR;
8: C_CHR_LF CONSTANT VARCHAR2(5) := fnd_global.local_chr(10);
9: g_bg_rec_cache PER_BUSINESS_GROUPS%ROWTYPE;
10: g_sql VARCHAR2(32767);
11: --------------------------------------------------------------------------------
12: FUNCTION LATEST_SQL RETURN VARCHAR2
13: --------------------------------------------------------------------------------

Line 276: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_BUSINESS_GROUPS%ROWTYPE

272: END;
273: --------------------------------------------------------------------------------
274: FUNCTION business_group_rec(
275: p_business_group_id IN NUMBER,
276: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_BUSINESS_GROUPS%ROWTYPE
277: --------------------------------------------------------------------------------
278: IS
279: l_unique_column_tbl UniColTbl;
280: l_csr RefCsr;

Line 281: l_rec PER_BUSINESS_GROUPS%ROWTYPE;

277: --------------------------------------------------------------------------------
278: IS
279: l_unique_column_tbl UniColTbl;
280: l_csr RefCsr;
281: l_rec PER_BUSINESS_GROUPS%ROWTYPE;
282: BEGIN
283: if p_business_group_id is NULL then
284: if p_error_when_not_exist = 'TRUE' then
285: fnd_message.set_name('PER','HR_JP_ID_NOT_FOUND');

Line 295: l_csr := csr('PER_BUSINESS_GROUPS',l_unique_column_tbl);

291: if g_bg_rec_cache.business_group_id = p_business_group_id then
292: NULL;
293: else
294: unique_tbl_constructor('BUSINESS_GROUP_ID','N',to_char(p_business_group_id),l_unique_column_tbl);
295: l_csr := csr('PER_BUSINESS_GROUPS',l_unique_column_tbl);
296: fetch l_csr into l_rec;
297: if not csr_found_and_close(l_csr,p_error_when_not_exist) then
298: l_rec := NULL;
299: end if;

Line 313: l_rec PER_BUSINESS_GROUPS%ROWTYPE;

309: p_business_group_id IN NUMBER,
310: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN VARCHAR2
311: --------------------------------------------------------------------------------
312: IS
313: l_rec PER_BUSINESS_GROUPS%ROWTYPE;
314: BEGIN
315: l_rec := business_group_rec(p_business_group_id,p_error_when_not_exist);
316:
317: return l_rec.legislation_code;

Line 331: l_rec PER_BUSINESS_GROUPS%ROWTYPE;

327: -- GRD Grade Key Flexfield(800)
328: -- JOB Job Key Flexfield(800)
329: -- COST Costing Key Flexfield(801)
330: -- GRP People Group Key Flexfield(801)
331: l_rec PER_BUSINESS_GROUPS%ROWTYPE;
332: l_id_flex_num NUMBER;
333: BEGIN
334: l_rec := business_group_rec(p_business_group_id,p_error_when_not_exist);
335:

Line 361: l_rec PER_BUSINESS_GROUPS%ROWTYPE;

357: p_business_group_id IN NUMBER,
358: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN VARCHAR2
359: --------------------------------------------------------------------------------
360: IS
361: l_rec PER_BUSINESS_GROUPS%ROWTYPE;
362: BEGIN
363: l_rec := business_group_rec(p_business_group_id,p_error_when_not_exist);
364:
365: return l_rec.currency_code;

Line 1283: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_BUSINESS_GROUPS%ROWTYPE

1279: END;
1280: --------------------------------------------------------------------------------
1281: FUNCTION business_group_rec(
1282: p_name IN VARCHAR2,
1283: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_BUSINESS_GROUPS%ROWTYPE
1284: --------------------------------------------------------------------------------
1285: IS
1286: l_unique_column_tbl UniColTbl;
1287: l_csr RefCsr;

Line 1288: l_rec PER_BUSINESS_GROUPS%ROWTYPE;

1284: --------------------------------------------------------------------------------
1285: IS
1286: l_unique_column_tbl UniColTbl;
1287: l_csr RefCsr;
1288: l_rec PER_BUSINESS_GROUPS%ROWTYPE;
1289: BEGIN
1290: if g_bg_rec_cache.name = p_name then
1291: NULL;
1292: else

Line 1295: l_csr := csr('PER_BUSINESS_GROUPS',l_unique_column_tbl);

1291: NULL;
1292: else
1293: unique_tbl_constructor('NAME','T',p_name,l_unique_column_tbl);
1294:
1295: l_csr := csr('PER_BUSINESS_GROUPS',l_unique_column_tbl);
1296: fetch l_csr into l_rec;
1297: if not csr_found_and_close(l_csr,p_error_when_not_exist) then
1298: l_rec := NULL;
1299: end if;