1 PACKAGE QLTAUFLB AS
2 /* $Header: qltauflb.pls 120.2.12000000.1 2007/01/19 07:14:11 appldev ship $ */
3 -- Fill in missing elements/actions for an Inspection Plan.
4 -- 07/31/97
5 -- Munazza Bukhari
6
7 --
8 -- Bug 3926150 need to add a new out param.
9 -- This proc is called from two places:
10 -- QLTPLMDF.QP_TRANSACTIONS_CONTROL various procedures
11 -- QASLSET.pld
12 --
13 FUNCTION auto_fill_missing_char (X_PLAN_ID NUMBER,
14 X_COPY_PLAN_ID NUMBER,
15 X_USER_ID NUMBER,
16 X_DISABLED_INDEXED_ELEMENTS OUT NOCOPY VARCHAR2
17 ) RETURN NUMBER;
18
19 FUNCTION add_ss_elements (p_plan_id NUMBER, p_user_id IN NUMBER)
20 RETURN NUMBER;
21
22 -- Fill in missing elements for the action 'Create a work request'.
23 -- suramasw Fri Jun 21 00:42:03 PDT 2002
24
25 PROCEDURE add_work_req_elements (p_plan_id IN NUMBER, p_user_id IN NUMBER);
26
27 -- Bug 3517598. If lot/serial number is present in plan
28 -- add LPN automatically. Function to add lpn to plan.
29
30 FUNCTION auto_fill_lpn (X_PLAN_ID NUMBER,
31 X_USER_ID NUMBER
32 ) RETURN NUMBER;
33
34 -- Bug 5147965 ksiddhar EAM Transaction Dependency Check
35 FUNCTION auto_fill_missing_char_eam (X_PLAN_ID NUMBER,
36 X_COPY_PLAN_ID NUMBER,
37 X_USER_ID NUMBER
38 ) RETURN NUMBER;
39 -- Bug 5147965 ksiddhar EAM Transaction Dependency Check
40 END QLTAUFLB;
41