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_SERVICEREQUEST_PUB dependencies on FND_API

Line 21: NOTE VARCHAR2(2000) := FND_API.G_MISS_CHAR,

17: defined in this package appears in the integration repository.
18: ****/
19:
20: TYPE notes_rec IS RECORD (
21: NOTE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
22: NOTE_DETAIL VARCHAR2(32767) := FND_API.G_MISS_CHAR,
23: NOTE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
24: NOTE_CONTEXT_TYPE_01 VARCHAR2(30) := FND_API.G_MISS_CHAR,
25: NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,

Line 22: NOTE_DETAIL VARCHAR2(32767) := FND_API.G_MISS_CHAR,

18: ****/
19:
20: TYPE notes_rec IS RECORD (
21: NOTE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
22: NOTE_DETAIL VARCHAR2(32767) := FND_API.G_MISS_CHAR,
23: NOTE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
24: NOTE_CONTEXT_TYPE_01 VARCHAR2(30) := FND_API.G_MISS_CHAR,
25: NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,
26: NOTE_CONTEXT_TYPE_02 VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 23: NOTE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,

19:
20: TYPE notes_rec IS RECORD (
21: NOTE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
22: NOTE_DETAIL VARCHAR2(32767) := FND_API.G_MISS_CHAR,
23: NOTE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
24: NOTE_CONTEXT_TYPE_01 VARCHAR2(30) := FND_API.G_MISS_CHAR,
25: NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,
26: NOTE_CONTEXT_TYPE_02 VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: NOTE_CONTEXT_TYPE_ID_02 NUMBER := FND_API.G_MISS_NUM,

Line 24: NOTE_CONTEXT_TYPE_01 VARCHAR2(30) := FND_API.G_MISS_CHAR,

20: TYPE notes_rec IS RECORD (
21: NOTE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
22: NOTE_DETAIL VARCHAR2(32767) := FND_API.G_MISS_CHAR,
23: NOTE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
24: NOTE_CONTEXT_TYPE_01 VARCHAR2(30) := FND_API.G_MISS_CHAR,
25: NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,
26: NOTE_CONTEXT_TYPE_02 VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: NOTE_CONTEXT_TYPE_ID_02 NUMBER := FND_API.G_MISS_NUM,
28: NOTE_CONTEXT_TYPE_03 VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 25: NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,

21: NOTE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
22: NOTE_DETAIL VARCHAR2(32767) := FND_API.G_MISS_CHAR,
23: NOTE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
24: NOTE_CONTEXT_TYPE_01 VARCHAR2(30) := FND_API.G_MISS_CHAR,
25: NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,
26: NOTE_CONTEXT_TYPE_02 VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: NOTE_CONTEXT_TYPE_ID_02 NUMBER := FND_API.G_MISS_NUM,
28: NOTE_CONTEXT_TYPE_03 VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: NOTE_CONTEXT_TYPE_ID_03 NUMBER := FND_API.G_MISS_NUM

Line 26: NOTE_CONTEXT_TYPE_02 VARCHAR2(30) := FND_API.G_MISS_CHAR,

22: NOTE_DETAIL VARCHAR2(32767) := FND_API.G_MISS_CHAR,
23: NOTE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
24: NOTE_CONTEXT_TYPE_01 VARCHAR2(30) := FND_API.G_MISS_CHAR,
25: NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,
26: NOTE_CONTEXT_TYPE_02 VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: NOTE_CONTEXT_TYPE_ID_02 NUMBER := FND_API.G_MISS_NUM,
28: NOTE_CONTEXT_TYPE_03 VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: NOTE_CONTEXT_TYPE_ID_03 NUMBER := FND_API.G_MISS_NUM
30:

Line 27: NOTE_CONTEXT_TYPE_ID_02 NUMBER := FND_API.G_MISS_NUM,

23: NOTE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
24: NOTE_CONTEXT_TYPE_01 VARCHAR2(30) := FND_API.G_MISS_CHAR,
25: NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,
26: NOTE_CONTEXT_TYPE_02 VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: NOTE_CONTEXT_TYPE_ID_02 NUMBER := FND_API.G_MISS_NUM,
28: NOTE_CONTEXT_TYPE_03 VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: NOTE_CONTEXT_TYPE_ID_03 NUMBER := FND_API.G_MISS_NUM
30:
31: );

Line 28: NOTE_CONTEXT_TYPE_03 VARCHAR2(30) := FND_API.G_MISS_CHAR,

24: NOTE_CONTEXT_TYPE_01 VARCHAR2(30) := FND_API.G_MISS_CHAR,
25: NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,
26: NOTE_CONTEXT_TYPE_02 VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: NOTE_CONTEXT_TYPE_ID_02 NUMBER := FND_API.G_MISS_NUM,
28: NOTE_CONTEXT_TYPE_03 VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: NOTE_CONTEXT_TYPE_ID_03 NUMBER := FND_API.G_MISS_NUM
30:
31: );
32: TYPE notes_table IS TABLE OF notes_rec INDEX BY BINARY_INTEGER;

Line 29: NOTE_CONTEXT_TYPE_ID_03 NUMBER := FND_API.G_MISS_NUM

25: NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,
26: NOTE_CONTEXT_TYPE_02 VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: NOTE_CONTEXT_TYPE_ID_02 NUMBER := FND_API.G_MISS_NUM,
28: NOTE_CONTEXT_TYPE_03 VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: NOTE_CONTEXT_TYPE_ID_03 NUMBER := FND_API.G_MISS_NUM
30:
31: );
32: TYPE notes_table IS TABLE OF notes_rec INDEX BY BINARY_INTEGER;
33:

Line 73: SR_CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,

69: --This table will hold the contacts and contact information
70: --for a Service Request customer
71: --
72: TYPE contacts_rec IS RECORD (
73: SR_CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
74: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
75: CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
76: CONTACT_POINT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 74: PARTY_ID NUMBER := FND_API.G_MISS_NUM,

70: --for a Service Request customer
71: --
72: TYPE contacts_rec IS RECORD (
73: SR_CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
74: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
75: CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
76: CONTACT_POINT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
78: CONTACT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 75: CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,

71: --
72: TYPE contacts_rec IS RECORD (
73: SR_CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
74: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
75: CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
76: CONTACT_POINT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
78: CONTACT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: party_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 76: CONTACT_POINT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,

72: TYPE contacts_rec IS RECORD (
73: SR_CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
74: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
75: CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
76: CONTACT_POINT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
78: CONTACT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: party_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
80: start_date_active DATE := FND_API.G_MISS_DATE,

Line 77: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

73: SR_CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
74: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
75: CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
76: CONTACT_POINT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
78: CONTACT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: party_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
80: start_date_active DATE := FND_API.G_MISS_DATE,
81: end_date_active DATE := FND_API.G_MISS_DATE

Line 78: CONTACT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,

74: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
75: CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
76: CONTACT_POINT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
78: CONTACT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: party_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
80: start_date_active DATE := FND_API.G_MISS_DATE,
81: end_date_active DATE := FND_API.G_MISS_DATE
82: );

Line 79: party_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

75: CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
76: CONTACT_POINT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
78: CONTACT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: party_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
80: start_date_active DATE := FND_API.G_MISS_DATE,
81: end_date_active DATE := FND_API.G_MISS_DATE
82: );
83:

Line 80: start_date_active DATE := FND_API.G_MISS_DATE,

76: CONTACT_POINT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
78: CONTACT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: party_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
80: start_date_active DATE := FND_API.G_MISS_DATE,
81: end_date_active DATE := FND_API.G_MISS_DATE
82: );
83:
84: TYPE contacts_table IS TABLE OF contacts_rec INDEX BY BINARY_INTEGER;

Line 81: end_date_active DATE := FND_API.G_MISS_DATE

77: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
78: CONTACT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: party_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
80: start_date_active DATE := FND_API.G_MISS_DATE,
81: end_date_active DATE := FND_API.G_MISS_DATE
82: );
83:
84: TYPE contacts_table IS TABLE OF contacts_rec INDEX BY BINARY_INTEGER;
85:

Line 349: project_id NUMBER DEFAULT FND_API.G_MISS_NUM,

345: created_by NUMBER,
346: -- Credit Card 9358401
347: instrument_payment_use_id NUMBER,
348: --create for integration with oracle projects
349: project_id NUMBER DEFAULT FND_API.G_MISS_NUM,
350: project_task_id NUMBER DEFAULT FND_API.G_MISS_NUM,
351: expenditure_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
352: --14004721 . Additional SLA dates
353: sla_date_1 DATE,

Line 350: project_task_id NUMBER DEFAULT FND_API.G_MISS_NUM,

346: -- Credit Card 9358401
347: instrument_payment_use_id NUMBER,
348: --create for integration with oracle projects
349: project_id NUMBER DEFAULT FND_API.G_MISS_NUM,
350: project_task_id NUMBER DEFAULT FND_API.G_MISS_NUM,
351: expenditure_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
352: --14004721 . Additional SLA dates
353: sla_date_1 DATE,
354: sla_date_2 DATE,

Line 351: expenditure_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,

347: instrument_payment_use_id NUMBER,
348: --create for integration with oracle projects
349: project_id NUMBER DEFAULT FND_API.G_MISS_NUM,
350: project_task_id NUMBER DEFAULT FND_API.G_MISS_NUM,
351: expenditure_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
352: --14004721 . Additional SLA dates
353: sla_date_1 DATE,
354: sla_date_2 DATE,
355: sla_date_3 DATE,

Line 801: -- Default = FND_API.G_FALSE

797: --
798: -- Standard IN Parameters:
799: -- p_api_version IN NUMBER Required
800: -- p_init_msg_list IN VARCHAR2 Optional
801: -- Default = FND_API.G_FALSE
802: -- p_commit IN VARCHAR2 Optional
803: -- Default = FND_API.G_FALSE
804: --
805: -- Standard OUT Parameters:

Line 803: -- Default = FND_API.G_FALSE

799: -- p_api_version IN NUMBER Required
800: -- p_init_msg_list IN VARCHAR2 Optional
801: -- Default = FND_API.G_FALSE
802: -- p_commit IN VARCHAR2 Optional
803: -- Default = FND_API.G_FALSE
804: --
805: -- Standard OUT Parameters:
806: -- x_return_status OUT VARCHAR2(1)
807: -- x_msg_count OUT NUMBER

Line 872: -- DEFAULT = FND_API.G_FALSE

868: -- Calls IN parameters:
869: -- p_comments IN VARCHAR2(2000) Optional
870: -- Service request comments or log of the conversation.
871: -- p_public_comment_flag IN VARCHAR2(1) Optional
872: -- DEFAULT = FND_API.G_FALSE
873: -- Indicate whether the service request comment is public (can be
874: -- viewed by anyone).
875: --
876: -- Calls OUT parameters:

Line 955: -- DEFAULT = FND_API.G_TRUE

951: -----------------------------------------------------------------------
952: -- These fields are no longer present in the record type
953: -- verify_request_flag VARCHAR2(1) Required
954: --
955: -- DEFAULT = FND_API.G_TRUE
956: -- Indicate whether the service request is entered in verified
957: -- mode. Must be non-null. If set to TRUE, the API will perform
958: -- validation on the attributes customer_id, employee_id,
959: -- contact_id, bill_to_site_use_id, bill_to_contact_id,

Line 962: -- DEFAULT = FND_API.G_FALSE

958: -- validation on the attributes customer_id, employee_id,
959: -- contact_id, bill_to_site_use_id, bill_to_contact_id,
960: -- ship_to_site_use_id, and ship_to_contact_id.
961: -- filed_by_emp_flag VARCHAR2(1) Required
962: -- DEFAULT = FND_API.G_FALSE
963: -- Indicate that the service request is filed by an employee.
964: -- Must be non-null. It can only be set when the
965: -- verify_request_flag parameter is set.
966: -------------------------------------------------------------------------------------

Line 1199: -- DEFAULT = FND_API.G_FALSE

1195: -- User-visible sales order number of the RMA.
1196: -- order_type_id NUMBER Optional
1197: -- Sales order type of the RMA.
1198: -- web_entry_flag VARCHAR2(1) Required
1199: -- DEFAULT = FND_API.G_FALSE
1200: -- Indicate whether the service request is entered from
1201: -- Self-Service Web Applications. Must be non-null.
1202: --------------------------------------------------------------------------------------
1203: -- request_segment1 VARCHAR2(150) Optional

Line 1398: -- urgency_id = FND_API.G_MISS_NUM and urgency_name = NULL,

1394: --
1395: -- For value-ID conversion, when the ID of an attribute is not
1396: -- passed, and the value of the attribute is passed and the value
1397: -- is NULL, the ID is converted into NULL. For example, if
1398: -- urgency_id = FND_API.G_MISS_NUM and urgency_name = NULL,
1399: -- NULL is inserted into the incident_urgency_id column. This has
1400: -- the effect that urgency ID will not be defaulted from the
1401: -- profile option (since the caller explicitly passed in NULL).
1402: --

Line 1492: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1488: ****/
1489:
1490: PROCEDURE Create_ServiceRequest
1491: ( p_api_version IN NUMBER,
1492: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1493: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1494: x_return_status OUT NOCOPY VARCHAR2,
1495: x_msg_count OUT NOCOPY NUMBER,
1496: x_msg_data OUT NOCOPY VARCHAR2,

Line 1493: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1489:
1490: PROCEDURE Create_ServiceRequest
1491: ( p_api_version IN NUMBER,
1492: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1493: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1494: x_return_status OUT NOCOPY VARCHAR2,
1495: x_msg_count OUT NOCOPY NUMBER,
1496: x_msg_data OUT NOCOPY VARCHAR2,
1497: p_resp_appl_id IN NUMBER := NULL,

Line 1501: p_org_id IN NUMBER := FND_API.G_MISS_NUM,

1497: p_resp_appl_id IN NUMBER := NULL,
1498: p_resp_id IN NUMBER := NULL,
1499: p_user_id IN NUMBER := NULL,
1500: p_login_id IN NUMBER := NULL,
1501: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
1502: p_request_id IN NUMBER := NULL,
1503: p_request_number IN VARCHAR2 := NULL,
1504: p_service_request_rec IN service_request_rec_type,
1505: p_notes IN notes_table,

Line 1535: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1531: -- since several new OUT parameters have been added to the 11.5.9 signature
1532: -- in the form of a new record type, sr_create_out_rec_type
1533: PROCEDURE Create_ServiceRequest
1534: ( p_api_version IN NUMBER,
1535: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1536: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1537: x_return_status OUT NOCOPY VARCHAR2,
1538: x_msg_count OUT NOCOPY NUMBER,
1539: x_msg_data OUT NOCOPY VARCHAR2,

Line 1536: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1532: -- in the form of a new record type, sr_create_out_rec_type
1533: PROCEDURE Create_ServiceRequest
1534: ( p_api_version IN NUMBER,
1535: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1536: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1537: x_return_status OUT NOCOPY VARCHAR2,
1538: x_msg_count OUT NOCOPY NUMBER,
1539: x_msg_data OUT NOCOPY VARCHAR2,
1540: p_resp_appl_id IN NUMBER := NULL,

Line 1700: -- Must be either FND_API.G_TRUE or FND_API.G_FALSE. Used

1696: -- Must be non-null
1697: -----------------------------------------------------------------------
1698: -- These fields are no longer present in the record type
1699: -- verify_request_flag VARCHAR2 Optional
1700: -- Must be either FND_API.G_TRUE or FND_API.G_FALSE. Used
1701: -- to indicate if this is a verified or non-verified request
1702: -----------------------------------------------------------------------------
1703: -- customer_id NUMBER Optional
1704:

Line 1999: -- missing parameter constants defined in the FND_API

1995: -- If both are passed in, request_number will be ignored
1996: --
1997: -- If a field is not to be updated, do not pass in NULL. Either
1998: -- don't pass in the parameter at all, or pass in one of the
1999: -- missing parameter constants defined in the FND_API
2000: -- package(G_MISS_...).
2001: --
2002: -- For all the "flag" parameters, and p_called_by_workflow
2003: -- parameter, pass in the boolean constants defined in the

Line 2004: -- FND_API package (G_TRUE and G_FALSE).

2000: -- package(G_MISS_...).
2001: --
2002: -- For all the "flag" parameters, and p_called_by_workflow
2003: -- parameter, pass in the boolean constants defined in the
2004: -- FND_API package (G_TRUE and G_FALSE).
2005: --
2006: -- Varchar parameters with the maximum length noted above will
2007: -- be truncated if the length of the value being passed in
2008: -- exceeds the maximum allowance, and a warning will be appended

Line 2078: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2074:
2075:
2076: PROCEDURE Update_ServiceRequest(
2077: p_api_version IN NUMBER,
2078: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2079: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2080: x_return_status OUT NOCOPY VARCHAR2,
2081: x_msg_count OUT NOCOPY NUMBER,
2082: x_msg_data OUT NOCOPY VARCHAR2,

Line 2079: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2075:
2076: PROCEDURE Update_ServiceRequest(
2077: p_api_version IN NUMBER,
2078: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2079: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2080: x_return_status OUT NOCOPY VARCHAR2,
2081: x_msg_count OUT NOCOPY NUMBER,
2082: x_msg_data OUT NOCOPY VARCHAR2,
2083: p_request_id IN NUMBER := NULL,

Line 2095: p_called_by_workflow IN VARCHAR2 := FND_API.G_FALSE,

2091: p_last_update_date IN DATE,
2092: p_service_request_rec IN service_request_rec_type,
2093: p_notes IN notes_table,
2094: p_contacts IN contacts_table,
2095: p_called_by_workflow IN VARCHAR2 := FND_API.G_FALSE,
2096: p_workflow_process_id IN NUMBER := NULL,
2097: -- Commented out since these are now part of the out rec type --anmukher--08/08/03
2098: -- x_workflow_process_id OUT NOCOPY NUMBER,
2099: -- x_interaction_id OUT NOCOPY NUMBER,

Line 2118: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2114: -- since several new OUT parameters have been added to the 11.5.9 signature
2115: -- in the form of a new record type, sr_update_out_rec_type
2116: PROCEDURE Update_ServiceRequest(
2117: p_api_version IN NUMBER,
2118: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2119: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2120: x_return_status OUT NOCOPY VARCHAR2,
2121: x_msg_count OUT NOCOPY NUMBER,
2122: x_msg_data OUT NOCOPY VARCHAR2,

Line 2119: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2115: -- in the form of a new record type, sr_update_out_rec_type
2116: PROCEDURE Update_ServiceRequest(
2117: p_api_version IN NUMBER,
2118: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2119: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2120: x_return_status OUT NOCOPY VARCHAR2,
2121: x_msg_count OUT NOCOPY NUMBER,
2122: x_msg_data OUT NOCOPY VARCHAR2,
2123: p_request_id IN NUMBER := NULL,

Line 2135: p_called_by_workflow IN VARCHAR2 := FND_API.G_FALSE,

2131: p_last_update_date IN DATE,
2132: p_service_request_rec IN service_request_rec_type,
2133: p_notes IN notes_table,
2134: p_contacts IN contacts_table,
2135: p_called_by_workflow IN VARCHAR2 := FND_API.G_FALSE,
2136: p_workflow_process_id IN NUMBER := NULL,
2137: p_default_contract_sla_ind IN VARCHAR2 Default 'N',
2138: x_workflow_process_id OUT NOCOPY NUMBER,
2139: x_interaction_id OUT NOCOPY NUMBER

Line 2152: -- Default = FND_API.G_FALSE

2148: --
2149: -- Standard IN Parameters:
2150: -- p_api_version IN NUMBER Required
2151: -- p_init_msg_list IN VARCHAR2 Optional
2152: -- Default = FND_API.G_FALSE
2153: -- p_commit IN VARCHAR2 Optional
2154: -- Default = FND_API.G_FALSE
2155: --
2156: -- Standard OUT Parameters:

Line 2154: -- Default = FND_API.G_FALSE

2150: -- p_api_version IN NUMBER Required
2151: -- p_init_msg_list IN VARCHAR2 Optional
2152: -- Default = FND_API.G_FALSE
2153: -- p_commit IN VARCHAR2 Optional
2154: -- Default = FND_API.G_FALSE
2155: --
2156: -- Standard OUT Parameters:
2157: -- p_return_status OUT VARCHAR2(1)
2158: -- p_msg_count OUT NUMBER

Line 2169: -- Default = FND_API.G_MISS_NUM

2165: -- Default = NULL
2166: -- p_user_id IN NUMBER Optional
2167: -- Default = NULL
2168: -- p_login_id IN NUMBER Optional
2169: -- Default = FND_API.G_MISS_NUM
2170:
2171: ----------------------------------------------------
2172: -- Not in the API
2173: -- p_org_id IN NUMBER Optional

Line 2188: -- Default = FND_API.G_MISS_DATE

2184: -- Default = NULL
2185: -- p_status IN VARCHAR2 Optional
2186: -- Default = NULL
2187: -- p_closed_date IN DATE Optional
2188: -- Default = FND_API.G_MISS_DATE
2189: -- p_audit_comments IN VARCHAR2 Optional
2190: -- Default = NULL
2191: -- Used for the audit record.
2192: -- p_called_by_workflow IN NUMBER Optional

Line 2193: -- Default = FND_API.G_FALSE

2189: -- p_audit_comments IN VARCHAR2 Optional
2190: -- Default = NULL
2191: -- Used for the audit record.
2192: -- p_called_by_workflow IN NUMBER Optional
2193: -- Default = FND_API.G_FALSE
2194: -- Whether or not this API is being called by the active workflow
2195: -- process of the service request.
2196: -- p_workflow_process_id IN NUMBER Optional
2197: -- Default = NULL

Line 2253: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2249: ****/
2250:
2251: PROCEDURE Update_Status
2252: ( p_api_version IN NUMBER,
2253: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2254: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2255: x_return_status OUT NOCOPY VARCHAR2,
2256: x_msg_count OUT NOCOPY NUMBER,
2257: x_msg_data OUT NOCOPY VARCHAR2,

Line 2254: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2250:
2251: PROCEDURE Update_Status
2252: ( p_api_version IN NUMBER,
2253: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2254: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2255: x_return_status OUT NOCOPY VARCHAR2,
2256: x_msg_count OUT NOCOPY NUMBER,
2257: x_msg_data OUT NOCOPY VARCHAR2,
2258: p_resp_appl_id IN NUMBER := NULL,

Line 2261: p_login_id IN NUMBER := FND_API.G_MISS_NUM,

2257: x_msg_data OUT NOCOPY VARCHAR2,
2258: p_resp_appl_id IN NUMBER := NULL,
2259: p_resp_id IN NUMBER := NULL,
2260: p_user_id IN NUMBER := NULL,
2261: p_login_id IN NUMBER := FND_API.G_MISS_NUM,
2262: p_request_id IN NUMBER := NULL,
2263: p_request_number IN VARCHAR2 := NULL,
2264: p_object_version_number IN NUMBER,
2265: p_status_id IN NUMBER := NULL,

Line 2267: p_closed_date IN DATE := FND_API.G_MISS_DATE,

2263: p_request_number IN VARCHAR2 := NULL,
2264: p_object_version_number IN NUMBER,
2265: p_status_id IN NUMBER := NULL,
2266: p_status IN VARCHAR2 := NULL,
2267: p_closed_date IN DATE := FND_API.G_MISS_DATE,
2268: p_audit_comments IN VARCHAR2 := NULL,
2269: p_called_by_workflow IN VARCHAR2 := FND_API.G_FALSE,
2270: p_workflow_process_id IN NUMBER := NULL,
2271: p_comments IN VARCHAR2 := NULL,

Line 2269: p_called_by_workflow IN VARCHAR2 := FND_API.G_FALSE,

2265: p_status_id IN NUMBER := NULL,
2266: p_status IN VARCHAR2 := NULL,
2267: p_closed_date IN DATE := FND_API.G_MISS_DATE,
2268: p_audit_comments IN VARCHAR2 := NULL,
2269: p_called_by_workflow IN VARCHAR2 := FND_API.G_FALSE,
2270: p_workflow_process_id IN NUMBER := NULL,
2271: p_comments IN VARCHAR2 := NULL,
2272: p_public_comment_flag IN VARCHAR2 := FND_API.G_FALSE,
2273: p_validate_sr_closure IN VARCHAR2 Default 'N',

Line 2272: p_public_comment_flag IN VARCHAR2 := FND_API.G_FALSE,

2268: p_audit_comments IN VARCHAR2 := NULL,
2269: p_called_by_workflow IN VARCHAR2 := FND_API.G_FALSE,
2270: p_workflow_process_id IN NUMBER := NULL,
2271: p_comments IN VARCHAR2 := NULL,
2272: p_public_comment_flag IN VARCHAR2 := FND_API.G_FALSE,
2273: p_validate_sr_closure IN VARCHAR2 Default 'N',
2274: p_auto_close_child_entities IN VARCHAR2 Default 'N',
2275: --Add p_auto_generate_tasks for 12.2-Auto Task creation
2276: p_auto_generate_tasks IN VARCHAR2 Default 'N',

Line 2290: -- Default = FND_API.G_FALSE

2286: --
2287: -- Standard IN Parameters:
2288: -- p_api_version IN NUMBER Required
2289: -- p_init_msg_list IN VARCHAR2 Optional
2290: -- Default = FND_API.G_FALSE
2291: -- p_commit IN VARCHAR2 Optional
2292: -- Default = FND_API.G_FALSE
2293: --
2294: -- Standard OUT Parameters:

Line 2292: -- Default = FND_API.G_FALSE

2288: -- p_api_version IN NUMBER Required
2289: -- p_init_msg_list IN VARCHAR2 Optional
2290: -- Default = FND_API.G_FALSE
2291: -- p_commit IN VARCHAR2 Optional
2292: -- Default = FND_API.G_FALSE
2293: --
2294: -- Standard OUT Parameters:
2295: -- p_return_status OUT VARCHAR2(1)
2296: -- p_msg_count OUT NUMBER

Line 2307: -- Default = FND_API.G_MISS_NUM

2303: -- Default = NULL
2304: -- p_user_id IN NUMBER Optional
2305: -- Default = NULL
2306: -- p_login_id IN NUMBER Optional
2307: -- Default = FND_API.G_MISS_NUM
2308:
2309: ---------------------------------------------------
2310: -- Not in the API
2311: -- p_org_id IN NUMBER Optional

Line 2351: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2347: -- -------------------------------------------------------------------
2348:
2349: PROCEDURE Update_Severity
2350: ( p_api_version IN NUMBER,
2351: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2352: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2353: x_return_status OUT NOCOPY VARCHAR2,
2354: x_msg_count OUT NOCOPY NUMBER,
2355: x_msg_data OUT NOCOPY VARCHAR2,

Line 2352: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2348:
2349: PROCEDURE Update_Severity
2350: ( p_api_version IN NUMBER,
2351: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2352: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2353: x_return_status OUT NOCOPY VARCHAR2,
2354: x_msg_count OUT NOCOPY NUMBER,
2355: x_msg_data OUT NOCOPY VARCHAR2,
2356: p_resp_appl_id IN NUMBER := NULL,

Line 2359: p_login_id IN NUMBER := FND_API.G_MISS_NUM,

2355: x_msg_data OUT NOCOPY VARCHAR2,
2356: p_resp_appl_id IN NUMBER := NULL,
2357: p_resp_id IN NUMBER := NULL,
2358: p_user_id IN NUMBER := NULL,
2359: p_login_id IN NUMBER := FND_API.G_MISS_NUM,
2360: p_request_id IN NUMBER := NULL,
2361: p_request_number IN VARCHAR2 := NULL,
2362: p_object_version_number IN NUMBER,
2363: p_severity_id IN NUMBER := NULL,

Line 2367: p_public_comment_flag IN VARCHAR2 := FND_API.G_FALSE,

2363: p_severity_id IN NUMBER := NULL,
2364: p_severity IN VARCHAR2 := NULL,
2365: p_audit_comments IN VARCHAR2 := NULL,
2366: p_comments IN VARCHAR2 := NULL,
2367: p_public_comment_flag IN VARCHAR2 := FND_API.G_FALSE,
2368: x_interaction_id OUT NOCOPY NUMBER
2369: );
2370:
2371: -- -------------------------------------------------------------------

Line 2381: -- Default = FND_API.G_FALSE

2377: --
2378: -- Standard IN Parameters:
2379: -- p_api_version IN NUMBER Required
2380: -- p_init_msg_list IN VARCHAR2 Optional
2381: -- Default = FND_API.G_FALSE
2382: -- p_commit IN VARCHAR2 Optional
2383: -- Default = FND_API.G_FALSE
2384: --
2385: -- Standard OUT Parameters:

Line 2383: -- Default = FND_API.G_FALSE

2379: -- p_api_version IN NUMBER Required
2380: -- p_init_msg_list IN VARCHAR2 Optional
2381: -- Default = FND_API.G_FALSE
2382: -- p_commit IN VARCHAR2 Optional
2383: -- Default = FND_API.G_FALSE
2384: --
2385: -- Standard OUT Parameters:
2386: -- p_return_status OUT VARCHAR2(1)
2387: -- p_msg_count OUT NUMBER

Line 2398: -- Default = FND_API.G_MISS_NUM

2394: -- Default = NULL
2395: -- p_user_id IN NUMBER Optional
2396: -- Default = NULL
2397: -- p_login_id IN NUMBER Optional
2398: -- Default = FND_API.G_MISS_NUM
2399:
2400: ----------------------------------------------
2401: -- Not in the API
2402:

Line 2412: -- Default = FND_API.G_MISS_NUM

2408: -- Default = NULL
2409: -- p_request_number IN VARCHAR2 Optional
2410: -- Default = NULL
2411: -- p_urgency_id IN NUMBER Optional
2412: -- Default = FND_API.G_MISS_NUM
2413: -- p_urgency IN VARCHAR2 Optional
2414: -- Default = FND_API.G_MISS_CHAR
2415: -- p_audit_comments IN VARCHAR2 Optional
2416: -- Default = NULL

Line 2414: -- Default = FND_API.G_MISS_CHAR

2410: -- Default = NULL
2411: -- p_urgency_id IN NUMBER Optional
2412: -- Default = FND_API.G_MISS_NUM
2413: -- p_urgency IN VARCHAR2 Optional
2414: -- Default = FND_API.G_MISS_CHAR
2415: -- p_audit_comments IN VARCHAR2 Optional
2416: -- Default = NULL
2417: -- Used for the audit record.
2418: --

Line 2443: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2439: -- -------------------------------------------------------------------
2440:
2441: PROCEDURE Update_Urgency
2442: ( p_api_version IN NUMBER,
2443: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2444: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2445: x_return_status OUT NOCOPY VARCHAR2,
2446: x_msg_count OUT NOCOPY NUMBER,
2447: x_msg_data OUT NOCOPY VARCHAR2,

Line 2444: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2440:
2441: PROCEDURE Update_Urgency
2442: ( p_api_version IN NUMBER,
2443: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2444: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2445: x_return_status OUT NOCOPY VARCHAR2,
2446: x_msg_count OUT NOCOPY NUMBER,
2447: x_msg_data OUT NOCOPY VARCHAR2,
2448: p_resp_appl_id IN NUMBER := NULL,

Line 2451: p_login_id IN NUMBER := FND_API.G_MISS_NUM,

2447: x_msg_data OUT NOCOPY VARCHAR2,
2448: p_resp_appl_id IN NUMBER := NULL,
2449: p_resp_id IN NUMBER := NULL,
2450: p_user_id IN NUMBER := NULL,
2451: p_login_id IN NUMBER := FND_API.G_MISS_NUM,
2452: p_request_id IN NUMBER := NULL,
2453: p_request_number IN VARCHAR2 := NULL,
2454: p_object_version_number IN NUMBER,
2455: p_urgency_id IN NUMBER := FND_API.G_MISS_NUM,

Line 2455: p_urgency_id IN NUMBER := FND_API.G_MISS_NUM,

2451: p_login_id IN NUMBER := FND_API.G_MISS_NUM,
2452: p_request_id IN NUMBER := NULL,
2453: p_request_number IN VARCHAR2 := NULL,
2454: p_object_version_number IN NUMBER,
2455: p_urgency_id IN NUMBER := FND_API.G_MISS_NUM,
2456: p_urgency IN VARCHAR2 := FND_API.G_MISS_CHAR,
2457: p_audit_comments IN VARCHAR2 := NULL,
2458: p_comments IN VARCHAR2 := NULL,
2459: p_public_comment_flag IN VARCHAR2 := FND_API.G_FALSE,

Line 2456: p_urgency IN VARCHAR2 := FND_API.G_MISS_CHAR,

2452: p_request_id IN NUMBER := NULL,
2453: p_request_number IN VARCHAR2 := NULL,
2454: p_object_version_number IN NUMBER,
2455: p_urgency_id IN NUMBER := FND_API.G_MISS_NUM,
2456: p_urgency IN VARCHAR2 := FND_API.G_MISS_CHAR,
2457: p_audit_comments IN VARCHAR2 := NULL,
2458: p_comments IN VARCHAR2 := NULL,
2459: p_public_comment_flag IN VARCHAR2 := FND_API.G_FALSE,
2460: x_interaction_id OUT NOCOPY NUMBER

Line 2459: p_public_comment_flag IN VARCHAR2 := FND_API.G_FALSE,

2455: p_urgency_id IN NUMBER := FND_API.G_MISS_NUM,
2456: p_urgency IN VARCHAR2 := FND_API.G_MISS_CHAR,
2457: p_audit_comments IN VARCHAR2 := NULL,
2458: p_comments IN VARCHAR2 := NULL,
2459: p_public_comment_flag IN VARCHAR2 := FND_API.G_FALSE,
2460: x_interaction_id OUT NOCOPY NUMBER
2461: );
2462:
2463:

Line 2475: -- Default = FND_API.G_FALSE

2471: --
2472: -- Standard IN Parameters:
2473: -- p_api_version IN NUMBER Required
2474: -- p_init_msg_list IN VARCHAR2 Optional
2475: -- Default = FND_API.G_FALSE
2476: -- p_commit IN VARCHAR2 Optional
2477: -- Default = FND_API.G_FALSE
2478: --
2479: -- Standard OUT Parameters:

Line 2477: -- Default = FND_API.G_FALSE

2473: -- p_api_version IN NUMBER Required
2474: -- p_init_msg_list IN VARCHAR2 Optional
2475: -- Default = FND_API.G_FALSE
2476: -- p_commit IN VARCHAR2 Optional
2477: -- Default = FND_API.G_FALSE
2478: --
2479: -- Standard OUT Parameters:
2480: -- p_return_status OUT VARCHAR2(1)
2481: -- p_msg_count OUT NUMBER

Line 2492: -- Default = FND_API.G_MISS_NUM

2488: -- Default = NULL
2489: -- p_user_id IN NUMBER Optional
2490: -- Default = NULL
2491: -- p_login_id IN NUMBER Optional
2492: -- Default = FND_API.G_MISS_NUM
2493:
2494: -----------------------------------------
2495: -- Not in the API
2496: -- p_org_id IN NUMBER Optional

Line 2510: -- Default = FND_API.G_FALSE

2506: -- p_audit_comments IN VARCHAR2 Optional
2507: -- Default = NULL
2508: -- Used for the audit record.
2509: -- p_called_by_workflow IN NUMBER Optional
2510: -- Default = FND_API.G_FALSE
2511: -- Whether or not this API is being called by the active workflow
2512: -- process of the service request.
2513: -- p_workflow_process_id IN NUMBER Optional
2514: -- Default = NULL

Line 2560: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2556: ****/
2557:
2558: PROCEDURE Update_Owner
2559: ( p_api_version IN NUMBER,
2560: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2561: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2562: x_return_status OUT NOCOPY VARCHAR2,
2563: x_msg_count OUT NOCOPY NUMBER,
2564: x_msg_data OUT NOCOPY VARCHAR2,

Line 2561: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2557:
2558: PROCEDURE Update_Owner
2559: ( p_api_version IN NUMBER,
2560: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2561: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2562: x_return_status OUT NOCOPY VARCHAR2,
2563: x_msg_count OUT NOCOPY NUMBER,
2564: x_msg_data OUT NOCOPY VARCHAR2,
2565: p_resp_appl_id IN NUMBER := NULL,

Line 2568: p_login_id IN NUMBER := FND_API.G_MISS_NUM,

2564: x_msg_data OUT NOCOPY VARCHAR2,
2565: p_resp_appl_id IN NUMBER := NULL,
2566: p_resp_id IN NUMBER := NULL,
2567: p_user_id IN NUMBER := NULL,
2568: p_login_id IN NUMBER := FND_API.G_MISS_NUM,
2569: p_request_id IN NUMBER := NULL,
2570: p_request_number IN VARCHAR2 := NULL,
2571: p_object_version_number IN NUMBER,
2572: p_owner_id IN NUMBER,

Line 2576: p_called_by_workflow IN VARCHAR2 := FND_API.G_FALSE,

2572: p_owner_id IN NUMBER,
2573: p_owner_group_id IN NUMBER,
2574: p_resource_type IN VARCHAR2,
2575: p_audit_comments IN VARCHAR2 := NULL,
2576: p_called_by_workflow IN VARCHAR2 := FND_API.G_FALSE,
2577: p_workflow_process_id IN NUMBER := NULL,
2578: p_comments IN VARCHAR2 := NULL,
2579: p_public_comment_flag IN VARCHAR2 := FND_API.G_FALSE,
2580: x_interaction_id OUT NOCOPY NUMBER

Line 2579: p_public_comment_flag IN VARCHAR2 := FND_API.G_FALSE,

2575: p_audit_comments IN VARCHAR2 := NULL,
2576: p_called_by_workflow IN VARCHAR2 := FND_API.G_FALSE,
2577: p_workflow_process_id IN NUMBER := NULL,
2578: p_comments IN VARCHAR2 := NULL,
2579: p_public_comment_flag IN VARCHAR2 := FND_API.G_FALSE,
2580: x_interaction_id OUT NOCOPY NUMBER
2581: );
2582:
2583: -- -------------------------------------------------------------------

Line 2593: -- Default = FND_API.G_FALSE

2589: --
2590: -- Standard IN Parameters:
2591: -- p_api_version IN NUMBER Required
2592: -- p_init_msg_list IN VARCHAR2 Optional
2593: -- Default = FND_API.G_FALSE
2594: -- p_commit IN VARCHAR2 Optional
2595: -- Default = FND_API.G_FALSE
2596: --
2597: -- Standard OUT Parameters:

Line 2595: -- Default = FND_API.G_FALSE

2591: -- p_api_version IN NUMBER Required
2592: -- p_init_msg_list IN VARCHAR2 Optional
2593: -- Default = FND_API.G_FALSE
2594: -- p_commit IN VARCHAR2 Optional
2595: -- Default = FND_API.G_FALSE
2596: --
2597: -- Standard OUT Parameters:
2598: -- p_return_status OUT VARCHAR2(1)
2599: -- p_msg_count OUT NUMBER

Line 2610: -- Default = FND_API.G_MISS_NUM

2606: -- Default = NULL
2607: -- p_user_id IN NUMBER Optional
2608: -- Default = NULL
2609: -- p_login_id IN NUMBER Optional
2610: -- Default = FND_API.G_MISS_NUM
2611:
2612: ---------------------------------
2613: -- Not in API
2614: -- p_org_id IN NUMBER Optional

Line 2647: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2643: -- -------------------------------------------------------------------
2644:
2645: PROCEDURE Update_Problem_Code
2646: ( p_api_version IN NUMBER,
2647: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2648: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2649: x_return_status OUT NOCOPY VARCHAR2,
2650: x_msg_count OUT NOCOPY NUMBER,
2651: x_msg_data OUT NOCOPY VARCHAR2,

Line 2648: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2644:
2645: PROCEDURE Update_Problem_Code
2646: ( p_api_version IN NUMBER,
2647: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2648: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2649: x_return_status OUT NOCOPY VARCHAR2,
2650: x_msg_count OUT NOCOPY NUMBER,
2651: x_msg_data OUT NOCOPY VARCHAR2,
2652: p_resp_appl_id IN NUMBER := NULL,

Line 2655: p_login_id IN NUMBER := FND_API.G_MISS_NUM,

2651: x_msg_data OUT NOCOPY VARCHAR2,
2652: p_resp_appl_id IN NUMBER := NULL,
2653: p_resp_id IN NUMBER := NULL,
2654: p_user_id IN NUMBER := NULL,
2655: p_login_id IN NUMBER := FND_API.G_MISS_NUM,
2656: p_request_id IN NUMBER := NULL,
2657: p_request_number IN VARCHAR2 := NULL,
2658: p_object_version_number IN NUMBER,
2659: p_problem_code IN VARCHAR2,

Line 2661: p_public_comment_flag IN VARCHAR2 := FND_API.G_FALSE,

2657: p_request_number IN VARCHAR2 := NULL,
2658: p_object_version_number IN NUMBER,
2659: p_problem_code IN VARCHAR2,
2660: p_comments IN VARCHAR2 := NULL,
2661: p_public_comment_flag IN VARCHAR2 := FND_API.G_FALSE,
2662: x_interaction_id OUT NOCOPY NUMBER
2663: );
2664:
2665:

Line 2678: -- Default = FND_API.G_FALSE

2674: -- Parameters :
2675: -- IN :
2676: -- p_api_version IN NUMBER Required
2677: -- p_init_msg_list IN VARCHAR2(1) Optional
2678: -- Default = FND_API.G_FALSE
2679: -- p_commit IN VARCHAR2(1) Optional
2680: -- Default = FND_API.G_FALSE
2681: -- p_request_id IN NUMBER Required
2682: -- p_statement_id IN NUMBER Required

Line 2680: -- Default = FND_API.G_FALSE

2676: -- p_api_version IN NUMBER Required
2677: -- p_init_msg_list IN VARCHAR2(1) Optional
2678: -- Default = FND_API.G_FALSE
2679: -- p_commit IN VARCHAR2(1) Optional
2680: -- Default = FND_API.G_FALSE
2681: -- p_request_id IN NUMBER Required
2682: -- p_statement_id IN NUMBER Required
2683: -- p_is_statement_true IN BOOLEAN Required
2684: --

Line 2701: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2697:
2698: PROCEDURE Link_KB_Statement
2699: (
2700: p_api_version IN NUMBER,
2701: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2702: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2703: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2704: x_return_status OUT NOCOPY VARCHAR2,
2705: x_msg_count OUT NOCOPY NUMBER,

Line 2702: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2698: PROCEDURE Link_KB_Statement
2699: (
2700: p_api_version IN NUMBER,
2701: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2702: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2703: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2704: x_return_status OUT NOCOPY VARCHAR2,
2705: x_msg_count OUT NOCOPY NUMBER,
2706: x_msg_data OUT NOCOPY VARCHAR2,

Line 2703: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2699: (
2700: p_api_version IN NUMBER,
2701: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2702: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2703: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2704: x_return_status OUT NOCOPY VARCHAR2,
2705: x_msg_count OUT NOCOPY NUMBER,
2706: x_msg_data OUT NOCOPY VARCHAR2,
2707: p_request_id IN NUMBER,

Line 2724: -- Default = FND_API.G_FALSE

2720: -- Parameters :
2721: -- IN :
2722: -- p_api_version IN NUMBER Required
2723: -- p_init_msg_list IN VARCHAR2(1) Optional
2724: -- Default = FND_API.G_FALSE
2725: -- p_commit IN VARCHAR2(1) Optional
2726: -- Default = FND_API.G_FALSE
2727: -- p_request_id IN NUMBER Required
2728: -- p_solution_id IN NUMBER Required

Line 2726: -- Default = FND_API.G_FALSE

2722: -- p_api_version IN NUMBER Required
2723: -- p_init_msg_list IN VARCHAR2(1) Optional
2724: -- Default = FND_API.G_FALSE
2725: -- p_commit IN VARCHAR2(1) Optional
2726: -- Default = FND_API.G_FALSE
2727: -- p_request_id IN NUMBER Required
2728: -- p_solution_id IN NUMBER Required
2729: -- p_is_solution_true IN BOOLEAN Required
2730: --

Line 2765: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2761:
2762: PROCEDURE Link_KB_Solution
2763: (
2764: p_api_version IN NUMBER,
2765: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2766: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2767: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2768: x_return_status OUT NOCOPY VARCHAR2,
2769: x_msg_count OUT NOCOPY NUMBER,

Line 2766: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2762: PROCEDURE Link_KB_Solution
2763: (
2764: p_api_version IN NUMBER,
2765: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2766: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2767: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2768: x_return_status OUT NOCOPY VARCHAR2,
2769: x_msg_count OUT NOCOPY NUMBER,
2770: x_msg_data OUT NOCOPY VARCHAR2,

Line 2767: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2763: (
2764: p_api_version IN NUMBER,
2765: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2766: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2767: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2768: x_return_status OUT NOCOPY VARCHAR2,
2769: x_msg_count OUT NOCOPY NUMBER,
2770: x_msg_data OUT NOCOPY VARCHAR2,
2771: p_request_id IN NUMBER,

Line 2786: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2782: as 3.0*/
2783:
2784: PROCEDURE Create_ServiceRequest
2785: ( p_api_version IN NUMBER,
2786: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2787: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2788: x_return_status OUT NOCOPY VARCHAR2,
2789: x_msg_count OUT NOCOPY NUMBER,
2790: x_msg_data OUT NOCOPY VARCHAR2,

Line 2787: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2783:
2784: PROCEDURE Create_ServiceRequest
2785: ( p_api_version IN NUMBER,
2786: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2787: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2788: x_return_status OUT NOCOPY VARCHAR2,
2789: x_msg_count OUT NOCOPY NUMBER,
2790: x_msg_data OUT NOCOPY VARCHAR2,
2791: p_resp_appl_id IN NUMBER := NULL,