DBA Data[Home] [Help]

APPS.PAY_NL_GENERAL dependencies on HRDYNDBI

Line 862: hrdyndbi.insert_user_entity (p_route_name,

858: l_created_by := c1rec.c_created_by;
859: l_last_login := c1rec.c_last_login;
860: --
861: hr_utility.trace ('creating SCL flex entity for '|| p_entity_name);
862: hrdyndbi.insert_user_entity (p_route_name,
863: p_entity_name,
864: 'route for SCL level : '|| p_attribute_type,
865: 'Y',
866: 'KF',

Line 881: hrdyndbi.insert_parameter_value (p_id_flex_num, 1);

877: IF l_record_inserted THEN
878: --
879: -- insert the id flex num for the where clause filler
880: --
881: hrdyndbi.insert_parameter_value (p_id_flex_num, 1);
882: l_db_item_exist := true;
883: END IF;
884: end if;
885: --

Line 889: hrdyndbi.insert_database_item (substr(p_entity_name,1,8) || p_leg_code,

885: --
886: -- now create the database item
887: --
888: IF p_entity_name = 'SCL_ASG_DE_NL' THEN
889: hrdyndbi.insert_database_item (substr(p_entity_name,1,8) || p_leg_code,
890: c1rec.c_db_name || '_DE' ,
891: 'T', -- data type
892: 'target.' || c1rec.c_def_text,
893: 'Y', -- null allowed

Line 896: hrdyndbi.insert_database_item (substr(p_entity_name,1,8) || p_leg_code,

892: 'target.' || c1rec.c_def_text,
893: 'Y', -- null allowed
894: 'database item for : ' || p_entity_name);
895: ELSIF p_entity_name = 'SCL_ASG_DP_NL' THEN
896: hrdyndbi.insert_database_item (substr(p_entity_name,1,8) || p_leg_code,
897: c1rec.c_db_name || '_DP' ,
898: 'T', -- data type
899: 'target.' || c1rec.c_def_text,
900: 'Y', -- null allowed

Line 903: hrdyndbi.insert_database_item (p_entity_name,

899: 'target.' || c1rec.c_def_text,
900: 'Y', -- null allowed
901: 'database item for : ' || p_entity_name);
902: ELSE
903: hrdyndbi.insert_database_item (p_entity_name,
904: c1rec.c_db_name ,
905: 'T', -- data type
906: 'target.' || c1rec.c_def_text,
907: 'Y', -- null allowed

Line 919: hr_utility.set_location ('hrdyndbi.create_scl_flex_dict', 1);

915: BEGIN
916: --
917: -- get each legislation code
918: --
919: hr_utility.set_location ('hrdyndbi.create_scl_flex_dict', 1);
920: --
921: for c0rec in c0 loop
922: --
923: l_legislation_code := c0rec.legislation_code;

Line 927: hrdyndbi.delete_keyflex_dict (p_id_flex_num,

923: l_legislation_code := c0rec.legislation_code;
924: --
925: -- delete any old SCL keyflex DB items that were created with the same id
926: --
927: hrdyndbi.delete_keyflex_dict (p_id_flex_num,
928: 'SCL',
929: l_legislation_code,
930: null);
931: