6386:
6387: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
6388: FROM dual;
6389:
6390: IF (JTF_USR_HKS.ok_to_execute
6391: (
6392: 'JTF_ASSIGN_PUB',
6393: 'GET_ASSIGN_DR_RESOURCES',
6394: 'W',
6418: END IF;
6419: END IF;
6420:
6421:
6422: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
6423:
6424: JTF_USR_HKS.WrkFlowLaunch
6425: (
6426: 'JTF_ASSIGN_WF',
6420:
6421:
6422: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
6423:
6424: JTF_USR_HKS.WrkFlowLaunch
6425: (
6426: 'JTF_ASSIGN_WF',
6427: l_workflow_profile,
6428: 'ASSIGN WF - '|| TO_CHAR(l_workflow_key),
6429: l_bind_data_id,
6430: l_return_code
6431: );
6432:
6433: JTF_USR_HKS.purge_bind_data
6434: (
6435: l_bind_data_id,
6436: 'W'
6437: );
6450: END IF;
6451:
6452: END IF; -- End of JTF_ASSIGN_CUHK
6453:
6454: END IF; -- End of JTF_USR_HKS
6455:
6456:
6457: /* Standard call to get message count and
6458: the message information */
7080:
7081: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
7082: FROM dual;
7083:
7084: IF (JTF_USR_HKS.ok_to_execute
7085: (
7086: 'JTF_ASSIGN_PUB',
7087: 'GET_ASSIGN_OPPR_RESOURCES',
7088: 'W',
7110: RAISE fnd_api.g_exc_unexpected_error;
7111: END IF;
7112: END IF;
7113:
7114: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
7115:
7116: JTF_USR_HKS.WrkFlowLaunch
7117: (
7118: 'JTF_ASSIGN_WF',
7112: END IF;
7113:
7114: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
7115:
7116: JTF_USR_HKS.WrkFlowLaunch
7117: (
7118: 'JTF_ASSIGN_WF',
7119: l_workflow_profile,
7120: 'ASSIGN WF - '|| TO_CHAR(l_workflow_key),
7121: l_bind_data_id,
7122: l_return_code
7123: );
7124:
7125: JTF_USR_HKS.purge_bind_data
7126: (
7127: l_bind_data_id,
7128: 'W'
7129: );
7141: END IF;
7142:
7143: END IF; -- End of JTF_ASSIGN_CUHK
7144:
7145: END IF; -- End of JTF_USR_HKS
7146:
7147:
7148:
7149:
7668:
7669: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
7670: FROM dual;
7671:
7672: IF (JTF_USR_HKS.ok_to_execute
7673: (
7674: 'JTF_ASSIGN_PUB',
7675: 'GET_ASSIGN_LEAD_RESOURCES',
7676: 'W',
7698: RAISE fnd_api.g_exc_unexpected_error;
7699: END IF;
7700: END IF;
7701:
7702: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
7703:
7704: JTF_USR_HKS.WrkFlowLaunch
7705: (
7706: 'JTF_ASSIGN_WF',
7700: END IF;
7701:
7702: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
7703:
7704: JTF_USR_HKS.WrkFlowLaunch
7705: (
7706: 'JTF_ASSIGN_WF',
7707: l_workflow_profile,
7708: 'ASSIGN WF - '|| TO_CHAR(l_workflow_key),
7709: l_bind_data_id,
7710: l_return_code
7711: );
7712:
7713: JTF_USR_HKS.purge_bind_data
7714: (
7715: l_bind_data_id,
7716: 'W'
7717: );
7729: END IF;
7730:
7731: END IF; -- End of JTF_ASSIGN_CUHK
7732:
7733: END IF; -- End of JTF_USR_HKS
7734:
7735:
7736:
7737:
8280:
8281: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
8282: FROM dual;
8283:
8284: IF (JTF_USR_HKS.ok_to_execute
8285: (
8286: 'JTF_ASSIGN_PUB',
8287: 'GET_ASSIGN_LEAD_RESOURCES',
8288: 'W',
8310: RAISE fnd_api.g_exc_unexpected_error;
8311: END IF;
8312: END IF;
8313:
8314: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
8315:
8316: JTF_USR_HKS.WrkFlowLaunch
8317: (
8318: 'JTF_ASSIGN_WF',
8312: END IF;
8313:
8314: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
8315:
8316: JTF_USR_HKS.WrkFlowLaunch
8317: (
8318: 'JTF_ASSIGN_WF',
8319: l_workflow_profile,
8320: 'ASSIGN WF - '|| TO_CHAR(l_workflow_key),
8321: l_bind_data_id,
8322: l_return_code
8323: );
8324:
8325: JTF_USR_HKS.purge_bind_data
8326: (
8327: l_bind_data_id,
8328: 'W'
8329: );
8342: END IF;
8343:
8344: END IF; -- End of JTF_ASSIGN_CUHK
8345:
8346: END IF; -- End of JTF_USR_HKS
8347:
8348:
8349:
8350: /* Standard call to get message count and
8928:
8929: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
8930: FROM dual;
8931:
8932: IF (JTF_USR_HKS.ok_to_execute
8933: (
8934: 'JTF_ASSIGN_PUB',
8935: 'GET_ASSIGN_ACCOUNT_RESOURCES',
8936: 'W',
8958: RAISE fnd_api.g_exc_unexpected_error;
8959: END IF;
8960: END IF;
8961:
8962: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
8963:
8964: JTF_USR_HKS.WrkFlowLaunch
8965: (
8966: 'JTF_ASSIGN_WF',
8960: END IF;
8961:
8962: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
8963:
8964: JTF_USR_HKS.WrkFlowLaunch
8965: (
8966: 'JTF_ASSIGN_WF',
8967: l_workflow_profile,
8968: 'ASSIGN WF - '|| TO_CHAR(l_workflow_key),
8969: l_bind_data_id,
8970: l_return_code
8971: );
8972:
8973: JTF_USR_HKS.purge_bind_data
8974: (
8975: l_bind_data_id,
8976: 'W'
8977: );
8989: END IF;
8990:
8991: END IF; -- End of JTF_ASSIGN_CUHK
8992:
8993: END IF; -- End of JTF_USR_HKS
8994:
8995:
8996:
8997:
10450:
10451: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
10452: FROM dual;
10453:
10454: IF (JTF_USR_HKS.ok_to_execute
10455: (
10456: 'JTF_ASSIGN_PUB',
10457: 'GET_ASSIGN_ESC_RESOURCES',
10458: 'W',
10481: END IF;
10482: END IF;
10483:
10484:
10485: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
10486:
10487: JTF_USR_HKS.WrkFlowLaunch
10488: (
10489: 'JTF_ASSIGN_WF',
10483:
10484:
10485: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
10486:
10487: JTF_USR_HKS.WrkFlowLaunch
10488: (
10489: 'JTF_ASSIGN_WF',
10490: l_workflow_profile,
10491: 'ASSIGN WF - '|| TO_CHAR(l_workflow_key),
10492: l_bind_data_id,
10493: l_return_code
10494: );
10495:
10496: JTF_USR_HKS.purge_bind_data
10497: (
10498: l_bind_data_id,
10499: 'W'
10500: );
10513: END IF;
10514:
10515: END IF; -- End of JTF_ASSIGN_CUHK
10516:
10517: END IF; -- End of JTF_USR_HKS
10518:
10519:
10520:
10521: /* Standard call to get message count and
11969:
11970: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
11971: FROM dual;
11972:
11973: IF (JTF_USR_HKS.ok_to_execute
11974: (
11975: 'JTF_ASSIGN_PUB',
11976: 'GET_ASSIGN_RESOURCES',
11977: 'W',
12001: END IF;
12002: END IF;
12003:
12004:
12005: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
12006:
12007: JTF_USR_HKS.WrkFlowLaunch
12008: (
12009: 'JTF_ASSIGN_WF',
12003:
12004:
12005: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
12006:
12007: JTF_USR_HKS.WrkFlowLaunch
12008: (
12009: 'JTF_ASSIGN_WF',
12010: l_workflow_profile,
12011: 'ASSIGN WF - '|| TO_CHAR(l_workflow_key),
12012: l_bind_data_id,
12013: l_return_code
12014: );
12015:
12016: JTF_USR_HKS.purge_bind_data
12017: (
12018: l_bind_data_id,
12019: 'W'
12020: );
12033: END IF;
12034:
12035: END IF; -- End of JTF_ASSIGN_CUHK
12036:
12037: END IF; -- End of JTF_USR_HKS
12038:
12039:
12040: /* Standard call to get message count and
12041: the message information */