DBA Data[Home] [Help]

APPS.IEM_SERVICEREQUEST_PVT dependencies on FND_API

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

191:
192:
193:
194: TYPE notes_rec IS RECORD (
195: NOTE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
196: NOTE_DETAIL VARCHAR2(32767) := FND_API.G_MISS_CHAR,
197: NOTE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
198: NOTE_CONTEXT_TYPE_01 VARCHAR2(30) := FND_API.G_MISS_CHAR,
199: NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,

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

192:
193:
194: TYPE notes_rec IS RECORD (
195: NOTE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
196: NOTE_DETAIL VARCHAR2(32767) := FND_API.G_MISS_CHAR,
197: NOTE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
198: NOTE_CONTEXT_TYPE_01 VARCHAR2(30) := FND_API.G_MISS_CHAR,
199: NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,
200: NOTE_CONTEXT_TYPE_02 VARCHAR2(30) := FND_API.G_MISS_CHAR,

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

193:
194: TYPE notes_rec IS RECORD (
195: NOTE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
196: NOTE_DETAIL VARCHAR2(32767) := FND_API.G_MISS_CHAR,
197: NOTE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
198: NOTE_CONTEXT_TYPE_01 VARCHAR2(30) := FND_API.G_MISS_CHAR,
199: NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,
200: NOTE_CONTEXT_TYPE_02 VARCHAR2(30) := FND_API.G_MISS_CHAR,
201: NOTE_CONTEXT_TYPE_ID_02 NUMBER := FND_API.G_MISS_NUM,

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

194: TYPE notes_rec IS RECORD (
195: NOTE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
196: NOTE_DETAIL VARCHAR2(32767) := FND_API.G_MISS_CHAR,
197: NOTE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
198: NOTE_CONTEXT_TYPE_01 VARCHAR2(30) := FND_API.G_MISS_CHAR,
199: NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,
200: NOTE_CONTEXT_TYPE_02 VARCHAR2(30) := FND_API.G_MISS_CHAR,
201: NOTE_CONTEXT_TYPE_ID_02 NUMBER := FND_API.G_MISS_NUM,
202: NOTE_CONTEXT_TYPE_03 VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 199: NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,

195: NOTE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
196: NOTE_DETAIL VARCHAR2(32767) := FND_API.G_MISS_CHAR,
197: NOTE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
198: NOTE_CONTEXT_TYPE_01 VARCHAR2(30) := FND_API.G_MISS_CHAR,
199: NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,
200: NOTE_CONTEXT_TYPE_02 VARCHAR2(30) := FND_API.G_MISS_CHAR,
201: NOTE_CONTEXT_TYPE_ID_02 NUMBER := FND_API.G_MISS_NUM,
202: NOTE_CONTEXT_TYPE_03 VARCHAR2(30) := FND_API.G_MISS_CHAR,
203: NOTE_CONTEXT_TYPE_ID_03 NUMBER := FND_API.G_MISS_NUM

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

196: NOTE_DETAIL VARCHAR2(32767) := FND_API.G_MISS_CHAR,
197: NOTE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
198: NOTE_CONTEXT_TYPE_01 VARCHAR2(30) := FND_API.G_MISS_CHAR,
199: NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,
200: NOTE_CONTEXT_TYPE_02 VARCHAR2(30) := FND_API.G_MISS_CHAR,
201: NOTE_CONTEXT_TYPE_ID_02 NUMBER := FND_API.G_MISS_NUM,
202: NOTE_CONTEXT_TYPE_03 VARCHAR2(30) := FND_API.G_MISS_CHAR,
203: NOTE_CONTEXT_TYPE_ID_03 NUMBER := FND_API.G_MISS_NUM
204:

Line 201: NOTE_CONTEXT_TYPE_ID_02 NUMBER := FND_API.G_MISS_NUM,

197: NOTE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
198: NOTE_CONTEXT_TYPE_01 VARCHAR2(30) := FND_API.G_MISS_CHAR,
199: NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,
200: NOTE_CONTEXT_TYPE_02 VARCHAR2(30) := FND_API.G_MISS_CHAR,
201: NOTE_CONTEXT_TYPE_ID_02 NUMBER := FND_API.G_MISS_NUM,
202: NOTE_CONTEXT_TYPE_03 VARCHAR2(30) := FND_API.G_MISS_CHAR,
203: NOTE_CONTEXT_TYPE_ID_03 NUMBER := FND_API.G_MISS_NUM
204:
205: );

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

198: NOTE_CONTEXT_TYPE_01 VARCHAR2(30) := FND_API.G_MISS_CHAR,
199: NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,
200: NOTE_CONTEXT_TYPE_02 VARCHAR2(30) := FND_API.G_MISS_CHAR,
201: NOTE_CONTEXT_TYPE_ID_02 NUMBER := FND_API.G_MISS_NUM,
202: NOTE_CONTEXT_TYPE_03 VARCHAR2(30) := FND_API.G_MISS_CHAR,
203: NOTE_CONTEXT_TYPE_ID_03 NUMBER := FND_API.G_MISS_NUM
204:
205: );
206: TYPE notes_table IS TABLE OF notes_rec INDEX BY BINARY_INTEGER;

Line 203: NOTE_CONTEXT_TYPE_ID_03 NUMBER := FND_API.G_MISS_NUM

199: NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,
200: NOTE_CONTEXT_TYPE_02 VARCHAR2(30) := FND_API.G_MISS_CHAR,
201: NOTE_CONTEXT_TYPE_ID_02 NUMBER := FND_API.G_MISS_NUM,
202: NOTE_CONTEXT_TYPE_03 VARCHAR2(30) := FND_API.G_MISS_CHAR,
203: NOTE_CONTEXT_TYPE_ID_03 NUMBER := FND_API.G_MISS_NUM
204:
205: );
206: TYPE notes_table IS TABLE OF notes_rec INDEX BY BINARY_INTEGER;
207:

Line 243: SR_CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,

239: -- NOTE_CONTEXT_TYPE_ID_03
240: -- VAlid incident_id from cs_incidents_all_b
241:
242: TYPE contacts_rec IS RECORD (
243: SR_CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
244: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
245: CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
246: CONTACT_POINT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
247: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 244: PARTY_ID NUMBER := FND_API.G_MISS_NUM,

240: -- VAlid incident_id from cs_incidents_all_b
241:
242: TYPE contacts_rec IS RECORD (
243: SR_CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
244: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
245: CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
246: CONTACT_POINT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
247: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
248: CONTACT_TYPE VARCHAR2(30) :=FND_API.G_MISS_CHAR

Line 245: CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,

241:
242: TYPE contacts_rec IS RECORD (
243: SR_CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
244: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
245: CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
246: CONTACT_POINT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
247: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
248: CONTACT_TYPE VARCHAR2(30) :=FND_API.G_MISS_CHAR
249: );

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

242: TYPE contacts_rec IS RECORD (
243: SR_CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
244: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
245: CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
246: CONTACT_POINT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
247: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
248: CONTACT_TYPE VARCHAR2(30) :=FND_API.G_MISS_CHAR
249: );
250:

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

243: SR_CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
244: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
245: CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
246: CONTACT_POINT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
247: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
248: CONTACT_TYPE VARCHAR2(30) :=FND_API.G_MISS_CHAR
249: );
250:
251: TYPE contacts_table IS TABLE OF contacts_rec INDEX BY BINARY_INTEGER;

Line 248: CONTACT_TYPE VARCHAR2(30) :=FND_API.G_MISS_CHAR

244: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
245: CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
246: CONTACT_POINT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
247: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
248: CONTACT_TYPE VARCHAR2(30) :=FND_API.G_MISS_CHAR
249: );
250:
251: TYPE contacts_table IS TABLE OF contacts_rec INDEX BY BINARY_INTEGER;
252:

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

441: -- Must be non-null
442: -----------------------------------------------------------------------
443: -- These fields are no longer present in the record type
444: -- verify_request_flag VARCHAR2 Optional
445: -- Must be either FND_API.G_TRUE or FND_API.G_FALSE. Used
446: -- to indicate if this is a verified or non-verified request
447: -----------------------------------------------------------------------------
448: -- customer_id NUMBER Optional
449:

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

740: -- If both are passed in, request_number will be ignored
741: --
742: -- If a field is not to be updated, do not pass in NULL. Either
743: -- don't pass in the parameter at all, or pass in one of the
744: -- missing parameter constants defined in the FND_API
745: -- package(G_MISS_...).
746: --
747: -- For all the "flag" parameters, and p_called_by_workflow
748: -- parameter, pass in the boolean constants defined in the

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

745: -- package(G_MISS_...).
746: --
747: -- For all the "flag" parameters, and p_called_by_workflow
748: -- parameter, pass in the boolean constants defined in the
749: -- FND_API package (G_TRUE and G_FALSE).
750: --
751: -- Varchar parameters with the maximum length noted above will
752: -- be truncated if the length of the value being passed in
753: -- exceeds the maximum allowance, and a warning will be appended

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

818: p_last_update_date IN DATE,
819: p_service_request_rec IN service_request_rec_type,
820: p_notes IN notes_table,
821: p_contacts IN contacts_table,
822: p_called_by_workflow IN VARCHAR2 := FND_API.G_FALSE,
823: p_workflow_process_id IN NUMBER := NULL,
824: x_workflow_process_id OUT NOCOPY NUMBER,
825: x_interaction_id OUT NOCOPY NUMBER
826: );

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

830: );
831:
832: PROCEDURE Update_Status_Wrap
833: ( p_api_version IN NUMBER,
834: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
835: p_commit IN VARCHAR2 := FND_API.G_FALSE,
836: x_return_status OUT NOCOPY VARCHAR2,
837: x_msg_count OUT NOCOPY NUMBER,
838: x_msg_data OUT NOCOPY VARCHAR2,

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

831:
832: PROCEDURE Update_Status_Wrap
833: ( p_api_version IN NUMBER,
834: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
835: p_commit IN VARCHAR2 := FND_API.G_FALSE,
836: x_return_status OUT NOCOPY VARCHAR2,
837: x_msg_count OUT NOCOPY NUMBER,
838: x_msg_data OUT NOCOPY VARCHAR2,
839: p_resp_appl_id IN NUMBER := NULL,

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

838: x_msg_data OUT NOCOPY VARCHAR2,
839: p_resp_appl_id IN NUMBER := NULL,
840: p_resp_id IN NUMBER := NULL,
841: p_user_id IN NUMBER := NULL,
842: p_login_id IN NUMBER := FND_API.G_MISS_NUM,
843: p_request_id IN NUMBER := NULL,
844: p_request_number IN VARCHAR2 := NULL,
845: p_object_version_number IN NUMBER,
846: p_status_id IN NUMBER := NULL,

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

844: p_request_number IN VARCHAR2 := NULL,
845: p_object_version_number IN NUMBER,
846: p_status_id IN NUMBER := NULL,
847: p_status IN VARCHAR2 := NULL,
848: p_closed_date IN DATE := FND_API.G_MISS_DATE,
849: p_audit_comments IN VARCHAR2 := NULL,
850: p_called_by_workflow IN VARCHAR2 := FND_API.G_FALSE,
851: p_workflow_process_id IN NUMBER := NULL,
852: p_comments IN VARCHAR2 := NULL,

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

846: p_status_id IN NUMBER := NULL,
847: p_status IN VARCHAR2 := NULL,
848: p_closed_date IN DATE := FND_API.G_MISS_DATE,
849: p_audit_comments IN VARCHAR2 := NULL,
850: p_called_by_workflow IN VARCHAR2 := FND_API.G_FALSE,
851: p_workflow_process_id IN NUMBER := NULL,
852: p_comments IN VARCHAR2 := NULL,
853: p_public_comment_flag IN VARCHAR2 := FND_API.G_FALSE,
854: x_interaction_id OUT NOCOPY NUMBER

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

849: p_audit_comments IN VARCHAR2 := NULL,
850: p_called_by_workflow IN VARCHAR2 := FND_API.G_FALSE,
851: p_workflow_process_id IN NUMBER := NULL,
852: p_comments IN VARCHAR2 := NULL,
853: p_public_comment_flag IN VARCHAR2 := FND_API.G_FALSE,
854: x_interaction_id OUT NOCOPY NUMBER
855: );
856:
857: PROCEDURE IEM_CREATE_SR

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

855: );
856:
857: PROCEDURE IEM_CREATE_SR
858: ( p_api_version IN NUMBER,
859: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
860: p_commit IN VARCHAR2 := FND_API.G_FALSE,
861: p_message_id IN NUMBER,
862: p_note IN VARCHAR2,
863: p_party_id IN NUMBER,

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

856:
857: PROCEDURE IEM_CREATE_SR
858: ( p_api_version IN NUMBER,
859: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
860: p_commit IN VARCHAR2 := FND_API.G_FALSE,
861: p_message_id IN NUMBER,
862: p_note IN VARCHAR2,
863: p_party_id IN NUMBER,
864: p_sr_type_id IN NUMBER,