[Home] [Help]
PACKAGE: APPS.IGC_CC_MC_DET_PF_HST_PKG
Source
1 PACKAGE IGC_CC_MC_DET_PF_HST_PKG AUTHID CURRENT_USER as
2 /* $Header: IGCCMHDS.pls 120.3.12000000.1 2007/08/20 12:13:19 mbremkum ship $ */
3
4
5
6 /* ================================================================================
7 PROCEDURE Insert_Row
8 ===============================================================================*/
9
10
11 PROCEDURE Insert_Row(
12 p_api_version IN NUMBER,
13 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
14 p_commit IN VARCHAR2 := FND_API.G_FALSE,
15 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
16 X_return_status OUT NOCOPY VARCHAR2,
17 X_msg_count OUT NOCOPY NUMBER,
18 X_msg_data OUT NOCOPY VARCHAR2,
19 p_Rowid IN OUT NOCOPY VARCHAR2,
20 p_CC_DET_PF_Line_Id IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Line_Id%TYPE,
21 p_Set_Of_Books_Id IGC_CC_MC_DET_PF_HISTORY.Set_Of_Books_Id%TYPE,
22 p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Func_Amt%TYPE,
23 p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Encmbrnc_Amt%TYPE,
24 p_CC_DET_PF_version_num IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_num%TYPE,
25 p_CC_DET_PF_version_action IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_action%TYPE,
26 p_Conversion_Type IGC_CC_MC_DET_PF_HISTORY.Conversion_Type%TYPE,
27 p_Conversion_Date IGC_CC_MC_DET_PF_HISTORY.Conversion_Date%TYPE,
28 p_Conversion_Rate IGC_CC_MC_DET_PF_HISTORY.Conversion_Rate%TYPE
29
30 );
31 /* =================================================================================
32 PROCEDURE Lock_Row
33 ================================================================================*/
34 PROCEDURE Lock_Row (
35 p_api_version IN NUMBER,
36 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
37 p_commit IN VARCHAR2 := FND_API.G_FALSE,
38 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
39 X_return_status OUT NOCOPY VARCHAR2,
40 X_msg_count OUT NOCOPY NUMBER,
41 X_msg_data OUT NOCOPY VARCHAR2,
42 p_Rowid IN OUT NOCOPY VARCHAR2,
43 p_CC_DET_PF_Line_Id IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Line_Id%TYPE,
44 p_Set_Of_Books_Id IGC_CC_MC_DET_PF_HISTORY.Set_Of_Books_Id%TYPE,
45 p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Func_Amt%TYPE,
46 p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Encmbrnc_Amt%TYPE,
47 p_CC_DET_PF_version_num IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_num%TYPE,
48 p_CC_DET_PF_version_action IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_action%TYPE,
49 p_Conversion_Type IGC_CC_MC_DET_PF_HISTORY.Conversion_Type%TYPE,
50 p_Conversion_Date IGC_CC_MC_DET_PF_HISTORY.Conversion_Date%TYPE,
51 p_Conversion_Rate IGC_CC_MC_DET_PF_HISTORY.Conversion_Rate%TYPE,
52 X_row_locked OUT NOCOPY VARCHAR2
53 );
54 /* ================================================================================
55 PROCEDURE Update_Row
56 ===============================================================================*/
57 PROCEDURE Update_Row(
58 p_api_version IN NUMBER,
59 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
60 p_commit IN VARCHAR2 := FND_API.G_FALSE,
61 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
62 X_return_status OUT NOCOPY VARCHAR2,
63 X_msg_count OUT NOCOPY NUMBER,
64 X_msg_data OUT NOCOPY VARCHAR2,
65 p_Rowid IN OUT NOCOPY VARCHAR2,
66 p_CC_DET_PF_Line_Id IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Line_Id%TYPE,
67 p_Set_Of_Books_Id IGC_CC_MC_DET_PF_HISTORY.Set_Of_Books_Id%TYPE,
68 p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Func_Amt%TYPE,
69 p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Encmbrnc_Amt%TYPE,
70 p_CC_DET_PF_version_num IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_num%TYPE,
71 p_CC_DET_PF_version_action IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_action%TYPE,
72 p_Conversion_Type IGC_CC_MC_DET_PF_HISTORY.Conversion_Type%TYPE,
73 p_Conversion_Date IGC_CC_MC_DET_PF_HISTORY.Conversion_Date%TYPE,
74 p_Conversion_Rate IGC_CC_MC_DET_PF_HISTORY.Conversion_Rate%TYPE
75 );
76
77
78 /* ==============================================================================
79 PROCEDURE Delete_Row
80 ============================================================================*/
81 PROCEDURE Delete_Row(
82 p_api_version IN NUMBER,
83 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
84 p_commit IN VARCHAR2 := FND_API.G_FALSE,
85 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
86 X_return_status OUT NOCOPY VARCHAR2,
87 X_msg_count OUT NOCOPY NUMBER,
88 X_msg_data OUT NOCOPY VARCHAR2,
89 p_Rowid IN OUT NOCOPY VARCHAR2
90 );
91
92 END IGC_CC_MC_DET_PF_HST_PKG ;