DBA Data[Home] [Help]

APPS.AHL_PRD_NONROUTINE_PVT dependencies on CS_SERVICEREQUEST_PUB

Line 77: p_service_request_rec IN CS_SERVICEREQUEST_PUB.service_request_rec_type,

73: );
74: -- procedure to write the SR API input parameters to log
75: Procedure write_sr_to_log
76: (
77: p_service_request_rec IN CS_SERVICEREQUEST_PUB.service_request_rec_type,
78: p_notes_table IN CS_SERVICEREQUEST_PUB.notes_table,
79: p_contacts_table IN CS_SERVICEREQUEST_PUB.contacts_table
80: );
81:

Line 78: p_notes_table IN CS_SERVICEREQUEST_PUB.notes_table,

74: -- procedure to write the SR API input parameters to log
75: Procedure write_sr_to_log
76: (
77: p_service_request_rec IN CS_SERVICEREQUEST_PUB.service_request_rec_type,
78: p_notes_table IN CS_SERVICEREQUEST_PUB.notes_table,
79: p_contacts_table IN CS_SERVICEREQUEST_PUB.contacts_table
80: );
81:
82: -- Define global variables here.

Line 79: p_contacts_table IN CS_SERVICEREQUEST_PUB.contacts_table

75: Procedure write_sr_to_log
76: (
77: p_service_request_rec IN CS_SERVICEREQUEST_PUB.service_request_rec_type,
78: p_notes_table IN CS_SERVICEREQUEST_PUB.notes_table,
79: p_contacts_table IN CS_SERVICEREQUEST_PUB.contacts_table
80: );
81:
82: -- Define global variables here.
83: -- SR status id for status PLANNED

Line 1884: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;

1880: p_x_sr_task_rec IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.sr_task_rec_type,
1881: x_return_status OUT NOCOPY VARCHAR2
1882: )IS
1883:
1884: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
1885: l_notes_table CS_ServiceRequest_PUB.notes_table;
1886: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
1887: l_contact_primary_flag CONSTANT VARCHAR2(1) := 'Y';
1888: l_auto_assign CONSTANT VARCHAR2(1) := 'N';

Line 1885: l_notes_table CS_ServiceRequest_PUB.notes_table;

1881: x_return_status OUT NOCOPY VARCHAR2
1882: )IS
1883:
1884: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
1885: l_notes_table CS_ServiceRequest_PUB.notes_table;
1886: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
1887: l_contact_primary_flag CONSTANT VARCHAR2(1) := 'Y';
1888: l_auto_assign CONSTANT VARCHAR2(1) := 'N';
1889:

Line 1886: l_contacts_table CS_ServiceRequest_PUB.contacts_table;

1882: )IS
1883:
1884: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
1885: l_notes_table CS_ServiceRequest_PUB.notes_table;
1886: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
1887: l_contact_primary_flag CONSTANT VARCHAR2(1) := 'Y';
1888: l_auto_assign CONSTANT VARCHAR2(1) := 'N';
1889:
1890: l_msg_count NUMBER;

Line 1926: CS_SERVICEREQUEST_PUB.initialize_rec(l_service_request_rec);

1922: -- END Changes
1923: BEGIN
1924:
1925: -- Initialize the SR record.
1926: CS_SERVICEREQUEST_PUB.initialize_rec(l_service_request_rec);
1927:
1928: get_note_value(p_sr_task_rec => p_x_sr_task_rec,
1929: x_note => l_note,
1930: x_note_detail => l_note_detail);

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

1983: -- Call write to log procedure to log the input parameter
1984: -- values for debug
1985:
1986: IF (G_DEBUG = 'Y') THEN
1987: AHL_DEBUG_PUB.debug('Inputs for CS_SERVICEREQUEST_PUB.Create_ServiceRequest:');
1988: write_sr_to_log(
1989: p_service_request_rec => l_service_request_rec,
1990: p_notes_table => l_notes_table,
1991: p_contacts_table => l_contacts_table

Line 1997: CS_SERVICEREQUEST_PUB.Create_ServiceRequest(

1993: END IF;
1994: */
1995: -- Call to Service Request API
1996:
1997: CS_SERVICEREQUEST_PUB.Create_ServiceRequest(
1998: p_api_version => 3.0,
1999: p_init_msg_list => FND_API.G_TRUE,
2000: p_commit => FND_API.G_FALSE,
2001: x_return_status => x_return_status,

Line 2792: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;

2788: p_x_sr_task_rec IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.sr_task_rec_type,
2789: x_return_status OUT NOCOPY VARCHAR2
2790: ) IS
2791:
2792: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
2793: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
2794: l_notes_table CS_ServiceRequest_PUB.notes_table;
2795: l_contact_primary_flag CONSTANT VARCHAR2(1) := 'Y';
2796:

Line 2793: l_contacts_table CS_ServiceRequest_PUB.contacts_table;

2789: x_return_status OUT NOCOPY VARCHAR2
2790: ) IS
2791:
2792: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
2793: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
2794: l_notes_table CS_ServiceRequest_PUB.notes_table;
2795: l_contact_primary_flag CONSTANT VARCHAR2(1) := 'Y';
2796:
2797: l_msg_count NUMBER;

Line 2794: l_notes_table CS_ServiceRequest_PUB.notes_table;

2790: ) IS
2791:
2792: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
2793: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
2794: l_notes_table CS_ServiceRequest_PUB.notes_table;
2795: l_contact_primary_flag CONSTANT VARCHAR2(1) := 'Y';
2796:
2797: l_msg_count NUMBER;
2798: l_msg_data VARCHAR2(2000);

Line 2803: CS_SERVICEREQUEST_PUB.initialize_rec(l_service_request_rec);

2799:
2800: BEGIN
2801:
2802: -- Initialize the SR record.
2803: CS_SERVICEREQUEST_PUB.initialize_rec(l_service_request_rec);
2804:
2805:
2806: -- Assign the SR rec values
2807: l_service_request_rec.status_id := p_x_sr_task_rec.status_id;

Line 2829: CS_SERVICEREQUEST_PUB.Update_ServiceRequest(

2825: l_contacts_table(1).primary_flag := l_contact_primary_flag;
2826: */
2827:
2828: -- Call to Service Request API
2829: CS_SERVICEREQUEST_PUB.Update_ServiceRequest(
2830: p_api_version => 3.0,
2831: p_init_msg_list => FND_API.G_TRUE,
2832: p_commit => FND_API.G_FALSE,
2833: x_return_status => x_return_status,

Line 2985: p_service_request_rec IN CS_SERVICEREQUEST_PUB.service_request_rec_type,

2981: -- values of the SR API to a log file
2982: -----------------------------------
2983: Procedure write_sr_to_log
2984: (
2985: p_service_request_rec IN CS_SERVICEREQUEST_PUB.service_request_rec_type,
2986: p_notes_table IN CS_SERVICEREQUEST_PUB.notes_table,
2987: p_contacts_table IN CS_SERVICEREQUEST_PUB.contacts_table
2988: )
2989: IS

Line 2986: p_notes_table IN CS_SERVICEREQUEST_PUB.notes_table,

2982: -----------------------------------
2983: Procedure write_sr_to_log
2984: (
2985: p_service_request_rec IN CS_SERVICEREQUEST_PUB.service_request_rec_type,
2986: p_notes_table IN CS_SERVICEREQUEST_PUB.notes_table,
2987: p_contacts_table IN CS_SERVICEREQUEST_PUB.contacts_table
2988: )
2989: IS
2990: BEGIN

Line 2987: p_contacts_table IN CS_SERVICEREQUEST_PUB.contacts_table

2983: Procedure write_sr_to_log
2984: (
2985: p_service_request_rec IN CS_SERVICEREQUEST_PUB.service_request_rec_type,
2986: p_notes_table IN CS_SERVICEREQUEST_PUB.notes_table,
2987: p_contacts_table IN CS_SERVICEREQUEST_PUB.contacts_table
2988: )
2989: IS
2990: BEGIN
2991: AHL_DEBUG_PUB.debug('SR Rec:');