663: INTO l_count
664: FROM FND_LOOKUP_values
665: WHERE lookup_type = P_LOOKUP_TYPE
666: AND lookup_code = P_LOOKUP_CODE
667: AND security_group_id = fnd_global.lookup_security_group(P_LOOKUP_TYPE,3);
668:
669: hr_utility.set_location('inside FND_LOOKUP_VAL_INSERT',5);
670: hr_utility.set_location('P_LOOKUP_TYPE' || P_LOOKUP_TYPE,10);
671: hr_utility.set_location('P_LOOKUP_CODE' || P_LOOKUP_CODE,15);
677:
678: IF l_count = 0 THEN
679:
680: hr_utility.set_location('No Row exists',50);
681: hr_utility.set_location('fnd_global.lookup_security_group(P_LOOKUP_TYPE,3)'|| fnd_global.lookup_security_group(P_LOOKUP_TYPE,3),60);
682:
683: len_desc:=length(P_DESCRIPTION);
684: SELECT vsize(P_DESCRIPTION)
685: INTO lenb_desc
702:
703: FND_LOOKUP_VALUES_PKG.INSERT_ROW(
704: X_ROWID => l_row_id,
705: X_LOOKUP_TYPE => P_LOOKUP_TYPE,
706: X_SECURITY_GROUP_ID => fnd_global.lookup_security_group(P_LOOKUP_TYPE,3),
707: X_VIEW_APPLICATION_ID => 3,
708: X_LOOKUP_CODE => P_LOOKUP_CODE,
709: X_ATTRIBUTE_CATEGORY => NULL,
710: X_ATTRIBUTE1 => NULL,
1584: hr_utility.trace('p_resp_id: ' || p_resp_id);
1585: hr_utility.trace('p_resp_appl_id: ' || p_resp_appl_id);
1586:
1587: hr_utility.trace('Initializing current user and responsibility');
1588: fnd_global.APPS_INITIALIZE(user_id => p_user_id,
1589: resp_id => p_resp_id,
1590: resp_appl_id => p_resp_appl_id);
1591:
1592: