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.IBU_REQ_PKG dependencies on DUAL

Line 252: select fnd_global.resp_id into l_responsibility_id from dual;

248: l_sr_rec.creation_program_code := 'ISUPPORTSRUI';
249: l_sr_rec.last_update_program_code := 'ISUPPORTSRUI';
250:
251: -- added by wei ma
252: select fnd_global.resp_id into l_responsibility_id from dual;
253:
254:
255: -- added for 11.5.10
256: l_temp_close_value := FND_PROFILE.VALUE('CS_SR_AUTO_CLOSE_CHILDREN');

Line 269: Into l_cs_auto_assignment From dual;

265: end if;
266:
267: -- added in 11510 for auto-assignment.
268: Select nvl(fnd_profile.value('CS_AUTO_ASSIGN_OWNER_HTML'), 'N')
269: Into l_cs_auto_assignment From dual;
270:
271: CS_SERVICEREQUEST_PVT.UPDATE_SERVICEREQUEST(
272: p_api_version => 4.0,
273: p_init_msg_list => fnd_api.g_true,

Line 516: x_individual_owner VARCHAR2(100);

512: l_ibu_assignment VARCHAR2(1);
513: l_default_coverage_temp_id NUMBER;
514:
515: --added by wei ma
516: x_individual_owner VARCHAR2(100);
517: x_group_owner VARCHAR2(100);
518: x_individual_type VARCHAR2(100);
519:
520: -- wei ma tempoary

Line 518: x_individual_type VARCHAR2(100);

514:
515: --added by wei ma
516: x_individual_owner VARCHAR2(100);
517: x_group_owner VARCHAR2(100);
518: x_individual_type VARCHAR2(100);
519:
520: -- wei ma tempoary
521: l_responsibility_id NUMBER;
522: l_type_return_staus VARCHAR2(1);

Line 828: Into l_cs_atuo_assignment From dual;

824: * 11-APR-2002 KLOU, (ASSG)
825: */
826:
827: Select nvl(fnd_profile.value('CS_AUTO_ASSIGN_OWNER_HTML'), 'N')
828: Into l_cs_atuo_assignment From dual;
829:
830: If l_cs_atuo_assignment = 'N' Then
831: Select nvl(fnd_profile.value('IBU_R_ASSIGNMENT_USED_OWNERS'), 'Y')
832: Into l_ibu_assignment From dual;

Line 832: Into l_ibu_assignment From dual;

828: Into l_cs_atuo_assignment From dual;
829:
830: If l_cs_atuo_assignment = 'N' Then
831: Select nvl(fnd_profile.value('IBU_R_ASSIGNMENT_USED_OWNERS'), 'Y')
832: Into l_ibu_assignment From dual;
833:
834: If l_ibu_assignment = 'Y' Then
835:
836: -- Start of Fix to Bug 6621657

Line 840: * Into l_sr_rec.group_type From dual;

836: -- Start of Fix to Bug 6621657
837: -- Profile CS_SR_DEFAULT_GROUP_TYPE is obsoleted in 12.0.2 and 12.0.3.
838:
839: /* Select fnd_profile.value('CS_SR_DEFAULT_GROUP_TYPE')
840: * Into l_sr_rec.group_type From dual;
841: */
842:
843: l_sr_rec.group_type := 'RS_GROUP';
844:

Line 848: Into l_sr_rec.owner_group_id From dual;

844:
845: --End of Fix to Bug 6621657
846:
847: Select fnd_profile.value('CS_SR_DEFAULT_GROUP_OWNER')
848: Into l_sr_rec.owner_group_id From dual;
849:
850: Select fnd_profile.value('INC_DEFAULT_INCIDENT_OWNER')
851: Into l_sr_rec.owner_id From dual;
852:

Line 851: Into l_sr_rec.owner_id From dual;

847: Select fnd_profile.value('CS_SR_DEFAULT_GROUP_OWNER')
848: Into l_sr_rec.owner_group_id From dual;
849:
850: Select fnd_profile.value('INC_DEFAULT_INCIDENT_OWNER')
851: Into l_sr_rec.owner_id From dual;
852:
853: Select fnd_profile.value('CS_SR_DEFAULT_OWNER_TYPE')
854: into l_sr_rec.resource_type from dual;
855:

Line 854: into l_sr_rec.resource_type from dual;

850: Select fnd_profile.value('INC_DEFAULT_INCIDENT_OWNER')
851: Into l_sr_rec.owner_id From dual;
852:
853: Select fnd_profile.value('CS_SR_DEFAULT_OWNER_TYPE')
854: into l_sr_rec.resource_type from dual;
855:
856: End If;
857: End If;
858: -- Done auto assignment

Line 1089: from dual;

1085:
1086: --wei ma added
1087: select fnd_global.resp_id, fnd_global.resp_appl_id, fnd_global.user_id, fnd_global.login_id
1088: into l_responsibility_id, l_resp_appl_id, l_user_id, l_login_id
1089: from dual;
1090: -- added for 11.5.10
1091: l_default_coverage_temp_id := fnd_profile.value('CS_SR_DEFAULT_COVERAGE');
1092:
1093: CS_ServiceRequest_PVT.Create_ServiceRequest(

Line 1411: select fnd_global.resp_id into l_responsibility_id from dual;

1407: TRUNC(NVL(csIncidentStatus.end_date_active, SYSDATE)) and
1408: rownum <=1 ;
1409:
1410: begin
1411: select fnd_global.resp_id into l_responsibility_id from dual;
1412:
1413: open cur_sr_def_status_group_a(p_type_id, l_responsibility_id);
1414: fetch cur_sr_def_status_group_a into l_group_id;
1415: close cur_sr_def_status_group_a;

Line 1537: --get_seq varchar2(50) := 'select ' || 'IBU_SR_NOTIFICATION_S' || '.nextval from dual';

1533: i number := 0;
1534: l_user varchar2(50);
1535: seq number := 0;
1536: --create_seq varchar2(50) := 'create sequence IBU_SR_NOTIFICATION_S';
1537: --get_seq varchar2(50) := 'select ' || 'IBU_SR_NOTIFICATION_S' || '.nextval from dual';
1538: get_seq varchar2(50) := 'select ' || 'IBU_WF_ITEM_KEY_S' || '.nextval from dual';
1539: mailAttrVals Wf_Engine.TextTabTyp ;
1540: begin
1541: /* Get schema name */

Line 1538: get_seq varchar2(50) := 'select ' || 'IBU_WF_ITEM_KEY_S' || '.nextval from dual';

1534: l_user varchar2(50);
1535: seq number := 0;
1536: --create_seq varchar2(50) := 'create sequence IBU_SR_NOTIFICATION_S';
1537: --get_seq varchar2(50) := 'select ' || 'IBU_SR_NOTIFICATION_S' || '.nextval from dual';
1538: get_seq varchar2(50) := 'select ' || 'IBU_WF_ITEM_KEY_S' || '.nextval from dual';
1539: mailAttrVals Wf_Engine.TextTabTyp ;
1540: begin
1541: /* Get schema name */
1542: select user into l_user from dual;

Line 1542: select user into l_user from dual;

1538: get_seq varchar2(50) := 'select ' || 'IBU_WF_ITEM_KEY_S' || '.nextval from dual';
1539: mailAttrVals Wf_Engine.TextTabTyp ;
1540: begin
1541: /* Get schema name */
1542: select user into l_user from dual;
1543:
1544: /* Get sequence for item key to be unique */
1545: /* select count(*) into cnt from all_objects
1546: where object_name like 'IBU_SR_NOTIFICATION_S'