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.PA_FUNDS_CONTROL_PKG dependencies on PA_BC_PACKET_ARRIVAL_ORDER

Line 3196: pa_bc_packet_arrival_order ao

3192: nvl(accounted_dr,0) - nvl(accounted_cr,0),0)),0),
3193: nvl(sum(decode(pbc.status_code||pbc.actual_flag, 'AE',nvl(accounted_dr,0)-nvl(accounted_cr,0),0)),0),
3194: nvl(sum(decode(pbc.status_code||pbc.actual_flag, 'AA',nvl(accounted_dr,0)-nvl(accounted_cr,0),0)),0)
3195: FROM pa_bc_packets pbc,
3196: pa_bc_packet_arrival_order ao
3197: WHERE pbc.project_id = p_record.project_id
3198: AND (
3199: (nvl(pbc.top_task_id,0) = p_record.bud_task_id)
3200: or (nvl(pbc.task_id,0) = p_record.bud_task_id)

Line 3378: pa_bc_packet_arrival_order ao

3374: nvl(accounted_dr,0) - nvl(accounted_cr,0),0)),0),
3375: nvl(sum(decode(pbc.status_code||pbc.actual_flag, 'AE',nvl(accounted_dr,0)-nvl(accounted_cr,0),0)),0),
3376: nvl(sum(decode(pbc.status_code||pbc.actual_flag, 'AA',nvl(accounted_dr,0)-nvl(accounted_cr,0),0)),0)
3377: FROM pa_bc_packets pbc,
3378: pa_bc_packet_arrival_order ao
3379: WHERE pbc.project_id = p_record.project_id
3380: AND (
3381: (nvl(pbc.top_task_id,0) = p_record.bud_task_id)
3382: or (nvl(pbc.task_id,0) = p_record.bud_task_id)

Line 3484: pa_bc_packet_arrival_order ao

3480: nvl(accounted_dr,0) - nvl(accounted_cr,0),0)),0),
3481: nvl(sum(decode(pbc.status_code||pbc.actual_flag, 'AE',nvl(accounted_dr,0)-nvl(accounted_cr,0),0)),0),
3482: nvl(sum(decode(pbc.status_code||pbc.actual_flag, 'AA',nvl(accounted_dr,0)-nvl(accounted_cr,0),0)),0)
3483: FROM pa_bc_packets pbc,
3484: pa_bc_packet_arrival_order ao
3485: WHERE pbc.project_id = p_record.project_id
3486: AND pbc.top_task_id = l_top_task_id
3487: AND pbc.task_id = l_task_id
3488: AND pbc.budget_version_id = p_record.budget_version_id

Line 3586: pa_bc_packet_arrival_order ao

3582: nvl(accounted_dr,0) - nvl(accounted_cr,0),0)),0),
3583: nvl(sum(decode(pbc.status_code||pbc.actual_flag, 'AE',nvl(accounted_dr,0)-nvl(accounted_cr,0),0)),0),
3584: nvl(sum(decode(pbc.status_code||pbc.actual_flag, 'AA',nvl(accounted_dr,0)-nvl(accounted_cr,0),0)),0)
3585: FROM pa_bc_packets pbc,
3586: pa_bc_packet_arrival_order ao
3587: WHERE pbc.project_id = p_record.project_id
3588: AND pbc.top_task_id = l_top_task_id
3589: AND pbc.budget_version_id = p_record.budget_version_id
3590: AND pbc.set_of_books_id = p_sob

Line 3653: pa_bc_packet_arrival_order ao

3649: nvl(accounted_dr,0) - nvl(accounted_cr,0),0)),0),
3650: nvl(sum(decode(pbc.status_code||pbc.actual_flag, 'AE',nvl(accounted_dr,0)-nvl(accounted_cr,0),0)),0),
3651: nvl(sum(decode(pbc.status_code||pbc.actual_flag, 'AA',nvl(accounted_dr,0)-nvl(accounted_cr,0),0)),0)
3652: FROM pa_bc_packets pbc,
3653: pa_bc_packet_arrival_order ao
3654: WHERE pbc.project_id = p_record.project_id
3655: AND pbc.budget_version_id = p_record.budget_version_id
3656: AND pbc.set_of_books_id = p_sob
3657: AND ((p_record.time_phased_type_code = 'G' and pbc.gl_date

Line 3694: pa_bc_packet_arrival_order ao

3690: nvl(accounted_dr,0) - nvl(accounted_cr,0),0)),0),
3691: nvl(sum(decode(pbc.status_code||pbc.actual_flag, 'AE',nvl(accounted_dr,0)-nvl(accounted_cr,0),0)),0),
3692: nvl(sum(decode(pbc.status_code||pbc.actual_flag, 'AA',nvl(accounted_dr,0)-nvl(accounted_cr,0),0)),0)
3693: FROM pa_bc_packets pbc,
3694: pa_bc_packet_arrival_order ao
3695: WHERE pbc.project_id = p_record.project_id
3696: AND pbc.budget_version_id = p_record.budget_version_id
3697: AND pbc.set_of_books_id = p_sob
3698: ANd pbc.budget_ccid = l_bdgt_ccid

Line 6326: INSERT INTO pa_bc_packet_arrival_order

6322:
6323: IF g_debug_mode = 'Y' THEN
6324: log_message(p_msg_token1 => 'Acquired the lock for funds check');
6325: End if;
6326: INSERT INTO pa_bc_packet_arrival_order
6327: ( packet_id
6328: , set_of_books_id
6329: , arrival_seq
6330: , affect_funds_flag

Line 6337: ,pa_bc_packet_arrival_order_s.nextval

6333: )
6334: VALUES (
6335: p_packet_id
6336: ,p_sobid
6337: ,pa_bc_packet_arrival_order_s.nextval
6338: ,DECODE ( p_mode, 'B', 'N', 'Y' )
6339: --For budget submit and baselining(S and B) it does not affect the funds.
6340: --For Encumbrances (E) it afffects funds.
6341: ,SYSDATE

Line 6345: log_message(p_msg_token1 => 'No of records inserted into pa_bc_packet_arrival_order ='||sql%rowcount);

6341: ,SYSDATE
6342: ,fnd_global.user_id
6343: );
6344: IF g_debug_mode = 'Y' THEN
6345: log_message(p_msg_token1 => 'No of records inserted into pa_bc_packet_arrival_order ='||sql%rowcount);
6346: End if;
6347:
6348: BEGIN
6349: SELECT arrival_seq

Line 6351: FROM pa_bc_packet_arrival_order ao

6347:
6348: BEGIN
6349: SELECT arrival_seq
6350: INTO v_arrival_seq
6351: FROM pa_bc_packet_arrival_order ao
6352: WHERE ao.packet_id = p_packet_id;
6353:
6354: EXCEPTION
6355: WHEN OTHERS THEN