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_ORG_ID IGC_CC_ROUTING_CTRLS_ALL.ORG_ID%TYPE,
21: p_CC_TYPE IGC_CC_ROUTING_CTRLS_ALL.CC_TYPE%TYPE,
22: p_CC_STATE IGC_CC_ROUTING_CTRLS_ALL.CC_STATE%TYPE,
23: p_CC_CAN_PRPR_APPRV_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_APPRV_FLAG%TYPE,
24: p_CC_CAN_PRPR_ENCMBR_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_ENCMBR_FLAG%TYPE,
17: x_msg_count OUT NOCOPY NUMBER,
18: x_msg_data OUT NOCOPY VARCHAR2,
19: p_Rowid IN OUT NOCOPY VARCHAR2,
20: p_ORG_ID IGC_CC_ROUTING_CTRLS_ALL.ORG_ID%TYPE,
21: p_CC_TYPE IGC_CC_ROUTING_CTRLS_ALL.CC_TYPE%TYPE,
22: p_CC_STATE IGC_CC_ROUTING_CTRLS_ALL.CC_STATE%TYPE,
23: p_CC_CAN_PRPR_APPRV_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_APPRV_FLAG%TYPE,
24: p_CC_CAN_PRPR_ENCMBR_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_ENCMBR_FLAG%TYPE,
25: p_wf_approval_itemtype IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_ITEMTYPE%TYPE,
18: x_msg_data OUT NOCOPY VARCHAR2,
19: p_Rowid IN OUT NOCOPY VARCHAR2,
20: p_ORG_ID IGC_CC_ROUTING_CTRLS_ALL.ORG_ID%TYPE,
21: p_CC_TYPE IGC_CC_ROUTING_CTRLS_ALL.CC_TYPE%TYPE,
22: p_CC_STATE IGC_CC_ROUTING_CTRLS_ALL.CC_STATE%TYPE,
23: p_CC_CAN_PRPR_APPRV_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_APPRV_FLAG%TYPE,
24: p_CC_CAN_PRPR_ENCMBR_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_ENCMBR_FLAG%TYPE,
25: p_wf_approval_itemtype IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_ITEMTYPE%TYPE,
26: p_wf_approval_process IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_PROCESS%TYPE,
19: p_Rowid IN OUT NOCOPY VARCHAR2,
20: p_ORG_ID IGC_CC_ROUTING_CTRLS_ALL.ORG_ID%TYPE,
21: p_CC_TYPE IGC_CC_ROUTING_CTRLS_ALL.CC_TYPE%TYPE,
22: p_CC_STATE IGC_CC_ROUTING_CTRLS_ALL.CC_STATE%TYPE,
23: p_CC_CAN_PRPR_APPRV_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_APPRV_FLAG%TYPE,
24: p_CC_CAN_PRPR_ENCMBR_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_ENCMBR_FLAG%TYPE,
25: p_wf_approval_itemtype IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_ITEMTYPE%TYPE,
26: p_wf_approval_process IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_PROCESS%TYPE,
27: p_DEFAULT_APPROVAL_PATH_ID IGC_CC_ROUTING_CTRLS_ALL.DEFAULT_APPROVAL_PATH_ID%TYPE,
20: p_ORG_ID IGC_CC_ROUTING_CTRLS_ALL.ORG_ID%TYPE,
21: p_CC_TYPE IGC_CC_ROUTING_CTRLS_ALL.CC_TYPE%TYPE,
22: p_CC_STATE IGC_CC_ROUTING_CTRLS_ALL.CC_STATE%TYPE,
23: p_CC_CAN_PRPR_APPRV_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_APPRV_FLAG%TYPE,
24: p_CC_CAN_PRPR_ENCMBR_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_ENCMBR_FLAG%TYPE,
25: p_wf_approval_itemtype IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_ITEMTYPE%TYPE,
26: p_wf_approval_process IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_PROCESS%TYPE,
27: p_DEFAULT_APPROVAL_PATH_ID IGC_CC_ROUTING_CTRLS_ALL.DEFAULT_APPROVAL_PATH_ID%TYPE,
28: p_LAST_UPDATE_DATE IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_DATE%TYPE,
21: p_CC_TYPE IGC_CC_ROUTING_CTRLS_ALL.CC_TYPE%TYPE,
22: p_CC_STATE IGC_CC_ROUTING_CTRLS_ALL.CC_STATE%TYPE,
23: p_CC_CAN_PRPR_APPRV_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_APPRV_FLAG%TYPE,
24: p_CC_CAN_PRPR_ENCMBR_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_ENCMBR_FLAG%TYPE,
25: p_wf_approval_itemtype IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_ITEMTYPE%TYPE,
26: p_wf_approval_process IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_PROCESS%TYPE,
27: p_DEFAULT_APPROVAL_PATH_ID IGC_CC_ROUTING_CTRLS_ALL.DEFAULT_APPROVAL_PATH_ID%TYPE,
28: p_LAST_UPDATE_DATE IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_DATE%TYPE,
29: p_LAST_UPDATE_LOGIN IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_LOGIN%TYPE,
22: p_CC_STATE IGC_CC_ROUTING_CTRLS_ALL.CC_STATE%TYPE,
23: p_CC_CAN_PRPR_APPRV_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_APPRV_FLAG%TYPE,
24: p_CC_CAN_PRPR_ENCMBR_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_ENCMBR_FLAG%TYPE,
25: p_wf_approval_itemtype IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_ITEMTYPE%TYPE,
26: p_wf_approval_process IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_PROCESS%TYPE,
27: p_DEFAULT_APPROVAL_PATH_ID IGC_CC_ROUTING_CTRLS_ALL.DEFAULT_APPROVAL_PATH_ID%TYPE,
28: p_LAST_UPDATE_DATE IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_DATE%TYPE,
29: p_LAST_UPDATE_LOGIN IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_LOGIN%TYPE,
30: p_CREATION_DATE IGC_CC_ROUTING_CTRLS_ALL.CREATION_DATE%TYPE,
23: p_CC_CAN_PRPR_APPRV_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_APPRV_FLAG%TYPE,
24: p_CC_CAN_PRPR_ENCMBR_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_ENCMBR_FLAG%TYPE,
25: p_wf_approval_itemtype IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_ITEMTYPE%TYPE,
26: p_wf_approval_process IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_PROCESS%TYPE,
27: p_DEFAULT_APPROVAL_PATH_ID IGC_CC_ROUTING_CTRLS_ALL.DEFAULT_APPROVAL_PATH_ID%TYPE,
28: p_LAST_UPDATE_DATE IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_DATE%TYPE,
29: p_LAST_UPDATE_LOGIN IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_LOGIN%TYPE,
30: p_CREATION_DATE IGC_CC_ROUTING_CTRLS_ALL.CREATION_DATE%TYPE,
31: p_LAST_UPDATED_BY IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATED_BY%TYPE,
24: p_CC_CAN_PRPR_ENCMBR_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_ENCMBR_FLAG%TYPE,
25: p_wf_approval_itemtype IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_ITEMTYPE%TYPE,
26: p_wf_approval_process IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_PROCESS%TYPE,
27: p_DEFAULT_APPROVAL_PATH_ID IGC_CC_ROUTING_CTRLS_ALL.DEFAULT_APPROVAL_PATH_ID%TYPE,
28: p_LAST_UPDATE_DATE IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_DATE%TYPE,
29: p_LAST_UPDATE_LOGIN IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_LOGIN%TYPE,
30: p_CREATION_DATE IGC_CC_ROUTING_CTRLS_ALL.CREATION_DATE%TYPE,
31: p_LAST_UPDATED_BY IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATED_BY%TYPE,
32: p_CREATED_BY IGC_CC_ROUTING_CTRLS_ALL.CREATED_BY%TYPE
25: p_wf_approval_itemtype IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_ITEMTYPE%TYPE,
26: p_wf_approval_process IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_PROCESS%TYPE,
27: p_DEFAULT_APPROVAL_PATH_ID IGC_CC_ROUTING_CTRLS_ALL.DEFAULT_APPROVAL_PATH_ID%TYPE,
28: p_LAST_UPDATE_DATE IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_DATE%TYPE,
29: p_LAST_UPDATE_LOGIN IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_LOGIN%TYPE,
30: p_CREATION_DATE IGC_CC_ROUTING_CTRLS_ALL.CREATION_DATE%TYPE,
31: p_LAST_UPDATED_BY IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATED_BY%TYPE,
32: p_CREATED_BY IGC_CC_ROUTING_CTRLS_ALL.CREATED_BY%TYPE
33: ) IS
26: p_wf_approval_process IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_PROCESS%TYPE,
27: p_DEFAULT_APPROVAL_PATH_ID IGC_CC_ROUTING_CTRLS_ALL.DEFAULT_APPROVAL_PATH_ID%TYPE,
28: p_LAST_UPDATE_DATE IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_DATE%TYPE,
29: p_LAST_UPDATE_LOGIN IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_LOGIN%TYPE,
30: p_CREATION_DATE IGC_CC_ROUTING_CTRLS_ALL.CREATION_DATE%TYPE,
31: p_LAST_UPDATED_BY IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATED_BY%TYPE,
32: p_CREATED_BY IGC_CC_ROUTING_CTRLS_ALL.CREATED_BY%TYPE
33: ) IS
34:
27: p_DEFAULT_APPROVAL_PATH_ID IGC_CC_ROUTING_CTRLS_ALL.DEFAULT_APPROVAL_PATH_ID%TYPE,
28: p_LAST_UPDATE_DATE IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_DATE%TYPE,
29: p_LAST_UPDATE_LOGIN IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_LOGIN%TYPE,
30: p_CREATION_DATE IGC_CC_ROUTING_CTRLS_ALL.CREATION_DATE%TYPE,
31: p_LAST_UPDATED_BY IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATED_BY%TYPE,
32: p_CREATED_BY IGC_CC_ROUTING_CTRLS_ALL.CREATED_BY%TYPE
33: ) IS
34:
35: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
28: p_LAST_UPDATE_DATE IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_DATE%TYPE,
29: p_LAST_UPDATE_LOGIN IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_LOGIN%TYPE,
30: p_CREATION_DATE IGC_CC_ROUTING_CTRLS_ALL.CREATION_DATE%TYPE,
31: p_LAST_UPDATED_BY IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATED_BY%TYPE,
32: p_CREATED_BY IGC_CC_ROUTING_CTRLS_ALL.CREATED_BY%TYPE
33: ) IS
34:
35: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
36: l_api_version CONSTANT NUMBER := 1.0;
34:
35: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
36: l_api_version CONSTANT NUMBER := 1.0;
37:
38: CURSOR C IS SELECT rowid FROM IGC_CC_ROUTING_CTRLS_ALL
39: WHERE org_id = p_org_id;
40:
41: BEGIN
42:
58:
59: x_return_status := FND_API.G_RET_STS_SUCCESS ;
60:
61:
62: INSERT INTO IGC_CC_ROUTING_CTRLS_ALL(
63:
64: ORG_ID,
65: CC_TYPE,
66: CC_STATE,
147: x_msg_count OUT NOCOPY NUMBER,
148: x_msg_data OUT NOCOPY VARCHAR2,
149:
150: p_Rowid IN OUT NOCOPY VARCHAR2,
151: p_ORG_ID IGC_CC_ROUTING_CTRLS_ALL.ORG_ID%TYPE,
152: p_CC_TYPE IGC_CC_ROUTING_CTRLS_ALL.CC_TYPE%TYPE,
153: p_CC_STATE IGC_CC_ROUTING_CTRLS_ALL.CC_STATE%TYPE,
154: p_CC_CAN_PRPR_APPRV_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_APPRV_FLAG%TYPE,
155: p_CC_CAN_PRPR_ENCMBR_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_ENCMBR_FLAG%TYPE,
148: x_msg_data OUT NOCOPY VARCHAR2,
149:
150: p_Rowid IN OUT NOCOPY VARCHAR2,
151: p_ORG_ID IGC_CC_ROUTING_CTRLS_ALL.ORG_ID%TYPE,
152: p_CC_TYPE IGC_CC_ROUTING_CTRLS_ALL.CC_TYPE%TYPE,
153: p_CC_STATE IGC_CC_ROUTING_CTRLS_ALL.CC_STATE%TYPE,
154: p_CC_CAN_PRPR_APPRV_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_APPRV_FLAG%TYPE,
155: p_CC_CAN_PRPR_ENCMBR_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_ENCMBR_FLAG%TYPE,
156: p_wf_approval_itemtype IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_ITEMTYPE%TYPE,
149:
150: p_Rowid IN OUT NOCOPY VARCHAR2,
151: p_ORG_ID IGC_CC_ROUTING_CTRLS_ALL.ORG_ID%TYPE,
152: p_CC_TYPE IGC_CC_ROUTING_CTRLS_ALL.CC_TYPE%TYPE,
153: p_CC_STATE IGC_CC_ROUTING_CTRLS_ALL.CC_STATE%TYPE,
154: p_CC_CAN_PRPR_APPRV_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_APPRV_FLAG%TYPE,
155: p_CC_CAN_PRPR_ENCMBR_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_ENCMBR_FLAG%TYPE,
156: p_wf_approval_itemtype IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_ITEMTYPE%TYPE,
157: p_wf_approval_process IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_PROCESS%TYPE,
150: p_Rowid IN OUT NOCOPY VARCHAR2,
151: p_ORG_ID IGC_CC_ROUTING_CTRLS_ALL.ORG_ID%TYPE,
152: p_CC_TYPE IGC_CC_ROUTING_CTRLS_ALL.CC_TYPE%TYPE,
153: p_CC_STATE IGC_CC_ROUTING_CTRLS_ALL.CC_STATE%TYPE,
154: p_CC_CAN_PRPR_APPRV_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_APPRV_FLAG%TYPE,
155: p_CC_CAN_PRPR_ENCMBR_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_ENCMBR_FLAG%TYPE,
156: p_wf_approval_itemtype IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_ITEMTYPE%TYPE,
157: p_wf_approval_process IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_PROCESS%TYPE,
158: p_DEFAULT_APPROVAL_PATH_ID IGC_CC_ROUTING_CTRLS_ALL.DEFAULT_APPROVAL_PATH_ID%TYPE,
151: p_ORG_ID IGC_CC_ROUTING_CTRLS_ALL.ORG_ID%TYPE,
152: p_CC_TYPE IGC_CC_ROUTING_CTRLS_ALL.CC_TYPE%TYPE,
153: p_CC_STATE IGC_CC_ROUTING_CTRLS_ALL.CC_STATE%TYPE,
154: p_CC_CAN_PRPR_APPRV_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_APPRV_FLAG%TYPE,
155: p_CC_CAN_PRPR_ENCMBR_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_ENCMBR_FLAG%TYPE,
156: p_wf_approval_itemtype IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_ITEMTYPE%TYPE,
157: p_wf_approval_process IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_PROCESS%TYPE,
158: p_DEFAULT_APPROVAL_PATH_ID IGC_CC_ROUTING_CTRLS_ALL.DEFAULT_APPROVAL_PATH_ID%TYPE,
159: p_LAST_UPDATE_DATE IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_DATE%TYPE,
152: p_CC_TYPE IGC_CC_ROUTING_CTRLS_ALL.CC_TYPE%TYPE,
153: p_CC_STATE IGC_CC_ROUTING_CTRLS_ALL.CC_STATE%TYPE,
154: p_CC_CAN_PRPR_APPRV_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_APPRV_FLAG%TYPE,
155: p_CC_CAN_PRPR_ENCMBR_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_ENCMBR_FLAG%TYPE,
156: p_wf_approval_itemtype IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_ITEMTYPE%TYPE,
157: p_wf_approval_process IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_PROCESS%TYPE,
158: p_DEFAULT_APPROVAL_PATH_ID IGC_CC_ROUTING_CTRLS_ALL.DEFAULT_APPROVAL_PATH_ID%TYPE,
159: p_LAST_UPDATE_DATE IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_DATE%TYPE,
160: p_LAST_UPDATE_LOGIN IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_LOGIN%TYPE,
153: p_CC_STATE IGC_CC_ROUTING_CTRLS_ALL.CC_STATE%TYPE,
154: p_CC_CAN_PRPR_APPRV_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_APPRV_FLAG%TYPE,
155: p_CC_CAN_PRPR_ENCMBR_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_ENCMBR_FLAG%TYPE,
156: p_wf_approval_itemtype IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_ITEMTYPE%TYPE,
157: p_wf_approval_process IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_PROCESS%TYPE,
158: p_DEFAULT_APPROVAL_PATH_ID IGC_CC_ROUTING_CTRLS_ALL.DEFAULT_APPROVAL_PATH_ID%TYPE,
159: p_LAST_UPDATE_DATE IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_DATE%TYPE,
160: p_LAST_UPDATE_LOGIN IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_LOGIN%TYPE,
161: p_CREATION_DATE IGC_CC_ROUTING_CTRLS_ALL.CREATION_DATE%TYPE,
154: p_CC_CAN_PRPR_APPRV_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_APPRV_FLAG%TYPE,
155: p_CC_CAN_PRPR_ENCMBR_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_ENCMBR_FLAG%TYPE,
156: p_wf_approval_itemtype IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_ITEMTYPE%TYPE,
157: p_wf_approval_process IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_PROCESS%TYPE,
158: p_DEFAULT_APPROVAL_PATH_ID IGC_CC_ROUTING_CTRLS_ALL.DEFAULT_APPROVAL_PATH_ID%TYPE,
159: p_LAST_UPDATE_DATE IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_DATE%TYPE,
160: p_LAST_UPDATE_LOGIN IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_LOGIN%TYPE,
161: p_CREATION_DATE IGC_CC_ROUTING_CTRLS_ALL.CREATION_DATE%TYPE,
162: p_LAST_UPDATED_BY IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATED_BY%TYPE,
155: p_CC_CAN_PRPR_ENCMBR_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_ENCMBR_FLAG%TYPE,
156: p_wf_approval_itemtype IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_ITEMTYPE%TYPE,
157: p_wf_approval_process IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_PROCESS%TYPE,
158: p_DEFAULT_APPROVAL_PATH_ID IGC_CC_ROUTING_CTRLS_ALL.DEFAULT_APPROVAL_PATH_ID%TYPE,
159: p_LAST_UPDATE_DATE IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_DATE%TYPE,
160: p_LAST_UPDATE_LOGIN IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_LOGIN%TYPE,
161: p_CREATION_DATE IGC_CC_ROUTING_CTRLS_ALL.CREATION_DATE%TYPE,
162: p_LAST_UPDATED_BY IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATED_BY%TYPE,
163: p_CREATED_BY IGC_CC_ROUTING_CTRLS_ALL.CREATED_BY%TYPE,
156: p_wf_approval_itemtype IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_ITEMTYPE%TYPE,
157: p_wf_approval_process IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_PROCESS%TYPE,
158: p_DEFAULT_APPROVAL_PATH_ID IGC_CC_ROUTING_CTRLS_ALL.DEFAULT_APPROVAL_PATH_ID%TYPE,
159: p_LAST_UPDATE_DATE IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_DATE%TYPE,
160: p_LAST_UPDATE_LOGIN IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_LOGIN%TYPE,
161: p_CREATION_DATE IGC_CC_ROUTING_CTRLS_ALL.CREATION_DATE%TYPE,
162: p_LAST_UPDATED_BY IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATED_BY%TYPE,
163: p_CREATED_BY IGC_CC_ROUTING_CTRLS_ALL.CREATED_BY%TYPE,
164: p_row_locked OUT NOCOPY VARCHAR2
157: p_wf_approval_process IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_PROCESS%TYPE,
158: p_DEFAULT_APPROVAL_PATH_ID IGC_CC_ROUTING_CTRLS_ALL.DEFAULT_APPROVAL_PATH_ID%TYPE,
159: p_LAST_UPDATE_DATE IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_DATE%TYPE,
160: p_LAST_UPDATE_LOGIN IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_LOGIN%TYPE,
161: p_CREATION_DATE IGC_CC_ROUTING_CTRLS_ALL.CREATION_DATE%TYPE,
162: p_LAST_UPDATED_BY IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATED_BY%TYPE,
163: p_CREATED_BY IGC_CC_ROUTING_CTRLS_ALL.CREATED_BY%TYPE,
164: p_row_locked OUT NOCOPY VARCHAR2
165: ) IS
158: p_DEFAULT_APPROVAL_PATH_ID IGC_CC_ROUTING_CTRLS_ALL.DEFAULT_APPROVAL_PATH_ID%TYPE,
159: p_LAST_UPDATE_DATE IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_DATE%TYPE,
160: p_LAST_UPDATE_LOGIN IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_LOGIN%TYPE,
161: p_CREATION_DATE IGC_CC_ROUTING_CTRLS_ALL.CREATION_DATE%TYPE,
162: p_LAST_UPDATED_BY IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATED_BY%TYPE,
163: p_CREATED_BY IGC_CC_ROUTING_CTRLS_ALL.CREATED_BY%TYPE,
164: p_row_locked OUT NOCOPY VARCHAR2
165: ) IS
166:
159: p_LAST_UPDATE_DATE IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_DATE%TYPE,
160: p_LAST_UPDATE_LOGIN IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_LOGIN%TYPE,
161: p_CREATION_DATE IGC_CC_ROUTING_CTRLS_ALL.CREATION_DATE%TYPE,
162: p_LAST_UPDATED_BY IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATED_BY%TYPE,
163: p_CREATED_BY IGC_CC_ROUTING_CTRLS_ALL.CREATED_BY%TYPE,
164: p_row_locked OUT NOCOPY VARCHAR2
165: ) IS
166:
167: l_api_name CONSTANT VARCHAR2(30) := 'Lock_Row';
168: l_api_version CONSTANT NUMBER := 1.0;
169: Counter NUMBER;
170: CURSOR C IS
171: SELECT *
172: FROM IGC_CC_ROUTING_CTRLS_ALL
173: WHERE rowid = p_Rowid
174: FOR UPDATE of ORG_ID NOWAIT;
175: Recinfo C%ROWTYPE;
176: BEGIN
299: x_msg_count OUT NOCOPY NUMBER,
300: x_msg_data OUT NOCOPY VARCHAR2,
301:
302: p_Rowid IN OUT NOCOPY VARCHAR2,
303: p_ORG_ID IGC_CC_ROUTING_CTRLS_ALL.ORG_ID%TYPE,
304: p_CC_TYPE IGC_CC_ROUTING_CTRLS_ALL.CC_TYPE%TYPE,
305: p_CC_STATE IGC_CC_ROUTING_CTRLS_ALL.CC_STATE%TYPE,
306: p_CC_CAN_PRPR_APPRV_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_APPRV_FLAG%TYPE,
307: p_CC_CAN_PRPR_ENCMBR_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_ENCMBR_FLAG%TYPE,
300: x_msg_data OUT NOCOPY VARCHAR2,
301:
302: p_Rowid IN OUT NOCOPY VARCHAR2,
303: p_ORG_ID IGC_CC_ROUTING_CTRLS_ALL.ORG_ID%TYPE,
304: p_CC_TYPE IGC_CC_ROUTING_CTRLS_ALL.CC_TYPE%TYPE,
305: p_CC_STATE IGC_CC_ROUTING_CTRLS_ALL.CC_STATE%TYPE,
306: p_CC_CAN_PRPR_APPRV_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_APPRV_FLAG%TYPE,
307: p_CC_CAN_PRPR_ENCMBR_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_ENCMBR_FLAG%TYPE,
308: p_wf_approval_itemtype IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_ITEMTYPE%TYPE,
301:
302: p_Rowid IN OUT NOCOPY VARCHAR2,
303: p_ORG_ID IGC_CC_ROUTING_CTRLS_ALL.ORG_ID%TYPE,
304: p_CC_TYPE IGC_CC_ROUTING_CTRLS_ALL.CC_TYPE%TYPE,
305: p_CC_STATE IGC_CC_ROUTING_CTRLS_ALL.CC_STATE%TYPE,
306: p_CC_CAN_PRPR_APPRV_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_APPRV_FLAG%TYPE,
307: p_CC_CAN_PRPR_ENCMBR_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_ENCMBR_FLAG%TYPE,
308: p_wf_approval_itemtype IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_ITEMTYPE%TYPE,
309: p_wf_approval_process IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_PROCESS%TYPE,
302: p_Rowid IN OUT NOCOPY VARCHAR2,
303: p_ORG_ID IGC_CC_ROUTING_CTRLS_ALL.ORG_ID%TYPE,
304: p_CC_TYPE IGC_CC_ROUTING_CTRLS_ALL.CC_TYPE%TYPE,
305: p_CC_STATE IGC_CC_ROUTING_CTRLS_ALL.CC_STATE%TYPE,
306: p_CC_CAN_PRPR_APPRV_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_APPRV_FLAG%TYPE,
307: p_CC_CAN_PRPR_ENCMBR_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_ENCMBR_FLAG%TYPE,
308: p_wf_approval_itemtype IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_ITEMTYPE%TYPE,
309: p_wf_approval_process IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_PROCESS%TYPE,
310: p_DEFAULT_APPROVAL_PATH_ID IGC_CC_ROUTING_CTRLS_ALL.DEFAULT_APPROVAL_PATH_ID%TYPE,
303: p_ORG_ID IGC_CC_ROUTING_CTRLS_ALL.ORG_ID%TYPE,
304: p_CC_TYPE IGC_CC_ROUTING_CTRLS_ALL.CC_TYPE%TYPE,
305: p_CC_STATE IGC_CC_ROUTING_CTRLS_ALL.CC_STATE%TYPE,
306: p_CC_CAN_PRPR_APPRV_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_APPRV_FLAG%TYPE,
307: p_CC_CAN_PRPR_ENCMBR_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_ENCMBR_FLAG%TYPE,
308: p_wf_approval_itemtype IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_ITEMTYPE%TYPE,
309: p_wf_approval_process IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_PROCESS%TYPE,
310: p_DEFAULT_APPROVAL_PATH_ID IGC_CC_ROUTING_CTRLS_ALL.DEFAULT_APPROVAL_PATH_ID%TYPE,
311: p_LAST_UPDATE_DATE IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_DATE%TYPE,
304: p_CC_TYPE IGC_CC_ROUTING_CTRLS_ALL.CC_TYPE%TYPE,
305: p_CC_STATE IGC_CC_ROUTING_CTRLS_ALL.CC_STATE%TYPE,
306: p_CC_CAN_PRPR_APPRV_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_APPRV_FLAG%TYPE,
307: p_CC_CAN_PRPR_ENCMBR_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_ENCMBR_FLAG%TYPE,
308: p_wf_approval_itemtype IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_ITEMTYPE%TYPE,
309: p_wf_approval_process IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_PROCESS%TYPE,
310: p_DEFAULT_APPROVAL_PATH_ID IGC_CC_ROUTING_CTRLS_ALL.DEFAULT_APPROVAL_PATH_ID%TYPE,
311: p_LAST_UPDATE_DATE IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_DATE%TYPE,
312: p_LAST_UPDATE_LOGIN IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_LOGIN%TYPE,
305: p_CC_STATE IGC_CC_ROUTING_CTRLS_ALL.CC_STATE%TYPE,
306: p_CC_CAN_PRPR_APPRV_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_APPRV_FLAG%TYPE,
307: p_CC_CAN_PRPR_ENCMBR_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_ENCMBR_FLAG%TYPE,
308: p_wf_approval_itemtype IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_ITEMTYPE%TYPE,
309: p_wf_approval_process IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_PROCESS%TYPE,
310: p_DEFAULT_APPROVAL_PATH_ID IGC_CC_ROUTING_CTRLS_ALL.DEFAULT_APPROVAL_PATH_ID%TYPE,
311: p_LAST_UPDATE_DATE IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_DATE%TYPE,
312: p_LAST_UPDATE_LOGIN IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_LOGIN%TYPE,
313: p_CREATION_DATE IGC_CC_ROUTING_CTRLS_ALL.CREATION_DATE%TYPE,
306: p_CC_CAN_PRPR_APPRV_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_APPRV_FLAG%TYPE,
307: p_CC_CAN_PRPR_ENCMBR_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_ENCMBR_FLAG%TYPE,
308: p_wf_approval_itemtype IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_ITEMTYPE%TYPE,
309: p_wf_approval_process IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_PROCESS%TYPE,
310: p_DEFAULT_APPROVAL_PATH_ID IGC_CC_ROUTING_CTRLS_ALL.DEFAULT_APPROVAL_PATH_ID%TYPE,
311: p_LAST_UPDATE_DATE IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_DATE%TYPE,
312: p_LAST_UPDATE_LOGIN IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_LOGIN%TYPE,
313: p_CREATION_DATE IGC_CC_ROUTING_CTRLS_ALL.CREATION_DATE%TYPE,
314: p_LAST_UPDATED_BY IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATED_BY%TYPE,
307: p_CC_CAN_PRPR_ENCMBR_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_ENCMBR_FLAG%TYPE,
308: p_wf_approval_itemtype IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_ITEMTYPE%TYPE,
309: p_wf_approval_process IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_PROCESS%TYPE,
310: p_DEFAULT_APPROVAL_PATH_ID IGC_CC_ROUTING_CTRLS_ALL.DEFAULT_APPROVAL_PATH_ID%TYPE,
311: p_LAST_UPDATE_DATE IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_DATE%TYPE,
312: p_LAST_UPDATE_LOGIN IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_LOGIN%TYPE,
313: p_CREATION_DATE IGC_CC_ROUTING_CTRLS_ALL.CREATION_DATE%TYPE,
314: p_LAST_UPDATED_BY IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATED_BY%TYPE,
315: p_CREATED_BY IGC_CC_ROUTING_CTRLS_ALL.CREATED_BY%TYPE
308: p_wf_approval_itemtype IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_ITEMTYPE%TYPE,
309: p_wf_approval_process IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_PROCESS%TYPE,
310: p_DEFAULT_APPROVAL_PATH_ID IGC_CC_ROUTING_CTRLS_ALL.DEFAULT_APPROVAL_PATH_ID%TYPE,
311: p_LAST_UPDATE_DATE IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_DATE%TYPE,
312: p_LAST_UPDATE_LOGIN IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_LOGIN%TYPE,
313: p_CREATION_DATE IGC_CC_ROUTING_CTRLS_ALL.CREATION_DATE%TYPE,
314: p_LAST_UPDATED_BY IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATED_BY%TYPE,
315: p_CREATED_BY IGC_CC_ROUTING_CTRLS_ALL.CREATED_BY%TYPE
316: ) IS
309: p_wf_approval_process IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_PROCESS%TYPE,
310: p_DEFAULT_APPROVAL_PATH_ID IGC_CC_ROUTING_CTRLS_ALL.DEFAULT_APPROVAL_PATH_ID%TYPE,
311: p_LAST_UPDATE_DATE IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_DATE%TYPE,
312: p_LAST_UPDATE_LOGIN IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_LOGIN%TYPE,
313: p_CREATION_DATE IGC_CC_ROUTING_CTRLS_ALL.CREATION_DATE%TYPE,
314: p_LAST_UPDATED_BY IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATED_BY%TYPE,
315: p_CREATED_BY IGC_CC_ROUTING_CTRLS_ALL.CREATED_BY%TYPE
316: ) IS
317:
310: p_DEFAULT_APPROVAL_PATH_ID IGC_CC_ROUTING_CTRLS_ALL.DEFAULT_APPROVAL_PATH_ID%TYPE,
311: p_LAST_UPDATE_DATE IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_DATE%TYPE,
312: p_LAST_UPDATE_LOGIN IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_LOGIN%TYPE,
313: p_CREATION_DATE IGC_CC_ROUTING_CTRLS_ALL.CREATION_DATE%TYPE,
314: p_LAST_UPDATED_BY IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATED_BY%TYPE,
315: p_CREATED_BY IGC_CC_ROUTING_CTRLS_ALL.CREATED_BY%TYPE
316: ) IS
317:
318: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';
311: p_LAST_UPDATE_DATE IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_DATE%TYPE,
312: p_LAST_UPDATE_LOGIN IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_LOGIN%TYPE,
313: p_CREATION_DATE IGC_CC_ROUTING_CTRLS_ALL.CREATION_DATE%TYPE,
314: p_LAST_UPDATED_BY IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATED_BY%TYPE,
315: p_CREATED_BY IGC_CC_ROUTING_CTRLS_ALL.CREATED_BY%TYPE
316: ) IS
317:
318: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';
319: l_api_version CONSTANT NUMBER := 1.0;
336: END IF;
337:
338: x_return_status := FND_API.G_RET_STS_SUCCESS ;
339:
340: UPDATE IGC_CC_ROUTING_CTRLS_ALL
341: SET
342:
343: ORG_ID = p_ORG_ID,
344: CC_TYPE = p_CC_TYPE,
431:
432: x_return_status := FND_API.G_RET_STS_SUCCESS ;
433:
434:
435: DELETE FROM IGC_CC_ROUTING_CTRLS_ALL
436: WHERE rowid = p_Rowid;
437: if (SQL%NOTFOUND) then
438: Raise NO_DATA_FOUND;
439: end if;