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.PO_STORE_TIMECARD_PKG_GRP dependencies on PO_RETRIEVED_TIMECARDS

Line 168: from po_retrieved_timecards

164: l_org_id, l_po_creation_date,
165: l_contractor_full_name, l_tc_uom, l_tc_approved_date,
166: l_tc_start_date, l_tc_entry_date, l_tc_end_date,
167: l_contingent_worker_id, l_line_rate_type, l_line_rate, l_po_currency
168: from po_retrieved_timecards
169: where tc_detail_id = p_tc_detail_id and tc_day_id = p_tc_day_id and
170: tc_id = p_tc_id and rownum = 1; --all we need is mandatory data; so first row is sufficient.
171: EXCEPTION
172: WHEN No_Data_Found THEN

Line 264: update PO_RETRIEVED_TIMECARDS

260:
261: if (upper(p_action) = 'UPDATE') then
262: l_stage := 'updating';
263: /*
264: update PO_RETRIEVED_TIMECARDS
265: set tc_time_received = p_tc_time_received, tc_comment_text = p_tc_comment_text,
266: line_rate_type = p_line_rate_type, line_rate = p_line_rate
267: where tc_detail_id = p_tc_detail_id and tc_day_id = p_tc_day_id and tc_id = p_tc_id;
268: */

Line 276: delete PO_RETRIEVED_TIMECARDS

272: elsif (upper(p_action) = 'DELETE') then
273: l_stage := 'deleting';
274: l_action := 'D';
275: /*
276: delete PO_RETRIEVED_TIMECARDS
277: where tc_detail_id = p_tc_detail_id and tc_day_id = p_tc_day_id and tc_id = p_tc_id;
278: */
279: end if;
280:

Line 284: insert into PO_RETRIEVED_TIMECARDS

280:
281: select po_timecards_entry_s.nextval into l_tc_entry_seq from dual;
282: l_stage := 'inserting';
283:
284: insert into PO_RETRIEVED_TIMECARDS
285: (
286: PO_HEADER_ID,
287: PO_NUMBER,
288: PO_LINE_ID,

Line 388: select /+ PO_RETRIEVED_TIMECARDS_N6 / tc_id, tc_day_id, tc_detail_id,

384: x_msg_data out NOCOPY varchar2
385: )
386: is
387: cursor reconcile_csr is
388: select /*+ PO_RETRIEVED_TIMECARDS_N6 */ tc_id, tc_day_id, tc_detail_id,
389: action_flag, tc_time_received,
390: tc_comment_text, interface_transaction_id
391: from po_retrieved_timecards
392: where action_flag in ('I', 'U', 'D')

Line 391: from po_retrieved_timecards

387: cursor reconcile_csr is
388: select /*+ PO_RETRIEVED_TIMECARDS_N6 */ tc_id, tc_day_id, tc_detail_id,
389: action_flag, tc_time_received,
390: tc_comment_text, interface_transaction_id
391: from po_retrieved_timecards
392: where action_flag in ('I', 'U', 'D')
393: order by TC_ENTRY_SEQUENCE;
394:
395: l_tc_id number;

Line 405: --First cleanup all the failed transactions from the po_retrieved_timecards.

401: l_transaction_id number;
402:
403: begin
404:
405: --First cleanup all the failed transactions from the po_retrieved_timecards.
406: delete /*+ PO_RETRIEVED_TIMECARDS_N6 */po_retrieved_timecards prt
407: where action_flag in ('I', 'U', 'D') and
408: not exists (select interface_transaction_id from rcv_transactions
409: where interface_transaction_id = prt.interface_transaction_id);

Line 406: delete /+ PO_RETRIEVED_TIMECARDS_N6 /po_retrieved_timecards prt

402:
403: begin
404:
405: --First cleanup all the failed transactions from the po_retrieved_timecards.
406: delete /*+ PO_RETRIEVED_TIMECARDS_N6 */po_retrieved_timecards prt
407: where action_flag in ('I', 'U', 'D') and
408: not exists (select interface_transaction_id from rcv_transactions
409: where interface_transaction_id = prt.interface_transaction_id);
410:

Line 424: update po_retrieved_timecards

420: exit when reconcile_csr%NOTFOUND;
421:
422:
423: if (l_action_flag = 'I') then
424: update po_retrieved_timecards
425: set action_flag = 'P'
426: where tc_id = l_tc_id and
427: tc_day_id = l_tc_day_id and
428: tc_detail_id = l_tc_detail_id and

Line 432: update po_retrieved_timecards

428: tc_detail_id = l_tc_detail_id and
429: action_flag = 'I';
430:
431: elsif (l_action_flag = 'U') then
432: update po_retrieved_timecards
433: set tc_time_received = l_tc_time_received,
434: tc_comment_text = l_tc_comment_text
435: where tc_id = l_tc_id and
436: tc_day_id = l_tc_day_id and

Line 440: update po_retrieved_timecards

436: tc_day_id = l_tc_day_id and
437: tc_detail_id = l_tc_detail_id and
438: action_flag = 'P';
439: elsif (l_action_flag = 'D') then
440: update po_retrieved_timecards
441: set action_flag = 'DP'
442: where tc_id = l_tc_id and
443: tc_day_id = l_tc_day_id and
444: tc_detail_id = l_tc_detail_id and

Line 453: delete po_retrieved_timecards

449: end loop;
450:
451: close reconcile_csr;
452:
453: delete po_retrieved_timecards
454: where action_flag in ('U', 'D');
455:
456:
457: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 533: update PO_RETRIEVED_TIMECARDS

529:
530: if (upper(p_action) = 'UPDATE') then
531: forall i in p_rtrvd_tcs.po_number.first..p_rtrvd_tcs.po_number.last
532: SAVE EXCEPTIONS
533: update PO_RETRIEVED_TIMECARDS
534: set tc_time_received = p_rtrvd_tcs.tc_time_received(i),
535: tc_comment_text = p_rtrvd_tcs.tc_comment_text(i),
536: line_rate_type = p_rtrvd_tcs.line_rate_type(i),
537: line_rate = p_rtrvd_tcs.line_rate(i)

Line 545: delete PO_RETRIEVED_TIMECARDS

541:
542: elsif (upper(p_action) = 'DELETE') then
543: forall i in p_rtrvd_tcs.po_number.first..p_rtrvd_tcs.po_number.last
544: SAVE EXCEPTIONS
545: delete PO_RETRIEVED_TIMECARDS
546: where tc_detail_id = p_rtrvd_tcs.tc_detail_id(i) and
547: tc_day_id = p_rtrvd_tcs.tc_day_id(i) and
548: tc_id = p_rtrvd_tcs.tc_id(i);
549:

Line 554: insert into PO_RETRIEVED_TIMECARDS

550: else
551:
552: forall i in p_rtrvd_tcs.po_number.first..p_rtrvd_tcs.po_number.last
553: SAVE EXCEPTIONS
554: insert into PO_RETRIEVED_TIMECARDS
555: (
556: PO_HEADER_ID,
557: PO_NUMBER,
558: PO_LINE_ID,