1 PACKAGE PJM_MASS_TRANSFER_PUB AUTHID CURRENT_USER AS
2 /* $Header: PJMMXFRS.pls 115.5 2002/10/29 20:13:46 alaw noship $ */
3
4 --
5 -- Transfer Modes
6 --
7 G_TXFR_MODE_ALL_ITEMS NUMBER := 1;
8 G_TXFR_MODE_ONE_ITEM NUMBER := 2;
9 G_TXFR_MODE_CATEGORY NUMBER := 3;
10
11 --
12 -- Process Modes
13 --
14 G_PROC_MODE_ONLINE NUMBER := 1;
15 G_PROC_MODE_IMMEDIATE NUMBER := 2;
16 G_PROC_MODE_BACKGROUND NUMBER := 3;
17 G_PROC_MODE_FORMLEVEL NUMBER := 4;
18
19 --
20 -- Record Types
21 --
22 TYPE DFF_Rec_Type IS RECORD
23 ( Category mtl_transactions_interface.attribute_category%TYPE := NULL
24 , Attr1 mtl_transactions_interface.attribute1%TYPE := NULL
25 , Attr2 mtl_transactions_interface.attribute2%TYPE := NULL
26 , Attr3 mtl_transactions_interface.attribute3%TYPE := NULL
27 , Attr4 mtl_transactions_interface.attribute4%TYPE := NULL
28 , Attr5 mtl_transactions_interface.attribute5%TYPE := NULL
29 , Attr6 mtl_transactions_interface.attribute6%TYPE := NULL
30 , Attr7 mtl_transactions_interface.attribute7%TYPE := NULL
31 , Attr8 mtl_transactions_interface.attribute8%TYPE := NULL
32 , Attr9 mtl_transactions_interface.attribute9%TYPE := NULL
33 , Attr10 mtl_transactions_interface.attribute10%TYPE := NULL
34 , Attr11 mtl_transactions_interface.attribute11%TYPE := NULL
35 , Attr12 mtl_transactions_interface.attribute12%TYPE := NULL
36 , Attr13 mtl_transactions_interface.attribute13%TYPE := NULL
37 , Attr14 mtl_transactions_interface.attribute14%TYPE := NULL
38 , Attr15 mtl_transactions_interface.attribute15%TYPE := NULL
39 );
40
41 --
42 -- Functions and Procedures
43 --
44 PROCEDURE Transfer
45 ( P_api_version IN NUMBER
46 , P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE
47 , P_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
48 , X_Return_Status OUT NOCOPY VARCHAR2
49 , X_Msg_Count OUT NOCOPY NUMBER
50 , X_Msg_Data OUT NOCOPY VARCHAR2
51 , P_Process_Mode IN NUMBER
52 , P_Transfer_Mode IN NUMBER
53 , P_Txn_Header_ID IN NUMBER
54 , P_Organization_ID IN NUMBER
55 , P_Item_ID IN NUMBER
56 , P_Category_Set_ID IN NUMBER
57 , P_Category_ID IN NUMBER
58 , P_From_Project_ID IN NUMBER
59 , P_From_Task_ID IN NUMBER
60 , P_To_Project_ID IN NUMBER
61 , P_To_Task_ID IN NUMBER
62 , P_Txn_Date IN DATE
63 , P_Acct_Period_ID IN NUMBER
64 , P_Txn_Reason_ID IN NUMBER
65 , P_Txn_Reference IN VARCHAR2
66 , P_DFF IN DFF_Rec_Type
67 , X_Txn_Header_ID OUT NOCOPY NUMBER
68 , X_Txn_Count OUT NOCOPY NUMBER
69 );
70
71
72 PROCEDURE Item_Transfer
73 ( P_api_version IN NUMBER
74 , P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE
75 , P_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
76 , X_Return_Status OUT NOCOPY VARCHAR2
77 , X_Msg_Count OUT NOCOPY NUMBER
78 , X_Msg_Data OUT NOCOPY VARCHAR2
79 , P_Process_Mode IN NUMBER
80 , P_Txn_Header_ID IN NUMBER
81 , P_Organization_ID IN NUMBER
82 , P_Item_ID IN NUMBER
83 , P_From_Project_ID IN NUMBER
84 , P_From_Task_ID IN NUMBER
85 , P_To_Project_ID IN NUMBER
86 , P_To_Task_ID IN NUMBER
87 , P_Txn_Date IN DATE
88 , P_Acct_Period_ID IN NUMBER
89 , P_Txn_Reason_ID IN NUMBER
90 , P_Txn_Reference IN VARCHAR2
91 , P_DFF IN DFF_Rec_Type
92 , X_Txn_Header_ID OUT NOCOPY NUMBER
93 , X_Txn_Count OUT NOCOPY NUMBER
94 );
95
96
97 PROCEDURE Mass_Transfer
98 ( P_api_version IN NUMBER
99 , P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE
100 , P_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
101 , X_Return_Status OUT NOCOPY VARCHAR2
102 , X_Msg_Count OUT NOCOPY NUMBER
103 , X_Msg_Data OUT NOCOPY VARCHAR2
104 , P_Transfer_ID IN NUMBER
105 , X_Txn_Header_ID OUT NOCOPY NUMBER
106 , X_Txn_Count OUT NOCOPY NUMBER
107 , X_Request_ID OUT NOCOPY NUMBER
108 );
109
110 END PJM_MASS_TRANSFER_PUB;