[Home] [Help]
PACKAGE: APPS.CRP_PLANNER_PK
Source
1 PACKAGE crp_planner_pk AUTHID CURRENT_USER AS
2 /* $Header: CRPPPLNS.pls 115.1 99/07/16 10:31:12 porting ship $ */
3 PROCEDURE start_plan(
4 arg_compile_desig VARCHAR2,
5 arg_org_id NUMBER,
6 arg_user_id NUMBER);
7 PROCEDURE complete_plan(
8 arg_compile_desig VARCHAR2,
9 arg_org_id NUMBER,
10 arg_user_id NUMBER);
11 PROCEDURE plan_jobs(
12 arg_compile_desig VARCHAR2,
13 arg_org_id NUMBER,
14 arg_user_id NUMBER,
15 arg_cutoff_date DATE,
16 arg_request_id NUMBER,
17 arg_calendar_code VARCHAR2,
18 arg_exception_set_id NUMBER);
19 PROCEDURE plan_discrete(
20 arg_compile_desig VARCHAR2,
21 arg_org_id NUMBER,
22 arg_user_id NUMBER,
23 arg_cutoff_date DATE,
24 arg_request_id NUMBER,
25 arg_calendar_code VARCHAR2,
26 arg_exception_set_id NUMBER);
27 PROCEDURE plan_repetitive(
28 arg_compile_desig VARCHAR2,
29 arg_org_id NUMBER,
30 arg_user_id NUMBER,
31 arg_cutoff_date DATE,
32 arg_request_id NUMBER,
33 arg_calendar_code VARCHAR2,
34 arg_exception_set_id NUMBER);
35 /*-------------------------------------------------------------------------+
36 | Defined constants |
37 +-------------------------------------------------------------------------*/
38 OPEN_ORDER CONSTANT INTEGER := 1; /* disposition status */
39 CANCEL_ORDER CONSTANT INTEGER := 2;
40
41 BASIS_PER_ITEM CONSTANT INTEGER := 1; /* CST_BASIS */
42 BASIS_PER_ORDER CONSTANT INTEGER := 2; /* CST_BASIS */
43 BASIS_RESOURCE_UNITS CONSTANT INTEGER := 3; /* CST_BASIS */
44 BASIS_RESOURCE_VALUE CONSTANT INTEGER := 4; /* CST_BASIS */
45 BASIS_TOTAL_VALUE CONSTANT INTEGER := 5; /* CST_BASIS */
46 BASIS_ACTIVITY_UNITS CONSTANT INTEGER := 6; /* CST_BASIS */
47
48 NOT_REPETITIVE_PLANNED CONSTANT INTEGER := 1; /*repetitive manufacturing */
49 REPETITIVELY_PLANNED CONSTANT INTEGER := 2;
50
51 PURCHASE_ORDER CONSTANT INTEGER := 1; /* order type lookup */
52 PURCH_REQ CONSTANT INTEGER := 2;
53 WORK_ORDER CONSTANT INTEGER := 3;
54 REPETITVE_SCHEDULE CONSTANT INTEGER := 4;
55 PLANNED_ORDER CONSTANT INTEGER := 5;
56 MATERIAL_TRANSFER CONSTANT INTEGER := 6;
57 NONSTD_JOB CONSTANT INTEGER := 7;
58 RECEIPT_PURCH_ORDER CONSTANT INTEGER := 8;
59 REQUIREMENT CONSTANT INTEGER := 9;
60 FPO_SUPPLY CONSTANT INTEGER := 10;
61
62 SYS_YES CONSTANT INTEGER := 1;
63 SYS_NO CONSTANT INTEGER := 2;
64
65 MAKE CONSTANT INTEGER := 1;
66 BUY CONSTANT INTEGER := 2;
67
68 END crp_planner_pk;