DBA Data[Home] [Help]

APPS.AHL_PRD_NONROUTINE_PVT dependencies on CS_SERVICEREQUEST_PUB

Line 93: p_service_request_rec IN CS_SERVICEREQUEST_PUB.service_request_rec_type,

89: );
90: -- procedure to write the SR API input parameters to log
91: Procedure write_sr_to_log
92: (
93: p_service_request_rec IN CS_SERVICEREQUEST_PUB.service_request_rec_type,
94: p_notes_table IN CS_SERVICEREQUEST_PUB.notes_table,
95: p_contacts_table IN CS_SERVICEREQUEST_PUB.contacts_table
96: );
97:

Line 94: p_notes_table IN CS_SERVICEREQUEST_PUB.notes_table,

90: -- procedure to write the SR API input parameters to log
91: Procedure write_sr_to_log
92: (
93: p_service_request_rec IN CS_SERVICEREQUEST_PUB.service_request_rec_type,
94: p_notes_table IN CS_SERVICEREQUEST_PUB.notes_table,
95: p_contacts_table IN CS_SERVICEREQUEST_PUB.contacts_table
96: );
97:
98: -- Define global variables here.

Line 95: p_contacts_table IN CS_SERVICEREQUEST_PUB.contacts_table

91: Procedure write_sr_to_log
92: (
93: p_service_request_rec IN CS_SERVICEREQUEST_PUB.service_request_rec_type,
94: p_notes_table IN CS_SERVICEREQUEST_PUB.notes_table,
95: p_contacts_table IN CS_SERVICEREQUEST_PUB.contacts_table
96: );
97:
98: -- Define global variables here.
99: -- SR status id for status PLANNED

Line 2070: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;

2066: p_x_sr_task_rec IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.sr_task_rec_type,
2067: x_return_status OUT NOCOPY VARCHAR2
2068: )IS
2069:
2070: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
2071: l_notes_table CS_ServiceRequest_PUB.notes_table;
2072: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
2073: l_contact_primary_flag CONSTANT VARCHAR2(1) := 'Y';
2074: l_auto_assign CONSTANT VARCHAR2(1) := 'N';

Line 2071: l_notes_table CS_ServiceRequest_PUB.notes_table;

2067: x_return_status OUT NOCOPY VARCHAR2
2068: )IS
2069:
2070: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
2071: l_notes_table CS_ServiceRequest_PUB.notes_table;
2072: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
2073: l_contact_primary_flag CONSTANT VARCHAR2(1) := 'Y';
2074: l_auto_assign CONSTANT VARCHAR2(1) := 'N';
2075:

Line 2072: l_contacts_table CS_ServiceRequest_PUB.contacts_table;

2068: )IS
2069:
2070: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
2071: l_notes_table CS_ServiceRequest_PUB.notes_table;
2072: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
2073: l_contact_primary_flag CONSTANT VARCHAR2(1) := 'Y';
2074: l_auto_assign CONSTANT VARCHAR2(1) := 'N';
2075:
2076: l_msg_count NUMBER;

Line 2125: CS_SERVICEREQUEST_PUB.initialize_rec(l_service_request_rec);

2121:
2122: BEGIN
2123:
2124: -- Initialize the SR record.
2125: CS_SERVICEREQUEST_PUB.initialize_rec(l_service_request_rec);
2126:
2127: get_note_value(p_sr_task_rec => p_x_sr_task_rec,
2128: x_note => l_note,
2129: x_note_detail => l_note_detail);

Line 2229: AHL_DEBUG_PUB.debug('Inputs for CS_SERVICEREQUEST_PUB.Create_ServiceRequest:');

2225: -- Call write to log procedure to log the input parameter
2226: -- values for debug
2227:
2228: IF (G_DEBUG = 'Y') THEN
2229: AHL_DEBUG_PUB.debug('Inputs for CS_SERVICEREQUEST_PUB.Create_ServiceRequest:');
2230: write_sr_to_log(
2231: p_service_request_rec => l_service_request_rec,
2232: p_notes_table => l_notes_table,
2233: p_contacts_table => l_contacts_table

Line 2239: CS_SERVICEREQUEST_PUB.Create_ServiceRequest(

2235: END IF;
2236: */
2237: -- Call to Service Request API
2238:
2239: CS_SERVICEREQUEST_PUB.Create_ServiceRequest(
2240: p_api_version => 3.0,
2241: p_init_msg_list => FND_API.G_TRUE,
2242: p_commit => FND_API.G_FALSE,
2243: x_return_status => x_return_status,

Line 3457: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;

3453: p_x_sr_task_rec IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.sr_task_rec_type,
3454: x_return_status OUT NOCOPY VARCHAR2
3455: ) IS
3456:
3457: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
3458: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
3459: l_notes_table CS_ServiceRequest_PUB.notes_table;
3460: l_contact_primary_flag CONSTANT VARCHAR2(1) := 'Y';
3461:

Line 3458: l_contacts_table CS_ServiceRequest_PUB.contacts_table;

3454: x_return_status OUT NOCOPY VARCHAR2
3455: ) IS
3456:
3457: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
3458: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
3459: l_notes_table CS_ServiceRequest_PUB.notes_table;
3460: l_contact_primary_flag CONSTANT VARCHAR2(1) := 'Y';
3461:
3462: l_msg_count NUMBER;

Line 3459: l_notes_table CS_ServiceRequest_PUB.notes_table;

3455: ) IS
3456:
3457: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
3458: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
3459: l_notes_table CS_ServiceRequest_PUB.notes_table;
3460: l_contact_primary_flag CONSTANT VARCHAR2(1) := 'Y';
3461:
3462: l_msg_count NUMBER;
3463: l_msg_data VARCHAR2(2000);

Line 3468: CS_SERVICEREQUEST_PUB.initialize_rec(l_service_request_rec);

3464:
3465: BEGIN
3466:
3467: -- Initialize the SR record.
3468: CS_SERVICEREQUEST_PUB.initialize_rec(l_service_request_rec);
3469:
3470:
3471: -- Assign the SR rec values
3472: l_service_request_rec.status_id := p_x_sr_task_rec.status_id;

Line 3494: CS_SERVICEREQUEST_PUB.Update_ServiceRequest(

3490: l_contacts_table(1).primary_flag := l_contact_primary_flag;
3491: */
3492:
3493: -- Call to Service Request API
3494: CS_SERVICEREQUEST_PUB.Update_ServiceRequest(
3495: p_api_version => 3.0,
3496: p_init_msg_list => FND_API.G_TRUE,
3497: p_commit => FND_API.G_FALSE,
3498: x_return_status => x_return_status,

Line 3651: p_service_request_rec IN CS_SERVICEREQUEST_PUB.service_request_rec_type,

3647: -- values of the SR API to a log file
3648: -----------------------------------
3649: Procedure write_sr_to_log
3650: (
3651: p_service_request_rec IN CS_SERVICEREQUEST_PUB.service_request_rec_type,
3652: p_notes_table IN CS_SERVICEREQUEST_PUB.notes_table,
3653: p_contacts_table IN CS_SERVICEREQUEST_PUB.contacts_table
3654: )
3655: IS

Line 3652: p_notes_table IN CS_SERVICEREQUEST_PUB.notes_table,

3648: -----------------------------------
3649: Procedure write_sr_to_log
3650: (
3651: p_service_request_rec IN CS_SERVICEREQUEST_PUB.service_request_rec_type,
3652: p_notes_table IN CS_SERVICEREQUEST_PUB.notes_table,
3653: p_contacts_table IN CS_SERVICEREQUEST_PUB.contacts_table
3654: )
3655: IS
3656: BEGIN

Line 3653: p_contacts_table IN CS_SERVICEREQUEST_PUB.contacts_table

3649: Procedure write_sr_to_log
3650: (
3651: p_service_request_rec IN CS_SERVICEREQUEST_PUB.service_request_rec_type,
3652: p_notes_table IN CS_SERVICEREQUEST_PUB.notes_table,
3653: p_contacts_table IN CS_SERVICEREQUEST_PUB.contacts_table
3654: )
3655: IS
3656: BEGIN
3657: AHL_DEBUG_PUB.debug('SR Rec:');