1 PACKAGE WSMPVLDT AUTHID CURRENT_USER AS
2 /* $Header: WSMVLDTS.pls 115.12 2002/11/20 01:42:50 bbalakum ship $ */
3
4 l_user_id number := FND_GLOBAL.USER_ID;
5 l_login_id number := FND_GLOBAL.LOGIN_ID;
6 l_request_id number := FND_GLOBAL.CONC_REQUEST_ID;
7 l_prog_appl_id number := FND_GLOBAL.PROG_APPL_ID;
8 l_program_id number := FND_GLOBAL.CONC_PROGRAM_ID;
9 l_debug varchar2(1) := FND_PROFILE.VALUE('MRP_DEBUG');
10 /*---------------------------------------------------------------------
11 | VALIDATE_RECORDS
12 |
13 | Validate the following columns in each records of the three
14 | interface table:
15 | WIP_SPLIT_MERGE_TNX_INTERFACE
16 | - transaction_type
17 | - organization_id
18 | - reason_id
19 | WIP_STARTING_JOBS_INTERFACE
20 | - header_id
21 | - wip_entity_id
22 | - operation_seq_num
23 | - intraoperation_step
24 | WIP_RESULTING_JOBS_INTERFACE
25 | - header_id
26 | - wip_entity_name
27 | - primary_item_id
28 | - class_code
29 | - start_quantity
30 | - bom_reference_id
31 | - routing_reference_id
32 | - alternate_bom_designator
33 | - alternate_routing_designator
34 | - populate common_bom_sequence_id and common_routing_sequence_id
35 | - starting_operation_seq_num
36 | - starting_intraoperation_step
37 | - starting_wip_entity_rename
38 |
39 | Validate the following is true for each transaction:
40 | - Merge tnx only: Verify all starting lots are at the same
41 | operation seq and intraopeartion step
42 | - Number of starting lots and resulting lots are correct
43 | - Sum of resulting lot starting quantities equal starting lot
44 | available quantities
45 | - Update the resulting lot primary item id, operation sequence,
46 | and intraoperation step to be same as the matching starting lot
47 +---------------------------------------------------------------------*/
48 PROCEDURE VALIDATE_RECORDS(p_err_msg IN OUT NOCOPY VARCHAR2,
49 -- p_err_code IN OUT VARCHAR2,
50 p_err_num IN OUT NOCOPY NUMBER);
51
52 PROCEDURE CHECK_MERGE_OP(p_err_msg IN OUT NOCOPY VARCHAR2,
53 -- p_err_code IN OUT VARCHAR2,
54 p_err_num IN OUT NOCOPY NUMBER);
55 PROCEDURE CHECK_NUMBER_OF_LOTS(p_err_msg IN OUT NOCOPY VARCHAR2,
56 -- p_err_code IN OUT VARCHAR2,
57 p_err_num IN OUT NOCOPY NUMBER);
58 PROCEDURE CHECK_TOTAL_QTY(p_err_msg IN OUT NOCOPY VARCHAR2,
59 -- p_err_code IN OUT VARCHAR2,
60 p_err_num IN OUT NOCOPY NUMBER);
61 PROCEDURE MATCH_START_RESULT_LOT(p_err_msg IN OUT NOCOPY VARCHAR2,
62 -- p_err_code IN OUT VARCHAR2,
63 p_err_num IN OUT NOCOPY NUMBER);
64
65 /*---------------------------------------------------------------------
66 | Default the following columns if they are null
67 | - class_code
68 | - starting_operation_seq_num
69 | - intraoperation_step
70 +---------------------------------------------------------------------*/
71 /* BD - WLTEnh - Made this procedure PRIVATE.
72
73 PROCEDURE POPULATE_COLUMNS(p_header_id IN OUT NUMBER, -- WLTEnh
74 p_err_msg IN OUT VARCHAR2,
75 -- p_err_code IN OUT VARCHAR2,
76 p_err_num IN OUT NUMBER);
77
78 */
79
80 END WSMPVLDT;