1 PACKAGE PON_EMD_PAYMENT_TYPES_UTIL AUTHID CURRENT_USER AS
2 /* $Header: ponemdutils.pls 120.1 2010/04/13 09:38:02 irasoolm noship $ */
3
4 PROCEDURE Insert_Row(
5 X_PAYMENT_TYPE_CODE IN VARCHAR2,
6 X_ORG_ID IN NUMBER,
7 X_NAME IN VARCHAR2,
8 X_DESCRIPTION IN VARCHAR2,
9 X_START_DATE_ACTIVE IN DATE,
10 X_END_DATE_ACTIVE IN DATE,
11 X_ENABLED_FLAG IN VARCHAR2,
12 X_RECEIPT_METHOD_ID IN NUMBER,
13 X_REFUND_PAYMENT_METHOD IN VARCHAR2,
14 X_CREATION_DATE IN VARCHAR2,
15 X_CREATED_BY IN NUMBER,
16 X_LAST_UPDATE_DATE IN DATE,
17 X_LAST_UPDATED_BY IN NUMBER,
18 X_LAST_UPDATE_LOGIN IN NUMBER,
19 X_REQUEST_ID IN NUMBER,
20 X_PROGRAM_APPLICATION_ID IN NUMBER,
21 X_PROGRAM_ID IN NUMBER,
22 X_PROGRAM_UPDATE_DATE IN DATE
23 );
24
25 PROCEDURE Update_Row(
26 X_PAYMENT_TYPE_CODE IN VARCHAR2,
27 X_ORG_ID IN NUMBER,
28 X_NAME IN VARCHAR2,
29 X_DESCRIPTION IN VARCHAR2,
30 X_START_DATE_ACTIVE IN DATE,
31 X_END_DATE_ACTIVE IN DATE,
32 X_ENABLED_FLAG IN VARCHAR2,
33 X_RECEIPT_METHOD_ID IN NUMBER,
34 X_REFUND_PAYMENT_METHOD IN VARCHAR2,
35 X_LAST_UPDATE_DATE IN DATE,
36 X_LAST_UPDATED_BY IN NUMBER,
37 X_LAST_UPDATE_LOGIN IN NUMBER,
38 X_REQUEST_ID IN NUMBER,
39 X_PROGRAM_APPLICATION_ID IN NUMBER,
40 X_PROGRAM_ID IN NUMBER,
41 X_PROGRAM_UPDATE_DATE IN DATE
42 );
43
44 PROCEDURE Translate_Row(
45 X_PAYMENT_TYPE_CODE IN VARCHAR2,
46 X_ORG_ID IN NUMBER,
47 X_NAME IN VARCHAR2,
48 X_DESCRIPTION IN VARCHAR2,
49 X_OWNER IN VARCHAR2
50 );
51
52 PROCEDURE LOAD_ROW(
53 X_PAYMENT_TYPE_CODE IN VARCHAR2,
54 X_ORG_ID IN NUMBER,
55 X_OWNER IN VARCHAR2,
56 X_NAME IN VARCHAR2,
57 X_DESCRIPTION IN VARCHAR2,
58 X_START_DATE_ACTIVE IN DATE,
59 X_END_DATE_ACTIVE IN DATE,
60 X_ENABLED_FLAG IN VARCHAR2,
61 X_RECEIPT_METHOD_ID IN NUMBER,
62 X_REFUND_PAYMENT_METHOD IN VARCHAR2,
63 X_LAST_UPDATE_DATE IN DATE,
64 X_LAST_UPDATED_BY IN NUMBER,
65 X_LAST_UPDATE_LOGIN IN NUMBER,
66 X_REQUEST_ID IN NUMBER,
67 X_PROGRAM_APPLICATION_ID IN NUMBER,
68 X_PROGRAM_ID IN NUMBER,
69 X_PROGRAM_UPDATE_DATE IN DATE
70 );
71
72 PROCEDURE add_language;
73
74
75 END PON_EMD_PAYMENT_TYPES_UTIL;