PACKAGE: APPS.IBY_EXT_PAYEE_RELSHIPS_PKG

Source

1 PACKAGE IBY_EXT_PAYEE_RELSHIPS_PKG AUTHID CURRENT_USER AS
2 /*$Header: ibyprels.pls 120.5 2011/02/18 09:37:37 pschalla noship $*/
3 
4 
5 G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBY_EXT_PAYEE_RELSHIPS_PKG';
6 
7 PROCEDURE print_debuginfo(
8     p_message_text IN VARCHAR2 );
9 
10 PROCEDURE default_Ext_Payee_Relationship(
11     p_party_id               IN NUMBER,
12     p_supplier_site_id       IN NUMBER,
13     p_date                   IN DATE,
14     x_remit_party_id         IN OUT NOCOPY NUMBER,
15     x_remit_supplier_site_id IN OUT NOCOPY NUMBER,
16     x_relationship_id        IN OUT NOCOPY NUMBER );
17 
18 PROCEDURE import_Ext_Payee_Relationship(
19     p_party_id               IN NUMBER,
20     p_supplier_site_id       IN NUMBER,
21     p_date                   IN DATE,
22     x_result                 IN OUT NOCOPY VARCHAR2,
23     x_remit_party_id         IN OUT NOCOPY NUMBER,
24     x_remit_supplier_site_id IN OUT NOCOPY NUMBER,
25     x_relationship_id        IN OUT NOCOPY NUMBER );
26 
27 Type Payee_Relationship_Rec_Type
28 IS
29   Record
30   (
31     relationship_id iby_ext_payee_relationships.relationship_id%TYPE,
32     party_id iby_ext_payee_relationships.party_id%TYPE,
33     supplier_site_id iby_ext_payee_relationships.supplier_site_id%TYPE,
34     remit_party_id iby_ext_payee_relationships.remit_party_id%TYPE,
35     remit_supplier_site_id iby_ext_payee_relationships.remit_supplier_site_id%TYPE,
36     from_date iby_ext_payee_relationships.from_date%TYPE,
37     to_date iby_ext_payee_relationships.to_date%TYPE,
38     primary_flag iby_ext_payee_relationships.primary_flag%TYPE,
39     additional_information iby_ext_payee_relationships.additional_information%TYPE,
40     active iby_ext_payee_relationships.active%TYPE,
41     created_by iby_ext_payee_relationships.created_by%TYPE,
42     creation_date iby_ext_payee_relationships.creation_date%TYPE,
43     last_updated_by iby_ext_payee_relationships.last_updated_by%TYPE,
44     last_update_date iby_ext_payee_relationships.last_update_date%TYPE,
45     last_update_login iby_ext_payee_relationships.last_update_login%TYPE,
46     object_version_number iby_ext_payee_relationships.object_version_number%TYPE,
47     attribute_category iby_ext_payee_relationships.attribute_category%TYPE,
48     attribute1 iby_ext_payee_relationships.attribute1%TYPE,
49     attribute2 iby_ext_payee_relationships.attribute2%TYPE,
50     attribute3 iby_ext_payee_relationships.attribute3%TYPE,
51     attribute4 iby_ext_payee_relationships.attribute4%TYPE,
52     attribute5 iby_ext_payee_relationships.attribute5%TYPE,
53     attribute6 iby_ext_payee_relationships.attribute6%TYPE,
54     attribute7 iby_ext_payee_relationships.attribute7%TYPE,
55     attribute8 iby_ext_payee_relationships.attribute8%TYPE,
56     attribute9 iby_ext_payee_relationships.attribute9%TYPE,
57     attribute10 iby_ext_payee_relationships.attribute10%TYPE,
58     attribute11 iby_ext_payee_relationships.attribute11%TYPE,
59     attribute12 iby_ext_payee_relationships.attribute12%TYPE,
60     attribute13 iby_ext_payee_relationships.attribute13%TYPE,
61     attribute14 iby_ext_payee_relationships.attribute14%TYPE,
62     attribute15 iby_ext_payee_relationships.attribute15%TYPE );
63 
64 TYPE Payee_Relationship_Tab_Type
65 IS
66   TABLE OF Payee_Relationship_Rec_Type INDEX BY BINARY_INTEGER;
67 
68 PROCEDURE create_Ext_Payee_Relationship(
69     p_api_version   IN NUMBER,
70     p_relationship  IN Payee_Relationship_Rec_Type,
71     x_return_status OUT NOCOPY      VARCHAR2,
72     x_relationship_id IN OUT NOCOPY NUMBER );
73 
74 PROCEDURE update_Ext_Payee_Relationship(
75     p_api_version   IN NUMBER,
76     p_relationship  IN Payee_Relationship_Rec_Type,
77     x_return_status OUT NOCOPY      VARCHAR2,
78     x_relationship_id IN OUT NOCOPY NUMBER);
79 
80 PROCEDURE validate_Payee_Relationship(
81     p_relationship  IN Payee_Relationship_Rec_Type,
82     p_action_mode IN VARCHAR2,
83     x_return_status OUT NOCOPY      VARCHAR2);
84 
85 END IBY_EXT_PAYEE_RELSHIPS_PKG;