1 PACKAGE AS_PIPELINE_MOVE_PUB AUTHID CURRENT_USER as
2 /* $Header: asxppmvs.pls 120.1 2005/06/05 22:52:24 appldev $ */
3
4 --
5 -- HISTORY
6 -- 02/27/01 ACNG Created.
7 -- NOTES
8 -- The main package for the concurrent program "Pipeline movement"
9 --
10 /************************************************************/
11 /* This script is used to move sales credits and access */
12 /* records from one salesforce to another salesforce */
13 /* Input required : User login (from which user ) */
14 /* group name (from which salesgroup) */
15 /* User login ( to which user ) */
16 /* group name ( to which salesgroup) */
17 /* win probability (win probability range) */
18 /* decision date (close date range ) */
19 /* status (statuses ) */
20 /************************************************************/
21 /********************************************************************************/
22 /* Instruction to run this SQL script, parameters are in sequence */
23 /* 1) from_user_name (move from which salesforce) */
24 /* 2) to_user_name (move to which salesforce) */
25 /* 3) from_group_name (move from group where the salesforce belongs to) */
26 /* 4) to_group_name (move to group where the salesforce belongs to) */
27 /* 5) from_win_prob (move sales credits with win prob range starts from) */
28 /* Default value = 0 if no input from user */
29 /* 6) to_win_prob (move sales credits with win prob range ends at) */
30 /* Default value = 100 if no input from user */
31 /* 7) from_close_date (decision date range starts from) */
32 /* Please input the date as the following format */
33 /* e.g.: 01-JAN-1999 */
34 /* Default value = 01-JAN-1900 */
35 /* 8) to_close_date (decision date range ends at) */
36 /* Please input the date as the following format */
37 /* e.g.: 01-JAN-1999 */
38 /* Default value = 01-JAN-4712 */
39 /* 9) Statuses : all leads with these statuses will be moved */
40 /* Please input a list of statuses separated by comma (,) */
41 /* e.g.: won,preliminary */
42 /* Default value = all statuses if no input from user */
43 /********************************************************************************/
44 /*-------------------------------------------------------------------------*
45 | PRIVATE ROUTINE
46 | Pipeline_Movement
47 |
48 | PURPOSE
49 | The main program for pipeline movement.
50 | NOTES
51 |
52 | HISTORY
53 | 02/27/01 ACNG Created
54 *-------------------------------------------------------------------------*/
55
56 PROCEDURE Pipeline_Movement(
57 ERRBUF OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
58 RETCODE OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
59 p_from_user IN VARCHAR2,
60 p_from_grp IN VARCHAR2,
61 p_to_user IN VARCHAR2,
62 p_to_grp IN VARCHAR2,
63 p_from_win_prob IN NUMBER := NULL,
64 p_to_win_prob IN NUMBER := NULL,
65 p_from_close_date IN DATE := NULL,
66 p_to_close_date IN DATE := NULL,
67 p_status IN VARCHAR2 := NULL);
68
69 /*-------------------------------------------------------------------------*
70 | PRIVATE ROUTINE
71 | Pipeline_Movement for sales credits only
72 |
73 | PURPOSE
74 | The main program for pipeline movement for sales credits only
75 | NOTES
76 |
77 | HISTORY
78 | 02/27/01 ACNG Created
79 *-------------------------------------------------------------------------*/
80
81 PROCEDURE Pipeline_SC_Movement(
82 ERRBUF OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
83 RETCODE OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
84 p_from_user IN VARCHAR2,
85 p_from_grp IN VARCHAR2,
86 p_to_user IN VARCHAR2,
87 p_to_grp IN VARCHAR2,
88 p_from_win_prob IN NUMBER := NULL,
89 p_to_win_prob IN NUMBER := NULL,
90 p_from_close_date IN DATE := NULL,
91 p_to_close_date IN DATE := NULL,
92 p_status IN VARCHAR2 := NULL);
93
94 END AS_PIPELINE_MOVE_PUB;