[Home] [Help]
PACKAGE: APPS.IGC_CC_MC_DET_PF_PKG
Source
1 PACKAGE IGC_CC_MC_DET_PF_PKG AUTHID CURRENT_USER as
2 /* $Header: IGCCMCDS.pls 120.3.12000000.1 2007/08/20 12:12:59 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.CC_DET_PF_Line_Id%TYPE,
21 p_Set_Of_Books_Id IGC_CC_MC_DET_PF.Set_Of_Books_Id%TYPE,
22 p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Func_Amt%TYPE,
23 p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Encmbrnc_Amt%TYPE,
24 p_Conversion_Type IGC_CC_MC_DET_PF.Conversion_Type%TYPE,
25 p_Conversion_Date IGC_CC_MC_DET_PF.Conversion_Date%TYPE,
26 p_Conversion_Rate IGC_CC_MC_DET_PF.Conversion_Rate%TYPE
27
28 );
29 /* =================================================================================
30 PROCEDURE Lock_Row
31 ================================================================================*/
32 PROCEDURE Lock_Row (
33 p_api_version IN NUMBER,
34 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
35 p_commit IN VARCHAR2 := FND_API.G_FALSE,
36 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
37 X_return_status OUT NOCOPY VARCHAR2,
38 X_msg_count OUT NOCOPY NUMBER,
39 X_msg_data OUT NOCOPY VARCHAR2,
40 p_Rowid IN OUT NOCOPY VARCHAR2,
41 p_CC_DET_PF_Line_Id IGC_CC_MC_DET_PF.CC_DET_PF_Line_Id%TYPE,
42 p_Set_Of_Books_Id IGC_CC_MC_DET_PF.Set_Of_Books_Id%TYPE,
43 p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Func_Amt%TYPE,
44 p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Encmbrnc_Amt%TYPE,
45 p_Conversion_Type IGC_CC_MC_DET_PF.Conversion_Type%TYPE,
46 p_Conversion_Date IGC_CC_MC_DET_PF.Conversion_Date%TYPE,
47 p_Conversion_Rate IGC_CC_MC_DET_PF.Conversion_Rate%TYPE,
48 X_row_locked OUT NOCOPY VARCHAR2
49 );
50 /* ================================================================================
51 PROCEDURE Update_Row
52 ===============================================================================*/
53 PROCEDURE Update_Row(
54 p_api_version IN NUMBER,
55 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
56 p_commit IN VARCHAR2 := FND_API.G_FALSE,
57 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
58 X_return_status OUT NOCOPY VARCHAR2,
59 X_msg_count OUT NOCOPY NUMBER,
60 X_msg_data OUT NOCOPY VARCHAR2,
61 p_Rowid IN OUT NOCOPY VARCHAR2,
62 p_CC_DET_PF_Line_Id IGC_CC_MC_DET_PF.CC_DET_PF_Line_Id%TYPE,
63 p_Set_Of_Books_Id IGC_CC_MC_DET_PF.Set_Of_Books_Id%TYPE,
64 p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Func_Amt%TYPE,
65 p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Encmbrnc_Amt%TYPE,
66 p_Conversion_Type IGC_CC_MC_DET_PF.Conversion_Type%TYPE,
67 p_Conversion_Date IGC_CC_MC_DET_PF.Conversion_Date%TYPE,
68 p_Conversion_Rate IGC_CC_MC_DET_PF.Conversion_Rate%TYPE
69 );
70
71
72 /* ==============================================================================
73 PROCEDURE Delete_Row
74 ============================================================================*/
75 PROCEDURE Delete_Row(
76 p_api_version IN NUMBER,
77 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
78 p_commit IN VARCHAR2 := FND_API.G_FALSE,
79 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
80 X_return_status OUT NOCOPY VARCHAR2,
81 X_msg_count OUT NOCOPY NUMBER,
82 X_msg_data OUT NOCOPY VARCHAR2,
83 p_Rowid IN OUT NOCOPY VARCHAR2
84 );
85
86 END IGC_CC_MC_DET_PF_PKG ;