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 580: -- Default = FND_API.G_FALSE

576: --
577: -- Standard IN Parameters:
578: -- p_api_version IN NUMBER Required
579: -- p_init_msg_list IN VARCHAR2 Optional
580: -- Default = FND_API.G_FALSE
581: -- p_commit IN VARCHAR2 Optional
582: -- Default = FND_API.G_FALSE
583: --
584: -- Standard OUT Parameters:

Line 582: -- Default = FND_API.G_FALSE

578: -- p_api_version IN NUMBER Required
579: -- p_init_msg_list IN VARCHAR2 Optional
580: -- Default = FND_API.G_FALSE
581: -- p_commit IN VARCHAR2 Optional
582: -- Default = FND_API.G_FALSE
583: --
584: -- Standard OUT Parameters:
585: -- x_return_status OUT VARCHAR2(1)
586: -- x_msg_count OUT NUMBER

Line 651: -- DEFAULT = FND_API.G_FALSE

647: -- Calls IN parameters:
648: -- p_comments IN VARCHAR2(2000) Optional
649: -- Service request comments or log of the conversation.
650: -- p_public_comment_flag IN VARCHAR2(1) Optional
651: -- DEFAULT = FND_API.G_FALSE
652: -- Indicate whether the service request comment is public (can be
653: -- viewed by anyone).
654: --
655: -- Calls OUT parameters:

Line 734: -- DEFAULT = FND_API.G_TRUE

730: -----------------------------------------------------------------------
731: -- These fields are no longer present in the record type
732: -- verify_request_flag VARCHAR2(1) Required
733: --
734: -- DEFAULT = FND_API.G_TRUE
735: -- Indicate whether the service request is entered in verified
736: -- mode. Must be non-null. If set to TRUE, the API will perform
737: -- validation on the attributes customer_id, employee_id,
738: -- contact_id, bill_to_site_use_id, bill_to_contact_id,

Line 741: -- DEFAULT = FND_API.G_FALSE

737: -- validation on the attributes customer_id, employee_id,
738: -- contact_id, bill_to_site_use_id, bill_to_contact_id,
739: -- ship_to_site_use_id, and ship_to_contact_id.
740: -- filed_by_emp_flag VARCHAR2(1) Required
741: -- DEFAULT = FND_API.G_FALSE
742: -- Indicate that the service request is filed by an employee.
743: -- Must be non-null. It can only be set when the
744: -- verify_request_flag parameter is set.
745: -------------------------------------------------------------------------------------

Line 978: -- DEFAULT = FND_API.G_FALSE

974: -- User-visible sales order number of the RMA.
975: -- order_type_id NUMBER Optional
976: -- Sales order type of the RMA.
977: -- web_entry_flag VARCHAR2(1) Required
978: -- DEFAULT = FND_API.G_FALSE
979: -- Indicate whether the service request is entered from
980: -- Self-Service Web Applications. Must be non-null.
981: --------------------------------------------------------------------------------------
982: -- request_segment1 VARCHAR2(150) Optional

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

1173: --
1174: -- For value-ID conversion, when the ID of an attribute is not
1175: -- passed, and the value of the attribute is passed and the value
1176: -- is NULL, the ID is converted into NULL. For example, if
1177: -- urgency_id = FND_API.G_MISS_NUM and urgency_name = NULL,
1178: -- NULL is inserted into the incident_urgency_id column. This has
1179: -- the effect that urgency ID will not be defaulted from the
1180: -- profile option (since the caller explicitly passed in NULL).
1181: --

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

1267: ****/
1268:
1269: PROCEDURE Create_ServiceRequest
1270: ( p_api_version IN NUMBER,
1271: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1272: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1273: x_return_status OUT NOCOPY VARCHAR2,
1274: x_msg_count OUT NOCOPY NUMBER,
1275: x_msg_data OUT NOCOPY VARCHAR2,

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

1268:
1269: PROCEDURE Create_ServiceRequest
1270: ( p_api_version IN NUMBER,
1271: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1272: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1273: x_return_status OUT NOCOPY VARCHAR2,
1274: x_msg_count OUT NOCOPY NUMBER,
1275: x_msg_data OUT NOCOPY VARCHAR2,
1276: p_resp_appl_id IN NUMBER := NULL,

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

1310: -- since several new OUT parameters have been added to the 11.5.9 signature
1311: -- in the form of a new record type, sr_create_out_rec_type
1312: PROCEDURE Create_ServiceRequest
1313: ( p_api_version IN NUMBER,
1314: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1315: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1316: x_return_status OUT NOCOPY VARCHAR2,
1317: x_msg_count OUT NOCOPY NUMBER,
1318: x_msg_data OUT NOCOPY VARCHAR2,

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

1311: -- in the form of a new record type, sr_create_out_rec_type
1312: PROCEDURE Create_ServiceRequest
1313: ( p_api_version IN NUMBER,
1314: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1315: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1316: x_return_status OUT NOCOPY VARCHAR2,
1317: x_msg_count OUT NOCOPY NUMBER,
1318: x_msg_data OUT NOCOPY VARCHAR2,
1319: p_resp_appl_id IN NUMBER := NULL,

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

1475: -- Must be non-null
1476: -----------------------------------------------------------------------
1477: -- These fields are no longer present in the record type
1478: -- verify_request_flag VARCHAR2 Optional
1479: -- Must be either FND_API.G_TRUE or FND_API.G_FALSE. Used
1480: -- to indicate if this is a verified or non-verified request
1481: -----------------------------------------------------------------------------
1482: -- customer_id NUMBER Optional
1483:

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

1774: -- If both are passed in, request_number will be ignored
1775: --
1776: -- If a field is not to be updated, do not pass in NULL. Either
1777: -- don't pass in the parameter at all, or pass in one of the
1778: -- missing parameter constants defined in the FND_API
1779: -- package(G_MISS_...).
1780: --
1781: -- For all the "flag" parameters, and p_called_by_workflow
1782: -- parameter, pass in the boolean constants defined in the

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

1779: -- package(G_MISS_...).
1780: --
1781: -- For all the "flag" parameters, and p_called_by_workflow
1782: -- parameter, pass in the boolean constants defined in the
1783: -- FND_API package (G_TRUE and G_FALSE).
1784: --
1785: -- Varchar parameters with the maximum length noted above will
1786: -- be truncated if the length of the value being passed in
1787: -- exceeds the maximum allowance, and a warning will be appended

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

1853:
1854:
1855: PROCEDURE Update_ServiceRequest(
1856: p_api_version IN NUMBER,
1857: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1858: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1859: x_return_status OUT NOCOPY VARCHAR2,
1860: x_msg_count OUT NOCOPY NUMBER,
1861: x_msg_data OUT NOCOPY VARCHAR2,

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

1854:
1855: PROCEDURE Update_ServiceRequest(
1856: p_api_version IN NUMBER,
1857: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1858: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1859: x_return_status OUT NOCOPY VARCHAR2,
1860: x_msg_count OUT NOCOPY NUMBER,
1861: x_msg_data OUT NOCOPY VARCHAR2,
1862: p_request_id IN NUMBER := NULL,

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

1870: p_last_update_date IN DATE,
1871: p_service_request_rec IN service_request_rec_type,
1872: p_notes IN notes_table,
1873: p_contacts IN contacts_table,
1874: p_called_by_workflow IN VARCHAR2 := FND_API.G_FALSE,
1875: p_workflow_process_id IN NUMBER := NULL,
1876: -- Commented out since these are now part of the out rec type --anmukher--08/08/03
1877: -- x_workflow_process_id OUT NOCOPY NUMBER,
1878: -- x_interaction_id OUT NOCOPY NUMBER,

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

1891: -- since several new OUT parameters have been added to the 11.5.9 signature
1892: -- in the form of a new record type, sr_update_out_rec_type
1893: PROCEDURE Update_ServiceRequest(
1894: p_api_version IN NUMBER,
1895: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1896: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1897: x_return_status OUT NOCOPY VARCHAR2,
1898: x_msg_count OUT NOCOPY NUMBER,
1899: x_msg_data OUT NOCOPY VARCHAR2,

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

1892: -- in the form of a new record type, sr_update_out_rec_type
1893: PROCEDURE Update_ServiceRequest(
1894: p_api_version IN NUMBER,
1895: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1896: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1897: x_return_status OUT NOCOPY VARCHAR2,
1898: x_msg_count OUT NOCOPY NUMBER,
1899: x_msg_data OUT NOCOPY VARCHAR2,
1900: p_request_id IN NUMBER := NULL,

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

1908: p_last_update_date IN DATE,
1909: p_service_request_rec IN service_request_rec_type,
1910: p_notes IN notes_table,
1911: p_contacts IN contacts_table,
1912: p_called_by_workflow IN VARCHAR2 := FND_API.G_FALSE,
1913: p_workflow_process_id IN NUMBER := NULL,
1914: p_default_contract_sla_ind IN VARCHAR2 Default 'N',
1915: x_workflow_process_id OUT NOCOPY NUMBER,
1916: x_interaction_id OUT NOCOPY NUMBER

Line 1929: -- Default = FND_API.G_FALSE

1925: --
1926: -- Standard IN Parameters:
1927: -- p_api_version IN NUMBER Required
1928: -- p_init_msg_list IN VARCHAR2 Optional
1929: -- Default = FND_API.G_FALSE
1930: -- p_commit IN VARCHAR2 Optional
1931: -- Default = FND_API.G_FALSE
1932: --
1933: -- Standard OUT Parameters:

Line 1931: -- Default = FND_API.G_FALSE

1927: -- p_api_version IN NUMBER Required
1928: -- p_init_msg_list IN VARCHAR2 Optional
1929: -- Default = FND_API.G_FALSE
1930: -- p_commit IN VARCHAR2 Optional
1931: -- Default = FND_API.G_FALSE
1932: --
1933: -- Standard OUT Parameters:
1934: -- p_return_status OUT VARCHAR2(1)
1935: -- p_msg_count OUT NUMBER

Line 1946: -- Default = FND_API.G_MISS_NUM

1942: -- Default = NULL
1943: -- p_user_id IN NUMBER Optional
1944: -- Default = NULL
1945: -- p_login_id IN NUMBER Optional
1946: -- Default = FND_API.G_MISS_NUM
1947:
1948: ----------------------------------------------------
1949: -- Not in the API
1950: -- p_org_id IN NUMBER Optional

Line 1965: -- Default = FND_API.G_MISS_DATE

1961: -- Default = NULL
1962: -- p_status IN VARCHAR2 Optional
1963: -- Default = NULL
1964: -- p_closed_date IN DATE Optional
1965: -- Default = FND_API.G_MISS_DATE
1966: -- p_audit_comments IN VARCHAR2 Optional
1967: -- Default = NULL
1968: -- Used for the audit record.
1969: -- p_called_by_workflow IN NUMBER Optional

Line 1970: -- Default = FND_API.G_FALSE

1966: -- p_audit_comments IN VARCHAR2 Optional
1967: -- Default = NULL
1968: -- Used for the audit record.
1969: -- p_called_by_workflow IN NUMBER Optional
1970: -- Default = FND_API.G_FALSE
1971: -- Whether or not this API is being called by the active workflow
1972: -- process of the service request.
1973: -- p_workflow_process_id IN NUMBER Optional
1974: -- Default = NULL

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

2026: ****/
2027:
2028: PROCEDURE Update_Status
2029: ( p_api_version IN NUMBER,
2030: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2031: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2032: x_return_status OUT NOCOPY VARCHAR2,
2033: x_msg_count OUT NOCOPY NUMBER,
2034: x_msg_data OUT NOCOPY VARCHAR2,

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

2027:
2028: PROCEDURE Update_Status
2029: ( p_api_version IN NUMBER,
2030: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2031: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2032: x_return_status OUT NOCOPY VARCHAR2,
2033: x_msg_count OUT NOCOPY NUMBER,
2034: x_msg_data OUT NOCOPY VARCHAR2,
2035: p_resp_appl_id IN NUMBER := NULL,

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

2034: x_msg_data OUT NOCOPY VARCHAR2,
2035: p_resp_appl_id IN NUMBER := NULL,
2036: p_resp_id IN NUMBER := NULL,
2037: p_user_id IN NUMBER := NULL,
2038: p_login_id IN NUMBER := FND_API.G_MISS_NUM,
2039: p_request_id IN NUMBER := NULL,
2040: p_request_number IN VARCHAR2 := NULL,
2041: p_object_version_number IN NUMBER,
2042: p_status_id IN NUMBER := NULL,

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

2040: p_request_number IN VARCHAR2 := NULL,
2041: p_object_version_number IN NUMBER,
2042: p_status_id IN NUMBER := NULL,
2043: p_status IN VARCHAR2 := NULL,
2044: p_closed_date IN DATE := FND_API.G_MISS_DATE,
2045: p_audit_comments IN VARCHAR2 := NULL,
2046: p_called_by_workflow IN VARCHAR2 := FND_API.G_FALSE,
2047: p_workflow_process_id IN NUMBER := NULL,
2048: p_comments IN VARCHAR2 := NULL,

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

2042: p_status_id IN NUMBER := NULL,
2043: p_status IN VARCHAR2 := NULL,
2044: p_closed_date IN DATE := FND_API.G_MISS_DATE,
2045: p_audit_comments IN VARCHAR2 := NULL,
2046: p_called_by_workflow IN VARCHAR2 := FND_API.G_FALSE,
2047: p_workflow_process_id IN NUMBER := NULL,
2048: p_comments IN VARCHAR2 := NULL,
2049: p_public_comment_flag IN VARCHAR2 := FND_API.G_FALSE,
2050: p_validate_sr_closure IN VARCHAR2 Default 'N',

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

2045: p_audit_comments IN VARCHAR2 := NULL,
2046: p_called_by_workflow IN VARCHAR2 := FND_API.G_FALSE,
2047: p_workflow_process_id IN NUMBER := NULL,
2048: p_comments IN VARCHAR2 := NULL,
2049: p_public_comment_flag IN VARCHAR2 := FND_API.G_FALSE,
2050: p_validate_sr_closure IN VARCHAR2 Default 'N',
2051: p_auto_close_child_entities IN VARCHAR2 Default 'N',
2052: x_interaction_id OUT NOCOPY NUMBER
2053: );

Line 2065: -- Default = FND_API.G_FALSE

2061: --
2062: -- Standard IN Parameters:
2063: -- p_api_version IN NUMBER Required
2064: -- p_init_msg_list IN VARCHAR2 Optional
2065: -- Default = FND_API.G_FALSE
2066: -- p_commit IN VARCHAR2 Optional
2067: -- Default = FND_API.G_FALSE
2068: --
2069: -- Standard OUT Parameters:

Line 2067: -- Default = FND_API.G_FALSE

2063: -- p_api_version IN NUMBER Required
2064: -- p_init_msg_list IN VARCHAR2 Optional
2065: -- Default = FND_API.G_FALSE
2066: -- p_commit IN VARCHAR2 Optional
2067: -- Default = FND_API.G_FALSE
2068: --
2069: -- Standard OUT Parameters:
2070: -- p_return_status OUT VARCHAR2(1)
2071: -- p_msg_count OUT NUMBER

Line 2082: -- Default = FND_API.G_MISS_NUM

2078: -- Default = NULL
2079: -- p_user_id IN NUMBER Optional
2080: -- Default = NULL
2081: -- p_login_id IN NUMBER Optional
2082: -- Default = FND_API.G_MISS_NUM
2083:
2084: ---------------------------------------------------
2085: -- Not in the API
2086: -- p_org_id IN NUMBER Optional

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

2122: -- -------------------------------------------------------------------
2123:
2124: PROCEDURE Update_Severity
2125: ( p_api_version IN NUMBER,
2126: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2127: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2128: x_return_status OUT NOCOPY VARCHAR2,
2129: x_msg_count OUT NOCOPY NUMBER,
2130: x_msg_data OUT NOCOPY VARCHAR2,

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

2123:
2124: PROCEDURE Update_Severity
2125: ( p_api_version IN NUMBER,
2126: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2127: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2128: x_return_status OUT NOCOPY VARCHAR2,
2129: x_msg_count OUT NOCOPY NUMBER,
2130: x_msg_data OUT NOCOPY VARCHAR2,
2131: p_resp_appl_id IN NUMBER := NULL,

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

2130: x_msg_data OUT NOCOPY VARCHAR2,
2131: p_resp_appl_id IN NUMBER := NULL,
2132: p_resp_id IN NUMBER := NULL,
2133: p_user_id IN NUMBER := NULL,
2134: p_login_id IN NUMBER := FND_API.G_MISS_NUM,
2135: p_request_id IN NUMBER := NULL,
2136: p_request_number IN VARCHAR2 := NULL,
2137: p_object_version_number IN NUMBER,
2138: p_severity_id IN NUMBER := NULL,

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

2138: p_severity_id IN NUMBER := NULL,
2139: p_severity IN VARCHAR2 := NULL,
2140: p_audit_comments IN VARCHAR2 := NULL,
2141: p_comments IN VARCHAR2 := NULL,
2142: p_public_comment_flag IN VARCHAR2 := FND_API.G_FALSE,
2143: x_interaction_id OUT NOCOPY NUMBER
2144: );
2145:
2146: -- -------------------------------------------------------------------

Line 2156: -- Default = FND_API.G_FALSE

2152: --
2153: -- Standard IN Parameters:
2154: -- p_api_version IN NUMBER Required
2155: -- p_init_msg_list IN VARCHAR2 Optional
2156: -- Default = FND_API.G_FALSE
2157: -- p_commit IN VARCHAR2 Optional
2158: -- Default = FND_API.G_FALSE
2159: --
2160: -- Standard OUT Parameters:

Line 2158: -- Default = FND_API.G_FALSE

2154: -- p_api_version IN NUMBER Required
2155: -- p_init_msg_list IN VARCHAR2 Optional
2156: -- Default = FND_API.G_FALSE
2157: -- p_commit IN VARCHAR2 Optional
2158: -- Default = FND_API.G_FALSE
2159: --
2160: -- Standard OUT Parameters:
2161: -- p_return_status OUT VARCHAR2(1)
2162: -- p_msg_count OUT NUMBER

Line 2173: -- Default = FND_API.G_MISS_NUM

2169: -- Default = NULL
2170: -- p_user_id IN NUMBER Optional
2171: -- Default = NULL
2172: -- p_login_id IN NUMBER Optional
2173: -- Default = FND_API.G_MISS_NUM
2174:
2175: ----------------------------------------------
2176: -- Not in the API
2177:

Line 2187: -- Default = FND_API.G_MISS_NUM

2183: -- Default = NULL
2184: -- p_request_number IN VARCHAR2 Optional
2185: -- Default = NULL
2186: -- p_urgency_id IN NUMBER Optional
2187: -- Default = FND_API.G_MISS_NUM
2188: -- p_urgency IN VARCHAR2 Optional
2189: -- Default = FND_API.G_MISS_CHAR
2190: -- p_audit_comments IN VARCHAR2 Optional
2191: -- Default = NULL

Line 2189: -- Default = FND_API.G_MISS_CHAR

2185: -- Default = NULL
2186: -- p_urgency_id IN NUMBER Optional
2187: -- Default = FND_API.G_MISS_NUM
2188: -- p_urgency IN VARCHAR2 Optional
2189: -- Default = FND_API.G_MISS_CHAR
2190: -- p_audit_comments IN VARCHAR2 Optional
2191: -- Default = NULL
2192: -- Used for the audit record.
2193: --

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

2214: -- -------------------------------------------------------------------
2215:
2216: PROCEDURE Update_Urgency
2217: ( p_api_version IN NUMBER,
2218: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2219: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2220: x_return_status OUT NOCOPY VARCHAR2,
2221: x_msg_count OUT NOCOPY NUMBER,
2222: x_msg_data OUT NOCOPY VARCHAR2,

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

2215:
2216: PROCEDURE Update_Urgency
2217: ( p_api_version IN NUMBER,
2218: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2219: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2220: x_return_status OUT NOCOPY VARCHAR2,
2221: x_msg_count OUT NOCOPY NUMBER,
2222: x_msg_data OUT NOCOPY VARCHAR2,
2223: p_resp_appl_id IN NUMBER := NULL,

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

2222: x_msg_data OUT NOCOPY VARCHAR2,
2223: p_resp_appl_id IN NUMBER := NULL,
2224: p_resp_id IN NUMBER := NULL,
2225: p_user_id IN NUMBER := NULL,
2226: p_login_id IN NUMBER := FND_API.G_MISS_NUM,
2227: p_request_id IN NUMBER := NULL,
2228: p_request_number IN VARCHAR2 := NULL,
2229: p_object_version_number IN NUMBER,
2230: p_urgency_id IN NUMBER := FND_API.G_MISS_NUM,

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

2226: p_login_id IN NUMBER := FND_API.G_MISS_NUM,
2227: p_request_id IN NUMBER := NULL,
2228: p_request_number IN VARCHAR2 := NULL,
2229: p_object_version_number IN NUMBER,
2230: p_urgency_id IN NUMBER := FND_API.G_MISS_NUM,
2231: p_urgency IN VARCHAR2 := FND_API.G_MISS_CHAR,
2232: p_audit_comments IN VARCHAR2 := NULL,
2233: p_comments IN VARCHAR2 := NULL,
2234: p_public_comment_flag IN VARCHAR2 := FND_API.G_FALSE,

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

2227: p_request_id IN NUMBER := NULL,
2228: p_request_number IN VARCHAR2 := NULL,
2229: p_object_version_number IN NUMBER,
2230: p_urgency_id IN NUMBER := FND_API.G_MISS_NUM,
2231: p_urgency IN VARCHAR2 := FND_API.G_MISS_CHAR,
2232: p_audit_comments IN VARCHAR2 := NULL,
2233: p_comments IN VARCHAR2 := NULL,
2234: p_public_comment_flag IN VARCHAR2 := FND_API.G_FALSE,
2235: x_interaction_id OUT NOCOPY NUMBER

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

2230: p_urgency_id IN NUMBER := FND_API.G_MISS_NUM,
2231: p_urgency IN VARCHAR2 := FND_API.G_MISS_CHAR,
2232: p_audit_comments IN VARCHAR2 := NULL,
2233: p_comments IN VARCHAR2 := NULL,
2234: p_public_comment_flag IN VARCHAR2 := FND_API.G_FALSE,
2235: x_interaction_id OUT NOCOPY NUMBER
2236: );
2237:
2238:

Line 2250: -- Default = FND_API.G_FALSE

2246: --
2247: -- Standard IN Parameters:
2248: -- p_api_version IN NUMBER Required
2249: -- p_init_msg_list IN VARCHAR2 Optional
2250: -- Default = FND_API.G_FALSE
2251: -- p_commit IN VARCHAR2 Optional
2252: -- Default = FND_API.G_FALSE
2253: --
2254: -- Standard OUT Parameters:

Line 2252: -- Default = FND_API.G_FALSE

2248: -- p_api_version IN NUMBER Required
2249: -- p_init_msg_list IN VARCHAR2 Optional
2250: -- Default = FND_API.G_FALSE
2251: -- p_commit IN VARCHAR2 Optional
2252: -- Default = FND_API.G_FALSE
2253: --
2254: -- Standard OUT Parameters:
2255: -- p_return_status OUT VARCHAR2(1)
2256: -- p_msg_count OUT NUMBER

Line 2267: -- Default = FND_API.G_MISS_NUM

2263: -- Default = NULL
2264: -- p_user_id IN NUMBER Optional
2265: -- Default = NULL
2266: -- p_login_id IN NUMBER Optional
2267: -- Default = FND_API.G_MISS_NUM
2268:
2269: -----------------------------------------
2270: -- Not in the API
2271: -- p_org_id IN NUMBER Optional

Line 2285: -- Default = FND_API.G_FALSE

2281: -- p_audit_comments IN VARCHAR2 Optional
2282: -- Default = NULL
2283: -- Used for the audit record.
2284: -- p_called_by_workflow IN NUMBER Optional
2285: -- Default = FND_API.G_FALSE
2286: -- Whether or not this API is being called by the active workflow
2287: -- process of the service request.
2288: -- p_workflow_process_id IN NUMBER Optional
2289: -- Default = NULL

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

2331: ****/
2332:
2333: PROCEDURE Update_Owner
2334: ( p_api_version IN NUMBER,
2335: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2336: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2337: x_return_status OUT NOCOPY VARCHAR2,
2338: x_msg_count OUT NOCOPY NUMBER,
2339: x_msg_data OUT NOCOPY VARCHAR2,

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

2332:
2333: PROCEDURE Update_Owner
2334: ( p_api_version IN NUMBER,
2335: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2336: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2337: x_return_status OUT NOCOPY VARCHAR2,
2338: x_msg_count OUT NOCOPY NUMBER,
2339: x_msg_data OUT NOCOPY VARCHAR2,
2340: p_resp_appl_id IN NUMBER := NULL,

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

2339: x_msg_data OUT NOCOPY VARCHAR2,
2340: p_resp_appl_id IN NUMBER := NULL,
2341: p_resp_id IN NUMBER := NULL,
2342: p_user_id IN NUMBER := NULL,
2343: p_login_id IN NUMBER := FND_API.G_MISS_NUM,
2344: p_request_id IN NUMBER := NULL,
2345: p_request_number IN VARCHAR2 := NULL,
2346: p_object_version_number IN NUMBER,
2347: p_owner_id IN NUMBER,

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

2347: p_owner_id IN NUMBER,
2348: p_owner_group_id IN NUMBER,
2349: p_resource_type IN VARCHAR2,
2350: p_audit_comments IN VARCHAR2 := NULL,
2351: p_called_by_workflow IN VARCHAR2 := FND_API.G_FALSE,
2352: p_workflow_process_id IN NUMBER := NULL,
2353: p_comments IN VARCHAR2 := NULL,
2354: p_public_comment_flag IN VARCHAR2 := FND_API.G_FALSE,
2355: x_interaction_id OUT NOCOPY NUMBER

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

2350: p_audit_comments IN VARCHAR2 := NULL,
2351: p_called_by_workflow IN VARCHAR2 := FND_API.G_FALSE,
2352: p_workflow_process_id IN NUMBER := NULL,
2353: p_comments IN VARCHAR2 := NULL,
2354: p_public_comment_flag IN VARCHAR2 := FND_API.G_FALSE,
2355: x_interaction_id OUT NOCOPY NUMBER
2356: );
2357:
2358: -- -------------------------------------------------------------------

Line 2368: -- Default = FND_API.G_FALSE

2364: --
2365: -- Standard IN Parameters:
2366: -- p_api_version IN NUMBER Required
2367: -- p_init_msg_list IN VARCHAR2 Optional
2368: -- Default = FND_API.G_FALSE
2369: -- p_commit IN VARCHAR2 Optional
2370: -- Default = FND_API.G_FALSE
2371: --
2372: -- Standard OUT Parameters:

Line 2370: -- Default = FND_API.G_FALSE

2366: -- p_api_version IN NUMBER Required
2367: -- p_init_msg_list IN VARCHAR2 Optional
2368: -- Default = FND_API.G_FALSE
2369: -- p_commit IN VARCHAR2 Optional
2370: -- Default = FND_API.G_FALSE
2371: --
2372: -- Standard OUT Parameters:
2373: -- p_return_status OUT VARCHAR2(1)
2374: -- p_msg_count OUT NUMBER

Line 2385: -- Default = FND_API.G_MISS_NUM

2381: -- Default = NULL
2382: -- p_user_id IN NUMBER Optional
2383: -- Default = NULL
2384: -- p_login_id IN NUMBER Optional
2385: -- Default = FND_API.G_MISS_NUM
2386:
2387: ---------------------------------
2388: -- Not in API
2389: -- p_org_id IN NUMBER Optional

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

2418: -- -------------------------------------------------------------------
2419:
2420: PROCEDURE Update_Problem_Code
2421: ( p_api_version IN NUMBER,
2422: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2423: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2424: x_return_status OUT NOCOPY VARCHAR2,
2425: x_msg_count OUT NOCOPY NUMBER,
2426: x_msg_data OUT NOCOPY VARCHAR2,

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

2419:
2420: PROCEDURE Update_Problem_Code
2421: ( p_api_version IN NUMBER,
2422: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2423: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2424: x_return_status OUT NOCOPY VARCHAR2,
2425: x_msg_count OUT NOCOPY NUMBER,
2426: x_msg_data OUT NOCOPY VARCHAR2,
2427: p_resp_appl_id IN NUMBER := NULL,

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

2426: x_msg_data OUT NOCOPY VARCHAR2,
2427: p_resp_appl_id IN NUMBER := NULL,
2428: p_resp_id IN NUMBER := NULL,
2429: p_user_id IN NUMBER := NULL,
2430: p_login_id IN NUMBER := FND_API.G_MISS_NUM,
2431: p_request_id IN NUMBER := NULL,
2432: p_request_number IN VARCHAR2 := NULL,
2433: p_object_version_number IN NUMBER,
2434: p_problem_code IN VARCHAR2,

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

2432: p_request_number IN VARCHAR2 := NULL,
2433: p_object_version_number IN NUMBER,
2434: p_problem_code IN VARCHAR2,
2435: p_comments IN VARCHAR2 := NULL,
2436: p_public_comment_flag IN VARCHAR2 := FND_API.G_FALSE,
2437: x_interaction_id OUT NOCOPY NUMBER
2438: );
2439:
2440:

Line 2453: -- Default = FND_API.G_FALSE

2449: -- Parameters :
2450: -- IN :
2451: -- p_api_version IN NUMBER Required
2452: -- p_init_msg_list IN VARCHAR2(1) Optional
2453: -- Default = FND_API.G_FALSE
2454: -- p_commit IN VARCHAR2(1) Optional
2455: -- Default = FND_API.G_FALSE
2456: -- p_request_id IN NUMBER Required
2457: -- p_statement_id IN NUMBER Required

Line 2455: -- Default = FND_API.G_FALSE

2451: -- p_api_version IN NUMBER Required
2452: -- p_init_msg_list IN VARCHAR2(1) Optional
2453: -- Default = FND_API.G_FALSE
2454: -- p_commit IN VARCHAR2(1) Optional
2455: -- Default = FND_API.G_FALSE
2456: -- p_request_id IN NUMBER Required
2457: -- p_statement_id IN NUMBER Required
2458: -- p_is_statement_true IN BOOLEAN Required
2459: --

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

2472:
2473: PROCEDURE Link_KB_Statement
2474: (
2475: p_api_version IN NUMBER,
2476: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2477: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2478: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2479: x_return_status OUT NOCOPY VARCHAR2,
2480: x_msg_count OUT NOCOPY NUMBER,

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

2473: PROCEDURE Link_KB_Statement
2474: (
2475: p_api_version IN NUMBER,
2476: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2477: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2478: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2479: x_return_status OUT NOCOPY VARCHAR2,
2480: x_msg_count OUT NOCOPY NUMBER,
2481: x_msg_data OUT NOCOPY VARCHAR2,

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

2474: (
2475: p_api_version IN NUMBER,
2476: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2477: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2478: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2479: x_return_status OUT NOCOPY VARCHAR2,
2480: x_msg_count OUT NOCOPY NUMBER,
2481: x_msg_data OUT NOCOPY VARCHAR2,
2482: p_request_id IN NUMBER,

Line 2499: -- Default = FND_API.G_FALSE

2495: -- Parameters :
2496: -- IN :
2497: -- p_api_version IN NUMBER Required
2498: -- p_init_msg_list IN VARCHAR2(1) Optional
2499: -- Default = FND_API.G_FALSE
2500: -- p_commit IN VARCHAR2(1) Optional
2501: -- Default = FND_API.G_FALSE
2502: -- p_request_id IN NUMBER Required
2503: -- p_solution_id IN NUMBER Required

Line 2501: -- Default = FND_API.G_FALSE

2497: -- p_api_version IN NUMBER Required
2498: -- p_init_msg_list IN VARCHAR2(1) Optional
2499: -- Default = FND_API.G_FALSE
2500: -- p_commit IN VARCHAR2(1) Optional
2501: -- Default = FND_API.G_FALSE
2502: -- p_request_id IN NUMBER Required
2503: -- p_solution_id IN NUMBER Required
2504: -- p_is_solution_true IN BOOLEAN Required
2505: --

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

2536:
2537: PROCEDURE Link_KB_Solution
2538: (
2539: p_api_version IN NUMBER,
2540: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2541: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2542: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2543: x_return_status OUT NOCOPY VARCHAR2,
2544: x_msg_count OUT NOCOPY NUMBER,

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

2537: PROCEDURE Link_KB_Solution
2538: (
2539: p_api_version IN NUMBER,
2540: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2541: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2542: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2543: x_return_status OUT NOCOPY VARCHAR2,
2544: x_msg_count OUT NOCOPY NUMBER,
2545: x_msg_data OUT NOCOPY VARCHAR2,

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

2538: (
2539: p_api_version IN NUMBER,
2540: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2541: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2542: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2543: x_return_status OUT NOCOPY VARCHAR2,
2544: x_msg_count OUT NOCOPY NUMBER,
2545: x_msg_data OUT NOCOPY VARCHAR2,
2546: p_request_id IN NUMBER,

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

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

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

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