[Home] [Help]
PACKAGE: APPS.CTO_AUTO_DROPSHIP_PK
Source
1 PACKAGE cto_auto_dropship_pk AUTHID CURRENT_USER AS
2 /*$Header: CTODROPS.pls 120.1 2005/06/06 09:45:16 appldev $ */
3 /*============================================================================+
4 | Copyright (c) 1999 Oracle Corporation Belmont, California, USA |
5 | All rights reserved. |
6 | Oracle Manufacturing |
7 +=============================================================================+
8 | |
9 | FILE NAME : CTODROPS.pls |
10 | DESCRIPTION: |
11 | Contain all CTO and WF related APIs for AutoCreate Purchase |
12 | Requisitions. This Package creates the following |
13 | Procedures |
14 | 1. AUTO_CREATE_DROPSHIP |
15 | Functions |
16 | HISTORY : |
17 | 20-FEB-2002 : Sushant Sawant Initial version |
18 | 01-Jun-2005 : Renga Kannan Added NOCOPY HINT for all out parameters.
19 =============================================================================*/
20
21 -- CTO_AUTO_DROPSHIP_PK
22 -- following parameters are created for
23 g_pkg_name CONSTANT VARCHAR2(30) := 'CTO_AUTO_DROPSHIP_PK';
24 gMrpAssignmentSet NUMBER ;
25
26
27 /**************************************************************************
28 Procedure: AUTO_CREATE_DROPSHIP
29 Parameters: p_sales_order NUMBER -- Sales Order number.
30 p_dummy_field VARCHAR2 -- Dummy field for the Concurrent Request.
31 p_sales_order_line_id NUMBER -- Sales Order Line number.
32 p_organization_id VARCHAR2 -- Ship From Organization ID.
33 current_organization_id NUMBER -- Current Org ID
34 p_offset_days NUMBER -- Offset days.
35
36 Description: This procedure is called from the concurrent progran to run the
37 AutoCreate Purchase Requisitions.
38 *****************************************************************************/
39 PROCEDURE auto_create_dropship (
40 errbuf OUT NOCOPY VARCHAR2,
41 retcode OUT NOCOPY VARCHAR2,
42 p_sales_order NUMBER,
43 p_dummy_field VARCHAR2,
44 p_sales_order_line_id NUMBER,
45 p_organization_id VARCHAR2,
46 current_organization_id NUMBER, -- VARCHAR2,
47 p_offset_days NUMBER );
48
49
50 END cto_auto_dropship_pk;