DBA Data[Home] [Help]

APPS.OKL_VP_JTF_PARTY_NAME_PVT dependencies on OKC_API

Line 3: TYPE party_rec_type is record (rle_code OKC_K_PARTY_ROLES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,

1: Package OKL_VP_JTF_PARTY_NAME_PVT AS
2: /* $Header: OKLRCTSS.pls 120.1 2005/09/08 12:44:58 sjalasut noship $ */
3: TYPE party_rec_type is record (rle_code OKC_K_PARTY_ROLES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
4: id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
5: id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
6: name VARCHAR2(250) := OKC_API.G_MISS_CHAR,
7: description VARCHAR2(250) := OKC_API.G_MISS_CHAR,

Line 4: id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,

1: Package OKL_VP_JTF_PARTY_NAME_PVT AS
2: /* $Header: OKLRCTSS.pls 120.1 2005/09/08 12:44:58 sjalasut noship $ */
3: TYPE party_rec_type is record (rle_code OKC_K_PARTY_ROLES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
4: id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
5: id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
6: name VARCHAR2(250) := OKC_API.G_MISS_CHAR,
7: description VARCHAR2(250) := OKC_API.G_MISS_CHAR,
8: object_code VARCHAR2(30) := OKC_API.G_MISS_CHAR);

Line 5: id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,

1: Package OKL_VP_JTF_PARTY_NAME_PVT AS
2: /* $Header: OKLRCTSS.pls 120.1 2005/09/08 12:44:58 sjalasut noship $ */
3: TYPE party_rec_type is record (rle_code OKC_K_PARTY_ROLES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
4: id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
5: id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
6: name VARCHAR2(250) := OKC_API.G_MISS_CHAR,
7: description VARCHAR2(250) := OKC_API.G_MISS_CHAR,
8: object_code VARCHAR2(30) := OKC_API.G_MISS_CHAR);
9: TYPE party_tab_type is table of party_rec_type INDEX BY BINARY_INTEGER;

Line 6: name VARCHAR2(250) := OKC_API.G_MISS_CHAR,

2: /* $Header: OKLRCTSS.pls 120.1 2005/09/08 12:44:58 sjalasut noship $ */
3: TYPE party_rec_type is record (rle_code OKC_K_PARTY_ROLES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
4: id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
5: id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
6: name VARCHAR2(250) := OKC_API.G_MISS_CHAR,
7: description VARCHAR2(250) := OKC_API.G_MISS_CHAR,
8: object_code VARCHAR2(30) := OKC_API.G_MISS_CHAR);
9: TYPE party_tab_type is table of party_rec_type INDEX BY BINARY_INTEGER;
10: TYPE rle_code_rec_type is record (scs_code OKC_SUBCLASS_ROLES.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,

Line 7: description VARCHAR2(250) := OKC_API.G_MISS_CHAR,

3: TYPE party_rec_type is record (rle_code OKC_K_PARTY_ROLES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
4: id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
5: id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
6: name VARCHAR2(250) := OKC_API.G_MISS_CHAR,
7: description VARCHAR2(250) := OKC_API.G_MISS_CHAR,
8: object_code VARCHAR2(30) := OKC_API.G_MISS_CHAR);
9: TYPE party_tab_type is table of party_rec_type INDEX BY BINARY_INTEGER;
10: TYPE rle_code_rec_type is record (scs_code OKC_SUBCLASS_ROLES.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
11: rle_code OKC_SUBCLASS_ROLES.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR);

Line 8: object_code VARCHAR2(30) := OKC_API.G_MISS_CHAR);

4: id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
5: id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
6: name VARCHAR2(250) := OKC_API.G_MISS_CHAR,
7: description VARCHAR2(250) := OKC_API.G_MISS_CHAR,
8: object_code VARCHAR2(30) := OKC_API.G_MISS_CHAR);
9: TYPE party_tab_type is table of party_rec_type INDEX BY BINARY_INTEGER;
10: TYPE rle_code_rec_type is record (scs_code OKC_SUBCLASS_ROLES.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
11: rle_code OKC_SUBCLASS_ROLES.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR);
12: TYPE rle_code_tbl_type is table of rle_code_rec_type INDEX BY BINARY_INTEGER;

Line 10: TYPE rle_code_rec_type is record (scs_code OKC_SUBCLASS_ROLES.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,

6: name VARCHAR2(250) := OKC_API.G_MISS_CHAR,
7: description VARCHAR2(250) := OKC_API.G_MISS_CHAR,
8: object_code VARCHAR2(30) := OKC_API.G_MISS_CHAR);
9: TYPE party_tab_type is table of party_rec_type INDEX BY BINARY_INTEGER;
10: TYPE rle_code_rec_type is record (scs_code OKC_SUBCLASS_ROLES.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
11: rle_code OKC_SUBCLASS_ROLES.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR);
12: TYPE rle_code_tbl_type is table of rle_code_rec_type INDEX BY BINARY_INTEGER;
13:
14: --Start of Comments

Line 11: rle_code OKC_SUBCLASS_ROLES.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR);

7: description VARCHAR2(250) := OKC_API.G_MISS_CHAR,
8: object_code VARCHAR2(30) := OKC_API.G_MISS_CHAR);
9: TYPE party_tab_type is table of party_rec_type INDEX BY BINARY_INTEGER;
10: TYPE rle_code_rec_type is record (scs_code OKC_SUBCLASS_ROLES.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
11: rle_code OKC_SUBCLASS_ROLES.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR);
12: TYPE rle_code_tbl_type is table of rle_code_rec_type INDEX BY BINARY_INTEGER;
13:
14: --Start of Comments
15: --API Name : Get_Party

Line 19: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,

15: --API Name : Get_Party
16: --Description : Fetches all parties attahced to a contract or line in a table
17: --End of Comments
18: Procedure Get_Party (p_api_version IN NUMBER,
19: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
20: x_return_status OUT NOCOPY VARCHAR2,
21: x_msg_count OUT NOCOPY NUMBER,
22: x_msg_data OUT NOCOPY VARCHAR2,
23: p_chr_id IN VARCHAR2,

Line 34: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,

30: --Description : Fetches Name, Description of a Party role for a given
31: -- object1_id1 and object2_id2
32: --End of comments
33: Procedure Get_Party (p_api_version IN NUMBER,
34: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
35: x_return_status OUT NOCOPY VARCHAR2,
36: x_msg_count OUT NOCOPY NUMBER,
37: x_msg_data OUT NOCOPY VARCHAR2,
38: p_role_code IN VARCHAR2,

Line 57: TYPE contact_rec_type is record (cro_code OKC_CONTACTS_V.cro_code%TYPE := OKC_API.G_MISS_CHAR,

53: --Start of Comments
54: --Procedure : Get contact
55: --Description : Returns the SQL string for LOV of a contact
56: --End of Comments
57: TYPE contact_rec_type is record (cro_code OKC_CONTACTS_V.cro_code%TYPE := OKC_API.G_MISS_CHAR,
58: id1 OKC_CONTACTS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
59: id2 OKC_CONTACTS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
60: name VARCHAR2(250) := OKC_API.G_MISS_CHAR,
61: description VARCHAR2(250) := OKC_API.G_MISS_CHAR,

Line 58: id1 OKC_CONTACTS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,

54: --Procedure : Get contact
55: --Description : Returns the SQL string for LOV of a contact
56: --End of Comments
57: TYPE contact_rec_type is record (cro_code OKC_CONTACTS_V.cro_code%TYPE := OKC_API.G_MISS_CHAR,
58: id1 OKC_CONTACTS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
59: id2 OKC_CONTACTS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
60: name VARCHAR2(250) := OKC_API.G_MISS_CHAR,
61: description VARCHAR2(250) := OKC_API.G_MISS_CHAR,
62: object_code VARCHAR2(30) := OKC_API.G_MISS_CHAR);

Line 59: id2 OKC_CONTACTS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,

55: --Description : Returns the SQL string for LOV of a contact
56: --End of Comments
57: TYPE contact_rec_type is record (cro_code OKC_CONTACTS_V.cro_code%TYPE := OKC_API.G_MISS_CHAR,
58: id1 OKC_CONTACTS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
59: id2 OKC_CONTACTS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
60: name VARCHAR2(250) := OKC_API.G_MISS_CHAR,
61: description VARCHAR2(250) := OKC_API.G_MISS_CHAR,
62: object_code VARCHAR2(30) := OKC_API.G_MISS_CHAR);
63: TYPE contact_tab_type is table of contact_rec_type INDEX BY BINARY_INTEGER;

Line 60: name VARCHAR2(250) := OKC_API.G_MISS_CHAR,

56: --End of Comments
57: TYPE contact_rec_type is record (cro_code OKC_CONTACTS_V.cro_code%TYPE := OKC_API.G_MISS_CHAR,
58: id1 OKC_CONTACTS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
59: id2 OKC_CONTACTS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
60: name VARCHAR2(250) := OKC_API.G_MISS_CHAR,
61: description VARCHAR2(250) := OKC_API.G_MISS_CHAR,
62: object_code VARCHAR2(30) := OKC_API.G_MISS_CHAR);
63: TYPE contact_tab_type is table of contact_rec_type INDEX BY BINARY_INTEGER;
64: Procedure Get_Contact(p_api_version IN NUMBER,

Line 61: description VARCHAR2(250) := OKC_API.G_MISS_CHAR,

57: TYPE contact_rec_type is record (cro_code OKC_CONTACTS_V.cro_code%TYPE := OKC_API.G_MISS_CHAR,
58: id1 OKC_CONTACTS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
59: id2 OKC_CONTACTS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
60: name VARCHAR2(250) := OKC_API.G_MISS_CHAR,
61: description VARCHAR2(250) := OKC_API.G_MISS_CHAR,
62: object_code VARCHAR2(30) := OKC_API.G_MISS_CHAR);
63: TYPE contact_tab_type is table of contact_rec_type INDEX BY BINARY_INTEGER;
64: Procedure Get_Contact(p_api_version IN NUMBER,
65: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,

Line 62: object_code VARCHAR2(30) := OKC_API.G_MISS_CHAR);

58: id1 OKC_CONTACTS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
59: id2 OKC_CONTACTS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
60: name VARCHAR2(250) := OKC_API.G_MISS_CHAR,
61: description VARCHAR2(250) := OKC_API.G_MISS_CHAR,
62: object_code VARCHAR2(30) := OKC_API.G_MISS_CHAR);
63: TYPE contact_tab_type is table of contact_rec_type INDEX BY BINARY_INTEGER;
64: Procedure Get_Contact(p_api_version IN NUMBER,
65: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
66: x_return_status OUT NOCOPY VARCHAR2,

Line 65: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,

61: description VARCHAR2(250) := OKC_API.G_MISS_CHAR,
62: object_code VARCHAR2(30) := OKC_API.G_MISS_CHAR);
63: TYPE contact_tab_type is table of contact_rec_type INDEX BY BINARY_INTEGER;
64: Procedure Get_Contact(p_api_version IN NUMBER,
65: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
66: x_return_status OUT NOCOPY VARCHAR2,
67: x_msg_count OUT NOCOPY NUMBER,
68: x_msg_data OUT NOCOPY VARCHAR2,
69: p_rle_code IN VARCHAR2,