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 1791: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */

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

Line 1794: P_Source_Ver_Tbl IN SYSTEM.pa_num_tbl_type,

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

Line 1795: P_Destin_Ver_Tbl IN SYSTEM.pa_num_tbl_type,

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

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

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

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

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

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

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

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

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

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

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

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

2388: /* Commented the following procedure code and rewritten the logic for procedure */
2389: /* Copy_Inter_Project_Dependency */
2390: /*Procedure Copy_Inter_Project_Dependency ( */
2391: /* Bug #: 3305199 SMukka */
2392: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
2393: /* P_Source_Ver_Tbl IN PA_PLSQL_DATATYPES.IdTabTyp, */
2394: /* P_Destin_Ver_Tbl IN PA_PLSQL_DATATYPES.IdTabTyp, */
2395: /* P_Source_Ver_Tbl IN SYSTEM.pa_num_tbl_type,
2396: P_Destin_Ver_Tbl IN SYSTEM.pa_num_tbl_type,

Line 2395: /* P_Source_Ver_Tbl IN SYSTEM.pa_num_tbl_type,

2391: /* Bug #: 3305199 SMukka */
2392: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
2393: /* P_Source_Ver_Tbl IN PA_PLSQL_DATATYPES.IdTabTyp, */
2394: /* P_Destin_Ver_Tbl IN PA_PLSQL_DATATYPES.IdTabTyp, */
2395: /* P_Source_Ver_Tbl IN SYSTEM.pa_num_tbl_type,
2396: P_Destin_Ver_Tbl IN SYSTEM.pa_num_tbl_type,
2397: X_Return_Status OUT VARCHAR2,
2398: X_Msg_Count OUT NUMBER,
2399: X_Msg_Data OUT VARCHAR2

Line 2396: P_Destin_Ver_Tbl IN SYSTEM.pa_num_tbl_type,

2392: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
2393: /* P_Source_Ver_Tbl IN PA_PLSQL_DATATYPES.IdTabTyp, */
2394: /* P_Destin_Ver_Tbl IN PA_PLSQL_DATATYPES.IdTabTyp, */
2395: /* P_Source_Ver_Tbl IN SYSTEM.pa_num_tbl_type,
2396: P_Destin_Ver_Tbl IN SYSTEM.pa_num_tbl_type,
2397: X_Return_Status OUT VARCHAR2,
2398: X_Msg_Count OUT NUMBER,
2399: X_Msg_Data OUT VARCHAR2
2400: ) IS

Line 2481: P_Source_Ver_Tbl IN SYSTEM.pa_num_tbl_type,

2477: End Copy_Inter_Project_Dependency;*/
2478:
2479:
2480: Procedure Copy_Inter_Project_Dependency (
2481: P_Source_Ver_Tbl IN SYSTEM.pa_num_tbl_type,
2482: P_Destin_Ver_Tbl IN SYSTEM.pa_num_tbl_type,
2483: X_Return_Status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2484: X_Msg_Count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2485: X_Msg_Data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2482: P_Destin_Ver_Tbl IN SYSTEM.pa_num_tbl_type,

2478:
2479:
2480: Procedure Copy_Inter_Project_Dependency (
2481: P_Source_Ver_Tbl IN SYSTEM.pa_num_tbl_type,
2482: P_Destin_Ver_Tbl IN SYSTEM.pa_num_tbl_type,
2483: X_Return_Status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2484: X_Msg_Count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2485: X_Msg_Data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2486: ) IS