1 PACKAGE CSD_Refurbish_IRO_GRP AUTHID CURRENT_USER AS
2 /* $Header: csdriros.pls 120.1 2008/03/14 01:05:29 takwong ship $ */
3
4 /*--------------------------------------------------------------------*/
5 /* PROCEDURE Name : Get_PartySiteID */
6 /* x_return_status Standard OUT param */
7 /* x_msg_data Standard OUT param */
8 /* x_msg_count Standard OUT param */
9 /* p_site_use_type Site Use Type Like To_Ship or To_Bill */
10 /* p_cust_site_use_id Customer Site USe Id value */
11 /* x_party_site_use_id Party Site Use Id OUT value */
12 /* Description : Takes Customer site use Id and site use type */
13 /* variables as input and returns corresponding */
14 /* party site use id , party Id and party site use id */
15 /*--------------------------------------------------------------------*/
16 PROCEDURE Get_PartySiteId
17 (
18 x_return_status Out NOCOPY Varchar2,
19 x_msg_Data Out NoCopy Varchar2 ,
20 x_msg_Count Out NoCopy Number,
21 p_site_use_type In Varchar2,
22 p_cust_site_use_id In Number ,
23 x_party_id OUT NOCOPY Number,
24 x_party_site_id OUT NOCOPY Number,
25 x_party_site_use_id Out NOCOPY Number ) ;
26
27
28
29
30
31 /*-----------------------------------------------------------------------------------------*/
32 /*-- Create_InternalRO Procedure takes 4 input parameters p_Internal_SO_Header_Id_In, */
33 /*-- p_Req_Header_Id_In,p_Internal_SO_Header_Id_Out, p_Req_Header_Id_Out and creates one */
34 /*-- serive request and returns service request in x_Service_Request_Number out parameter. */
35 /* */
36 /*-- If procedure is not processed successfully then it returns error code and */
37 /*-- message. In case procedure returns errors all database transactions are rolled */
38 /*-- back. If item on internal sales order In is non serialized then one repair order */
39 /*-- is created under above service request. If item is serialized then number of */
40 /*-- repair orders will be as many as ordered quantity on internal sales order in. */
41 /*-- THis procedure creates two product trxn lines for each repair order, one product */
42 /*-- trxn line for internal SO Move In and another for internal SO Move out. */
43 /*-- p_Internal_SO_Header_Id_In, p_Req_Header_Id_In,p_Internal_SO_Header_Id_Out, */
44 /*-- p_Req_Header_Id_Out are required parameters. */
45 /*-- Internal RO are always created under new SR. */
46 /*-----------------------------------------------------------------------------------------*/
47 /* Procedure Name : Create_InternalRO */
48 /* P_api_version Standard In param */
49 /* P_init_msg_list Standard In param */
50 /* P_commit Standard In param */
51 /* P_validation_level Standard In param */
52 /* x_return_status Standard Out param */
53 /* x_msg_count Standard Out param */
54 /* x_msg_data Standard Out param */
55 /* P_req_header_id_in Requisition Header Id for IO1 (Required) */
56 /* P_internal_SO_header_id_in Internal SO header Id for IO1 (Required) */
57 /* P_req_header_id_out Requisition Header Id for IO2 (Required) */
58 /* P_internal_SO_header_id_out Internal SO header Id for IO2 (Required) */
59 /* x_service_request_number Service Request Number OUT variable */
60 /*-----------------------------------------------------------------------------------------*/
61
62
63 Procedure Create_InternalRO(
64 P_api_version In Number,
65 P_init_msg_list In Varchar2,
66 P_commit In Varchar2,
67 P_validation_level In Number,
68 x_return_status Out NOCOPY Varchar2,
69 x_msg_count Out NOCOPY Number,
70 x_msg_data Out NOCOPY Varchar2,
71 P_req_header_id_in In Number,
72 P_ISO_header_id_in In Number,
73 P_req_header_id_out In Number,
74 P_ISO_header_id_out In Number,
75 x_service_request_number Out NOCOPY Varchar2,
76 P_need_by_date In DATE := FND_API.G_MISS_DATE ); --Enhancement:3391950
77
78
79 End CSD_Refurbish_IRO_GRP ;