1 PACKAGE CSTPECEP AS
2 /* $Header: CSTECEPS.pls 120.1 2005/08/09 07:06:28 arathee noship $*/
3
4 /*---------------------------------------------------------------------------*
5 | PUBLIC PROCEDURE |
6 | estimate_wip_jobs |
7 | |
8 | p_job_otion : |
9 | 1: All Jobs |
10 | 2: Specific job |
11 | 3: All Jobs for an asset |
12 | 4: All Jobs for an department |
13 | |
14 | Estimation Status : |
15 | NULL,1: Pending |
16 | -ve : Running |
17 | 3: Error |
18 | 7: Complete |
19 | |
20 | PARAMETERS |
21 | p_organization_id |
22 | p_entity_type |
23 | p_job_option |
24 | p_wip_entity_id |
25 | p_asset_group_id |
26 | p_asset_number |
27 | p_owning_department_id |
28 | |
29 *----------------------------------------------------------------------------*/
30
31 PROCEDURE estimate_wip_jobs(
32 errbuf OUT NOCOPY VARCHAR2,
33 retcode OUT NOCOPY NUMBER,
34 p_organization_id IN NUMBER,
35 p_entity_type IN NUMBER DEFAULT 6,
36 p_job_option IN NUMBER DEFAULT 1,
37 p_item_dummy IN NUMBER DEFAULT NULL,
38 p_job_dummy IN NUMBER DEFAULT NULL,
39 p_owning_department_dummy IN NUMBER DEFAULT NULL,
40 p_wip_entity_id IN NUMBER DEFAULT NULL,
41 p_inventory_item_id IN NUMBER DEFAULT NULL,
42 p_asset_number IN VARCHAR2 DEFAULT NULL,
43 p_owning_department_id IN NUMBER DEFAULT NULL
44 );
45
46 /*---------------------------------------------------------------------------*
47 | PUBLIC PROCEDURE |
48 | Estimate_WorkOrder_GRP |
49 | |
50 | API provided for online estimation of workorder. |
51 | WDJ.estimation_status should be set to Running and Committed |
52 | before calling this API. This is to prevent concurrency issues |
53 | if there is a Cost Estimation Concurrent request currently |
54 | running. |
55 | |
56 | This API has been added as part of estimation enhancements for |
57 | Patchset I. |
58 | |
59 | |
60 | PARAMETERS |
61 | p_organization_id |
62 | p_wip_entity_id |
63 | |
64 *----------------------------------------------------------------------------*/
65
66 PROCEDURE Estimate_WorkOrder_GRP(
67 p_api_version IN NUMBER,
68 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
69 p_commit IN VARCHAR2 := FND_API.G_FALSE,
70 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_msg_count OUT NOCOPY NUMBER,
73 x_msg_data OUT NOCOPY VARCHAR2,
74 p_organization_id IN NUMBER,
75 p_wip_entity_id IN NUMBER
76 );
77
78 /*------------------------------------------------------------------------------------*
79 Declaring a table type to be used to get wip_entity_id for processing during estimation
80 *-------------------------------------------------------------------------------------*/
81 TYPE wip_entity_id_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
82
83 END CSTPECEP;