APPS.WMS_OP_PLANS_PKG dependencies on WMS_OP_PLANS_B

Line 46: CURSOR C IS SELECT ROWID FROM WMS_OP_PLANS_B

42: ,x_default_flag IN VARCHAR2
43: ,x_template_flag IN VARCHAR2
44: ,x_crossdock_to_wip_flag IN VARCHAR2
45: )IS
46: CURSOR C IS SELECT ROWID FROM WMS_OP_PLANS_B
47: WHERE operation_plan_id = x_operation_plan_id;
48: BEGIN
49:
50: INSERT INTO WMS_OP_PLANS_B (

Line 50: INSERT INTO WMS_OP_PLANS_B (

46: CURSOR C IS SELECT ROWID FROM WMS_OP_PLANS_B
47: WHERE operation_plan_id = x_operation_plan_id;
48: BEGIN
49:
50: INSERT INTO WMS_OP_PLANS_B (
51: operation_plan_id
52: ,last_updated_by
53: ,last_update_date
54: ,created_by

Line 201: UPDATE WMS_OP_PLANS_B SET

197: ,x_template_flag IN VARCHAR2
198: ,x_crossdock_to_wip_flag IN VARCHAR2
199: )IS
200: BEGIN
201: UPDATE WMS_OP_PLANS_B SET
202: last_updated_by = x_last_updated_by
203: ,last_update_date = x_last_update_date
204: ,last_update_login = x_last_update_login
205: ,system_task_type = x_system_task_type

Line 304: from wms_op_plans_B where

300: BEGIN
301: l_operation_plan_id := fnd_number.canonical_to_number(x_operation_plan_id);
302: select LAST_UPDATED_BY,LAST_UPDATE_DATE
303: INTO db_luby,db_ludate
304: from wms_op_plans_B where
305: operation_plan_id = l_operation_plan_id ;
306: -- Test for customization and version
307: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
308: db_ludate, X_CUSTOM_MODE)) then

Line 405: delete from WMS_OP_PLANS_B

401: ) IS
402:
403: BEGIN
404:
405: delete from WMS_OP_PLANS_B
406: where OPERATION_PLAN_ID = X_OPERATION_PLAN_ID;
407:
408: if (sql%notfound) then
409: raise no_data_found;

Line 486: from wms_op_plans_b

482: ,attribute15
483: ,default_flag
484: ,template_flag
485: ,crossdock_to_wip_flag
486: from wms_op_plans_b
487: where operation_plan_id = x_operation_plan_id
488: for UPDATE of OPERATION_PLAN_ID NOWAIT;
489: recinfo C%rowtype;
490:

Line 643: UPDATE wms_op_plans_b SET

639:
640: -- Translate char last_update_date to date
641: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
642: /*
643: UPDATE wms_op_plans_b SET
644: last_update_date = Sysdate,
645: last_updated_by = Decode(x_owner, 'SEED', 1, 0),
646: last_update_login = 0
647: WHERE operation_plan_id = fnd_number.canonical_to_number(x_operation_plan_id);

Line 653: from wms_op_plans_B where

649: BEGIN
650: -- Test for customization and version
651: select LAST_UPDATED_BY,LAST_UPDATE_DATE
652: INTO db_luby,db_ludate
653: from wms_op_plans_B where
654: operation_plan_id = fnd_number.canonical_to_number(x_operation_plan_id);
655: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
656: db_ludate, x_custom_mode)) then
657:

Line 683: from WMS_OP_PLANS_B B

679: begin
680: delete from WMS_OP_PLANS_TL T
681: where not exists
682: (select NULL
683: from WMS_OP_PLANS_B B
684: where B.OPERATION_PLAN_ID = T.OPERATION_PLAN_ID
685: );
686:
687: update WMS_OP_PLANS_TL T set (