DBA Data[Home] [Help]

APPS.CS_SR_COST_CP dependencies on FND_CONCURRENT

Line 102: fnd_concurrent_requests

98: IS
99: SELECT
100: request_id
101: FROM
102: fnd_concurrent_requests
103: WHERE
104: parent_request_id = c_request_id;
105:
106:

Line 277: fnd_concurrent_requests r

273: (
274: SELECT
275: request_id
276: FROM
277: fnd_concurrent_requests r
278: , fnd_concurrent_programs p
279: WHERE
280: r.phase_code = 'C'
281: AND p.concurrent_program_id = r.concurrent_program_id

Line 278: , fnd_concurrent_programs p

274: SELECT
275: request_id
276: FROM
277: fnd_concurrent_requests r
278: , fnd_concurrent_programs p
279: WHERE
280: r.phase_code = 'C'
281: AND p.concurrent_program_id = r.concurrent_program_id
282: AND p.concurrent_program_name = 'CSCSTPG'

Line 548: IF FND_CONCURRENT.Get_Request_Status

544: , 'Worker Concurrent Request No : ' || r_child_request.request_id
545: );
546: END IF;
547:
548: IF FND_CONCURRENT.Get_Request_Status
549: (
550: request_id => r_child_request.request_id
551: , phase => l_worker_conc_req_phase
552: , status => l_worker_conc_req_status

Line 650: , 'Call to function fnd_concurrent.get_request_status failed. '

646: FND_LOG.String
647: (
648: FND_LOG.level_unexpected
649: , L_LOG_MODULE || 'collect_child_status_failed'
650: , 'Call to function fnd_concurrent.get_request_status failed. '
651: || l_main_conc_req_message
652: );
653: END IF;
654:

Line 789: l_ret := fnd_concurrent.set_completion_status

785: ---
786: -- Setting the completion status of this concurrent
787: -- request as COMPLETED NORMALLY
788:
789: l_ret := fnd_concurrent.set_completion_status
790: (
791: 'NORMAL'
792: , ' '
793: );

Line 813: IF FND_CONCURRENT.Get_Request_Status

809:
810:
811: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
812: THEN
813: IF FND_CONCURRENT.Get_Request_Status
814: (
815: request_id => l_request_id
816: , phase => l_main_conc_req_phase
817: , status => l_main_conc_req_status

Line 898: l_ret := fnd_concurrent.set_completion_status

894: , p_msg_index_out => x_msg_index_out
895: );
896: END IF;
897:
898: l_ret := fnd_concurrent.set_completion_status
899: (
900: 'WARNING'
901: , SUBSTR(x_msg_data, 1, 240)
902: );

Line 961: l_ret := fnd_concurrent.set_completion_status

957: , p_msg_index_out => x_msg_index_out
958: );
959: END IF;
960:
961: l_ret := fnd_concurrent.set_completion_status
962: (
963: 'ERROR'
964: , SUBSTR(x_msg_data, 1, 240)
965: );

Line 1023: l_ret := fnd_concurrent.set_completion_status

1019: , p_msg_index_out => x_msg_index_out
1020: );
1021: END IF;
1022:
1023: l_ret := fnd_concurrent.set_completion_status
1024: (
1025: 'ERROR'
1026: , SUBSTR(x_msg_data, 1, 240)
1027: );

Line 1091: l_ret := fnd_concurrent.set_completion_status

1087: , p_msg_index_out => x_msg_index_out
1088: );
1089: END IF;
1090:
1091: l_ret := fnd_concurrent.set_completion_status
1092: (
1093: 'ERROR'
1094: , SUBSTR(x_msg_data, 1, 240)
1095: );

Line 1718: fnd_concurrent_requests r

1714: 1
1715: INTO
1716: l_row_count
1717: FROM
1718: fnd_concurrent_requests r
1719: , fnd_concurrent_programs p
1720: WHERE
1721: r.request_id = p_cost_set_id
1722: AND p.concurrent_program_id = r.concurrent_program_id

Line 1719: , fnd_concurrent_programs p

1715: INTO
1716: l_row_count
1717: FROM
1718: fnd_concurrent_requests r
1719: , fnd_concurrent_programs p
1720: WHERE
1721: r.request_id = p_cost_set_id
1722: AND p.concurrent_program_id = r.concurrent_program_id
1723: AND p.concurrent_program_name = 'CSCSTPG'