DBA Data[Home] [Help]

APPS.CSD_REPAIR_ACTUAL_PROCESS_PVT dependencies on CSD_REPAIR_ACTUAL_LINES

Line 513: l_curr_actual_line_rec CSD_REPAIR_ACTUAL_LINES_PVT.CSD_ACTUAL_LINES_REC_TYPE;

509: l_charge_line_rec CS_CHARGE_DETAILS_PUB.CHARGES_REC_TYPE;
510:
511: -- The following variable will be used to store
512: -- actual line info for each record in the loop.
513: l_curr_actual_line_rec CSD_REPAIR_ACTUAL_LINES_PVT.CSD_ACTUAL_LINES_REC_TYPE;
514:
515: -- The folowing variable will be used to skip processing for
516: -- a current row in the loop, if we encounter an error.
517: l_skip_curr_row BOOLEAN := FALSE;

Line 565: FROM CSD_REPAIR_ACTUAL_LINES ACTL

561: /* end swai fix 5949309 */
562: AND NOT EXISTS
563: (
564: SELECT 'EXISTS'
565: FROM CSD_REPAIR_ACTUAL_LINES ACTL
566: WHERE ACTL.repair_actual_id = nvl(p_repair_actual_id,ACTL.repair_actual_id)
567: AND ACTL.estimate_detail_id = CEST.estimate_detail_id
568: AND ACTL.actual_source_code = G_ACTUAL_SOURCE_CODE_TASK
569: AND ACTL.actual_source_id = JTB.task_id -- swai: bug 6042488

Line 837: 'Calling CSD_REPAIR_ACTUAL_LINES_PVT.create_repair_actual_lines');

833: BEGIN
834:
835: if (lc_proc_level >= lc_debug_level) then
836: FND_LOG.STRING(lc_proc_level, lc_mod_name,
837: 'Calling CSD_REPAIR_ACTUAL_LINES_PVT.create_repair_actual_lines');
838: end if;
839:
840: CSD_REPAIR_ACTUAL_LINES_PVT.create_repair_actual_lines(
841: p_api_version => 1.0,

Line 840: CSD_REPAIR_ACTUAL_LINES_PVT.create_repair_actual_lines(

836: FND_LOG.STRING(lc_proc_level, lc_mod_name,
837: 'Calling CSD_REPAIR_ACTUAL_LINES_PVT.create_repair_actual_lines');
838: end if;
839:
840: CSD_REPAIR_ACTUAL_LINES_PVT.create_repair_actual_lines(
841: p_api_version => 1.0,
842: p_commit => p_commit,
843: p_init_msg_list => p_init_msg_list,
844: p_validation_level => p_validation_level,

Line 854: 'Returned from CSD_REPAIR_ACTUAL_LINES_PVT.create_repair_actual_lines');

850: );
851:
852: if (lc_proc_level >= lc_debug_level) then
853: FND_LOG.STRING(lc_proc_level, lc_mod_name,
854: 'Returned from CSD_REPAIR_ACTUAL_LINES_PVT.create_repair_actual_lines');
855: end if;
856:
857: -- Throw an error if the API returned an error.
858: -- We do not stall the process if we find an error in

Line 911: 'Calling CSD_REPAIR_ACTUAL_LINES_PVT.update_repair_actual_lines');

907: l_charge_line_rec.ship_to_org_id := l_ship_to_party_site_id;
908:
909: if (lc_proc_level >= lc_debug_level) then
910: FND_LOG.STRING(lc_proc_level, lc_mod_name,
911: 'Calling CSD_REPAIR_ACTUAL_LINES_PVT.update_repair_actual_lines');
912: end if;
913:
914: CSD_REPAIR_ACTUAL_LINES_PVT.update_repair_actual_lines (
915: p_api_version => 1.0,

Line 914: CSD_REPAIR_ACTUAL_LINES_PVT.update_repair_actual_lines (

910: FND_LOG.STRING(lc_proc_level, lc_mod_name,
911: 'Calling CSD_REPAIR_ACTUAL_LINES_PVT.update_repair_actual_lines');
912: end if;
913:
914: CSD_REPAIR_ACTUAL_LINES_PVT.update_repair_actual_lines (
915: p_api_version => 1.0,
916: p_commit => p_commit,
917: p_init_msg_list => p_init_msg_list,
918: p_validation_level => p_validation_level,

Line 927: 'Returned from CSD_REPAIR_ACTUAL_LINES_PVT.update_repair_actual_lines');

923: x_msg_data => x_msg_data
924: );
925: if (lc_proc_level >= lc_debug_level) then
926: FND_LOG.STRING(lc_proc_level, lc_mod_name,
927: 'Returned from CSD_REPAIR_ACTUAL_LINES_PVT.update_repair_actual_lines');
928: end if;
929:
930: -- Throw an error if the API returned an error.
931: -- We do not stall the process if we find an error in

Line 1642: -- CSD_REPAIR_ACTUAL_LINES_PVT.CSD_ACTUAL_LINES_TBL_TYPE is specific to

1638: -- It's really same as x_valid_MLE_lines_tbl but in repair actual line format.
1639: -- The reason we have two TYPES for the same set of data is that -
1640: -- CSD_CHARGE_LINE_UTIL.MLE_LINES_TBL_TYPE is generic format and can be
1641: -- utilized by both ESTIMATE and ACTUALS, whereas
1642: -- CSD_REPAIR_ACTUAL_LINES_PVT.CSD_ACTUAL_LINES_TBL_TYPE is specific to
1643: -- Actuals.
1644: l_actual_lines_tbl CSD_REPAIR_ACTUAL_LINES_PVT.CSD_ACTUAL_LINES_TBL_TYPE;
1645:
1646: l_curr_warning_flag VARCHAR2(5) := FND_API.G_FALSE;

Line 1644: l_actual_lines_tbl CSD_REPAIR_ACTUAL_LINES_PVT.CSD_ACTUAL_LINES_TBL_TYPE;

1640: -- CSD_CHARGE_LINE_UTIL.MLE_LINES_TBL_TYPE is generic format and can be
1641: -- utilized by both ESTIMATE and ACTUALS, whereas
1642: -- CSD_REPAIR_ACTUAL_LINES_PVT.CSD_ACTUAL_LINES_TBL_TYPE is specific to
1643: -- Actuals.
1644: l_actual_lines_tbl CSD_REPAIR_ACTUAL_LINES_PVT.CSD_ACTUAL_LINES_TBL_TYPE;
1645:
1646: l_curr_warning_flag VARCHAR2(5) := FND_API.G_FALSE;
1647: x_curr_warning_flag VARCHAR2(5) := FND_API.G_FALSE;
1648: l_actuals_count NUMBER := 0;

Line 2004: 'Calling procedure CSD_REPAIR_ACTUAL_LINES_PVT.create_repair_actual_lines'

2000: -- If any row encounters any error, stop processing
2001: -- any further.
2002: if (lc_proc_level >= lc_debug_level) then
2003: FND_LOG.STRING(lc_proc_level, lc_mod_name,
2004: 'Calling procedure CSD_REPAIR_ACTUAL_LINES_PVT.create_repair_actual_lines'
2005: || ' for all actual lines. l_actuals_count = ' || l_actuals_count);
2006: end if;
2007:
2008: FOR i IN 1..l_actuals_count LOOP

Line 2028: CSD_REPAIR_ACTUAL_LINES_PVT.create_repair_actual_lines( p_api_version => 1.0,

2024: x_charge_lines_tbl( i ).ship_to_party_id := l_ship_to_party_id;
2025: x_charge_lines_tbl( i ).ship_to_account_id := l_ship_to_account_id;
2026: x_charge_lines_tbl( i ).ship_to_org_id := l_ship_to_party_site_id;
2027:
2028: CSD_REPAIR_ACTUAL_LINES_PVT.create_repair_actual_lines( p_api_version => 1.0,
2029: p_commit => FND_API.G_FALSE,
2030: p_init_msg_list => FND_API.G_FALSE,
2031: p_validation_level => 0,
2032: px_CSD_ACTUAL_LINES_REC => l_actual_lines_tbl( i ),

Line 2050: 'Returned from procedure CSD_REPAIR_ACTUAL_LINES_PVT.create_repair_actual_lines'

2046: END LOOP;
2047:
2048: if (lc_proc_level >= lc_debug_level) then
2049: FND_LOG.STRING(lc_proc_level, lc_mod_name,
2050: 'Returned from procedure CSD_REPAIR_ACTUAL_LINES_PVT.create_repair_actual_lines'
2051: || ' for all actual lines. l_actuals_count = ' || l_actuals_count);
2052: end if;
2053:
2054: IF ( l_curr_warning_flag <> FND_API.G_FALSE ) THEN

Line 2439: l_curr_actual_line_rec CSD_REPAIR_ACTUAL_LINES_PVT.CSD_ACTUAL_LINES_REC_TYPE;

2435: l_charge_line_rec CS_CHARGE_DETAILS_PUB.CHARGES_REC_TYPE;
2436:
2437: -- The following variable will be used to store
2438: -- actual line info for each record in the loop.
2439: l_curr_actual_line_rec CSD_REPAIR_ACTUAL_LINES_PVT.CSD_ACTUAL_LINES_REC_TYPE;
2440:
2441: -- The folowing variable will be used to skip processing for
2442: -- a current row in the loop, if we encounter an error.
2443: l_skip_curr_row BOOLEAN := FALSE;

Line 2505: FROM CSD_REPAIR_ACTUAL_LINES ACTL

2501: AND ESTL.repair_estimate_id = ESTH.repair_estimate_id
2502: AND NOT EXISTS
2503: (
2504: SELECT 'EXISTS'
2505: FROM CSD_REPAIR_ACTUAL_LINES ACTL
2506: WHERE ACTL.actual_source_code = G_ACTUAL_SOURCE_CODE_ESTIMATE
2507: AND ACTL.actual_source_id = ESTL.repair_estimate_line_id
2508: );
2509:

Line 2787: 'Calling CSD_REPAIR_ACTUAL_LINES_PVT.create_repair_actual_lines');

2783: BEGIN
2784:
2785: if (lc_proc_level >= lc_debug_level) then
2786: FND_LOG.STRING(lc_proc_level, lc_mod_name,
2787: 'Calling CSD_REPAIR_ACTUAL_LINES_PVT.create_repair_actual_lines');
2788: end if;
2789: CSD_REPAIR_ACTUAL_LINES_PVT.create_repair_actual_lines(
2790: p_api_version => 1.0,
2791: p_commit => p_commit,

Line 2789: CSD_REPAIR_ACTUAL_LINES_PVT.create_repair_actual_lines(

2785: if (lc_proc_level >= lc_debug_level) then
2786: FND_LOG.STRING(lc_proc_level, lc_mod_name,
2787: 'Calling CSD_REPAIR_ACTUAL_LINES_PVT.create_repair_actual_lines');
2788: end if;
2789: CSD_REPAIR_ACTUAL_LINES_PVT.create_repair_actual_lines(
2790: p_api_version => 1.0,
2791: p_commit => p_commit,
2792: p_init_msg_list => p_init_msg_list,
2793: p_validation_level => p_validation_level,

Line 2802: 'Returned from CSD_REPAIR_ACTUAL_LINES_PVT.create_repair_actual_lines');

2798: x_msg_data => x_msg_data
2799: );
2800: if (lc_proc_level >= lc_debug_level) then
2801: FND_LOG.STRING(lc_proc_level, lc_mod_name,
2802: 'Returned from CSD_REPAIR_ACTUAL_LINES_PVT.create_repair_actual_lines');
2803: end if;
2804:
2805: -- Throw an error if the API returned an error.
2806: -- We do not stall the process if we find an error in

Line 2857: 'Calling CSD_REPAIR_ACTUAL_LINES_PVT.update_repair_actual_lines');

2853: l_charge_line_rec.ship_to_org_id := l_ship_to_party_site_id;
2854:
2855: if (lc_proc_level >= lc_debug_level) then
2856: FND_LOG.STRING(lc_proc_level, lc_mod_name,
2857: 'Calling CSD_REPAIR_ACTUAL_LINES_PVT.update_repair_actual_lines');
2858: end if;
2859:
2860: CSD_REPAIR_ACTUAL_LINES_PVT.update_repair_actual_lines (
2861: p_api_version => 1.0,

Line 2860: CSD_REPAIR_ACTUAL_LINES_PVT.update_repair_actual_lines (

2856: FND_LOG.STRING(lc_proc_level, lc_mod_name,
2857: 'Calling CSD_REPAIR_ACTUAL_LINES_PVT.update_repair_actual_lines');
2858: end if;
2859:
2860: CSD_REPAIR_ACTUAL_LINES_PVT.update_repair_actual_lines (
2861: p_api_version => 1.0,
2862: p_commit => p_commit,
2863: p_init_msg_list => p_init_msg_list,
2864: p_validation_level => p_validation_level,

Line 2873: 'Returned from CSD_REPAIR_ACTUAL_LINES_PVT.update_repair_actual_lines');

2869: x_msg_data => x_msg_data
2870: );
2871: if (lc_proc_level >= lc_debug_level) then
2872: FND_LOG.STRING(lc_proc_level, lc_mod_name,
2873: 'Returned from CSD_REPAIR_ACTUAL_LINES_PVT.update_repair_actual_lines');
2874: end if;
2875:
2876: -- Throw an error if the API returned an error.
2877: -- We do not stall the process if we find an error in

Line 3088: x_actual_lines_tbl IN OUT NOCOPY CSD_REPAIR_ACTUAL_LINES_PVT.CSD_ACTUAL_LINES_TBL_TYPE ) IS

3084:
3085: PROCEDURE Convert_MLE_To_Actuals( p_MLE_lines_tbl IN CSD_CHARGE_LINE_UTIL.MLE_LINES_TBL_TYPE,
3086: p_repair_line_id IN NUMBER,
3087: p_repair_actual_id IN NUMBER,
3088: x_actual_lines_tbl IN OUT NOCOPY CSD_REPAIR_ACTUAL_LINES_PVT.CSD_ACTUAL_LINES_TBL_TYPE ) IS
3089: l_count NUMBER := 0;
3090:
3091: BEGIN
3092: l_count := p_MLE_lines_tbl.COUNT;