[Home] [Help]
PACKAGE: APPS.RLM_PS_SV
Source
1 PACKAGE RLM_PS_SV as
2 /*$Header: RLMDPPSS.pls 120.1.12000000.1 2007/01/18 18:31:47 appldev ship $*/
3 /*===========================================================================
4 PACKAGE NAME: RLM_PS_SV
5
6 DESCRIPTION: Contains all specifications for the PurgeSchedule package
7
8 CLIENT/SERVER: Server
9
10 LIBRARY NAME: None
11
12 OWNER:
13
14 PROCEDURE/FUNCTIONS:
15
16 GLOBALS:
17
18 ===========================================================================*/
19 C_SDEBUG CONSTANT NUMBER := rlm_core_sv.C_LEVEL1;
20 C_DEBUG CONSTANT NUMBER := rlm_core_sv.C_LEVEL2;
21 C_TDEBUG CONSTANT NUMBER := rlm_core_sv.C_LEVEL3;
22
23 /*===========================================================================
24 PROCEDURE NAME: PurgeSchedule
25
26 DESCRIPTION:
27
28 PARAMETERS: p_org_id NUMBER
29 p_execution_mode VARCHAR2 DEFAULT NULL
30 p_translator_code_from VARCHAR2 DEFAULT NULL
31 p_translator_code_to VARCHAR2 DEFAULT NULL
32 p_customer VARCHAR2 DEFAULT NULL
33 p_ship_to_address_id_from NUMBER DEFAULT NULL
34 p_ship_to_address_id_to NUMBER DEFAULT NULL
35 p_issue_date_from VARCHAR2 DEFAULT NULL
36 p_issue_date_to VARCHAR2 DEFAULT NULL
37 p_schedule_type VARCHAR2 DEFAULT NULL
38 p_schedule_ref_no VARCHAR2 DEFAULT NULL
39 p_delete_beyond_days NUMBER DEFAULT NULL
40 p_authorization VARCHAR2 DEFAULT NULL
41 p_status NUMBER DEFAULT NULL
42
43
44 DESIGN REFERENCES:
45
46 ALGORITHM:
47
48 NOTES:
49
50 OPEN ISSUES:
51
52 CLOSED ISSUES:
53
54 CHANGE HISTORY: created asutar 07/31/00
55 ===========================================================================*/
56 PROCEDURE PurgeSchedule( errbuf OUT NOCOPY VARCHAR2,
57 retcode OUT NOCOPY NUMBER,
58 p_org_id NUMBER,
59 p_execution_mode VARCHAR2 DEFAULT NULL,
60 p_translator_code_from VARCHAR2 DEFAULT NULL,
61 p_translator_code_to VARCHAR2 DEFAULT NULL,
62 p_customer VARCHAR2 DEFAULT NULL,
63 p_ship_to_address_id_from NUMBER DEFAULT NULL,
64 p_ship_to_address_id_to NUMBER DEFAULT NULL,
65 p_issue_date_from VARCHAR2 DEFAULT NULL,
66 p_issue_date_to VARCHAR2 DEFAULT NULL,
67 p_schedule_type VARCHAR2 DEFAULT NULL,
68 p_schedule_ref_no VARCHAR2 DEFAULT NULL,
69 p_delete_beyond_days NUMBER DEFAULT NULL,
70 p_authorization VARCHAR2 DEFAULT NULL,
71 p_status NUMBER DEFAULT NULL);
72
73
74 PROCEDURE PurgeInterface(p_execution_mode VARCHAR2 DEFAULT NULL,
75 p_authorization VARCHAR2 DEFAULT NULL,
76 p_ship_to_address_id_from NUMBER DEFAULT NULL,
77 p_ship_to_address_id_to NUMBER DEFAULT NULL,
78 p_statement VARCHAR2 DEFAULT NULL);
79
80 PROCEDURE PurgeArchive(p_execution_mode VARCHAR2 DEFAULT NULL,
81 p_authorization VARCHAR2 DEFAULT NULL,
82 p_ship_to_address_id_from NUMBER DEFAULT NULL,
83 p_ship_to_address_id_to NUMBER DEFAULT NULL,
84 p_statement VARCHAR2 DEFAULT NULL);
85
86
87
88 FUNCTION BuildQuery ( p_execution_mode VARCHAR2 DEFAULT NULL,
89 p_translator_code_from VARCHAR2 DEFAULT NULL,
90 p_translator_code_to VARCHAR2 DEFAULT NULL,
91 p_customer VARCHAR2 DEFAULT NULL,
92 p_ship_to_address_id_from NUMBER DEFAULT NULL,
93 p_ship_to_address_id_to NUMBER DEFAULT NULL,
94 p_issue_date_from VARCHAR2 DEFAULT NULL,
95 p_issue_date_to VARCHAR2 DEFAULT NULL,
96 p_schedule_type VARCHAR2 DEFAULT NULL,
97 p_schedule_ref_no NUMBER DEFAULT NULL,
98 p_delete_beyond_days NUMBER DEFAULT NULL,
99 p_authorization VARCHAR2 DEFAULT NULL,
100 p_status NUMBER DEFAULT NULL)
101 RETURN VARCHAR2;
102
103
104 PROCEDURE RunReport ( p_org_id NUMBER,
105 p_execution_mode VARCHAR2 DEFAULT NULL,
106 p_translator_code_from VARCHAR2 DEFAULT NULL,
107 p_translator_code_to VARCHAR2 DEFAULT NULL,
108 p_customer VARCHAR2 DEFAULT NULL,
109 p_ship_to_address_id_from NUMBER DEFAULT NULL,
110 p_ship_to_address_id_to NUMBER DEFAULT NULL,
111 p_issue_date_from VARCHAR2 DEFAULT NULL,
112 p_issue_date_to VARCHAR2 DEFAULT NULL,
113 p_schedule_type VARCHAR2 DEFAULT NULL,
114 p_schedule_ref_no NUMBER DEFAULT NULL,
115 p_delete_beyond_days NUMBER DEFAULT NULL,
116 p_authorization VARCHAR2 DEFAULT NULL,
117 p_status NUMBER DEFAULT NULL);
118
119
120 FUNCTION CheckOpenOrder (p_schedule_header_id NUMBER,
121 x_purge_rec rlm_message_sv.t_PurExp_rec)
122 RETURN BOOLEAN;
123
124 END RLM_PS_SV;