DBA Data[Home] [Help]

APPS.HZ_HIERARCHY_PUB dependencies on HZ_HIERARCHY_PUB

Line 1: PACKAGE BODY HZ_HIERARCHY_PUB AS

1: PACKAGE BODY HZ_HIERARCHY_PUB AS
2: /*$Header: ARHHINSB.pls 120.20.12020000.2 2012/07/18 12:14:45 rgokavar ship $ */
3:
4: -----------------------------------------
5: -- declaration of private global varibles

Line 20: l_module_prefix CONSTANT VARCHAR2(30) := 'HZ:ARHHINSB:HZ_HIERARCHY_PUB ';

16: l_table_owner VARCHAR2(255);
17: l_tmp VARCHAR2(2000);
18: l_line_number NUMBER;
19:
20: l_module_prefix CONSTANT VARCHAR2(30) := 'HZ:ARHHINSB:HZ_HIERARCHY_PUB ';
21: l_module CONSTANT VARCHAR2(30) := 'HIERARCHY_NODE';
22: l_debug_prefix VARCHAR2(30) ;
23:
24: --------------------------------------------------

Line 1970: l_hierarchy_rec HZ_HIERARCHY_PUB.HIERARCHY_NODE_REC_TYPE;

1966:
1967: r1 c1%ROWTYPE;
1968: r2 c2%ROWTYPE;
1969: r_parent c_parent%ROWTYPE;
1970: l_hierarchy_rec HZ_HIERARCHY_PUB.HIERARCHY_NODE_REC_TYPE;
1971: l_return_status VARCHAR2(1);
1972: l_msg_count NUMBER;
1973: l_msg_data VARCHAR2(2000);
1974: l_count NUMBER;

Line 2124: HZ_HIERARCHY_PUB.create_link(

2120: l_hierarchy_rec.relationship_id := r1.relationship_id;
2121: l_hierarchy_rec.status := NVL(r1.status, 'A');
2122: END IF;
2123:
2124: HZ_HIERARCHY_PUB.create_link(
2125: p_init_msg_list => FND_API.G_FALSE,
2126: p_hierarchy_node_rec => l_hierarchy_rec,
2127: x_return_status => l_return_status,
2128: x_msg_count => l_msg_count,

Line 2174: END HZ_HIERARCHY_PUB;

2170: END IF;
2171:
2172: END convert_rel_type;
2173:
2174: END HZ_HIERARCHY_PUB;