1 Package Body IPA_CLIENT_EXTN_TRX_SRC_PROC AS
2 /* $Header: IPACLPRB.pls 120.0 2005/05/29 13:16:32 appldev noship $ */
3
4 /*========================================================================*/
5 /* PRE-PROCESS EXTENSION */
6 /*========================================================================*/
7 /* Pre-Process Extension for Transaction Source - 'Capitalized Interest' */
8 PROCEDURE PRE_PROCESS_EXTN(
9 P_transaction_source IN VARCHAR2,
10 P_batch IN VARCHAR2,
11 P_xface_id IN NUMBER,
12 P_user_id IN NUMBER) IS
13
14 /* Declare here any local Variables that might need to be used
15 for this Pre-Processing Extension */
16 /* Begin Declaring Variables */
17
18
19
20
21 /* End Declaring Variables */
22
23 BEGIN
24
25 /* The eligible records for Post-Processing are those whose
26 transaction_status_code is 'P'. After Processing, mark the
27 transaction_status_code as 'P' for Success and 'PR' for Rejection.
28 This needs to be strictly adhered to inorder to view the
29 Transactions in Review transactions accordingly. */
30
31 /* Include Cusotmised code for Pre-Processing Extension */
32
33 /* Begin Customised Code */
34 /* If Customised Code is included here,
35 comment the next line containing NULL; */
36 NULL;
37
38
39
40
41
42
43 /* End Customised Code */
44
45 EXCEPTION
46 WHEN OTHERS THEN
47 RAISE;
48
49 END PRE_PROCESS_EXTN;
50
51 /*========================================================================*/
52 /* POST-PROCESS EXTENSION */
53 /*========================================================================*/
54 /* Post-Process Extension for Transaction Source - 'Capitalized Interest' */
55 PROCEDURE POST_PROCESS_EXTN(
56 P_transaction_source IN VARCHAR2,
57 P_batch IN VARCHAR2,
58 P_xface_id IN NUMBER,
59 P_user_id IN NUMBER) IS
60
61 /* Declare here any local Variables that might need to be used
62 for this Post-Processing Extension */
63 /* Begin Declaring Variables */
64
65
66
67
68 /* End Declaring Variables */
69
70 BEGIN
71
72 /* The eligible records for Post-Processing are those whose
73 transaction_status_code is 'I'. After Processing, mark the
74 transaction_status_code as 'A' for Success and 'PO' for Rejection.
75 This needs to be strictly adhered to inorder to view the
76 Transactions in Review transactions accordingly. */
77
78 /* Include Cusotmised code for Post-Processing Extension */
79
80 /* Begin Customised Code */
81 /* If Customised Code is included here,
82 comment the next line containing NULL; */
83 NULL;
84
85
86
87
88
89
90 /* End Customised Code */
91
92 EXCEPTION
93 WHEN OTHERS THEN
94 RAISE;
95
96 END POST_PROCESS_EXTN;
97
98 END IPA_CLIENT_EXTN_TRX_SRC_PROC;