[Home] [Help]
PACKAGE: APPS.GL_CI_WORKFLOW_PKG
Source
1 PACKAGE GL_CI_WORKFLOW_PKG AUTHID CURRENT_USER AS
2 /* $Header: gluciwfs.pls 120.3 2005/05/05 01:37:26 kvora noship $ */
3 -- Start of DDL Script for Package APPS.GL_CI_WORKFLOW_PKG
4 -- Generated 1-Jun-2004 16:04:41 from APPS@findv115
5 --+ Public variables
6 diagn_msg_flag BOOLEAN := TRUE; --+ Determines if diagnostic messages are displayed
7 --+ Procedure
8 --+ SEND_CIT_NTF
9 --+ Purpose
10 --+ Called from GL_CI_DATA_TRANSFER_PKG
11 --+ Create work flow process and Start work notification process if
12 --+ Transaction amount is greater then Threshold amount
13 --+ Arguments
14 --+ IN PARAMETERS
15 --+ 1. concurrent request id
16 --+ 2. Action on transaction
17 --+ OUT NOCOPY Parameter
18 --+ p_Return_Code
19 --+ NOTIFICATION_PROCESS_STARTED Number := 0;
20 --+ FATAL_EXCEPTION Number := -1;
21 --+ INVALID_ACTION Number := -3;
22 --+ CONTACT_INFO_NOT_FOUND Number := -4;
23 --+ Example
24 --+ GL_CI_WORKFLOW_PKG.SEND_CIT_NTF
25 --+ Notes
26 --+
27 PROCEDURE SEND_CIT_WF_NTF
28 ( p_cons_request_id IN number, --+consolidation request id
29 p_Action IN VARCHAR2,
30 p_dblink IN varchar2,
31 p_batch_name IN varchar2, --+100 CHARS
32 p_source_database_name IN varchar2,
33 p_target_ledger_name IN varchar2,
34 p_interface_table_name IN varchar2,
35 p_interface_run_id IN number,
36 p_posting_run_id IN number,
37 p_request_id IN number,
38 p_group_id IN number,
39 p_send_to IN varchar2,
40 p_sender_name IN varchar2,
41 p_message_name IN varchar2,
42 p_send_from IN varchar2,
43 p_source_ledger_id IN number,
44 p_import_message_body IN varchar2,
45 p_post_request_id IN varchar2,
46 p_Return_Code OUT NOCOPY NUMBER);
47 --+ Procedure
48 --+ Get_Action_Type
49 --+ Purpose
50 --+ Called from GLCITNTF Worlflow process
51 --+ Determine what what message to be sent with notification
52 --+ Example
53 --+ GL_CI_WORKFLOW_PKG.Get_Action_Type
54 --+ Notes
55 --+
56 Procedure Get_Action_Type
57 ( p_item_type IN VARCHAR2,
58 p_item_key IN VARCHAR2,
59 p_actid IN NUMBER,
60 p_funcmode IN VARCHAR2,
61 p_result OUT NOCOPY VARCHAR2 );
62 --+ Procedure
63 --+ set_wf_variables
64 --+ Purpose
65 --+ Called from SEND_cit_NTF
66 --+ Sets workflow variables
67 --+ Example
68 --+ GL_CI_WORKFLOW_PKG.set_wf_variables
69 --+ Notes
70 --+
71 Procedure set_wf_variables (
72 l_item_type IN VARCHAR2,
73 l_item_key IN NUMBER,
74 l_application_name IN VARCHAR2,
75 l_responsibility_name IN VARCHAR2,
76 l_user_name IN VARCHAR2,
77 l_mapping_rule_name IN VARCHAR2,
78 l_batch_name IN VARChar2, --+100 CHARS
79 l_source_database_name IN VARCHAR2,
80 l_target_database_name IN VARCHAR2,
81 l_source_ledger_name IN VARCHAR2,
82 l_target_ledger_name IN VARCHAR2,
83 l_period_name IN VARCHAR2, --+15 CHARS
84 l_journal_source_name IN VARCHAR2, --+25 chars
85 l_interface_table_name IN VARCHAR2,
86 l_interface_run_id IN number,
87 l_posting_run_id IN number,
88 l_request_id IN number,
89 l_group_id IN number,
90 l_send_to IN VARCHAR2,
91 l_sender_name IN VARCHAR2,
92 l_message_name IN varchar2,
93 l_send_from IN VARCHAR2,
94 l_import_message_body IN VARCHAR2,
95 l_post_request_id IN varchar2);
96 --+ Function
97 --+ set_wf_variables
98 --+ Purpose
99 --+ Called from SEND_CIT_NTF
100 --+ Sets workflow item key
101 --+ Example
102 --+ GL_CI_WORKFLOW_PKG.get_unique_id
103 --+ Notes
104 --+
105 FUNCTION get_unique_id RETURN NUMBER;
106 End GL_CI_WORKFLOW_PKG;