1 PACKAGE WIP_JOB_DTLS_VALIDATIONS AUTHID CURRENT_USER AS
2 /* $Header: wipjdvds.pls 115.8 2003/04/11 23:08:18 rseela ship $ */
3
4 x_statement VARCHAR2(2000);
5
6 /********* check each job in a given group ********************************/
7
8 /* Jobs must exist */
9 Procedure Jobs (p_group_id number,
10 p_parent_header_id number);
11
12 /* job must be in status unreleased, released, complete, hold */
13 Procedure Job_Status(p_group_id number,
14 p_parent_header_id number);
15
16 /* Job must be NOT firmed */
17 Procedure Is_Firm(p_group_id number,
18 p_parent_header_id number);
19
20 /****** Check for each load_type/substitution_type in a given job **********/
21
22 /* operation_seq_num must exist in that job */
23 Procedure OP_Seq_Num(p_group_id number,
24 p_parent_header_id number,
25 p_wip_entity_id number,
26 p_organization_id number);
27
28 /* Load_type must be 1(resource) or 2 (Requirement),
29 Substitution type must be 1(delete) or 2 (add) or 3 Delete) */
30 Procedure Load_Sub_Types (p_group_id number,
31 p_parent_header_id number,
32 p_wip_entity_id number,
33 p_organization_id number);
34
35 /* must be created and updated by valid user */
36 PROCEDURE Last_Updated_By(p_group_id number,
37 p_parent_header_id number,
38 p_wip_entity_id number,
39 p_organization_id number);
40
41 PROCEDURE Created_By(p_group_id number,
42 p_parent_header_id number,
43 p_wip_entity_id number,
44 p_organization_id number);
45
46
47 /*********** Utilites to detect and display errors *********************/
48
49 /* If any row for a discrete job fails, all rows for that job will fail */
50 Procedure ERROR_ALL_IF_ANY(p_group_id number,
51 p_parent_header_id number,
52 P_wip_entity_id number,
53 p_organization_id number);
54
55 END WIP_JOB_DTLS_VALIDATIONS;