PACKAGE: APPS.JTF_RS_IMP_RES_PVT

Source

1 PACKAGE jtf_rs_imp_res_pvt AUTHID CURRENT_USER AS
2   /* $Header: jtfrsvus.pls 120.1 2005/06/07 23:05:02 baianand ship $ */
3 
4   TYPE imp_rec_type IS RECORD (
5     role_id                jtf_rs_roles_b.role_id%TYPE,
6     rs_start_date_active   jtf_rs_resource_extns.start_date_active%TYPE,
7     rs_end_date_active     jtf_rs_resource_extns.end_date_active%TYPE,
8     role_start_date_active jtf_rs_role_relations.start_date_active%TYPE,
9     role_end_date_active   jtf_rs_role_relations.end_date_active%TYPE,
10     sales_credit_type_id   jtf_rs_salesreps.sales_credit_type_id%TYPE,
11     org_id                 jtf_rs_salesreps.org_id%TYPE,
12     resource_id            jtf_rs_resource_extns.resource_id%TYPE,
13     category               jtf_rs_resource_extns.category%TYPE,
14     person_id              jtf_rs_resource_extns.source_id%TYPE,
15     contact_id             jtf_rs_resource_extns.contact_id%TYPE,
16     user_id                jtf_rs_resource_extns.user_id%TYPE,
17     name                   jtf_rs_resource_extns.source_name%TYPE,
18     user_name              jtf_rs_resource_extns.user_name%TYPE,
19     address_id             jtf_rs_resource_extns.address_id%TYPE,
20     salesperson_number     jtf_rs_salesreps.salesrep_number%TYPE,
21     selected               VARCHAR2(1),
22     comment_code           VARCHAR2(30),
23     create_salesperson     VARCHAR2(1)
24   );
25 
26   TYPE imp_tbl_type IS TABLE OF imp_rec_type
27   INDEX BY BINARY_INTEGER;
28 
29   TYPE res_id_rec_type IS RECORD (
30     res_id            jtf_rs_resource_extns.resource_id%TYPE
31   );
32 
33   TYPE res_id_tbl_type is TABLE OF res_id_rec_type
34   INDEX BY BINARY_INTEGER;
35 
36   PROCEDURE import_resources (
37    P_API_VERSION     IN   NUMBER,
38    P_INIT_MSG_LIST   IN   VARCHAR2   DEFAULT  FND_API.G_FALSE,
39    P_COMMIT          IN   VARCHAR2   DEFAULT  FND_API.G_FALSE,
40    P_IMP_RES_TBL     IN   imp_tbl_type,
41    X_RES_ID_TBL      OUT NOCOPY res_id_tbl_type,
42    X_TRANSACTION_NUM OUT NOCOPY NUMBER,
43    X_RETURN_STATUS   OUT NOCOPY VARCHAR2,
44    X_MSG_COUNT       OUT NOCOPY NUMBER,
45    X_MSG_DATA        OUT NOCOPY VARCHAR2
46   );
47 
48 END jtf_rs_imp_res_pvt;