DBA Data[Home] [Help]

APPS.CSD_RULES_ENGINE_PVT dependencies on FND_GLOBAL

Line 750: l_number_input := FND_GLOBAL.USER_ID;

746: --** debug starts!!
747: --dbms_output.put_line('>>>MATCH_CONDITION - USER_ID');
748: --** debug ends!!
749:
750: l_number_input := FND_GLOBAL.USER_ID;
751: l_return_val := CHECK_CONDITION_MATCH(p_input_param => l_number_input,
752: p_operator => p_operator,
753: p_criterion => to_number(p_criterion));
754: ELSIF (p_parameter_type = 'USER_RESPONSIBILITY') THEN -- to test

Line 758: l_number_input := FND_GLOBAL.RESP_ID;

754: ELSIF (p_parameter_type = 'USER_RESPONSIBILITY') THEN -- to test
755: --** debug starts!!
756: --dbms_output.put_line('>>>MATCH_CONDITION - USER_RESPONSIBILITY');
757: --** debug ends!!
758: l_number_input := FND_GLOBAL.RESP_ID;
759: l_return_val := CHECK_CONDITION_MATCH(p_input_param => l_number_input,
760: p_operator => p_operator,
761: p_criterion => to_number(p_criterion));
762: ELSIF (p_parameter_type = 'USER_INV_ORG') THEN -- to test

Line 776: l_number_input := FND_GLOBAL.ORG_ID; -- ou id

772: --** debug starts!!
773: --dbms_output.put_line('>>>MATCH_CONDITION - USER_OU');
774: --** debug ends!!
775:
776: l_number_input := FND_GLOBAL.ORG_ID; -- ou id
777: l_return_val := CHECK_CONDITION_MATCH(p_input_param => l_number_input,
778: p_operator => p_operator,
779: p_criterion => to_number(p_criterion));
780: ELSIF (p_parameter_type = 'SR_CUSTOMER_ID') THEN -- to test

Line 1955: l_join_stmt := 'FND_GLOBAL.USER_ID ' || l_num_condition;

1951: l_str_condition := l_operator || ' ''' || l_rule_condition_rec.attribute2 || '''';
1952:
1953: case l_rule_condition_rec.attribute_category
1954: when 'USER_ID' then
1955: l_join_stmt := 'FND_GLOBAL.USER_ID ' || l_num_condition;
1956: when 'USER_RESPONSIBILITY' then
1957: l_join_stmt := 'FND_GLOBAL.RESP_ID ' || l_num_condition;
1958: when 'USER_INV_ORG' then
1959: l_join_stmt := 'FND_PROFILE.VALUE(''' || G_PROFILE_INV_ORG || ''') '

Line 1957: l_join_stmt := 'FND_GLOBAL.RESP_ID ' || l_num_condition;

1953: case l_rule_condition_rec.attribute_category
1954: when 'USER_ID' then
1955: l_join_stmt := 'FND_GLOBAL.USER_ID ' || l_num_condition;
1956: when 'USER_RESPONSIBILITY' then
1957: l_join_stmt := 'FND_GLOBAL.RESP_ID ' || l_num_condition;
1958: when 'USER_INV_ORG' then
1959: l_join_stmt := 'FND_PROFILE.VALUE(''' || G_PROFILE_INV_ORG || ''') '
1960: || l_num_condition;
1961: when 'USER_OU' then

Line 1962: l_join_stmt := 'FND_GLOBAL.ORG_ID ' || l_num_condition;

1958: when 'USER_INV_ORG' then
1959: l_join_stmt := 'FND_PROFILE.VALUE(''' || G_PROFILE_INV_ORG || ''') '
1960: || l_num_condition;
1961: when 'USER_OU' then
1962: l_join_stmt := 'FND_GLOBAL.ORG_ID ' || l_num_condition;
1963: when 'SR_CUSTOMER_ID' then
1964: l_join_stmt := 'csb.customer_id ' || l_num_condition;
1965: when 'SR_CUSTOMER_ACCOUNT_ID' then
1966: l_join_stmt := 'csb.account_id ' || l_num_condition;