[Home] [Help]
PACKAGE: APPS.CSD_TO_FORM_REPAIR_JOB_XREF
Source
1 PACKAGE CSD_TO_FORM_REPAIR_JOB_XREF AUTHID CURRENT_USER as
2 /* $Header: csdgdrjs.pls 115.12 2003/09/15 21:34:53 sragunat ship $ */
3 -- Start of Comments
4 -- Package name : CSD_TO_FORM_REPAIR_JOB_XREF
5 -- Purpose : Takes all parameters from the FORM and construct those parameters into a record for calling
6 -- the prviate API in the CSP_MOVEORDER_HEADERS_PVT package.
7 -- History : 11/17/1999, Created by Vernon Lou
8 -- History : 12/26/2001, TRAVI Added INVENTORY_ITEM_ID and ITEM_REVISION
9 -- History : 01/17/2002, TRAVI added column OBJECT_VERSION_NUMBER
10 -- History : 08/20/2003, Shiv Ragunathan, 11.5.10 Changes: Added
11 -- History : parameters p_source_type_code, p_source_id1,
12 -- History : p_ro_service_code_id, p_job_name to
13 -- History : Validate_And_Write.
14 -- NOTE :
15 -- End of Comments
16
17 -- travi changes
18 PROCEDURE Validate_And_Write (
19 P_Api_Version_Number IN NUMBER,
20 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
21 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
22 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
23 p_action_code IN NUMBER, /* 0 = insert, 1 = update, 2 = delete */
24 px_REPAIR_JOB_XREF_ID IN OUT NOCOPY NUMBER,
25 p_CREATED_BY NUMBER,
26 p_CREATION_DATE DATE,
27 p_LAST_UPDATED_BY NUMBER,
28 p_LAST_UPDATE_DATE DATE,
29 p_LAST_UPDATE_LOGIN NUMBER,
30 p_REPAIR_LINE_ID NUMBER,
31 p_WIP_ENTITY_ID NUMBER,
32 p_GROUP_ID NUMBER,
33 p_ORGANIZATION_ID NUMBER,
34 p_QUANTITY NUMBER,
35 p_INVENTORY_ITEM_ID NUMBER,
36 p_ITEM_REVISION VARCHAR2,
37 p_SOURCE_TYPE_CODE VARCHAR2,
38 p_SOURCE_ID1 NUMBER,
39 p_RO_SERVICE_CODE_ID NUMBER,
40 p_JOB_NAME VARCHAR2,
41 p_OBJECT_VERSION_NUMBER NUMBER,
42 p_ATTRIBUTE_CATEGORY VARCHAR2,
43 p_ATTRIBUTE1 VARCHAR2,
44 p_ATTRIBUTE2 VARCHAR2,
45 p_ATTRIBUTE3 VARCHAR2,
46 p_ATTRIBUTE4 VARCHAR2,
47 p_ATTRIBUTE5 VARCHAR2,
48 p_ATTRIBUTE6 VARCHAR2,
49 p_ATTRIBUTE7 VARCHAR2,
50 p_ATTRIBUTE8 VARCHAR2,
51 p_ATTRIBUTE9 VARCHAR2,
52 p_ATTRIBUTE10 VARCHAR2,
53 p_ATTRIBUTE11 VARCHAR2,
54 p_ATTRIBUTE12 VARCHAR2,
55 p_ATTRIBUTE13 VARCHAR2,
56 p_ATTRIBUTE14 VARCHAR2,
57 p_ATTRIBUTE15 VARCHAR2,
58 p_QUANTITY_COMPLETED NUMBER,
59 X_Return_Status OUT NOCOPY VARCHAR2,
60 X_Msg_Count OUT NOCOPY NUMBER,
61 X_Msg_Data OUT NOCOPY VARCHAR2
62 );
63
64 END CSD_TO_FORM_REPAIR_JOB_XREF;