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 269: select fnd_global.resp_id into l_responsibility_id from dual;

265: l_sr_rec.creation_program_code := 'ISUPPORTSRUI';
266: l_sr_rec.last_update_program_code := 'ISUPPORTSRUI';
267:
268: -- added by wei ma
269: select fnd_global.resp_id into l_responsibility_id from dual;
270:
271:
272: -- added for 11.5.10
273: l_temp_close_value := FND_PROFILE.VALUE('CS_SR_AUTO_CLOSE_CHILDREN');

Line 286: Into l_cs_auto_assignment From dual;

282: end if;
283:
284: -- added in 11510 for auto-assignment.
285: Select nvl(fnd_profile.value('CS_AUTO_ASSIGN_OWNER_HTML'), 'N')
286: Into l_cs_auto_assignment From dual;
287:
288: CS_SERVICEREQUEST_PVT.UPDATE_SERVICEREQUEST(
289: p_api_version => 4.0,
290: p_init_msg_list => fnd_api.g_true,

Line 540: x_individual_owner VARCHAR2(100);

536: l_ibu_assignment VARCHAR2(1);
537: l_default_coverage_temp_id NUMBER;
538:
539: --added by wei ma
540: x_individual_owner VARCHAR2(100);
541: x_group_owner VARCHAR2(100);
542: x_individual_type VARCHAR2(100);
543:
544: -- wei ma tempoary

Line 542: x_individual_type VARCHAR2(100);

538:
539: --added by wei ma
540: x_individual_owner VARCHAR2(100);
541: x_group_owner VARCHAR2(100);
542: x_individual_type VARCHAR2(100);
543:
544: -- wei ma tempoary
545: l_responsibility_id NUMBER;
546: l_type_return_staus VARCHAR2(1);

Line 891: Into l_cs_atuo_assignment From dual;

887: * 11-APR-2002 KLOU, (ASSG)
888: */
889:
890: Select nvl(fnd_profile.value('CS_AUTO_ASSIGN_OWNER_HTML'), 'N')
891: Into l_cs_atuo_assignment From dual;
892:
893: If l_cs_atuo_assignment = 'N' Then
894: Select nvl(fnd_profile.value('IBU_R_ASSIGNMENT_USED_OWNERS'), 'Y')
895: Into l_ibu_assignment From dual;

Line 895: Into l_ibu_assignment From dual;

891: Into l_cs_atuo_assignment From dual;
892:
893: If l_cs_atuo_assignment = 'N' Then
894: Select nvl(fnd_profile.value('IBU_R_ASSIGNMENT_USED_OWNERS'), 'Y')
895: Into l_ibu_assignment From dual;
896:
897: If l_ibu_assignment = 'Y' Then
898:
899: -- Start of Fix to Bug 6621657

Line 903: * Into l_sr_rec.group_type From dual;

899: -- Start of Fix to Bug 6621657
900: -- Profile CS_SR_DEFAULT_GROUP_TYPE is obsoleted in 12.0.2 and 12.0.3.
901:
902: /* Select fnd_profile.value('CS_SR_DEFAULT_GROUP_TYPE')
903: * Into l_sr_rec.group_type From dual;
904: */
905:
906: l_sr_rec.group_type := 'RS_GROUP';
907:

Line 911: Into l_sr_rec.owner_group_id From dual;

907:
908: --End of Fix to Bug 6621657
909:
910: Select fnd_profile.value('CS_SR_DEFAULT_GROUP_OWNER')
911: Into l_sr_rec.owner_group_id From dual;
912:
913: Select fnd_profile.value('INC_DEFAULT_INCIDENT_OWNER')
914: Into l_sr_rec.owner_id From dual;
915:

Line 914: Into l_sr_rec.owner_id From dual;

910: Select fnd_profile.value('CS_SR_DEFAULT_GROUP_OWNER')
911: Into l_sr_rec.owner_group_id From dual;
912:
913: Select fnd_profile.value('INC_DEFAULT_INCIDENT_OWNER')
914: Into l_sr_rec.owner_id From dual;
915:
916: Select fnd_profile.value('CS_SR_DEFAULT_OWNER_TYPE')
917: into l_sr_rec.resource_type from dual;
918:

Line 917: into l_sr_rec.resource_type from dual;

913: Select fnd_profile.value('INC_DEFAULT_INCIDENT_OWNER')
914: Into l_sr_rec.owner_id From dual;
915:
916: Select fnd_profile.value('CS_SR_DEFAULT_OWNER_TYPE')
917: into l_sr_rec.resource_type from dual;
918:
919: End If;
920: End If;
921: -- Done auto assignment

Line 1168: from dual;

1164:
1165: --wei ma added
1166: select fnd_global.resp_id, fnd_global.resp_appl_id, fnd_global.user_id, fnd_global.login_id
1167: into l_responsibility_id, l_resp_appl_id, l_user_id, l_login_id
1168: from dual;
1169: -- added for 11.5.10
1170: l_default_coverage_temp_id := fnd_profile.value('CS_SR_DEFAULT_COVERAGE');
1171:
1172: -- Fix 11815997

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

1494: TRUNC(NVL(csIncidentStatus.end_date_active, SYSDATE)) and
1495: rownum <=1 ;
1496:
1497: begin
1498: select fnd_global.resp_id into l_responsibility_id from dual;
1499:
1500: open cur_sr_def_status_group_a(p_type_id, l_responsibility_id);
1501: fetch cur_sr_def_status_group_a into l_group_id;
1502: close cur_sr_def_status_group_a;

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

1623: i number := 0;
1624: l_user varchar2(50);
1625: seq number := 0;
1626: --create_seq varchar2(50) := 'create sequence IBU_SR_NOTIFICATION_S';
1627: --get_seq varchar2(50) := 'select ' || 'IBU_SR_NOTIFICATION_S' || '.nextval from dual';
1628: get_seq varchar2(50) := 'select ' || 'IBU_WF_ITEM_KEY_S' || '.nextval from dual';
1629: mailAttrVals Wf_Engine.TextTabTyp ;
1630: begin
1631: /* Get schema name */

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

1624: l_user varchar2(50);
1625: seq number := 0;
1626: --create_seq varchar2(50) := 'create sequence IBU_SR_NOTIFICATION_S';
1627: --get_seq varchar2(50) := 'select ' || 'IBU_SR_NOTIFICATION_S' || '.nextval from dual';
1628: get_seq varchar2(50) := 'select ' || 'IBU_WF_ITEM_KEY_S' || '.nextval from dual';
1629: mailAttrVals Wf_Engine.TextTabTyp ;
1630: begin
1631: /* Get schema name */
1632: select user into l_user from dual;

Line 1632: select user into l_user from dual;

1628: get_seq varchar2(50) := 'select ' || 'IBU_WF_ITEM_KEY_S' || '.nextval from dual';
1629: mailAttrVals Wf_Engine.TextTabTyp ;
1630: begin
1631: /* Get schema name */
1632: select user into l_user from dual;
1633:
1634: /* Get sequence for item key to be unique */
1635: /* select count(*) into cnt from all_objects
1636: where object_name like 'IBU_SR_NOTIFICATION_S'