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 262: update PO_RETRIEVED_TIMECARDS

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

Line 274: delete PO_RETRIEVED_TIMECARDS

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

Line 282: insert into PO_RETRIEVED_TIMECARDS

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

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

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

Line 389: from po_retrieved_timecards

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

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

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

Line 404: delete /+ PO_RETRIEVED_TIMECARDS_N6 /po_retrieved_timecards prt

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

Line 422: update po_retrieved_timecards

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

Line 430: update po_retrieved_timecards

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

Line 438: update po_retrieved_timecards

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

Line 451: delete po_retrieved_timecards

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

Line 531: update PO_RETRIEVED_TIMECARDS

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

Line 543: delete PO_RETRIEVED_TIMECARDS

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

Line 552: insert into PO_RETRIEVED_TIMECARDS

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