[Home] [Help]
PACKAGE: APPS.IGC_CC_ROUTING_CTRLS_PKG
Source
1 PACKAGE IGC_CC_ROUTING_CTRLS_PKG AUTHID CURRENT_USER as
2 /* $Header: IGCCCTLS.pls 120.3.12000000.2 2007/10/08 05:51:21 smannava ship $ */
3
4
5 /* ================================================================================
6 PROCEDURE Insert_Row
7 ===============================================================================*/
8
9 PROCEDURE Insert_Row(
10 p_api_version IN NUMBER,
11 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
12 p_commit IN VARCHAR2 := FND_API.G_FALSE,
13 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
14 x_return_status OUT NOCOPY VARCHAR2,
15 x_msg_count OUT NOCOPY NUMBER,
16 x_msg_data OUT NOCOPY VARCHAR2,
17 p_Rowid IN OUT NOCOPY VARCHAR2,
18 p_ORG_ID IGC_CC_ROUTING_CTRLS_ALL.ORG_ID%TYPE,
19 p_CC_TYPE IGC_CC_ROUTING_CTRLS_ALL.CC_TYPE%TYPE,
20 p_CC_STATE IGC_CC_ROUTING_CTRLS_ALL.CC_STATE%TYPE,
21 p_CC_CAN_PRPR_APPRV_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_APPRV_FLAG%TYPE,
22 p_CC_CAN_PRPR_ENCMBR_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_ENCMBR_FLAG%TYPE,
23 p_wf_approval_itemtype IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_ITEMTYPE%TYPE,
24 p_wf_approval_process IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_PROCESS%TYPE,
25 p_DEFAULT_APPROVAL_PATH_ID IGC_CC_ROUTING_CTRLS_ALL.DEFAULT_APPROVAL_PATH_ID%TYPE,
26 p_LAST_UPDATE_DATE IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_DATE%TYPE,
27 p_LAST_UPDATE_LOGIN IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_LOGIN%TYPE,
28 p_CREATION_DATE IGC_CC_ROUTING_CTRLS_ALL.CREATION_DATE%TYPE,
29 p_LAST_UPDATED_BY IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATED_BY%TYPE,
30 p_CREATED_BY IGC_CC_ROUTING_CTRLS_ALL.CREATED_BY%TYPE
31 );
32
33 PROCEDURE Lock_Row(
34 p_api_version IN NUMBER,
35 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
36 p_commit IN VARCHAR2 := FND_API.G_FALSE,
37 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
38 x_return_status OUT NOCOPY VARCHAR2,
39 x_msg_count OUT NOCOPY NUMBER,
40 x_msg_data OUT NOCOPY VARCHAR2,
41
42 p_Rowid IN OUT NOCOPY VARCHAR2,
43 p_ORG_ID IGC_CC_ROUTING_CTRLS_ALL.ORG_ID%TYPE,
44 p_CC_TYPE IGC_CC_ROUTING_CTRLS_ALL.CC_TYPE%TYPE,
45 p_CC_STATE IGC_CC_ROUTING_CTRLS_ALL.CC_STATE%TYPE,
46 p_CC_CAN_PRPR_APPRV_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_APPRV_FLAG%TYPE,
47 p_CC_CAN_PRPR_ENCMBR_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_ENCMBR_FLAG%TYPE,
48 p_wf_approval_itemtype IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_ITEMTYPE%TYPE,
49 p_wf_approval_process IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_PROCESS%TYPE,
50 p_DEFAULT_APPROVAL_PATH_ID IGC_CC_ROUTING_CTRLS_ALL.DEFAULT_APPROVAL_PATH_ID%TYPE,
51 p_LAST_UPDATE_DATE IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_DATE%TYPE,
52 p_LAST_UPDATE_LOGIN IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_LOGIN%TYPE,
53 p_CREATION_DATE IGC_CC_ROUTING_CTRLS_ALL.CREATION_DATE%TYPE,
54 p_LAST_UPDATED_BY IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATED_BY%TYPE,
55 p_CREATED_BY IGC_CC_ROUTING_CTRLS_ALL.CREATED_BY%TYPE,
56 p_row_locked OUT NOCOPY VARCHAR2
57 );
58
59 PROCEDURE Update_Row(
60 p_api_version IN NUMBER,
61 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
62 p_commit IN VARCHAR2 := FND_API.G_FALSE,
63 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_msg_data OUT NOCOPY VARCHAR2,
67
68 p_Rowid IN OUT NOCOPY VARCHAR2,
69 p_ORG_ID IGC_CC_ROUTING_CTRLS_ALL.ORG_ID%TYPE,
70 p_CC_TYPE IGC_CC_ROUTING_CTRLS_ALL.CC_TYPE%TYPE,
71 p_CC_STATE IGC_CC_ROUTING_CTRLS_ALL.CC_STATE%TYPE,
72 p_CC_CAN_PRPR_APPRV_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_APPRV_FLAG%TYPE,
73 p_CC_CAN_PRPR_ENCMBR_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_ENCMBR_FLAG%TYPE,
74 p_wf_approval_itemtype IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_ITEMTYPE%TYPE,
75 p_wf_approval_process IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_PROCESS%TYPE,
76 p_DEFAULT_APPROVAL_PATH_ID IGC_CC_ROUTING_CTRLS_ALL.DEFAULT_APPROVAL_PATH_ID%TYPE,
77 p_LAST_UPDATE_DATE IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_DATE%TYPE,
78 p_LAST_UPDATE_LOGIN IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_LOGIN%TYPE,
79 p_CREATION_DATE IGC_CC_ROUTING_CTRLS_ALL.CREATION_DATE%TYPE,
80 p_LAST_UPDATED_BY IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATED_BY%TYPE,
81 p_CREATED_BY IGC_CC_ROUTING_CTRLS_ALL.CREATED_BY%TYPE
82 );
83
84 PROCEDURE Delete_Row(p_api_version IN NUMBER,
85 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
86 p_commit IN VARCHAR2 := FND_API.G_FALSE,
87 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
88 x_return_status OUT NOCOPY VARCHAR2,
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2,
91 p_Rowid VARCHAR2);
92
93 END IGC_CC_ROUTING_CTRLS_PKG;