APPS.FUN_RULE_PUB dependencies on FND_GLOBAL

Line 477: l_application_id := FND_GLOBAL.RESP_APPL_ID;

473:
474: l_application_id := FUN_RULE_UTILITY_PKG.getApplicationID(p_application_short_name);
475:
476: IF(l_application_id IS NULL) THEN
477: l_application_id := FND_GLOBAL.RESP_APPL_ID;
478: END IF;
479:
480: destination_cursor := DBMS_SQL.OPEN_CURSOR;
481:

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

568:
569:
570: if(l_param_name = 'APPLICATION') then
571: if(NOT containsKey(g_parameter_list,'APPLICATION')) then
572: add_parameter('APPLICATION' , FND_GLOBAL.RESP_APPL_ID);
573: end if;
574: end if;
575:
576: if(l_param_name = 'RESPONSIBILITY') then

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

574: end if;
575:
576: if(l_param_name = 'RESPONSIBILITY') then
577: if(NOT containsKey(g_parameter_list,'RESPONSIBILITY')) then
578: add_parameter('RESPONSIBILITY' , FND_GLOBAL.RESP_ID);
579: end if;
580: end if;
581:
582:

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

597: end if;
598:
599: if(l_param_name = 'USER') then
600: if(NOT containsKey(g_parameter_list,'USER')) then
601: add_parameter('USER' , FND_GLOBAL.USER_ID);
602: end if;
603: end if;
604:
605:

Line 797: l_application_id := FND_GLOBAL.RESP_APPL_ID;

793:
794: l_application_id := FUN_RULE_UTILITY_PKG.getApplicationID(p_application_short_name);
795:
796: IF(l_application_id IS NULL) THEN
797: l_application_id := FND_GLOBAL.RESP_APPL_ID;
798: END IF;
799:
800: destination_cursor := DBMS_SQL.OPEN_CURSOR;
801:

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

887: dbms_sql.column_value(params_cursor, 6, l_criteria_id);
888:
889: if(l_param_name = 'APPLICATION') then
890: if(NOT containsKey(g_parameter_list,'APPLICATION')) then
891: add_parameter('APPLICATION' , FND_GLOBAL.RESP_APPL_ID);
892: end if;
893: end if;
894:
895: if(l_param_name = 'RESPONSIBILITY') then

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

893: end if;
894:
895: if(l_param_name = 'RESPONSIBILITY') then
896: if(NOT containsKey(g_parameter_list,'RESPONSIBILITY')) then
897: add_parameter('RESPONSIBILITY' , FND_GLOBAL.RESP_ID);
898: end if;
899: end if;
900:
901:

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

916: end if;
917:
918: if(l_param_name = 'USER') then
919: if(NOT containsKey(g_parameter_list,'USER')) then
920: add_parameter('USER' , FND_GLOBAL.USER_ID);
921: end if;
922: end if;
923:
924:

Line 2679: l_application_id := FND_GLOBAL.RESP_APPL_ID;

2675:
2676:
2677:
2678: IF(l_application_id IS NULL) THEN
2679: l_application_id := FND_GLOBAL.RESP_APPL_ID;
2680: END IF;
2681:
2682: IF (p_additional_where_clause IS NULL) THEN
2683: l_stringToParse := 'select * from ' || p_param_view_name || ' where ROWNUM = 1';

Line 2985: 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 ';

2981: p_rule_object_name,
2982: l_flexfield_name,
2983: l_flexfield_app_short_name,
2984: l_rule_detail_id);
2985: 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 ';
2986: l_default_select_query := l_select_query || ' AND ROWNUM =1 ';
2987: if(l_where_clause IS NOT NULL) then
2988: l_select_query := l_select_query || l_where_clause;
2989: end if;

Line 3042: 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 ';

3038: l_flexfield_app_short_name,
3039: l_rule_detail_id);
3040: end if;
3041:
3042: 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 ';
3043: l_select_query := l_select_query || l_where_clause;
3044:
3045: IF (p_additional_where_clause IS NOT NULL) THEN
3046: l_select_query := l_select_query || ' AND ' || p_additional_where_clause;