eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGC_CC_ROUTING_CTRLS_PKG dependencies on IGC_CC_ROUTING_CTRLS_ALL

Line 20: p_ORG_ID IGC_CC_ROUTING_CTRLS_ALL.ORG_ID%TYPE,

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,

Line 21: p_CC_TYPE IGC_CC_ROUTING_CTRLS_ALL.CC_TYPE%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,

Line 22: p_CC_STATE IGC_CC_ROUTING_CTRLS_ALL.CC_STATE%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,

Line 23: p_CC_CAN_PRPR_APPRV_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_APPRV_FLAG%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,

Line 24: p_CC_CAN_PRPR_ENCMBR_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_ENCMBR_FLAG%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,

Line 25: p_wf_approval_itemtype IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_ITEMTYPE%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,

Line 26: p_wf_approval_process IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_PROCESS%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,

Line 27: p_DEFAULT_APPROVAL_PATH_ID IGC_CC_ROUTING_CTRLS_ALL.DEFAULT_APPROVAL_PATH_ID%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,

Line 28: p_LAST_UPDATE_DATE IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_DATE%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

Line 29: p_LAST_UPDATE_LOGIN IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_LOGIN%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

Line 30: p_CREATION_DATE IGC_CC_ROUTING_CTRLS_ALL.CREATION_DATE%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
34:

Line 31: p_LAST_UPDATED_BY IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATED_BY%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:
35: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';

Line 32: p_CREATED_BY IGC_CC_ROUTING_CTRLS_ALL.CREATED_BY%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';
36: l_api_version CONSTANT NUMBER := 1.0;

Line 38: CURSOR C IS SELECT rowid FROM IGC_CC_ROUTING_CTRLS_ALL

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:

Line 62: INSERT INTO IGC_CC_ROUTING_CTRLS_ALL(

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,

Line 151: p_ORG_ID IGC_CC_ROUTING_CTRLS_ALL.ORG_ID%TYPE,

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,

Line 152: p_CC_TYPE IGC_CC_ROUTING_CTRLS_ALL.CC_TYPE%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,

Line 153: p_CC_STATE IGC_CC_ROUTING_CTRLS_ALL.CC_STATE%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,

Line 154: p_CC_CAN_PRPR_APPRV_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_APPRV_FLAG%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,

Line 155: p_CC_CAN_PRPR_ENCMBR_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_ENCMBR_FLAG%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,

Line 156: p_wf_approval_itemtype IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_ITEMTYPE%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,

Line 157: p_wf_approval_process IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_PROCESS%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,

Line 158: p_DEFAULT_APPROVAL_PATH_ID IGC_CC_ROUTING_CTRLS_ALL.DEFAULT_APPROVAL_PATH_ID%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,

Line 159: p_LAST_UPDATE_DATE IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_DATE%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,

Line 160: p_LAST_UPDATE_LOGIN IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_LOGIN%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

Line 161: p_CREATION_DATE IGC_CC_ROUTING_CTRLS_ALL.CREATION_DATE%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
165: ) IS

Line 162: p_LAST_UPDATED_BY IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATED_BY%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
166:

Line 163: p_CREATED_BY IGC_CC_ROUTING_CTRLS_ALL.CREATED_BY%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:
167: l_api_name CONSTANT VARCHAR2(30) := 'Lock_Row';

Line 172: FROM IGC_CC_ROUTING_CTRLS_ALL

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

Line 303: p_ORG_ID IGC_CC_ROUTING_CTRLS_ALL.ORG_ID%TYPE,

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,

Line 304: p_CC_TYPE IGC_CC_ROUTING_CTRLS_ALL.CC_TYPE%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,

Line 305: p_CC_STATE IGC_CC_ROUTING_CTRLS_ALL.CC_STATE%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,

Line 306: p_CC_CAN_PRPR_APPRV_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_APPRV_FLAG%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,

Line 307: p_CC_CAN_PRPR_ENCMBR_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_ENCMBR_FLAG%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,

Line 308: p_wf_approval_itemtype IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_ITEMTYPE%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,

Line 309: p_wf_approval_process IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_PROCESS%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,

Line 310: p_DEFAULT_APPROVAL_PATH_ID IGC_CC_ROUTING_CTRLS_ALL.DEFAULT_APPROVAL_PATH_ID%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,

Line 311: p_LAST_UPDATE_DATE IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_DATE%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

Line 312: p_LAST_UPDATE_LOGIN IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_LOGIN%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

Line 313: p_CREATION_DATE IGC_CC_ROUTING_CTRLS_ALL.CREATION_DATE%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
317:

Line 314: p_LAST_UPDATED_BY IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATED_BY%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:
318: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';

Line 315: p_CREATED_BY IGC_CC_ROUTING_CTRLS_ALL.CREATED_BY%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';
319: l_api_version CONSTANT NUMBER := 1.0;

Line 340: UPDATE IGC_CC_ROUTING_CTRLS_ALL

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,

Line 435: DELETE FROM IGC_CC_ROUTING_CTRLS_ALL

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;