APPS.JTF_TAE_ASSIGN_PUB dependencies on JTF_TAE_GEN_PVT

Line 1399: p_sql OUT NOCOPY JTF_TAE_GEN_PVT.terrsql_tbl_type,

1395: p_source_id IN NUMBER,
1396: p_trans_object_type_id IN NUMBER,
1397: p_view_name IN VARCHAR2,
1398: x_return_status OUT NOCOPY VARCHAR2,
1399: p_sql OUT NOCOPY JTF_TAE_GEN_PVT.terrsql_tbl_type,
1400: x_msg_count OUT NOCOPY NUMBER,
1401: x_msg_data OUT NOCOPY VARCHAR2,
1402: ERRBUF OUT NOCOPY VARCHAR2,
1403: RETCODE OUT NOCOPY VARCHAR2

Line 1411: JTF_TAE_GEN_PVT.gen_details_for_terr_change(

1407: l_qual_type_id number := p_trans_object_type_id;
1408: l_view_name VARCHAR2(30) := p_view_name;
1409: BEGIN
1410: --dbms_output.put_line(' Get_SQL_For_Changes :BEGINS ');
1411: JTF_TAE_GEN_PVT.gen_details_for_terr_change(
1412: p_source_id => l_source_id, --IN NUMBER,
1413: p_qual_type_id => l_qual_type_id, --IN NUMBER,
1414: p_view_name => l_view_name, --IN VARCHAR2,
1415: p_sql => p_sql --OUT NOCOPY terrsql_tbl_type

Line 1417: --dbms_output.put_line('JTF_TAE_GEN_PVT.gen_details_for_terr_change returned');

1413: p_qual_type_id => l_qual_type_id, --IN NUMBER,
1414: p_view_name => l_view_name, --IN VARCHAR2,
1415: p_sql => p_sql --OUT NOCOPY terrsql_tbl_type
1416: );
1417: --dbms_output.put_line('JTF_TAE_GEN_PVT.gen_details_for_terr_change returned');
1418:
1419: /* Program completed successfully */
1420: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_SQL_FOR_CHANGES: Successfully completed.';
1421: x_return_status := FND_API.G_RET_STS_SUCCESS;