APPS.RRS_HIERARCHY_CRUD_PKG dependencies on RRS_HIER_MEMBERS_COARSE_TAB

Line 484: p_hier_members_tab IN RRS_HIER_MEMBERS_COARSE_TAB DEFAULT NULL,

480: p_hier_description IN VARCHAR2 DEFAULT NULL,
481: p_hier_purpose_code IN VARCHAR2 DEFAULT NULL,
482: p_hier_start_date IN DATE DEFAULT NULL,
483: p_hier_end_date IN DATE DEFAULT NULL,
484: p_hier_members_tab IN RRS_HIER_MEMBERS_COARSE_TAB DEFAULT NULL,
485: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
486: x_return_status OUT NOCOPY varchar2,
487: x_msg_count OUT NOCOPY NUMBER,
488: x_msg_data OUT NOCOPY VARCHAR2

Line 908: p_hier_members_tab IN RRS_HIER_MEMBERS_COARSE_TAB,

904: p_hier_id IN NUMBER,
905: p_root_id IN NUMBER,
906: p_root_number IN VARCHAR2,
907: p_hier_purpose_code IN VARCHAR2,
908: p_hier_members_tab IN RRS_HIER_MEMBERS_COARSE_TAB,
909: x_return_status OUT NOCOPY varchar2,
910: x_msg_count OUT NOCOPY NUMBER,
911: x_msg_data OUT NOCOPY VARCHAR2
912: )IS

Line 1573: p_hier_members_tab IN RRS_HIER_MEMBERS_COARSE_TAB DEFAULT NULL,

1569: p_hier_description IN VARCHAR2 DEFAULT NULL,
1570: p_hier_purpose_code IN VARCHAR2 DEFAULT NULL,
1571: p_hier_start_date IN DATE DEFAULT NULL,
1572: p_hier_end_date IN DATE DEFAULT NULL,
1573: p_hier_members_tab IN RRS_HIER_MEMBERS_COARSE_TAB DEFAULT NULL,
1574: p_nullify_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1575: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1576: x_return_status OUT NOCOPY varchar2,
1577: x_msg_count OUT NOCOPY NUMBER,

Line 2739: v_tab RRS_HIER_MEMBERS_COARSE_TAB;

2735: v_desc VARCHAR2(30) := 'test desc';
2736: v_purp VARCHAR2(30) := 'OPER';
2737: v_sd DATE := TO_DATE('jan 23 2009', 'MON DD YYYY');
2738: v_ed DATE := TO_DATE('DEC 23 2009', 'MON DD YYYY');
2739: v_tab RRS_HIER_MEMBERS_COARSE_TAB;
2740: x_return_status VARCHAR2(30);
2741: x_msg_count NUMBER;
2742: x_msg_data VARCHAR2(30);
2743: BEGIN

Line 2745: v_tab := RRS_HIER_MEMBERS_COARSE_TAB();

2741: x_msg_count NUMBER;
2742: x_msg_data VARCHAR2(30);
2743: BEGIN
2744:
2745: v_tab := RRS_HIER_MEMBERS_COARSE_TAB();
2746: v_tab.EXTEND();
2747: v_tab(1) := RRS_HIER_MEMBERS_COARSE_REC('NONE', NULL, 'NONE', 'NODE', NULL, 'ROOT_R0005', 0, 'R0005', NULL, 'ROOT');
2748: v_tab.EXTEND();
2749: v_tab(2) := RRS_HIER_MEMBERS_COARSE_REC('NODE', NULL, 'ROOT_R0005', 'SITE', 10141, NULL, 10, NULL, NULL, NULL);

Line 2780: v_tab RRS_HIER_MEMBERS_COARSE_TAB;

2776: v_desc VARCHAR2(30) := 'TEST ROUTE';
2777: v_purp VARCHAR2(30) := 'OPER2';
2778: v_sd DATE := TO_DATE('jan 24 2009', 'MON DD YYYY');
2779: v_ed DATE := TO_DATE('DEC 23 2009', 'MON DD YYYY');
2780: v_tab RRS_HIER_MEMBERS_COARSE_TAB;
2781: x_return_status VARCHAR2(30);
2782: x_msg_count NUMBER;
2783: x_msg_data VARCHAR2(30);
2784: BEGIN

Line 2786: v_tab := RRS_HIER_MEMBERS_COARSE_TAB();

2782: x_msg_count NUMBER;
2783: x_msg_data VARCHAR2(30);
2784: BEGIN
2785:
2786: v_tab := RRS_HIER_MEMBERS_COARSE_TAB();
2787:
2788: v_tab.EXTEND();
2789: v_tab(1) := RRS_HIER_MEMBERS_COARSE_REC('NONE', -1, NULL, 'NODE', 10003, NULL, 0, NULL, NULL, 'ROOT');
2790: v_tab.EXTEND();