APPS.WMS_OP_PLAN_DETAILS_PKG dependencies on WMS_OP_PLAN_DETAILS

Line 1: PACKAGE BODY WMS_OP_PLAN_DETAILS_PKG AS

1: PACKAGE BODY WMS_OP_PLAN_DETAILS_PKG AS
2: /* $Header: WMSOPLDB.pls 120.0 2005/05/25 08:53:00 appldev noship $ */
3: --
4: PROCEDURE INSERT_ROW (
5: x_rowid IN OUT nocopy VARCHAR2

Line 58: CURSOR C IS SELECT ROWID FROM WMS_OP_PLAN_DETAILS

54: ,x_is_in_inventory IN VARCHAR2
55: ,x_subsequent_op_plan_id IN NUMBER
56: ,x_consolidation_method_id IN NUMBER
57: )IS
58: CURSOR C IS SELECT ROWID FROM WMS_OP_PLAN_DETAILS
59: WHERE operation_plan_detail_id = x_operation_plan_detail_id
60: AND operation_plan_id = x_operation_plan_id;
61: BEGIN
62: INSERT INTO WMS_OP_PLAN_DETAILS (

Line 62: INSERT INTO WMS_OP_PLAN_DETAILS (

58: CURSOR C IS SELECT ROWID FROM WMS_OP_PLAN_DETAILS
59: WHERE operation_plan_detail_id = x_operation_plan_detail_id
60: AND operation_plan_id = x_operation_plan_id;
61: BEGIN
62: INSERT INTO WMS_OP_PLAN_DETAILS (
63: operation_plan_id
64: ,operation_plan_detail_id
65: ,operation_type
66: ,operation_sequence

Line 230: UPDATE WMS_OP_PLAN_DETAILS SET

226: ,x_subsequent_op_plan_id IN NUMBER
227: ,x_consolidation_method_id IN NUMBER
228: )IS
229: BEGIN
230: UPDATE WMS_OP_PLAN_DETAILS SET
231: last_updated_by = x_last_updated_by
232: ,last_update_date = x_last_update_date
233: ,last_update_login = x_last_update_login
234: ,operation_type = x_operation_type

Line 349: WMS_OP_PLAN_DETAILS_PKG.update_row (

345: END IF;
346: --
347: --SELECT Sysdate INTO l_sysdate FROM dual ;
348: l_operation_plan_detail_id := fnd_number.canonical_to_number(x_operation_plan_detail_id);
349: WMS_OP_PLAN_DETAILS_PKG.update_row (
350: x_operation_plan_detail_id => l_operation_plan_detail_id
351: ,x_last_updated_by => l_user_id
352: ,x_last_update_date => to_date(x_last_update_date,'yyyy/mm/dd')
353: ,x_last_update_login => 0

Line 402: WMS_OP_PLAN_DETAILS_PKG.insert_row (

398: ,x_consolidation_method_id => x_consolidation_method_id
399: );
400: EXCEPTION
401: WHEN no_data_found THEN
402: WMS_OP_PLAN_DETAILS_PKG.insert_row (
403: x_rowid => l_row_id
404: ,x_operation_plan_detail_id => l_operation_plan_detail_id
405: ,x_last_updated_by => l_user_id
406: ,x_last_update_date => to_date(x_last_update_date,'yyyy/mm/dd')

Line 555: from wms_op_plan_details

551: ,organization_id
552: ,is_in_inventory
553: ,subsequent_op_plan_id
554: ,consolidation_method_id
555: from wms_op_plan_details
556: where operation_plan_detail_id = x_operation_plan_detail_id
557: for UPDATE of OPERATION_PLAN_DETAIL_ID NOWAIT;
558: recinfo C%rowtype;
559:

Line 715: delete from WMS_OP_PLAN_DETAILS

711: ) IS
712:
713: BEGIN
714:
715: delete from WMS_OP_PLAN_DETAILS
716: where OPERATION_PLAN_DETAIL_ID = X_OPERATION_PLAN_DETAIL_ID;
717:
718: if (sql%notfound) then
719: raise no_data_found;

Line 726: END WMS_OP_PLAN_DETAILS_PKG;

722: END delete_row;
723:
724:
725:
726: END WMS_OP_PLAN_DETAILS_PKG;