1 PACKAGE XTR_IMPORT_DEAL_DATA AUTHID CURRENT_USER AS
2 /* $Header: xtrimdds.pls 120.4 2005/06/29 08:34:39 badiredd ship $*/
3
4
5 Procedure Transfer_Deals( ERRBUF Out NOCOPY Varchar2,
6 RETCODE Out NOCOPY Varchar2,
7 P_Company_Code In Varchar2,
8 P_Deal_Type In Varchar2,
9 P_Ext_Deal_Id_From In Varchar2,
10 P_Ext_Deal_Id_To In Varchar2,
11 P_Load_Status In Varchar2,
12 P_Source In Varchar2
13 ) ;
14
15 Procedure Translate_Deal_Details( deal_type In Varchar2,
16 ARec In Out NOCOPY xtr_deals_interface%rowtype);
17
18 Procedure Translate_Deal_Details_UI(p_external_deal_id xtr_deals_interface.external_deal_id%type,
19 p_user_deal_type xtr_deals_interface.deal_type%type);
20
21 Procedure Log_Interface_Errors(AExt_Deal_Id In Varchar2,
22 ADeal_Type Varchar2,
23 Error_Column In Varchar2,
24 Error_Code in Varchar2,
25 Transaction_No in Number Default Null);
26
27 Procedure Log_Deal_Warning(p_warning_message In Varchar2);
28
29 Procedure log_successful_deal(Deal_Type IN VARCHAR2,
30 Deal_Number IN NUMBER,
31 Deal_Subtype IN VARCHAR2,
32 Product_Type IN VARCHAR2,
33 Company_Code IN VARCHAR2,
34 Cparty_Code IN VARCHAR2,
35 Currency IN VARCHAR2,
36 Amount IN NUMBER);
37
38 Procedure log_failed_deal(Deal_Type IN VARCHAR2,
39 External_Deal_Id IN VARCHAR2,
40 Deal_Subtype IN VARCHAR2,
41 Product_Type IN VARCHAR2,
42 Company_Code IN VARCHAR2,
43 Cparty_Code IN VARCHAR2,
44 Currency IN VARCHAR2,
45 Amount IN NUMBER);
46
47 procedure CHECK_DEAL_DUPLICATE_ID(p_external_deal_id IN VARCHAR2,
48 p_external_deal_type IN VARCHAR2,
49 p_deal_type IN VARCHAR2,
50 error OUT NOCOPY BOOLEAN);
51
52 Procedure Put_Log(Avr_Buff In Varchar2);
53
54 PROCEDURE CHECK_USER_AUTH(p_external_deal_id IN VARCHAR2,
55 p_deal_type IN VARCHAR2,
56 p_company_code IN VARCHAR2,
57 error OUT NOCOPY BOOLEAN);
58
59
60 --* Public Variables
61 type message_list_type is table of varchar2(4000) index by binary_integer;
62 G_current_deal_log_list message_list_type;
63 G_failure_log_list message_list_type;
64
65 G_Total_Success_Recs Number Default 0;
66 G_Total_Failure_Recs Number Default 0;
67 G_Control_Total Number Default 0;
68 G_Total_Record_Scanned Number Default 0;
69 G_Has_Warnings Boolean Default false;
70 G_DFF_Error_Column Varchar2(80);
71
72 FUNCTION val_desc_flex( p_Interface_Rec IN XTR_DEALS_INTERFACE%ROWTYPE,
73 p_desc_flex IN VARCHAR2,
74 p_error_segment IN OUT NOCOPY VARCHAR2) return BOOLEAN;
75
76 FUNCTION val_transaction_desc_flex( p_Interface_Rec IN XTR_TRANSACTIONS_INTERFACE%ROWTYPE,
77 p_desc_flex IN VARCHAR2,
78 p_error_segment IN OUT NOCOPY VARCHAR2) return BOOLEAN;
79 END;