eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSD_RO_BULLETINS_PVT dependencies on CSD_RULES_ENGINE_PVT

Line 604: l_rule_matching_rec CSD_RULES_ENGINE_PVT.CSD_RULE_MATCHING_REC_TYPE;

600: c_API_VERSION_NUMBER CONSTANT NUMBER := G_L_API_VERSION_NUMBER;
601:
602: ---- local viariables ----
603: l_ro_bulletin_id NUMBER := NULL;
604: l_rule_matching_rec CSD_RULES_ENGINE_PVT.CSD_RULE_MATCHING_REC_TYPE;
605: l_rule_input_rec CSD_RULES_ENGINE_PVT.CSD_RULE_INPUT_REC_TYPE;
606: l_bulletin_id NUMBER := NULL;
607: l_rule_id NUMBER := NULL;
608: l_rule_results_tbl CSD_RULES_ENGINE_PVT.CSD_RULE_RESULTS_TBL_TYPE;

Line 605: l_rule_input_rec CSD_RULES_ENGINE_PVT.CSD_RULE_INPUT_REC_TYPE;

601:
602: ---- local viariables ----
603: l_ro_bulletin_id NUMBER := NULL;
604: l_rule_matching_rec CSD_RULES_ENGINE_PVT.CSD_RULE_MATCHING_REC_TYPE;
605: l_rule_input_rec CSD_RULES_ENGINE_PVT.CSD_RULE_INPUT_REC_TYPE;
606: l_bulletin_id NUMBER := NULL;
607: l_rule_id NUMBER := NULL;
608: l_rule_results_tbl CSD_RULES_ENGINE_PVT.CSD_RULE_RESULTS_TBL_TYPE;
609: l_rule_results_rec CSD_RULES_ENGINE_PVT.CSD_RULE_RESULTS_REC_TYPE;

Line 608: l_rule_results_tbl CSD_RULES_ENGINE_PVT.CSD_RULE_RESULTS_TBL_TYPE;

604: l_rule_matching_rec CSD_RULES_ENGINE_PVT.CSD_RULE_MATCHING_REC_TYPE;
605: l_rule_input_rec CSD_RULES_ENGINE_PVT.CSD_RULE_INPUT_REC_TYPE;
606: l_bulletin_id NUMBER := NULL;
607: l_rule_id NUMBER := NULL;
608: l_rule_results_tbl CSD_RULES_ENGINE_PVT.CSD_RULE_RESULTS_TBL_TYPE;
609: l_rule_results_rec CSD_RULES_ENGINE_PVT.CSD_RULE_RESULTS_REC_TYPE;
610: l_rec_ind INTEGER := NULL;
611: l_repln_rec CSD_REPAIRS_PUB.REPLN_Rec_Type;
612:

Line 609: l_rule_results_rec CSD_RULES_ENGINE_PVT.CSD_RULE_RESULTS_REC_TYPE;

605: l_rule_input_rec CSD_RULES_ENGINE_PVT.CSD_RULE_INPUT_REC_TYPE;
606: l_bulletin_id NUMBER := NULL;
607: l_rule_id NUMBER := NULL;
608: l_rule_results_tbl CSD_RULES_ENGINE_PVT.CSD_RULE_RESULTS_TBL_TYPE;
609: l_rule_results_rec CSD_RULES_ENGINE_PVT.CSD_RULE_RESULTS_REC_TYPE;
610: l_rec_ind INTEGER := NULL;
611: l_repln_rec CSD_REPAIRS_PUB.REPLN_Rec_Type;
612:
613: BEGIN

Line 666: * l_rule_matching_rec.rule_match_code := CSD_RULES_ENGINE_PVT.G_RULE_MATCH_ALL;

662: END IF; --* end IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) *--
663:
664: /* BEGIN: Algorithm:
665: * (1) init l_rule_matching_rec with
666: * l_rule_matching_rec.rule_match_code := CSD_RULES_ENGINE_PVT.G_RULE_MATCH_ALL;
667: * l_rule_matching_rec.rule_type := CSD_RULES_ENGINE_PVT.G_RULE_TYPE_BULLETIN;
668: * l_rule_matching_rec.rule_input_rec := l_rule_input_rec;
669: * l_rule_input_rec.repair_line_Id := p_repair_line_id;
670: * (2) call CSD_RULES_ENGINE_PVT.PROCESS_RULE_MATCHING(

Line 667: * l_rule_matching_rec.rule_type := CSD_RULES_ENGINE_PVT.G_RULE_TYPE_BULLETIN;

663:
664: /* BEGIN: Algorithm:
665: * (1) init l_rule_matching_rec with
666: * l_rule_matching_rec.rule_match_code := CSD_RULES_ENGINE_PVT.G_RULE_MATCH_ALL;
667: * l_rule_matching_rec.rule_type := CSD_RULES_ENGINE_PVT.G_RULE_TYPE_BULLETIN;
668: * l_rule_matching_rec.rule_input_rec := l_rule_input_rec;
669: * l_rule_input_rec.repair_line_Id := p_repair_line_id;
670: * (2) call CSD_RULES_ENGINE_PVT.PROCESS_RULE_MATCHING(
671: * p_api_version => p_api_version,

Line 670: * (2) call CSD_RULES_ENGINE_PVT.PROCESS_RULE_MATCHING(

666: * l_rule_matching_rec.rule_match_code := CSD_RULES_ENGINE_PVT.G_RULE_MATCH_ALL;
667: * l_rule_matching_rec.rule_type := CSD_RULES_ENGINE_PVT.G_RULE_TYPE_BULLETIN;
668: * l_rule_matching_rec.rule_input_rec := l_rule_input_rec;
669: * l_rule_input_rec.repair_line_Id := p_repair_line_id;
670: * (2) call CSD_RULES_ENGINE_PVT.PROCESS_RULE_MATCHING(
671: * p_api_version => p_api_version,
672: * p_commit => p_commit,
673: * p_init_msg_list => p_init_msg_list,
674: * p_validation_level => p_validation_level,

Line 700: l_rule_matching_rec.rule_match_code := CSD_RULES_ENGINE_PVT.G_RULE_MATCH_ALL;

696: * - check if work flow, if yes, place holder for launching workflow
697: * - add associated SCs to SC list
698: * END: Algorithm */
699: --* init l_rule_matching_rec
700: l_rule_matching_rec.rule_match_code := CSD_RULES_ENGINE_PVT.G_RULE_MATCH_ALL;
701: l_rule_matching_rec.rule_type := CSD_RULES_ENGINE_PVT.G_RULE_TYPE_BULLETIN;
702:
703: l_rule_input_rec.repair_line_Id := p_repair_line_id; -- must assign this val to rec first
704: l_rule_matching_rec.rule_input_rec := l_rule_input_rec;

Line 701: l_rule_matching_rec.rule_type := CSD_RULES_ENGINE_PVT.G_RULE_TYPE_BULLETIN;

697: * - add associated SCs to SC list
698: * END: Algorithm */
699: --* init l_rule_matching_rec
700: l_rule_matching_rec.rule_match_code := CSD_RULES_ENGINE_PVT.G_RULE_MATCH_ALL;
701: l_rule_matching_rec.rule_type := CSD_RULES_ENGINE_PVT.G_RULE_TYPE_BULLETIN;
702:
703: l_rule_input_rec.repair_line_Id := p_repair_line_id; -- must assign this val to rec first
704: l_rule_matching_rec.rule_input_rec := l_rule_input_rec;
705:

Line 707: CSD_RULES_ENGINE_PVT.PROCESS_RULE_MATCHING(

703: l_rule_input_rec.repair_line_Id := p_repair_line_id; -- must assign this val to rec first
704: l_rule_matching_rec.rule_input_rec := l_rule_input_rec;
705:
706:
707: CSD_RULES_ENGINE_PVT.PROCESS_RULE_MATCHING(
708: p_api_version_number => p_api_version_number,
709: p_commit => p_commit,
710: p_init_msg_list => p_init_msg_list,
711: p_validation_level => p_validation_level,

Line 990: l_instance_id := CSD_RULES_ENGINE_PVT.GET_RO_INSTANCE_ID(p_repair_line_id);

986: l_create_new_ro_bulletin_link := FND_API.G_TRUE;
987: END IF; -- end IF ( cur_check_by_repair%NOTFOUND) THEN --
988: CLOSE cur_check_by_repair; -- close cursor
989: ELSIF (l_freq_code = G_FREQ_ONE_INSTANCE) THEN
990: l_instance_id := CSD_RULES_ENGINE_PVT.GET_RO_INSTANCE_ID(p_repair_line_id);
991: --** debug starts!!
992: --dbms_output.put_line('in LINK_BULLETINS_TO_RO INSTANCE - l_instance_id = ' || l_instance_id);
993: --** debug ends!!
994:

Line 1522: l_sql_query := CSD_RULES_ENGINE_PVT.GET_RULE_SQL_FOR_RO(p_bulletin_rule_id);

1518: l_bulletin_id := p_bulletin_id;
1519: END IF;
1520:
1521: -- get all the matching ROs for the given rule
1522: l_sql_query := CSD_RULES_ENGINE_PVT.GET_RULE_SQL_FOR_RO(p_bulletin_rule_id);
1523:
1524: -- exclude any repair orders in closed state
1525: l_sql_query := l_sql_query || ' AND dra.status <> ''C''';
1526: