eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_RELATIONSHIP_PVT dependencies on PA_NUM_TBL_TYPE

Line 1793: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */

1789:
1790: -- Added for FP_M changes 3305199
1791: Procedure Copy_Intra_Dependency (
1792: /* Bug #: 3305199 SMukka */
1793: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
1794: /* P_Source_Ver_Tbl IN PA_PLSQL_DATATYPES.IdTabTyp, */
1795: /* P_Destin_Ver_Tbl IN PA_PLSQL_DATATYPES.IdTabTyp, */
1796: P_Source_Ver_Tbl IN SYSTEM.pa_num_tbl_type,
1797: P_Destin_Ver_Tbl IN SYSTEM.pa_num_tbl_type,

Line 1796: P_Source_Ver_Tbl IN SYSTEM.pa_num_tbl_type,

1792: /* Bug #: 3305199 SMukka */
1793: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
1794: /* P_Source_Ver_Tbl IN PA_PLSQL_DATATYPES.IdTabTyp, */
1795: /* P_Destin_Ver_Tbl IN PA_PLSQL_DATATYPES.IdTabTyp, */
1796: P_Source_Ver_Tbl IN SYSTEM.pa_num_tbl_type,
1797: P_Destin_Ver_Tbl IN SYSTEM.pa_num_tbl_type,
1798: P_source_struc_ver_id IN NUMBER := NULL,
1799: p_dest_struc_ver_id IN NUMBER := NULL,
1800: X_Return_Status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 1797: P_Destin_Ver_Tbl IN SYSTEM.pa_num_tbl_type,

1793: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
1794: /* P_Source_Ver_Tbl IN PA_PLSQL_DATATYPES.IdTabTyp, */
1795: /* P_Destin_Ver_Tbl IN PA_PLSQL_DATATYPES.IdTabTyp, */
1796: P_Source_Ver_Tbl IN SYSTEM.pa_num_tbl_type,
1797: P_Destin_Ver_Tbl IN SYSTEM.pa_num_tbl_type,
1798: P_source_struc_ver_id IN NUMBER := NULL,
1799: p_dest_struc_ver_id IN NUMBER := NULL,
1800: X_Return_Status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1801: X_Msg_Count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 1883: l_pred_ver_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1879: and rownum = 1;
1880: l_dummy NUMBER;
1881:
1882: --bug 4153377
1883: l_pred_ver_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1884: l_pred_proj_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1885: l_suc_ver_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1886: l_suc_proj_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1887: l_comment_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();

Line 1884: l_pred_proj_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1880: l_dummy NUMBER;
1881:
1882: --bug 4153377
1883: l_pred_ver_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1884: l_pred_proj_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1885: l_suc_ver_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1886: l_suc_proj_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1887: l_comment_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
1888: l_subtype_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 1885: l_suc_ver_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1881:
1882: --bug 4153377
1883: l_pred_ver_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1884: l_pred_proj_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1885: l_suc_ver_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1886: l_suc_proj_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1887: l_comment_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
1888: l_subtype_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1889: l_lag_days_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 1886: l_suc_proj_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1882: --bug 4153377
1883: l_pred_ver_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1884: l_pred_proj_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1885: l_suc_ver_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1886: l_suc_proj_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1887: l_comment_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
1888: l_subtype_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1889: l_lag_days_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1890:

Line 1889: l_lag_days_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1885: l_suc_ver_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1886: l_suc_proj_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1887: l_comment_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
1888: l_subtype_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1889: l_lag_days_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1890:
1891: CURSOR get_dependency2 IS
1892: select /*+ leading(dt1) use_nl(dt1 rel) */ -- hint added per performance team recommendation for bug 5576900
1893: rel.object_id_from1, dt1.dest_task_ver_id DEST_FROM_ID,

Line 2400: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */

2396: /* Commented the following procedure code and rewritten the logic for procedure */
2397: /* Copy_Inter_Project_Dependency */
2398: /*Procedure Copy_Inter_Project_Dependency ( */
2399: /* Bug #: 3305199 SMukka */
2400: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
2401: /* P_Source_Ver_Tbl IN PA_PLSQL_DATATYPES.IdTabTyp, */
2402: /* P_Destin_Ver_Tbl IN PA_PLSQL_DATATYPES.IdTabTyp, */
2403: /* P_Source_Ver_Tbl IN SYSTEM.pa_num_tbl_type,
2404: P_Destin_Ver_Tbl IN SYSTEM.pa_num_tbl_type,

Line 2403: /* P_Source_Ver_Tbl IN SYSTEM.pa_num_tbl_type,

2399: /* Bug #: 3305199 SMukka */
2400: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
2401: /* P_Source_Ver_Tbl IN PA_PLSQL_DATATYPES.IdTabTyp, */
2402: /* P_Destin_Ver_Tbl IN PA_PLSQL_DATATYPES.IdTabTyp, */
2403: /* P_Source_Ver_Tbl IN SYSTEM.pa_num_tbl_type,
2404: P_Destin_Ver_Tbl IN SYSTEM.pa_num_tbl_type,
2405: X_Return_Status OUT VARCHAR2,
2406: X_Msg_Count OUT NUMBER,
2407: X_Msg_Data OUT VARCHAR2

Line 2404: P_Destin_Ver_Tbl IN SYSTEM.pa_num_tbl_type,

2400: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
2401: /* P_Source_Ver_Tbl IN PA_PLSQL_DATATYPES.IdTabTyp, */
2402: /* P_Destin_Ver_Tbl IN PA_PLSQL_DATATYPES.IdTabTyp, */
2403: /* P_Source_Ver_Tbl IN SYSTEM.pa_num_tbl_type,
2404: P_Destin_Ver_Tbl IN SYSTEM.pa_num_tbl_type,
2405: X_Return_Status OUT VARCHAR2,
2406: X_Msg_Count OUT NUMBER,
2407: X_Msg_Data OUT VARCHAR2
2408: ) IS

Line 2489: P_Source_Ver_Tbl IN SYSTEM.pa_num_tbl_type,

2485: End Copy_Inter_Project_Dependency;*/
2486:
2487:
2488: Procedure Copy_Inter_Project_Dependency (
2489: P_Source_Ver_Tbl IN SYSTEM.pa_num_tbl_type,
2490: P_Destin_Ver_Tbl IN SYSTEM.pa_num_tbl_type,
2491: X_Return_Status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2492: X_Msg_Count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2493: X_Msg_Data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2490: P_Destin_Ver_Tbl IN SYSTEM.pa_num_tbl_type,

2486:
2487:
2488: Procedure Copy_Inter_Project_Dependency (
2489: P_Source_Ver_Tbl IN SYSTEM.pa_num_tbl_type,
2490: P_Destin_Ver_Tbl IN SYSTEM.pa_num_tbl_type,
2491: X_Return_Status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2492: X_Msg_Count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2493: X_Msg_Data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2494: ) IS