DBA Data[Home] [Help]

APPS.JTF_EC_WORKFLOW_PKG dependencies on JTF_EC_WORKFLOW_PKG

Line 1: PACKAGE BODY JTF_EC_WORKFLOW_PKG as

1: PACKAGE BODY JTF_EC_WORKFLOW_PKG as
2: /* $Header: jtfecwfb.pls 120.6.12020000.2 2012/07/25 14:54:54 aditysin ship $ */
3:
4: FUNCTION get_resource_name(
5: p_resource_type IN VARCHAR2,

Line 74: i BINARY_INTEGER := jtf_ec_workflow_pkg.NotifList.COUNT;

70: p_role_name IN VARCHAR2,
71: x_return_status OUT NOCOPY VARCHAR2) is
72:
73: l_api_name VARCHAR2(30) := 'Include_Role';
74: i BINARY_INTEGER := jtf_ec_workflow_pkg.NotifList.COUNT;
75:
76: BEGIN
77:
78: -- doesn't perform a role validation

Line 82: jtf_ec_workflow_pkg.NotifList(i+1).name := p_role_name;

78: -- doesn't perform a role validation
79:
80: x_return_status := FND_API.G_RET_STS_SUCCESS;
81:
82: jtf_ec_workflow_pkg.NotifList(i+1).name := p_role_name;
83:
84: EXCEPTION
85: WHEN FND_API.G_EXC_ERROR THEN
86: x_return_status := FND_API.G_Ret_Sts_Error;

Line 1231: JTF_EC_WORKFLOW_PKG.NotifList.Delete; -- := JTF_EC_WORKFLOW_PKG.G_Miss_NotifList;

1227: -------------------------------------------------------------------------
1228: -- initialize the table with the performer details
1229: -------------------------------------------------------------------------
1230:
1231: JTF_EC_WORKFLOW_PKG.NotifList.Delete; -- := JTF_EC_WORKFLOW_PKG.G_Miss_NotifList;
1232:
1233: g_notif_not_sent := NULL;
1234:
1235: -------------------------------------------------------------------------

Line 1666: l_counter := jtf_ec_workflow_pkg.NotifList.COUNT;

1662: -------------------------------------------------------------------------
1663: -- Set the process counters
1664: -------------------------------------------------------------------------
1665:
1666: l_counter := jtf_ec_workflow_pkg.NotifList.COUNT;
1667:
1668: wf_engine.SetItemAttrNumber(
1669: itemtype => p_wf_item_type_name,
1670: itemkey => l_itemkey,

Line 1957: l_role := jtf_ec_workflow_pkg.NotifList(l_counter).Name;

1953: itemkey => itemkey,
1954: aname => 'LIST_COUNTER'
1955: );
1956:
1957: l_role := jtf_ec_workflow_pkg.NotifList(l_counter).Name;
1958:
1959: if l_role is not NULL then
1960:
1961: wf_engine.SetItemAttrText(

Line 2058: l_esc_rec JTF_EC_WORKFLOW_PKG.esc_rec_type ;

2054: old_level IN VARCHAR2,
2055: old_status_id IN NUMBER,
2056: old_target_date IN DATE )
2057: IS
2058: l_esc_rec JTF_EC_WORKFLOW_PKG.esc_rec_type ;
2059: BEGIN
2060: l_esc_rec.task_id := task_id;
2061: l_esc_rec.doc_created := doc_created;
2062: l_esc_rec.owner_changed := owner_changed;

Line 2073: JTF_EC_WORKFLOW_PKG.Raise_Esc_Update_Event(p_esc_rec => l_esc_rec);

2069: l_esc_rec.old_level := old_level;
2070: l_esc_rec.old_status_id := old_status_id;
2071: l_esc_rec.old_target_date := old_target_date;
2072:
2073: JTF_EC_WORKFLOW_PKG.Raise_Esc_Update_Event(p_esc_rec => l_esc_rec);
2074: END Raise_Esc_Update_Event;
2075:
2076: PROCEDURE Raise_Esc_Update_Event(P_ESC_REC IN JTF_EC_WORKFLOW_PKG.esc_rec_type)
2077: IS

Line 2076: PROCEDURE Raise_Esc_Update_Event(P_ESC_REC IN JTF_EC_WORKFLOW_PKG.esc_rec_type)

2072:
2073: JTF_EC_WORKFLOW_PKG.Raise_Esc_Update_Event(p_esc_rec => l_esc_rec);
2074: END Raise_Esc_Update_Event;
2075:
2076: PROCEDURE Raise_Esc_Update_Event(P_ESC_REC IN JTF_EC_WORKFLOW_PKG.esc_rec_type)
2077: IS
2078: l_list WF_PARAMETER_LIST_T;
2079: l_key varchar2(240);
2080: l_event_name varchar2(240) := 'oracle.apps.jtf.cac.esc.updateEscalation';

Line 2081: l_esc_rec JTF_EC_WORKFLOW_PKG.esc_rec_type := p_esc_rec;

2077: IS
2078: l_list WF_PARAMETER_LIST_T;
2079: l_key varchar2(240);
2080: l_event_name varchar2(240) := 'oracle.apps.jtf.cac.esc.updateEscalation';
2081: l_esc_rec JTF_EC_WORKFLOW_PKG.esc_rec_type := p_esc_rec;
2082:
2083: BEGIN
2084: --Get the item key
2085: l_list := NULL;

Line 2148: wf_core.CONTEXT('jtf_ec_workflow_pkg', 'create_esc_notif_subs', p_event.event_name, p_subscription_guid);

2144: x_notif_not_sent =>l_notif_not_sent,
2145: X_WF_PROCESS_ID =>l_wf_process_id);
2146:
2147: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
2148: wf_core.CONTEXT('jtf_ec_workflow_pkg', 'create_esc_notif_subs', p_event.event_name, p_subscription_guid);
2149: wf_event.seterrorinfo(p_event, 'WARNING');
2150: RETURN 'WARNING';
2151: END IF;
2152:

Line 2156: wf_core.CONTEXT('jtf_ec_workflow_pkg', 'create_esc_notif_subs', p_event.event_name, p_subscription_guid);

2152:
2153: RETURN 'SUCCESS';
2154: EXCEPTION
2155: WHEN OTHERS THEN
2156: wf_core.CONTEXT('jtf_ec_workflow_pkg', 'create_esc_notif_subs', p_event.event_name, p_subscription_guid);
2157: wf_event.seterrorinfo(p_event, 'WARNING');
2158: RETURN 'WARNING';
2159: END create_esc_notif_subs;
2160:

Line 2171: l_esc_rec JTF_EC_WORKFLOW_PKG.esc_rec_type;

2167: x_return_status VARCHAR2(200);
2168: x_msg_count NUMBER;
2169: x_msg_data VARCHAR2(1000);
2170:
2171: l_esc_rec JTF_EC_WORKFLOW_PKG.esc_rec_type;
2172: BEGIN
2173: l_esc_rec.task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
2174: l_esc_rec.doc_created := wf_event.getvalueforparameter('DOC_CREATED', p_event.parameter_list);
2175: l_esc_rec.owner_changed := wf_event.getvalueforparameter('OWNER_CHANGED', p_event.parameter_list);

Line 2209: wf_core.CONTEXT('jtf_ec_workflow_pkg', 'update_esc_notif_subs', p_event.event_name, p_subscription_guid);

2205: x_notif_not_sent =>l_notif_not_sent,
2206: X_WF_PROCESS_ID =>l_wf_process_id);
2207:
2208: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
2209: wf_core.CONTEXT('jtf_ec_workflow_pkg', 'update_esc_notif_subs', p_event.event_name, p_subscription_guid);
2210: wf_event.seterrorinfo(p_event, 'WARNING');
2211: RETURN 'WARNING';
2212: END IF;
2213:

Line 2217: wf_core.CONTEXT('jtf_ec_workflow_pkg', 'update_esc_notif_subs', p_event.event_name, p_subscription_guid);

2213:
2214: RETURN 'SUCCESS';
2215: EXCEPTION
2216: WHEN OTHERS THEN
2217: wf_core.CONTEXT('jtf_ec_workflow_pkg', 'update_esc_notif_subs', p_event.event_name, p_subscription_guid);
2218: wf_event.seterrorinfo(p_event, 'WARNING');
2219: RETURN 'WARNING';
2220: END update_esc_notif_subs;
2221:

Line 2224: END JTF_EC_WORKFLOW_PKG;

2220: END update_esc_notif_subs;
2221:
2222: --End of code for ER 7032664
2223:
2224: END JTF_EC_WORKFLOW_PKG;