DBA Data[Home] [Help]

APPS.CSD_SOO_PVT dependencies on CSD_RULES_ENGINE_PVT

Line 350: l_rule_input_rec CSD_RULES_ENGINE_PVT.CSD_RULE_INPUT_REC_TYPE;

346: l_prev_status_id NUMBER;
347: l_status_id NUMBER;
348: l_repair_line_id NUMBER;
349: l_wip_entity_id NUMBER;
350: l_rule_input_rec CSD_RULES_ENGINE_PVT.CSD_RULE_INPUT_REC_TYPE;
351: l_rule_id NUMBER;
352:
353: CURSOR c_get_defaulting_info(c_orchestration_id NUMBER) IS
354: SELECT prev_status_id, status_id, repair_line_id, document_header_id

Line 553: CSD_RULES_ENGINE_PVT.SOO_DEFAULTING(

549: l_rule_input_rec.wip_entity_id := l_wip_entity_id;
550: l_rule_input_rec.job_prev_status_id := l_prev_status_id;
551: l_rule_input_rec.job_curr_status_id := l_status_id;
552:
553: CSD_RULES_ENGINE_PVT.SOO_DEFAULTING(
554: p_api_version_number => 1.0,
555: p_commit => fnd_api.g_false,
556: p_validation_level => p_validation_level,
557: p_event_type => 'JOB_STATUS',

Line 650: l_rule_input_rec CSD_RULES_ENGINE_PVT.CSD_RULE_INPUT_REC_TYPE;

646:
647: l_prev_status_id NUMBER;
648: l_status_id NUMBER;
649: l_repair_line_id NUMBER;
650: l_rule_input_rec CSD_RULES_ENGINE_PVT.CSD_RULE_INPUT_REC_TYPE;
651: l_rule_id NUMBER;
652:
653: CURSOR c_get_defaulting_info(c_orchestration_id NUMBER) IS
654: SELECT prev_status_id, status_id, repair_line_id

Line 846: CSD_RULES_ENGINE_PVT.SOO_DEFAULTING(

842: l_rule_input_rec.repair_line_id := l_repair_line_id;
843: l_rule_input_rec.sr_prev_status_id := l_prev_status_id;
844: l_rule_input_rec.sr_curr_status_id := l_status_id;
845:
846: CSD_RULES_ENGINE_PVT.SOO_DEFAULTING(
847: p_api_version_number => 1.0,
848: p_commit => fnd_api.g_false,
849: p_validation_level => p_validation_level,
850: p_event_type => 'SR_STATUS',

Line 944: l_rule_input_rec CSD_RULES_ENGINE_PVT.CSD_RULE_INPUT_REC_TYPE;

940:
941: l_prev_status_id NUMBER;
942: l_status_id NUMBER;
943: l_repair_line_id NUMBER;
944: l_rule_input_rec CSD_RULES_ENGINE_PVT.CSD_RULE_INPUT_REC_TYPE;
945: l_rule_id NUMBER;
946:
947: CURSOR c_get_defaulting_info(c_orchestration_id NUMBER) IS
948: SELECT prev_status_id, status_id, repair_line_id

Line 1144: CSD_RULES_ENGINE_PVT.SOO_DEFAULTING(

1140: l_rule_input_rec.repair_line_id := l_repair_line_id;
1141: l_rule_input_rec.sr_task_prev_status_id := l_prev_status_id;
1142: l_rule_input_rec.sr_task_curr_status_id := l_status_id;
1143:
1144: CSD_RULES_ENGINE_PVT.SOO_DEFAULTING(
1145: p_api_version_number => 1.0,
1146: p_commit => fnd_api.g_false,
1147: p_validation_level => p_validation_level,
1148: p_event_type => 'SR_TASK_STATUS',

Line 1244: l_rule_input_rec CSD_RULES_ENGINE_PVT.CSD_RULE_INPUT_REC_TYPE;

1240: l_status_CODE VARCHAR2(80);
1241: l_repair_line_id NUMBER;
1242: l_wip_entity_id NUMBER;
1243: l_pr_header_id NUMBER;
1244: l_rule_input_rec CSD_RULES_ENGINE_PVT.CSD_RULE_INPUT_REC_TYPE;
1245: l_rule_id NUMBER;
1246:
1247: CURSOR c_get_defaulting_info(c_orchestration_id NUMBER) IS
1248: SELECT prev_status_code, status_code, repair_line_id, document_header_id

Line 1456: CSD_RULES_ENGINE_PVT.SOO_DEFAULTING(

1452: l_rule_input_rec.wip_entity_id := l_wip_entity_id;
1453: l_rule_input_rec.pr_prev_status_code := l_prev_status_code;
1454: l_rule_input_rec.pr_curr_status_code := l_status_code;
1455:
1456: CSD_RULES_ENGINE_PVT.SOO_DEFAULTING(
1457: p_api_version_number => 1.0,
1458: p_commit => fnd_api.g_false,
1459: p_validation_level => p_validation_level,
1460: p_event_type => 'PR_STATUS',

Line 1556: l_rule_input_rec CSD_RULES_ENGINE_PVT.CSD_RULE_INPUT_REC_TYPE;

1552: l_status_CODE VARCHAR2(80);
1553: l_repair_line_id NUMBER;
1554: l_wip_entity_id NUMBER;
1555: l_pr_header_id NUMBER;
1556: l_rule_input_rec CSD_RULES_ENGINE_PVT.CSD_RULE_INPUT_REC_TYPE;
1557: l_rule_id NUMBER;
1558:
1559: l_order_header_id NUMBER;
1560:

Line 1774: CSD_RULES_ENGINE_PVT.SOO_DEFAULTING(

1770: l_rule_input_rec.wip_entity_id := l_wip_entity_id;
1771: l_rule_input_rec.ir_prev_status_code := l_prev_status_code;
1772: l_rule_input_rec.ir_curr_status_code := l_status_code;
1773:
1774: CSD_RULES_ENGINE_PVT.SOO_DEFAULTING(
1775: p_api_version_number => 1.0,
1776: p_commit => fnd_api.g_false,
1777: p_validation_level => p_validation_level,
1778: p_event_type => 'IR_STATUS',

Line 1882: l_rule_input_rec CSD_RULES_ENGINE_PVT.CSD_RULE_INPUT_REC_TYPE;

1878: l_prev_status_CODE VARCHAR2(80);
1879: l_status_CODE VARCHAR2(80);
1880: l_repair_line_id NUMBER;
1881: l_order_header_id NUMBER;
1882: l_rule_input_rec CSD_RULES_ENGINE_PVT.CSD_RULE_INPUT_REC_TYPE;
1883: l_rule_id NUMBER;
1884:
1885: CURSOR c_get_defaulting_info(c_orchestration_id NUMBER) IS
1886: SELECT prev_status_code, status_code, repair_line_id, document_header_id

Line 2085: CSD_RULES_ENGINE_PVT.SOO_DEFAULTING(

2081: l_rule_input_rec.repair_line_id := l_repair_line_id;
2082: l_rule_input_rec.int_so_prev_status_code := l_prev_status_code;
2083: l_rule_input_rec.int_so_curr_status_code := l_status_code;
2084:
2085: CSD_RULES_ENGINE_PVT.SOO_DEFAULTING(
2086: p_api_version_number => 1.0,
2087: p_commit => fnd_api.g_false,
2088: p_validation_level => p_validation_level,
2089: p_event_type => 'INTERNAL_SALES_STATUS',

Line 2185: l_rule_input_rec CSD_RULES_ENGINE_PVT.CSD_RULE_INPUT_REC_TYPE;

2181:
2182: l_prev_status_CODE VARCHAR2(80);
2183: l_status_CODE VARCHAR2(80);
2184: l_repair_line_id NUMBER;
2185: l_rule_input_rec CSD_RULES_ENGINE_PVT.CSD_RULE_INPUT_REC_TYPE;
2186: l_rule_id NUMBER;
2187:
2188: CURSOR c_get_defaulting_info(c_orchestration_id NUMBER) IS
2189: SELECT prev_status_code, status_code, repair_line_id

Line 2388: CSD_RULES_ENGINE_PVT.SOO_DEFAULTING(

2384: l_rule_input_rec.repair_line_id := l_repair_line_id;
2385: l_rule_input_rec.rma_prev_status_code := l_prev_status_code;
2386: l_rule_input_rec.rma_curr_status_code := l_status_code;
2387:
2388: CSD_RULES_ENGINE_PVT.SOO_DEFAULTING(
2389: p_api_version_number => 1.0,
2390: p_commit => fnd_api.g_false,
2391: p_validation_level => p_validation_level,
2392: p_event_type => 'RMA_STATUS',

Line 2487: l_rule_input_rec CSD_RULES_ENGINE_PVT.CSD_RULE_INPUT_REC_TYPE;

2483:
2484: l_prev_status_CODE VARCHAR2(80);
2485: l_status_CODE VARCHAR2(80);
2486: l_repair_line_id NUMBER;
2487: l_rule_input_rec CSD_RULES_ENGINE_PVT.CSD_RULE_INPUT_REC_TYPE;
2488: l_rule_id NUMBER;
2489:
2490: CURSOR c_get_defaulting_info(c_orchestration_id NUMBER) IS
2491: SELECT prev_status_code, status_code, repair_line_id

Line 2691: CSD_RULES_ENGINE_PVT.SOO_DEFAULTING(

2687: l_rule_input_rec.repair_line_id := l_repair_line_id;
2688: l_rule_input_rec.rma_tp_prev_status_code := l_prev_status_code;
2689: l_rule_input_rec.rma_tp_curr_status_code := l_status_code;
2690:
2691: CSD_RULES_ENGINE_PVT.SOO_DEFAULTING(
2692: p_api_version_number => 1.0,
2693: p_commit => fnd_api.g_false,
2694: p_validation_level => p_validation_level,
2695: p_event_type => 'RMA_TP_STATUS',

Line 2791: l_rule_input_rec CSD_RULES_ENGINE_PVT.CSD_RULE_INPUT_REC_TYPE;

2787:
2788: l_prev_status_CODE VARCHAR2(80);
2789: l_status_CODE VARCHAR2(80);
2790: l_repair_line_id NUMBER;
2791: l_rule_input_rec CSD_RULES_ENGINE_PVT.CSD_RULE_INPUT_REC_TYPE;
2792: l_rule_id NUMBER;
2793:
2794: CURSOR c_get_defaulting_info(c_orchestration_id NUMBER) IS
2795: SELECT prev_status_code, status_code, repair_line_id

Line 2995: CSD_RULES_ENGINE_PVT.SOO_DEFAULTING(

2991: l_rule_input_rec.repair_line_id := l_repair_line_id;
2992: l_rule_input_rec.ship_prev_status_code := l_prev_status_code;
2993: l_rule_input_rec.ship_curr_status_code := l_status_code;
2994:
2995: CSD_RULES_ENGINE_PVT.SOO_DEFAULTING(
2996: p_api_version_number => 1.0,
2997: p_commit => fnd_api.g_false,
2998: p_validation_level => p_validation_level,
2999: p_event_type => 'SHIP_STATUS',

Line 3095: l_rule_input_rec CSD_RULES_ENGINE_PVT.CSD_RULE_INPUT_REC_TYPE;

3091:
3092: l_prev_status_CODE VARCHAR2(80);
3093: l_status_CODE VARCHAR2(80);
3094: l_repair_line_id NUMBER;
3095: l_rule_input_rec CSD_RULES_ENGINE_PVT.CSD_RULE_INPUT_REC_TYPE;
3096: l_rule_id NUMBER;
3097:
3098: CURSOR c_get_defaulting_info(c_orchestration_id NUMBER) IS
3099: SELECT prev_status_code, status_code, repair_line_id

Line 3299: CSD_RULES_ENGINE_PVT.SOO_DEFAULTING(

3295: l_rule_input_rec.repair_line_id := l_repair_line_id;
3296: l_rule_input_rec.ship_tp_prev_status_code := l_prev_status_code;
3297: l_rule_input_rec.ship_tp_curr_status_code := l_status_code;
3298:
3299: CSD_RULES_ENGINE_PVT.SOO_DEFAULTING(
3300: p_api_version_number => 1.0,
3301: p_commit => fnd_api.g_false,
3302: p_validation_level => p_validation_level,
3303: p_event_type => 'SHIP_TP_STATUS',

Line 3399: l_rule_input_rec CSD_RULES_ENGINE_PVT.CSD_RULE_INPUT_REC_TYPE;

3395:
3396: l_prev_status_CODE VARCHAR2(80);
3397: l_status_CODE VARCHAR2(80);
3398: l_repair_line_id NUMBER;
3399: l_rule_input_rec CSD_RULES_ENGINE_PVT.CSD_RULE_INPUT_REC_TYPE;
3400: l_rule_id NUMBER;
3401:
3402: CURSOR c_get_defaulting_info(c_orchestration_id NUMBER) IS
3403: SELECT prev_status_code, status_code, repair_line_id

Line 3607: CSD_RULES_ENGINE_PVT.SOO_DEFAULTING(

3603: l_rule_input_rec.repair_line_id := l_repair_line_id;
3604: l_rule_input_rec.delivery_prev_status_code := l_prev_status_code;
3605: l_rule_input_rec.delivery_curr_status_code := l_status_code;
3606:
3607: CSD_RULES_ENGINE_PVT.SOO_DEFAULTING(
3608: p_api_version_number => 1.0,
3609: p_commit => fnd_api.g_false,
3610: p_validation_level => p_validation_level,
3611: p_event_type => 'DELIVERY_STATUS',