DBA Data[Home] [Help]

APPS.QPR_DEAL_APPROVALS_PVT dependencies on QPR_WKFL_UTIL

Line 1030: l_user_list qpr_wkfl_util.char_type;

1026: p_comments in varchar2)
1027: is
1028: l_retcode number;
1029: l_errbuf varchar2(2000);
1030: l_user_list qpr_wkfl_util.char_type;
1031: l_user_list_cancel qpr_wkfl_util.char_type;
1032: l_requestor varchar2(50);
1033: l_requestor_present_flag boolean;
1034: l_increment number;

Line 1031: l_user_list_cancel qpr_wkfl_util.char_type;

1027: is
1028: l_retcode number;
1029: l_errbuf varchar2(2000);
1030: l_user_list qpr_wkfl_util.char_type;
1031: l_user_list_cancel qpr_wkfl_util.char_type;
1032: l_requestor varchar2(50);
1033: l_requestor_present_flag boolean;
1034: l_increment number;
1035: cursor get_requestor_cancel(p_respone_header_id number)

Line 1094: qpr_wkfl_util.invoke_toapp_nfn_process(

1090: then
1091:
1092: for i in l_user_list.first .. l_user_list.last
1093: loop
1094: qpr_wkfl_util.invoke_toapp_nfn_process(
1095: p_response_id => p_response_header_id,
1096: p_fwd_to_user => l_user_list(i),
1097: retcode => l_retcode,
1098: errbuf => l_errbuf);

Line 1114: qpr_wkfl_util.cancel_toapp_nfn_process(

1110:
1111: --pp_debug('amitl_increment = '||l_increment||'response_header_id = '||p_response_header_id);
1112:
1113:
1114: qpr_wkfl_util.cancel_toapp_nfn_process(
1115: p_response_id => p_response_header_id,
1116: p_usr_list => l_user_list_cancel,
1117: retcode => l_retcode,
1118: errbuf => l_errbuf);

Line 1121: qpr_wkfl_util.invoke_cb_nfn_process(

1117: retcode => l_retcode,
1118: errbuf => l_errbuf);
1119:
1120:
1121: qpr_wkfl_util.invoke_cb_nfn_process(
1122: p_response_id => p_response_header_id,
1123: p_usr_list => l_user_list,
1124: p_comments => p_comments,
1125: retcode => l_retcode,

Line 1129: qpr_wkfl_util.invoke_appstat_nfn_process(

1125: retcode => l_retcode,
1126: errbuf => l_errbuf);
1127: else
1128:
1129: qpr_wkfl_util.invoke_appstat_nfn_process(
1130: p_response_id => p_response_header_id,
1131: p_usr_list => l_user_list,
1132: p_comments => p_comments,
1133: p_status => p_notification_type,

Line 1393: l_user_list qpr_wkfl_util.char_type;

1389: is
1390: l_user_name varchar2(100);
1391: l_retcode number;
1392: l_errbuf varchar2(2000);
1393: l_user_list qpr_wkfl_util.char_type;
1394:
1395: begin
1396:
1397: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1407: qpr_wkfl_util.complete_toapp_nfn_process(

1403: from qpr_pn_response_approvals
1404: where response_header_id = p_response_header_id
1405: and approver_id = p_user_id;
1406:
1407: qpr_wkfl_util.complete_toapp_nfn_process(
1408: p_response_id => p_response_header_id,
1409: p_current_user => l_user_name,
1410: p_status => p_action_code,
1411: retcode => l_retcode,