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