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.CS_SR_EXTATTRIBUTES_PVT dependencies on CS_SERVICEREQUEST_PUB

Line 50: ,p_ext_attr_tbl IN OUT NOCOPY CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE

46: p_row_identifier IN NUMBER
47: ,p_application_id IN NUMBER
48: ,p_attr_group_type IN VARCHAR2
49: ,p_attr_group_name IN VARCHAR2
50: ,p_ext_attr_tbl IN OUT NOCOPY CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE
51: );
52:
53: FUNCTION IS_ROW_VALID(
54: p_incident_id IN NUMBER

Line 81: ,p_ext_attr_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE

77: p_incident_id IN NUMBER
78: ,p_context IN NUMBER
79: ,p_attr_group_id IN NUMBER
80: ,p_row_id IN NUMBER
81: ,p_ext_attr_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE
82: ,p_sr_audit_rec_table IN OUT NOCOPY Ext_Attr_Audit_Tbl_Type
83: ,x_rec_found OUT NOCOPY VARCHAR2
84: );
85:

Line 94: ,p_ext_attr_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE

90: ,p_party_role_code IN VARCHAR2
91: ,p_context IN VARCHAR2
92: ,p_attr_group_id IN NUMBER
93: ,p_row_id IN NUMBER
94: ,p_ext_attr_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE
95: ,p_sr_audit_rec_table IN OUT NOCOPY Ext_Attr_Audit_Tbl_Type
96: ,x_rec_found OUT NOCOPY VARCHAR2
97: );
98:

Line 113: p_ext_attr_grp_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_GRP_TBL_TYPE

109: PROCEDURE INIT_AUDIT_REC(p_count NUMBER,
110: p_audit_rec IN OUT NOCOPY Ext_Attr_Audit_Tbl_Type);
111:
112: PROCEDURE Log_EXT_PVT_Parameters (
113: p_ext_attr_grp_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_GRP_TBL_TYPE
114: ,p_ext_attr_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE );
115:
116: -- -----------------------------------------------------------------------------
117: -- Procedure Name : Log_EGO_EXT_Parameters

Line 114: ,p_ext_attr_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE );

110: p_audit_rec IN OUT NOCOPY Ext_Attr_Audit_Tbl_Type);
111:
112: PROCEDURE Log_EXT_PVT_Parameters (
113: p_ext_attr_grp_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_GRP_TBL_TYPE
114: ,p_ext_attr_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE );
115:
116: -- -----------------------------------------------------------------------------
117: -- Procedure Name : Log_EGO_EXT_Parameters
118: -- Parameters :

Line 262: ,p_ext_attr_grp_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_GRP_TBL_TYPE

258: p_api_version IN NUMBER
259: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
260: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
261: ,p_incident_id IN NUMBER
262: ,p_ext_attr_grp_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_GRP_TBL_TYPE
263: ,p_ext_attr_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE
264: ,p_modified_by IN NUMBER := FND_GLOBAL.USER_ID
265: ,p_modified_on IN DATE := SYSDATE
266: ,x_failed_row_id_list OUT NOCOPY VARCHAR2

Line 263: ,p_ext_attr_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE

259: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
260: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
261: ,p_incident_id IN NUMBER
262: ,p_ext_attr_grp_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_GRP_TBL_TYPE
263: ,p_ext_attr_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE
264: ,p_modified_by IN NUMBER := FND_GLOBAL.USER_ID
265: ,p_modified_on IN DATE := SYSDATE
266: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
267: ,x_return_status OUT NOCOPY VARCHAR2

Line 283: l_ext_attr_tbl CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE;

279: l_return_status VARCHAR2(1);
280: l_errorcode NUMBER;
281: l_msg_count NUMBER;
282: l_msg_data VARCHAR2(4000);
283: l_ext_attr_tbl CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE;
284: l_application_id NUMBER;
285: l_attr_group_type VARCHAR2(30);
286: l_attr_group_name VARCHAR2(30);
287: l_old_context VARCHAR2(1000);

Line 2025: ,p_ext_attr_tbl IN OUT NOCOPY CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE) IS

2021: p_row_identifier IN NUMBER
2022: ,p_application_id IN NUMBER
2023: ,p_attr_group_type IN VARCHAR2
2024: ,p_attr_group_name IN VARCHAR2
2025: ,p_ext_attr_tbl IN OUT NOCOPY CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE) IS
2026:
2027: CURSOR c_get_attr_cur IS
2028: SELECT database_column, attr_name
2029: FROM ego_attrs_v

Line 2089: ,p_ext_attr_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE

2085: ,p_party_role_code IN VARCHAR2
2086: ,p_context IN VARCHAR2
2087: ,p_attr_group_id IN NUMBER
2088: ,p_row_id IN NUMBER
2089: ,p_ext_attr_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE
2090: ,p_sr_audit_rec_table IN OUT NOCOPY Ext_Attr_Audit_Tbl_Type
2091: ,x_rec_found OUT NOCOPY VARCHAR2
2092: ) IS
2093:

Line 3007: ,p_ext_attr_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE

3003: p_incident_id IN NUMBER
3004: ,p_context IN NUMBER
3005: ,p_attr_group_id IN NUMBER
3006: ,p_row_id IN NUMBER
3007: ,p_ext_attr_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE
3008: ,p_sr_audit_rec_table IN OUT NOCOPY Ext_Attr_Audit_Tbl_Type
3009: ,x_rec_found OUT NOCOPY VARCHAR2
3010: ) IS
3011:

Line 3911: ,x_ext_attr_grp_tbl OUT NOCOPY CS_ServiceRequest_PUB.EXT_ATTR_GRP_TBL_TYPE

3907: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3908: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3909: ,p_incident_id IN NUMBER
3910: ,p_object_name IN VARCHAR2
3911: ,x_ext_attr_grp_tbl OUT NOCOPY CS_ServiceRequest_PUB.EXT_ATTR_GRP_TBL_TYPE
3912: ,x_ext_attr_tbl OUT NOCOPY CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE
3913: ,x_return_status OUT NOCOPY VARCHAR2
3914: ,x_msg_count OUT NOCOPY NUMBER
3915: ,x_msg_data OUT NOCOPY VARCHAR2) IS

Line 3912: ,x_ext_attr_tbl OUT NOCOPY CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE

3908: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3909: ,p_incident_id IN NUMBER
3910: ,p_object_name IN VARCHAR2
3911: ,x_ext_attr_grp_tbl OUT NOCOPY CS_ServiceRequest_PUB.EXT_ATTR_GRP_TBL_TYPE
3912: ,x_ext_attr_tbl OUT NOCOPY CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE
3913: ,x_return_status OUT NOCOPY VARCHAR2
3914: ,x_msg_count OUT NOCOPY NUMBER
3915: ,x_msg_data OUT NOCOPY VARCHAR2) IS
3916:

Line 5094: (p_ext_attr_grp_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_GRP_TBL_TYPE

5090:
5091: END;
5092:
5093: Procedure Merge_Ext_Attrs_Details
5094: (p_ext_attr_grp_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_GRP_TBL_TYPE
5095: ,p_ext_attr_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE
5096: ,x_ext_grp_attr_tbl OUT NOCOPY EXT_GRP_ATTR_TBL_TYPE
5097: ,x_return_status OUT NOCOPY VARCHAR2
5098: ,x_msg_count OUT NOCOPY NUMBER

Line 5095: ,p_ext_attr_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE

5091: END;
5092:
5093: Procedure Merge_Ext_Attrs_Details
5094: (p_ext_attr_grp_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_GRP_TBL_TYPE
5095: ,p_ext_attr_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE
5096: ,x_ext_grp_attr_tbl OUT NOCOPY EXT_GRP_ATTR_TBL_TYPE
5097: ,x_return_status OUT NOCOPY VARCHAR2
5098: ,x_msg_count OUT NOCOPY NUMBER
5099: ,x_msg_data OUT NOCOPY VARCHAR2) IS

Line 6608: p_ext_attr_grp_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_GRP_TBL_TYPE

6604: -- -------- -------- -----------------------------------------------------------
6605: -- 11/08/05 mviswana Created
6606: -- -----------------------------------------------------------------------------
6607: PROCEDURE Log_EXT_PVT_Parameters (
6608: p_ext_attr_grp_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_GRP_TBL_TYPE
6609: ,p_ext_attr_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE )
6610: IS
6611:
6612: l_api_name CONSTANT VARCHAR2(30) := 'Process_SR_Ext_Attrs';

Line 6609: ,p_ext_attr_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE )

6605: -- 11/08/05 mviswana Created
6606: -- -----------------------------------------------------------------------------
6607: PROCEDURE Log_EXT_PVT_Parameters (
6608: p_ext_attr_grp_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_GRP_TBL_TYPE
6609: ,p_ext_attr_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE )
6610: IS
6611:
6612: l_api_name CONSTANT VARCHAR2(30) := 'Process_SR_Ext_Attrs';
6613: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_api_name;