DBA Data[Home] [Help]

APPS.CSD_REPAIR_ACTUAL_PROCESS_PVT dependencies on CSD_CHARGE_LINE_UTIL

Line 1532: 'Calling CSD_CHARGE_LINE_UTIL.Get_DefaultContract');

1528: -- unnecessary validate them.
1529:
1530: if (lc_proc_level >= lc_debug_level) then
1531: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1532: 'Calling CSD_CHARGE_LINE_UTIL.Get_DefaultContract');
1533: end if;
1534:
1535: -- Get default Contract.
1536: l_default_contract_line_id := CSD_CHARGE_LINE_UTIL.Get_DefaultContract( p_repair_line_id );

Line 1536: l_default_contract_line_id := CSD_CHARGE_LINE_UTIL.Get_DefaultContract( p_repair_line_id );

1532: 'Calling CSD_CHARGE_LINE_UTIL.Get_DefaultContract');
1533: end if;
1534:
1535: -- Get default Contract.
1536: l_default_contract_line_id := CSD_CHARGE_LINE_UTIL.Get_DefaultContract( p_repair_line_id );
1537:
1538: if (lc_proc_level >= lc_debug_level) then
1539: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1540: 'Returned from CSD_CHARGE_LINE_UTIL.Get_DefaultContract. '

Line 1540: 'Returned from CSD_CHARGE_LINE_UTIL.Get_DefaultContract. '

1536: l_default_contract_line_id := CSD_CHARGE_LINE_UTIL.Get_DefaultContract( p_repair_line_id );
1537:
1538: if (lc_proc_level >= lc_debug_level) then
1539: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1540: 'Returned from CSD_CHARGE_LINE_UTIL.Get_DefaultContract. '
1541: || 'l_default_contract_line_id = ' || l_default_contract_line_id);
1542: end if;
1543:
1544: --DBMS_OUTPUT.put_line( 'l_default_contract_line_id = '

Line 1549: 'Calling CSD_CHARGE_LINE_UTIL.Get_RO_PriceList');

1545: -- || TO_CHAR( l_default_contract_line_id ));
1546:
1547: if (lc_proc_level >= lc_debug_level) then
1548: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1549: 'Calling CSD_CHARGE_LINE_UTIL.Get_RO_PriceList');
1550: end if;
1551:
1552: -- Get default pricelist for the repair order.
1553: l_default_price_list_hdr_id := CSD_CHARGE_LINE_UTIL.Get_RO_PriceList(p_repair_line_id);

Line 1553: l_default_price_list_hdr_id := CSD_CHARGE_LINE_UTIL.Get_RO_PriceList(p_repair_line_id);

1549: 'Calling CSD_CHARGE_LINE_UTIL.Get_RO_PriceList');
1550: end if;
1551:
1552: -- Get default pricelist for the repair order.
1553: l_default_price_list_hdr_id := CSD_CHARGE_LINE_UTIL.Get_RO_PriceList(p_repair_line_id);
1554:
1555: if (lc_proc_level >= lc_debug_level) then
1556: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1557: 'Returned from CSD_CHARGE_LINE_UTIL.Get_RO_PriceList. '

Line 1557: 'Returned from CSD_CHARGE_LINE_UTIL.Get_RO_PriceList. '

1553: l_default_price_list_hdr_id := CSD_CHARGE_LINE_UTIL.Get_RO_PriceList(p_repair_line_id);
1554:
1555: if (lc_proc_level >= lc_debug_level) then
1556: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1557: 'Returned from CSD_CHARGE_LINE_UTIL.Get_RO_PriceList. '
1558: || 'l_default_price_list_hdr_id = ' ||l_default_price_list_hdr_id);
1559: end if;
1560:
1561: --DBMS_OUTPUT.put_line( 'The price list id is = '

Line 1684: l_MLE_MTL_lines_tbl CSD_CHARGE_LINE_UTIL.MLE_LINES_TBL_TYPE;

1680:
1681: DECLARE
1682:
1683: -- Stores all the material txn lines
1684: l_MLE_MTL_lines_tbl CSD_CHARGE_LINE_UTIL.MLE_LINES_TBL_TYPE;
1685:
1686: -- Stores all the WIP/resource txn lines
1687: l_MLE_RES_lines_tbl CSD_CHARGE_LINE_UTIL.MLE_LINES_TBL_TYPE;
1688:

Line 1687: l_MLE_RES_lines_tbl CSD_CHARGE_LINE_UTIL.MLE_LINES_TBL_TYPE;

1683: -- Stores all the material txn lines
1684: l_MLE_MTL_lines_tbl CSD_CHARGE_LINE_UTIL.MLE_LINES_TBL_TYPE;
1685:
1686: -- Stores all the WIP/resource txn lines
1687: l_MLE_RES_lines_tbl CSD_CHARGE_LINE_UTIL.MLE_LINES_TBL_TYPE;
1688:
1689: -- Stores eligible material/resource txn lines only
1690: x_valid_MLE_lines_tbl CSD_CHARGE_LINE_UTIL.MLE_LINES_TBL_TYPE;
1691:

Line 1690: x_valid_MLE_lines_tbl CSD_CHARGE_LINE_UTIL.MLE_LINES_TBL_TYPE;

1686: -- Stores all the WIP/resource txn lines
1687: l_MLE_RES_lines_tbl CSD_CHARGE_LINE_UTIL.MLE_LINES_TBL_TYPE;
1688:
1689: -- Stores eligible material/resource txn lines only
1690: x_valid_MLE_lines_tbl CSD_CHARGE_LINE_UTIL.MLE_LINES_TBL_TYPE;
1691:
1692: -- Stores eligible charge lines corresponding to x_valid_MLE_lines_tbl
1693: x_charge_lines_tbl CSD_CHARGE_LINE_UTIL.CHARGE_LINES_TBL_TYPE;
1694:

Line 1693: x_charge_lines_tbl CSD_CHARGE_LINE_UTIL.CHARGE_LINES_TBL_TYPE;

1689: -- Stores eligible material/resource txn lines only
1690: x_valid_MLE_lines_tbl CSD_CHARGE_LINE_UTIL.MLE_LINES_TBL_TYPE;
1691:
1692: -- Stores eligible charge lines corresponding to x_valid_MLE_lines_tbl
1693: x_charge_lines_tbl CSD_CHARGE_LINE_UTIL.CHARGE_LINES_TBL_TYPE;
1694:
1695: -- It's really same as x_valid_MLE_lines_tbl but in repair actual line format.
1696: -- The reason we have two TYPES for the same set of data is that -
1697: -- CSD_CHARGE_LINE_UTIL.MLE_LINES_TBL_TYPE is generic format and can be

Line 1697: -- CSD_CHARGE_LINE_UTIL.MLE_LINES_TBL_TYPE is generic format and can be

1693: x_charge_lines_tbl CSD_CHARGE_LINE_UTIL.CHARGE_LINES_TBL_TYPE;
1694:
1695: -- It's really same as x_valid_MLE_lines_tbl but in repair actual line format.
1696: -- The reason we have two TYPES for the same set of data is that -
1697: -- CSD_CHARGE_LINE_UTIL.MLE_LINES_TBL_TYPE is generic format and can be
1698: -- utilized by both ESTIMATE and ACTUALS, whereas
1699: -- CSD_REPAIR_ACTUAL_LINES_PVT.CSD_ACTUAL_LINES_TBL_TYPE is specific to
1700: -- Actuals.
1701: l_actual_lines_tbl CSD_REPAIR_ACTUAL_LINES_PVT.CSD_ACTUAL_LINES_TBL_TYPE;

Line 1817: 'Calling procedure CSD_CHARGE_LINE_UTIL.Convert_To_Charge_Lines.');

1813: -- || l_MLE_MTL_lines_tbl.COUNT );
1814:
1815: if (lc_proc_level >= lc_debug_level) then
1816: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1817: 'Calling procedure CSD_CHARGE_LINE_UTIL.Convert_To_Charge_Lines.');
1818: end if;
1819:
1820: -- Filter out all the bad data and populate 'Charges' table
1821: -- and MLE table with valid set of data.

Line 1822: CSD_CHARGE_LINE_UTIL.Convert_To_Charge_Lines( p_api_version => 1.0,

1818: end if;
1819:
1820: -- Filter out all the bad data and populate 'Charges' table
1821: -- and MLE table with valid set of data.
1822: CSD_CHARGE_LINE_UTIL.Convert_To_Charge_Lines( p_api_version => 1.0,
1823: p_commit => FND_API.G_FALSE,
1824: p_init_msg_list => FND_API.G_FALSE,
1825: p_validation_level => p_validation_level,
1826: x_return_status => l_return_status,

Line 1848: 'Returned from procedure CSD_CHARGE_LINE_UTIL.Convert_To_Charge_Lines. '

1844: x_warning_flag => x_curr_warning_flag );
1845:
1846: if (lc_proc_level >= lc_debug_level) then
1847: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1848: 'Returned from procedure CSD_CHARGE_LINE_UTIL.Convert_To_Charge_Lines. '
1849: || 'x_curr_warning_flag = ' || x_curr_warning_flag);
1850: end if;
1851:
1852: --DBMS_OUTPUT.put_line( 'after getting the valid MTL data '

Line 1943: 'Calling procedure CSD_CHARGE_LINE_UTIL.Convert_To_Charge_Lines.');

1939: -- || l_MLE_MTL_lines_tbl.COUNT );
1940:
1941: if (lc_proc_level >= lc_debug_level) then
1942: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1943: 'Calling procedure CSD_CHARGE_LINE_UTIL.Convert_To_Charge_Lines.');
1944: end if;
1945:
1946: -- Filter out all the bad data and populate 'Charges' table
1947: -- and MLE table with valid set of data.

Line 1948: CSD_CHARGE_LINE_UTIL.Convert_To_Charge_Lines( p_api_version => 1.0,

1944: end if;
1945:
1946: -- Filter out all the bad data and populate 'Charges' table
1947: -- and MLE table with valid set of data.
1948: CSD_CHARGE_LINE_UTIL.Convert_To_Charge_Lines( p_api_version => 1.0,
1949: p_commit => FND_API.G_FALSE,
1950: p_init_msg_list => FND_API.G_FALSE,
1951: p_validation_level => p_validation_level,
1952: x_return_status => l_return_status,

Line 1974: 'Returned from procedure CSD_CHARGE_LINE_UTIL.Convert_To_Charge_Lines. '

1970: x_warning_flag => x_curr_warning_flag );
1971:
1972: if (lc_proc_level >= lc_debug_level) then
1973: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1974: 'Returned from procedure CSD_CHARGE_LINE_UTIL.Convert_To_Charge_Lines. '
1975: || 'x_curr_warning_flag = ' || x_curr_warning_flag);
1976: end if;
1977:
1978: --DBMS_OUTPUT.put_line( 'after getting the valid RES lines '

Line 3128: PROCEDURE Convert_MLE_To_Actuals( p_MLE_lines_tbl IN CSD_CHARGE_LINE_UTIL.MLE_LINES_TBL_TYPE,

3124: /* Called from : Import_Actuals_From_Wip */
3125: /* */
3126: /*--------------------------------------------------------------------*/
3127:
3128: PROCEDURE Convert_MLE_To_Actuals( p_MLE_lines_tbl IN CSD_CHARGE_LINE_UTIL.MLE_LINES_TBL_TYPE,
3129: p_repair_line_id IN NUMBER,
3130: p_repair_actual_id IN NUMBER,
3131: x_actual_lines_tbl IN OUT NOCOPY CSD_REPAIR_ACTUAL_LINES_PVT.CSD_ACTUAL_LINES_TBL_TYPE ) IS
3132: l_count NUMBER := 0;