APPS.WSM_RESERVATIONS_PVT dependencies on WSM_RESERVATIONS_PVT

Line 1: package body WSM_RESERVATIONS_PVT as

1: package body WSM_RESERVATIONS_PVT as
2: /* $Header: WSMVRSVB.pls 120.16 2006/06/21 10:17:28 sisankar noship $ */
3:
4: /* Package name */
5: g_pkg_name VARCHAR2(20) := 'WSM_RESERVATIONS_PVT';

Line 5: g_pkg_name VARCHAR2(20) := 'WSM_RESERVATIONS_PVT';

1: package body WSM_RESERVATIONS_PVT as
2: /* $Header: WSMVRSVB.pls 120.16 2006/06/21 10:17:28 sisankar noship $ */
3:
4: /* Package name */
5: g_pkg_name VARCHAR2(20) := 'WSM_RESERVATIONS_PVT';
6:
7: type t_wsm_rsv_v_tbl_type is table of wsm_reservations_v%rowtype index by binary_integer;
8: type t_wsm_reservations is table of wsm_reservations%rowtype index by binary_integer;
9: --type r_mtl_rsv_rec_type is record of mtl_reservations%rowtype;

Line 60: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSM_RESERVATIONS_PVT.modify_reservations_wlt';

56: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
57: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
58:
59: l_stmt_num NUMBER;
60: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSM_RESERVATIONS_PVT.modify_reservations_wlt';
61: l_param_tbl WSM_Log_PVT.param_tbl_type;
62:
63: l_msg_index number;
64: l_quantity_modified NUMBER;

Line 230: l_rsvd_qty := Wsm_reservations_pvt.check_reservation_quantity(

226: end loop; --MP delete reservations loop
227: end if; --MP Delete Changes :End of check on l_wsm_rsv_v_tbl.count > 0
228: --Elsif (p_starting_jobs_tbl(p_starting_jobs_tbl.first).net_quantity > p_resulting_jobs_tbl(p_sj_also_rj_index).net_quantity) then
229: ELSE
230: l_rsvd_qty := Wsm_reservations_pvt.check_reservation_quantity(
231: p_wip_entity_id => p_resulting_jobs_tbl(p_sj_also_rj_index).wip_entity_id,
232: P_org_id => p_starting_jobs_tbl(p_rep_job_index).organization_id,
233: P_inventory_item_id => p_starting_jobs_tbl(p_rep_job_index).primary_item_id
234: );

Line 548: WSM_RESERVATIONS_PVT.Modify_reservations_jobupdate(

544: if l_rsvd_qty > p_resulting_jobs_tbl(l_rj_index).net_quantity THEN
545: l_return_status := FND_API.G_RET_STS_SUCCESS;
546: l_msg_count := 0;
547: l_msg_data := null;
548: WSM_RESERVATIONS_PVT.Modify_reservations_jobupdate(
549: p_wip_entity_id => p_resulting_jobs_tbl(l_rj_index).wip_entity_id,
550: P_old_net_qty => l_rsvd_qty, --p_resulting_jobs_tbl(l_rj_index).net_quantity,
551: P_new_net_qty => p_resulting_jobs_tbl(l_rj_index).net_quantity,
552: P_inventory_item_id => p_resulting_jobs_tbl(l_rj_index).primary_item_id,

Line 566: p_msg_text => 'WSM_RESERVATIONS_PVT.Modify_reservations_jobupdate failed:'||l_msg_data,

562: if( g_log_level_statement >= l_log_level ) then
563:
564: l_msg_tokens.delete;
565: WSM_log_PVT.logMessage(p_module_name => l_module ,
566: p_msg_text => 'WSM_RESERVATIONS_PVT.Modify_reservations_jobupdate failed:'||l_msg_data,
567: p_stmt_num => l_stmt_num ,
568: p_msg_tokens => l_msg_tokens,
569: p_fnd_msg_level => G_MSG_LVL_ERROR ,
570: p_fnd_log_level => G_LOG_LEVEL_ERROR ,

Line 987: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSM_RESERVATIONS_PVT.modify_reservations_jobupdate';

983: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
984: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
985:
986: l_stmt_num NUMBER;
987: l_module CONSTANT VARCHAR2(100) := 'wsm.plsql.WSM_RESERVATIONS_PVT.modify_reservations_jobupdate';
988: l_param_tbl WSM_Log_PVT.param_tbl_type;
989:
990: l_msg_index number;
991: -- Logging variables...

Line 1347: end WSM_RESERVATIONS_PVT;

1343: Return false;
1344: end if;
1345: end check_reservation_exists;
1346:
1347: end WSM_RESERVATIONS_PVT;