1 PACKAGE PO_DIFF_CONFIG_PKG AUTHID CURRENT_USER AS
2 /* $Header: PO_DIFF_CONFIG_PKG.pls 120.0 2011/10/13 18:11:26 bhuchand noship $ */
3
4 PROCEDURE INSERT_ROW (
5 P_DIFF_CONFIG_ID IN NUMBER,
6 P_DOCUMENT_TYPE IN VARCHAR2,
7 P_ENTITY_NAME IN VARCHAR2,
8 P_SUB_ENTITY_NAME IN VARCHAR2,
9 P_BASE_DOC_SOURCE_NAME IN VARCHAR2,
10 P_MOD_DOC_SOURCE_NAME IN VARCHAR2,
11 P_COLUMN_NAME IN VARCHAR2,
12 P_CMP_FILTER_PRED_FLAG IN VARCHAR2,
13 P_IS_PRINTABLE_FLAG IN VARCHAR2,
14 P_ROLLUP_ELIGIBILITY_FLAG IN VARCHAR2,
15 P_DISPLAY_SEQ_NUMBER IN NUMBER,
16 P_DISP_DATA_TYPE IN VARCHAR2,
17 P_LABEL_MESSAGE_CODE IN VARCHAR2,
18 P_IGNORE_SOURCE_FLAG IN VARCHAR2,
19 P_CREATION_DATE IN DATE,
20 P_CREATED_BY IN NUMBER,
21 P_LAST_UPDATE_DATE IN DATE,
22 P_LAST_UPDATED_BY IN NUMBER,
23 P_LAST_UPDATE_LOGIN IN NUMBER
24 ) ;
25
26 PROCEDURE UPDATE_ROW(
27 P_DIFF_CONFIG_ID IN NUMBER,
28 P_DOCUMENT_TYPE IN VARCHAR2,
29 P_ENTITY_NAME IN VARCHAR2,
30 P_SUB_ENTITY_NAME IN VARCHAR2,
31 P_BASE_DOC_SOURCE_NAME IN VARCHAR2,
32 P_MOD_DOC_SOURCE_NAME IN VARCHAR2,
33 P_COLUMN_NAME IN VARCHAR2,
34 P_CMP_FILTER_PRED_FLAG IN VARCHAR2,
35 P_IS_PRINTABLE_FLAG IN VARCHAR2,
36 P_ROLLUP_ELIGIBILITY_FLAG IN VARCHAR2,
37 P_DISPLAY_SEQ_NUMBER IN NUMBER,
38 P_DISP_DATA_TYPE IN VARCHAR2,
39 P_LABEL_MESSAGE_CODE IN VARCHAR2,
40 P_IGNORE_SOURCE_FLAG IN VARCHAR2,
41 P_LAST_UPDATE_DATE IN DATE,
42 P_LAST_UPDATED_BY IN NUMBER,
43 P_LAST_UPDATE_LOGIN IN NUMBER
44 ) ;
45
46 PROCEDURE FORCE_UPDATE_ROW(
47 P_DIFF_CONFIG_ID IN NUMBER,
48 P_DOCUMENT_TYPE IN VARCHAR2,
49 P_ENTITY_NAME IN VARCHAR2,
50 P_SUB_ENTITY_NAME IN VARCHAR2,
51 P_BASE_DOC_SOURCE_NAME IN VARCHAR2,
52 P_MOD_DOC_SOURCE_NAME IN VARCHAR2,
53 P_COLUMN_NAME IN VARCHAR2,
54 P_CMP_FILTER_PRED_FLAG IN VARCHAR2,
55 P_IS_PRINTABLE_FLAG IN VARCHAR2,
56 P_ROLLUP_ELIGIBILITY_FLAG IN VARCHAR2,
57 P_DISPLAY_SEQ_NUMBER IN NUMBER,
58 P_DISP_DATA_TYPE IN VARCHAR2,
59 P_LABEL_MESSAGE_CODE IN VARCHAR2,
60 P_IGNORE_SOURCE_FLAG IN VARCHAR2,
61 P_LAST_UPDATE_DATE IN DATE,
62 P_LAST_UPDATED_BY IN NUMBER,
63 P_LAST_UPDATE_LOGIN IN NUMBER
64 ) ;
65
66 PROCEDURE LOAD_ROW (
67 L_DIFF_CONFIG_ID IN NUMBER,
68 L_OWNER IN VARCHAR2,
69 L_LAST_UPDATE_DATE IN VARCHAR2,
70 L_DOCUMENT_TYPE IN VARCHAR2,
71 L_ENTITY_NAME IN VARCHAR2,
72 L_MOD_DOC_SOURCE_NAME IN VARCHAR2,
73 L_COLUMN_NAME IN VARCHAR2,
74 L_BASE_DOC_SOURCE_NAME IN VARCHAR2,
75 L_SUB_ENTITY_NAME IN VARCHAR2,
76 L_CMP_FILTER_PRED_FLAG IN VARCHAR2,
77 L_IS_PRINTABLE_FLAG IN VARCHAR2,
78 L_ROLLUP_ELIGIBILITY_FLAG IN VARCHAR2,
79 L_DISPLAY_SEQ_NUMBER IN NUMBER,
80 L_DISP_DATA_TYPE IN VARCHAR2,
81 L_LABEL_MESSAGE_CODE IN VARCHAR2,
82 L_IGNORE_SOURCE_FLAG IN VARCHAR2,
83 L_CUSTOM_MODE IN VARCHAR2
84 );
85 END PO_DIFF_CONFIG_PKG;
[Home] [Help]