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.AS_SALES_LEAD_ASSIGN_PVT dependencies on AS_LEAD_ROUTING_WF

Line 157: g_resource_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;

153: -- length of Update array for AS_TERRITORY_ACCESSES
154: g_tu_count NUMBER := 0;
155:
156:
157: g_resource_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;
158: g_group_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;
159: g_person_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;
160:
161: -- The follwing is the meaning of g_resource_flag_tbl:

Line 158: g_group_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;

154: g_tu_count NUMBER := 0;
155:
156:
157: g_resource_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;
158: g_group_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;
159: g_person_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;
160:
161: -- The follwing is the meaning of g_resource_flag_tbl:
162: -- 'D': This resource is the default resource from profile

Line 159: g_person_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;

155:
156:
157: g_resource_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;
158: g_group_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;
159: g_person_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;
160:
161: -- The follwing is the meaning of g_resource_flag_tbl:
162: -- 'D': This resource is the default resource from profile
163: -- AS_DEFAULT_RESOURCE_ID, "OS: Default Resource ID used for Sales

Line 167: g_resource_flag_tbl AS_LEAD_ROUTING_WF.FLAG_TABLE;

163: -- AS_DEFAULT_RESOURCE_ID, "OS: Default Resource ID used for Sales
164: -- Lead Assignment".
165: -- 'L': This resource is the login user.
166: -- 'T': This resource is defined in territory.
167: g_resource_flag_tbl AS_LEAD_ROUTING_WF.FLAG_TABLE;
168:
169: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
170: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
171: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

Line 789: 'Calling AS_LEAD_ROUTING_WF.STARTPROCESS');

785:
786: -- Debug Message
787: IF (AS_DEBUG_LOW_ON) THEN
788: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
789: 'Calling AS_LEAD_ROUTING_WF.STARTPROCESS');
790: END IF;
791:
792: AS_LEAD_ROUTING_WF.STARTPROCESS (
793: p_sales_lead_id => p_sales_lead_id,

Line 792: AS_LEAD_ROUTING_WF.STARTPROCESS (

788: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
789: 'Calling AS_LEAD_ROUTING_WF.STARTPROCESS');
790: END IF;
791:
792: AS_LEAD_ROUTING_WF.STARTPROCESS (
793: p_sales_lead_id => p_sales_lead_id,
794: p_salesgroup_id => fnd_api.g_miss_num,
795: x_return_status => x_return_status,
796: x_item_type => l_itemtype,

Line 4700: l_resource_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;

4696: x_msg_data OUT NOCOPY VARCHAR2)
4697: IS
4698: l_sales_lead_rec AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type;
4699:
4700: l_resource_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;
4701: l_group_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;
4702: l_person_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;
4703: l_resource_flag_tbl AS_LEAD_ROUTING_WF.FLAG_TABLE;
4704:

Line 4701: l_group_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;

4697: IS
4698: l_sales_lead_rec AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type;
4699:
4700: l_resource_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;
4701: l_group_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;
4702: l_person_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;
4703: l_resource_flag_tbl AS_LEAD_ROUTING_WF.FLAG_TABLE;
4704:
4705: l_rs_id NUMBER;

Line 4702: l_person_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;

4698: l_sales_lead_rec AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type;
4699:
4700: l_resource_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;
4701: l_group_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;
4702: l_person_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;
4703: l_resource_flag_tbl AS_LEAD_ROUTING_WF.FLAG_TABLE;
4704:
4705: l_rs_id NUMBER;
4706: l_resource_id NUMBER;

Line 4703: l_resource_flag_tbl AS_LEAD_ROUTING_WF.FLAG_TABLE;

4699:
4700: l_resource_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;
4701: l_group_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;
4702: l_person_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;
4703: l_resource_flag_tbl AS_LEAD_ROUTING_WF.FLAG_TABLE;
4704:
4705: l_rs_id NUMBER;
4706: l_resource_id NUMBER;
4707: l_group_id NUMBER;

Line 4780: AS_LEAD_ROUTING_WF_CUHK.Get_Owner_Pre(

4776: BEGIN
4777: -- give sales_lead_id only for Oracle internal
4778: l_sales_lead_rec.sales_lead_id := p_sales_lead_id;
4779:
4780: AS_LEAD_ROUTING_WF_CUHK.Get_Owner_Pre(
4781: p_api_version_number => 2.0,
4782: p_init_msg_list => FND_API.G_FALSE,
4783: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4784: p_commit => FND_API.G_FALSE,

Line 5507: l_resource_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;

5503: x_msg_count OUT NOCOPY NUMBER,
5504: x_msg_data OUT NOCOPY VARCHAR2)
5505: IS
5506: l_sales_lead_id NUMBER;
5507: l_resource_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;
5508: l_group_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;
5509: l_person_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;
5510: l_resource_flag_tbl AS_LEAD_ROUTING_WF.FLAG_TABLE;
5511: l_check_calendar VARCHAR2(1);

Line 5508: l_group_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;

5504: x_msg_data OUT NOCOPY VARCHAR2)
5505: IS
5506: l_sales_lead_id NUMBER;
5507: l_resource_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;
5508: l_group_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;
5509: l_person_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;
5510: l_resource_flag_tbl AS_LEAD_ROUTING_WF.FLAG_TABLE;
5511: l_check_calendar VARCHAR2(1);
5512: l_index1 NUMBER; -- point to l_resource_id_tbl

Line 5509: l_person_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;

5505: IS
5506: l_sales_lead_id NUMBER;
5507: l_resource_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;
5508: l_group_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;
5509: l_person_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;
5510: l_resource_flag_tbl AS_LEAD_ROUTING_WF.FLAG_TABLE;
5511: l_check_calendar VARCHAR2(1);
5512: l_index1 NUMBER; -- point to l_resource_id_tbl
5513: l_index2 NUMBER; -- point to g_resource_id_tbl

Line 5510: l_resource_flag_tbl AS_LEAD_ROUTING_WF.FLAG_TABLE;

5506: l_sales_lead_id NUMBER;
5507: l_resource_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;
5508: l_group_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;
5509: l_person_id_tbl AS_LEAD_ROUTING_WF.NUMBER_TABLE;
5510: l_resource_flag_tbl AS_LEAD_ROUTING_WF.FLAG_TABLE;
5511: l_check_calendar VARCHAR2(1);
5512: l_index1 NUMBER; -- point to l_resource_id_tbl
5513: l_index2 NUMBER; -- point to g_resource_id_tbl
5514: l_last NUMBER; -- total number of rec in l_resource_id_tbl

Line 5703: l_call_user_hook := JTF_USR_HKS.Ok_to_execute('AS_LEAD_ROUTING_WF',

5699: THEN
5700: Get_Alternate_Resource(p_salesgroup_id);
5701: END IF;
5702:
5703: l_call_user_hook := JTF_USR_HKS.Ok_to_execute('AS_LEAD_ROUTING_WF',
5704: 'GetOwner','B','C');
5705:
5706: -- USER HOOK standard : customer pre-processing section - mandatory
5707: IF l_call_user_hook

Line 5790: AS_LEAD_ROUTING_WF_CUHK.Get_Owner_Pre(

5786: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5787: 'desc:' || l_sales_lead_rec.description);
5788: END IF;
5789:
5790: AS_LEAD_ROUTING_WF_CUHK.Get_Owner_Pre(
5791: p_api_version_number => 2.0,
5792: p_init_msg_list => FND_API.G_FALSE,
5793: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
5794: p_commit => FND_API.G_FALSE,