DBA Data[Home] [Help]

APPS.EAM_LINEAR_LOCATIONS_PUB dependencies on WIP_EAM_WORK_REQUESTS

Line 612: ,p_work_request_rec IN WIP_EAM_WORK_REQUESTS%ROWTYPE

608: ,p_external_linear_id IN NUMBER
609: ,p_external_linear_name IN VARCHAR2
610: ,p_external_source_name IN VARCHAR2
611: ,p_external_linear_type IN VARCHAR2
612: ,p_work_request_rec IN WIP_EAM_WORK_REQUESTS%ROWTYPE
613: ,p_user_name IN VARCHAR2
614: ,p_mode IN VARCHAR2
615: ,p_request_log IN VARCHAR2
616: ,x_work_request_id OUT NOCOPY VARCHAR2

Line 632: l_work_request_rec WIP_EAM_WORK_REQUESTS%ROWTYPE;

628: l_x_return_status varchar2(30);
629: l_x_msg_count number;
630: l_x_msg_data varchar2(2000);
631: l_x_eam_linear_id number;
632: l_work_request_rec WIP_EAM_WORK_REQUESTS%ROWTYPE;
633:
634: l_user_id number;
635: l_resp_id number := 111;
636: l_resp_appl_id number := 426;

Line 1226: mfg_lookups ml2, wip_eam_work_requests wewr, wip_entities we,

1222: wewr.expected_resolution_date expected_resolution_date,
1223: ml2.meaning work_request_type, wewr.phone_number phone_number,
1224: wewr.e_mail e_mail, wewr.contact_preference contact_preference
1225: from org_access_view oav, mfg_lookups ml, mfg_lookups ml1,
1226: mfg_lookups ml2, wip_eam_work_requests wewr, wip_entities we,
1227: bom_departments bd
1228: where wewr.work_request_id = p_work_request_id
1229: and oav.organization_id = wewr.organization_id
1230: and oav.resp_application_id = appl