APPS.FUN_RULE_PUB dependencies on FND_GLOBAL

Line 485: l_application_id := FND_GLOBAL.RESP_APPL_ID;

481:
482: l_application_id := FUN_RULE_UTILITY_PKG.getApplicationID(p_application_short_name);
483:
484: IF(l_application_id IS NULL) THEN
485: l_application_id := FND_GLOBAL.RESP_APPL_ID;
486: END IF;
487:
488: destination_cursor := DBMS_SQL.OPEN_CURSOR;
489:

Line 580: add_parameter('APPLICATION' , FND_GLOBAL.RESP_APPL_ID);

576:
577:
578: if(l_param_name = 'APPLICATION') then
579: if(NOT containsKey(g_parameter_list,'APPLICATION')) then
580: add_parameter('APPLICATION' , FND_GLOBAL.RESP_APPL_ID);
581: end if;
582: end if;
583:
584: if(l_param_name = 'RESPONSIBILITY') then

Line 586: add_parameter('RESPONSIBILITY' , FND_GLOBAL.RESP_ID);

582: end if;
583:
584: if(l_param_name = 'RESPONSIBILITY') then
585: if(NOT containsKey(g_parameter_list,'RESPONSIBILITY')) then
586: add_parameter('RESPONSIBILITY' , FND_GLOBAL.RESP_ID);
587: end if;
588: end if;
589:
590:

Line 609: add_parameter('USER' , FND_GLOBAL.USER_ID);

605: end if;
606:
607: if(l_param_name = 'USER') then
608: if(NOT containsKey(g_parameter_list,'USER')) then
609: add_parameter('USER' , FND_GLOBAL.USER_ID);
610: end if;
611: end if;
612:
613:

Line 805: l_application_id := FND_GLOBAL.RESP_APPL_ID;

801:
802: l_application_id := FUN_RULE_UTILITY_PKG.getApplicationID(p_application_short_name);
803:
804: IF(l_application_id IS NULL) THEN
805: l_application_id := FND_GLOBAL.RESP_APPL_ID;
806: END IF;
807:
808: destination_cursor := DBMS_SQL.OPEN_CURSOR;
809:

Line 899: add_parameter('APPLICATION' , FND_GLOBAL.RESP_APPL_ID);

895: dbms_sql.column_value(params_cursor, 6, l_criteria_id);
896:
897: if(l_param_name = 'APPLICATION') then
898: if(NOT containsKey(g_parameter_list,'APPLICATION')) then
899: add_parameter('APPLICATION' , FND_GLOBAL.RESP_APPL_ID);
900: end if;
901: end if;
902:
903: if(l_param_name = 'RESPONSIBILITY') then

Line 905: add_parameter('RESPONSIBILITY' , FND_GLOBAL.RESP_ID);

901: end if;
902:
903: if(l_param_name = 'RESPONSIBILITY') then
904: if(NOT containsKey(g_parameter_list,'RESPONSIBILITY')) then
905: add_parameter('RESPONSIBILITY' , FND_GLOBAL.RESP_ID);
906: end if;
907: end if;
908:
909:

Line 928: add_parameter('USER' , FND_GLOBAL.USER_ID);

924: end if;
925:
926: if(l_param_name = 'USER') then
927: if(NOT containsKey(g_parameter_list,'USER')) then
928: add_parameter('USER' , FND_GLOBAL.USER_ID);
929: end if;
930: end if;
931:
932:

Line 2689: l_application_id := FND_GLOBAL.RESP_APPL_ID;

2685:
2686:
2687:
2688: IF(l_application_id IS NULL) THEN
2689: l_application_id := FND_GLOBAL.RESP_APPL_ID;
2690: END IF;
2691:
2692: IF (p_additional_where_clause IS NULL) THEN
2693: l_stringToParse := 'select * from ' || p_param_view_name || ' where ROWNUM = 1';

Line 3016: l_select_query := l_select_query ||' '''||m_resultValue||''', '''||m_ruleName||''', '||NVL(m_resultApplicationId, FND_GLOBAL.resp_appl_id)||' , '||m_ruleDetailId||' FROM '||p_param_view_name||' WHERE ';

3012: p_rule_object_name,
3013: l_flexfield_name,
3014: l_flexfield_app_short_name,
3015: l_rule_detail_id);
3016: l_select_query := l_select_query ||' '''||m_resultValue||''', '''||m_ruleName||''', '||NVL(m_resultApplicationId, FND_GLOBAL.resp_appl_id)||' , '||m_ruleDetailId||' FROM '||p_param_view_name||' WHERE ';
3017: l_default_select_query := l_select_query || ' AND ROWNUM =1 ';
3018: if(l_where_clause IS NOT NULL) then
3019: l_select_query := l_select_query || l_where_clause;
3020: end if;

Line 3073: l_select_query := l_select_query ||' '''||m_resultValue||''', '''||m_ruleName||''', '||NVL(m_resultApplicationId, FND_GLOBAL.resp_appl_id)||' , '||m_ruleDetailId||' FROM '||p_param_view_name||' WHERE 1=1 ';

3069: l_flexfield_app_short_name,
3070: l_rule_detail_id);
3071: end if;
3072:
3073: l_select_query := l_select_query ||' '''||m_resultValue||''', '''||m_ruleName||''', '||NVL(m_resultApplicationId, FND_GLOBAL.resp_appl_id)||' , '||m_ruleDetailId||' FROM '||p_param_view_name||' WHERE 1=1 ';
3074: l_select_query := l_select_query || l_where_clause;
3075:
3076: IF (p_additional_where_clause IS NOT NULL) THEN
3077: l_select_query := l_select_query || ' AND ' || p_additional_where_clause;