[Home] [Help]
266: -- -------------------------------------------------------------------------
267: PROCEDURE add_hr_param_list_to_content(p_application_id in number
268: ,p_content_code in varchar2) IS
269: --
270: l_param_list_name varchar2(30) := 'HR_STANDARD';
271: l_update_sql varchar2(2000);
272: --
273: BEGIN
274: --
581: -- 1. hr:sessionDate
582: -- 2. hr:where
583: -- 3. hr:extra
584: --
585: l_param_defn_code := 'HR_STANDARD_SESS_DATE';
586: l_attribute_code := 'HR_STANDARD_NO_SAVE';
587: --
588: l_plsql := 'BEGIN ' ||
589: ' :1 := BNE_PARAMETER_UTILS.CREATE_LIST_ITEMS_ALL' ||
582: -- 2. hr:where
583: -- 3. hr:extra
584: --
585: l_param_defn_code := 'HR_STANDARD_SESS_DATE';
586: l_attribute_code := 'HR_STANDARD_NO_SAVE';
587: --
588: l_plsql := 'BEGIN ' ||
589: ' :1 := BNE_PARAMETER_UTILS.CREATE_LIST_ITEMS_ALL' ||
590: ' (p_application_id => :2 ' ||
609: IN l_param_list_code,
610: IN l_param_defn_code,
611: IN l_attribute_code;
612: --
613: l_param_defn_code := 'HR_STANDARD_WHERE';
614: l_attribute_code := 'HR_STANDARD_NO_SAVE';
615: --
616: l_plsql := 'BEGIN ' ||
617: ' :1 := BNE_PARAMETER_UTILS.CREATE_LIST_ITEMS_ALL' ||
610: IN l_param_defn_code,
611: IN l_attribute_code;
612: --
613: l_param_defn_code := 'HR_STANDARD_WHERE';
614: l_attribute_code := 'HR_STANDARD_NO_SAVE';
615: --
616: l_plsql := 'BEGIN ' ||
617: ' :1 := BNE_PARAMETER_UTILS.CREATE_LIST_ITEMS_ALL' ||
618: ' (p_application_id => :2 ' ||
637: IN l_param_list_code,
638: IN l_param_defn_code,
639: IN l_attribute_code;
640: --
641: l_param_defn_code := 'HR_STANDARD_EXTRA';
642: l_attribute_code := 'HR_STANDARD_NO_SAVE';
643: --
644: l_plsql := 'BEGIN ' ||
645: ' :1 := BNE_PARAMETER_UTILS.CREATE_LIST_ITEMS_ALL' ||
638: IN l_param_defn_code,
639: IN l_attribute_code;
640: --
641: l_param_defn_code := 'HR_STANDARD_EXTRA';
642: l_attribute_code := 'HR_STANDARD_NO_SAVE';
643: --
644: l_plsql := 'BEGIN ' ||
645: ' :1 := BNE_PARAMETER_UTILS.CREATE_LIST_ITEMS_ALL' ||
646: ' (p_application_id => :2 ' ||
793: END IF;
794: --
795: -- Have param defn, now define item in list
796: --
797: l_attribute_code := 'HR_STANDARD_NO_SAVE';
798: --
799: l_plsql := 'BEGIN ' ||
800: ' :1 := BNE_PARAMETER_UTILS.CREATE_LIST_ITEMS_ALL' ||
801: ' (p_application_id => :2 '||
923: IN p_sql,
924: IN l_user_id;
925: --
926: --
927: -- Create standard parameter list with hr:session_date and hr:where
928: -- parameters, and then assign to content
929: create_param_list_for_content(l_content_code,
930: p_application_id,
931: l_param_list_code);