DBA Data[Home] [Help]

APPS.CSD_RULES_ENGINE_PVT dependencies on FND_GLOBAL

Line 1044: l_number_input := FND_GLOBAL.USER_ID;

1040: --** debug starts!!
1041: --dbms_output.put_line('>>>MATCH_CONDITION - USER_ID');
1042: --** debug ends!!
1043:
1044: l_number_input := FND_GLOBAL.USER_ID;
1045: l_return_val := CHECK_CONDITION_MATCH(p_input_param => l_number_input,
1046: p_operator => p_operator,
1047: p_criterion => to_number(p_criterion));
1048: ELSIF (p_parameter_type = 'USER_RESPONSIBILITY') THEN -- to test

Line 1052: l_number_input := FND_GLOBAL.RESP_ID;

1048: ELSIF (p_parameter_type = 'USER_RESPONSIBILITY') THEN -- to test
1049: --** debug starts!!
1050: --dbms_output.put_line('>>>MATCH_CONDITION - USER_RESPONSIBILITY');
1051: --** debug ends!!
1052: l_number_input := FND_GLOBAL.RESP_ID;
1053: l_return_val := CHECK_CONDITION_MATCH(p_input_param => l_number_input,
1054: p_operator => p_operator,
1055: p_criterion => to_number(p_criterion));
1056: ELSIF (p_parameter_type = 'USER_INV_ORG') THEN -- to test

Line 1074: l_number_input := FND_GLOBAL.ORG_ID;

1070: IF l_repair_line_id IS NOT NULL AND G_INCIDENT_ID IS NOT NULL
1071: THEN
1072: l_number_input := csd_process_util.get_org_id(p_incident_id => G_INCIDENT_ID);
1073: ELSE
1074: l_number_input := FND_GLOBAL.ORG_ID;
1075: END IF;
1076: l_return_val := CHECK_CONDITION_MATCH(p_input_param => l_number_input,
1077: p_operator => p_operator,
1078: p_criterion => to_number(p_criterion));

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

2523: l_str_condition := l_operator || ' ''' || l_rule_condition_rec.attribute2 || '''';
2524:
2525: case l_rule_condition_rec.attribute_category
2526: when 'USER_ID' then
2527: l_join_stmt := 'FND_GLOBAL.USER_ID ' || l_num_condition;
2528: when 'USER_RESPONSIBILITY' then
2529: l_join_stmt := 'FND_GLOBAL.RESP_ID ' || l_num_condition;
2530: when 'USER_INV_ORG' then
2531: l_join_stmt := 'FND_PROFILE.VALUE(''' || G_PROFILE_INV_ORG || ''') '

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

2525: case l_rule_condition_rec.attribute_category
2526: when 'USER_ID' then
2527: l_join_stmt := 'FND_GLOBAL.USER_ID ' || l_num_condition;
2528: when 'USER_RESPONSIBILITY' then
2529: l_join_stmt := 'FND_GLOBAL.RESP_ID ' || l_num_condition;
2530: when 'USER_INV_ORG' then
2531: l_join_stmt := 'FND_PROFILE.VALUE(''' || G_PROFILE_INV_ORG || ''') '
2532: || l_num_condition;
2533: when 'USER_OU' then

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

2530: when 'USER_INV_ORG' then
2531: l_join_stmt := 'FND_PROFILE.VALUE(''' || G_PROFILE_INV_ORG || ''') '
2532: || l_num_condition;
2533: when 'USER_OU' then
2534: l_join_stmt := 'FND_GLOBAL.ORG_ID ' || l_num_condition;
2535: when 'SR_CUSTOMER_ID' then
2536: l_join_stmt := 'csb.customer_id ' || l_num_condition;
2537: when 'SR_CUSTOMER_ACCOUNT_ID' then
2538: l_join_stmt := 'csb.account_id ' || l_num_condition;