[Home] [Help]
PACKAGE BODY: APPS.MRP_SNAPSHOT_PK
Source
1 PACKAGE BODY mrp_snapshot_pk AS
2 /* $Header: MRPPSNPB.pls 115.0 99/07/16 12:34:33 porting ship $ */
3
4 MAKE_ITEM CONSTANT INTEGER:= 1;
5
6 -- ********************** complete_task *************************
7 PROCEDURE complete_task(
8 arg_compile_desig IN VARCHAR2,
9 arg_org_id IN NUMBER,
10 arg_task IN NUMBER) IS
11 BEGIN
12
13 UPDATE mrp_snapshot_tasks
14 SET completion_date = SYSDATE,
15 program_update_date = SYSDATE
16 WHERE task = arg_task
17 AND organization_id = arg_org_id
18 AND compile_designator = arg_compile_desig;
19
20 COMMIT;
21
22 END complete_task;
23
24 END; -- package