DBA Data[Home] [Help]

APPS.HR_DU_RULES dependencies on HR_DU_DI_INSERT

Line 366: hr_du_di_insert.g_current_delimiter := ':';

362:
363: --
364: IF upper(p_user_key) <> 'NONE' THEN
365: --
366: hr_du_di_insert.g_current_delimiter := ':';
367: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(p_user_key);
368: l_number_keys := hr_du_di_insert.WORDS_ON_LINE(p_user_key);
369:
370: FOR j IN 1..l_number_keys LOOP

Line 367: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(p_user_key);

363: --
364: IF upper(p_user_key) <> 'NONE' THEN
365: --
366: hr_du_di_insert.g_current_delimiter := ':';
367: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(p_user_key);
368: l_number_keys := hr_du_di_insert.WORDS_ON_LINE(p_user_key);
369:
370: FOR j IN 1..l_number_keys LOOP
371: --

Line 368: l_number_keys := hr_du_di_insert.WORDS_ON_LINE(p_user_key);

364: IF upper(p_user_key) <> 'NONE' THEN
365: --
366: hr_du_di_insert.g_current_delimiter := ':';
367: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(p_user_key);
368: l_number_keys := hr_du_di_insert.WORDS_ON_LINE(p_user_key);
369:
370: FOR j IN 1..l_number_keys LOOP
371: --
372: hr_du_di_insert.g_current_delimiter := ':';

Line 372: hr_du_di_insert.g_current_delimiter := ':';

368: l_number_keys := hr_du_di_insert.WORDS_ON_LINE(p_user_key);
369:
370: FOR j IN 1..l_number_keys LOOP
371: --
372: hr_du_di_insert.g_current_delimiter := ':';
373: l_pval_value := hr_du_di_insert.Return_Word(p_user_key, j);
374:
375: l_position := INSTRB(l_pval_value, '%');
376:

Line 373: l_pval_value := hr_du_di_insert.Return_Word(p_user_key, j);

369:
370: FOR j IN 1..l_number_keys LOOP
371: --
372: hr_du_di_insert.g_current_delimiter := ':';
373: l_pval_value := hr_du_di_insert.Return_Word(p_user_key, j);
374:
375: l_position := INSTRB(l_pval_value, '%');
376:
377: IF l_position = 0 THEN

Line 401: hr_du_di_insert.g_current_delimiter := '%';

397: --Error the second quote should be present
398: l_fatal_error_message := 'End Quote on the User Key is not present ';
399: RAISE e_fatal_error;
400: ELSE
401: hr_du_di_insert.g_current_delimiter := '%';
402: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(p_user_key);
403: l_pval_value := hr_du_di_insert.Return_Word(l_pval_value, 2);
404:
405: --Checks begin to see if there are any pointers to DESCRIPTORS

Line 402: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(p_user_key);

398: l_fatal_error_message := 'End Quote on the User Key is not present ';
399: RAISE e_fatal_error;
400: ELSE
401: hr_du_di_insert.g_current_delimiter := '%';
402: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(p_user_key);
403: l_pval_value := hr_du_di_insert.Return_Word(l_pval_value, 2);
404:
405: --Checks begin to see if there are any pointers to DESCRIPTORS
406: l_position := INSTRB(l_pval_value, '$');

Line 403: l_pval_value := hr_du_di_insert.Return_Word(l_pval_value, 2);

399: RAISE e_fatal_error;
400: ELSE
401: hr_du_di_insert.g_current_delimiter := '%';
402: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(p_user_key);
403: l_pval_value := hr_du_di_insert.Return_Word(l_pval_value, 2);
404:
405: --Checks begin to see if there are any pointers to DESCRIPTORS
406: l_position := INSTRB(l_pval_value, '$');
407: --

Line 410: hr_du_di_insert.g_current_delimiter := '$';

406: l_position := INSTRB(l_pval_value, '$');
407: --
408: IF l_position = 1 THEN
409: --
410: hr_du_di_insert.g_current_delimiter := '$';
411: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(p_user_key);
412: l_pval_value := hr_du_di_insert.Return_Word(l_pval_value, 2);
413: OPEN csr_dollar_key;
414: FETCH csr_dollar_key INTO l_temp;

Line 411: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(p_user_key);

407: --
408: IF l_position = 1 THEN
409: --
410: hr_du_di_insert.g_current_delimiter := '$';
411: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(p_user_key);
412: l_pval_value := hr_du_di_insert.Return_Word(l_pval_value, 2);
413: OPEN csr_dollar_key;
414: FETCH csr_dollar_key INTO l_temp;
415: IF csr_dollar_key%NOTFOUND THEN

Line 412: l_pval_value := hr_du_di_insert.Return_Word(l_pval_value, 2);

408: IF l_position = 1 THEN
409: --
410: hr_du_di_insert.g_current_delimiter := '$';
411: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(p_user_key);
412: l_pval_value := hr_du_di_insert.Return_Word(l_pval_value, 2);
413: OPEN csr_dollar_key;
414: FETCH csr_dollar_key INTO l_temp;
415: IF csr_dollar_key%NOTFOUND THEN
416: --