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.MST_RELEASE dependencies on WSH_TP_RELEASE_GRP

Line 69: g_tp_release_code := wsh_tp_release_grp.G_TP_RELEASE_CODE;

65:
66: l_mode_of_transport varchar2(30);
67: begin
68: --g_release_type
69: g_tp_release_code := wsh_tp_release_grp.G_TP_RELEASE_CODE;
70:
71: g_cnt_group_released := 0;
72: g_cnt_group_failed := 0;
73: g_cnt_group_not_attempted := 0;

Line 1175: , p_group_tab out nocopy wsh_tp_release_grp.id_tab_type

1171: end remove_grp_of_unwanted_trip;
1172: */
1173:
1174: procedure reset_grp_ids_in_sequence_of_1(x_return_status out nocopy varchar2
1175: , p_group_tab out nocopy wsh_tp_release_grp.id_tab_type
1176: , p_plan_id in pls_integer
1177: , p_release_id in pls_integer) is
1178: l_count pls_integer;
1179: l_group_id pls_integer;

Line 2531: , p_group_tab in wsh_tp_release_grp.id_tab_type

2527: set_concurrent_status('ERROR',get_seeded_message('MST_REL_BK_MESSAGE_47') || to_char(sqlcode) || ':' || SQLERRM);
2528: end update_sr_ids_in_mdd;
2529:
2530: procedure update_tp_tables (x_return_status out nocopy varchar2
2531: , p_group_tab in wsh_tp_release_grp.id_tab_type
2532: , p_plan_id in number
2533: , p_release_id in pls_integer
2534: , p_release_mode in number
2535: , p_release_start_date in date) is

Line 2543: and wie.interface_action_code = wsh_tp_release_grp.G_TP_RELEASE_CODE;

2539: is
2540: select 1
2541: from wsh_interface_errors wie
2542: where wie.interface_error_group_id = l_group_id
2543: and wie.interface_action_code = wsh_tp_release_grp.G_TP_RELEASE_CODE;
2544:
2545: --cursor to log error message into log file after pulling from wsh_interface_errors
2546: cursor cur_log_error (l_group_id in pls_integer)
2547: is

Line 2551: and wie.interface_action_code = wsh_tp_release_grp.G_TP_RELEASE_CODE

2547: is
2548: select error_message
2549: from wsh_interface_errors wie
2550: where wie.interface_error_group_id = l_group_id
2551: and wie.interface_action_code = wsh_tp_release_grp.G_TP_RELEASE_CODE
2552: order by wie.interface_error_id;
2553:
2554: l_dummy pls_integer;
2555: l_error_found pls_integer := 0;

Line 2991: l_group_tab wsh_tp_release_grp.id_tab_type;

2987: where release_id = l_release_id;
2988:
2989: l_dummy pls_integer := null;
2990:
2991: l_group_tab wsh_tp_release_grp.id_tab_type;
2992: l_input_rec wsh_tp_release_grp.input_rec_type;
2993: l_output_rec wsh_tp_release_grp.output_rec_type;
2994:
2995: l_return_status varchar2(1);

Line 2992: l_input_rec wsh_tp_release_grp.input_rec_type;

2988:
2989: l_dummy pls_integer := null;
2990:
2991: l_group_tab wsh_tp_release_grp.id_tab_type;
2992: l_input_rec wsh_tp_release_grp.input_rec_type;
2993: l_output_rec wsh_tp_release_grp.output_rec_type;
2994:
2995: l_return_status varchar2(1);
2996: l_release_start_date date;

Line 2993: l_output_rec wsh_tp_release_grp.output_rec_type;

2989: l_dummy pls_integer := null;
2990:
2991: l_group_tab wsh_tp_release_grp.id_tab_type;
2992: l_input_rec wsh_tp_release_grp.input_rec_type;
2993: l_output_rec wsh_tp_release_grp.output_rec_type;
2994:
2995: l_return_status varchar2(1);
2996: l_release_start_date date;
2997: l_Message_Text varchar2(1000);

Line 3035: l_input_rec.ACTION_CODE := wsh_tp_release_grp.G_ACTION_RELEASE;

3031: populate_interface_tables(l_return_status, p_release_id);
3032: if l_return_status = fnd_api.g_ret_sts_success then
3033: if g_apply_to_te = 1 then
3034: print_info(g_log_flow_of_control,'g_apply_to_te : ' ||g_apply_to_te);
3035: l_input_rec.ACTION_CODE := wsh_tp_release_grp.G_ACTION_RELEASE;
3036: l_input_rec.COMMIT_FLAG := fnd_api.G_FALSE;
3037:
3038: wsh_tp_release_grp.action( l_group_tab -- list of group ids created in release process above
3039: , l_input_rec

Line 3038: wsh_tp_release_grp.action( l_group_tab -- list of group ids created in release process above

3034: print_info(g_log_flow_of_control,'g_apply_to_te : ' ||g_apply_to_te);
3035: l_input_rec.ACTION_CODE := wsh_tp_release_grp.G_ACTION_RELEASE;
3036: l_input_rec.COMMIT_FLAG := fnd_api.G_FALSE;
3037:
3038: wsh_tp_release_grp.action( l_group_tab -- list of group ids created in release process above
3039: , l_input_rec
3040: , l_output_rec
3041: , l_return_status);
3042: -- l_return_status -> fnd_api.g_ret_sts_success ---> all group released to TE

Line 3059: l_input_rec.ACTION_CODE := wsh_tp_release_grp.G_ACTION_PURGE;

3055: end if;
3056: end if;
3057: print_info(g_log_flow_of_control,'g_purge_interface_table : ' ||g_purge_interface_table);
3058: if g_purge_interface_table = 1 then
3059: l_input_rec.ACTION_CODE := wsh_tp_release_grp.G_ACTION_PURGE;
3060: l_input_rec.COMMIT_FLAG := fnd_api.G_FALSE;
3061:
3062: wsh_tp_release_grp.action( l_group_tab -- list of group ids created in release process above
3063: , l_input_rec

Line 3062: wsh_tp_release_grp.action( l_group_tab -- list of group ids created in release process above

3058: if g_purge_interface_table = 1 then
3059: l_input_rec.ACTION_CODE := wsh_tp_release_grp.G_ACTION_PURGE;
3060: l_input_rec.COMMIT_FLAG := fnd_api.G_FALSE;
3061:
3062: wsh_tp_release_grp.action( l_group_tab -- list of group ids created in release process above
3063: , l_input_rec
3064: , l_output_rec
3065: , l_return_status);
3066: end if;