DBA Data[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;