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 3215: -- pa_bc_packet_arrival_order ao --7531681

3211: nvl(accounted_dr,0) - nvl(accounted_cr,0),0)),0),
3212: nvl(sum(decode(pbc.status_code||pbc.actual_flag, 'AE',nvl(accounted_dr,0)-nvl(accounted_cr,0),0)),0),
3213: nvl(sum(decode(pbc.status_code||pbc.actual_flag, 'AA',nvl(accounted_dr,0)-nvl(accounted_cr,0),0)),0)
3214: FROM pa_bc_packets pbc
3215: -- pa_bc_packet_arrival_order ao --7531681
3216: WHERE pbc.project_id = p_record.project_id
3217: AND (
3218: (nvl(pbc.top_task_id,0) = p_record.bud_task_id)
3219: or (nvl(pbc.task_id,0) = p_record.bud_task_id)

Line 3237: ( select 1 from pa_bc_packet_arrival_order ao

3233: -- AND pbc.packet_id = ao.packet_id /* 7531681 */
3234: and substr(nvl(pbc.result_code,'P'),1,1)= 'P'
3235: AND pbc.balance_posted_flag = 'N'
3236: AND exists
3237: ( select 1 from pa_bc_packet_arrival_order ao
3238: where ao.packet_id = pbc.packet_id
3239: AND (
3240: -- This condition is added to avoid the concurrency issues like when two packets arrive for funds check
3241: -- one is funds check completed but not updated the status to Aprroved as the final status is updated

Line 3409: -- pa_bc_packet_arrival_order ao --7531681

3405: nvl(accounted_dr,0) - nvl(accounted_cr,0),0)),0),
3406: nvl(sum(decode(pbc.status_code||pbc.actual_flag, 'AE',nvl(accounted_dr,0)-nvl(accounted_cr,0),0)),0),
3407: nvl(sum(decode(pbc.status_code||pbc.actual_flag, 'AA',nvl(accounted_dr,0)-nvl(accounted_cr,0),0)),0)
3408: FROM pa_bc_packets pbc
3409: -- pa_bc_packet_arrival_order ao --7531681
3410: WHERE pbc.project_id = p_record.project_id
3411: AND (
3412: (nvl(pbc.top_task_id,0) = p_record.bud_task_id)
3413: or (nvl(pbc.task_id,0) = p_record.bud_task_id)

Line 3434: ( select 1 from pa_bc_packet_arrival_order ao /* 7531681 */

3430: -- AND pbc.packet_id = ao.packet_id -- 7531681
3431: and substr(nvl(pbc.result_code,'P'),1,1)= 'P'
3432: AND pbc.balance_posted_flag = 'N'
3433: AND exists
3434: ( select 1 from pa_bc_packet_arrival_order ao /* 7531681 */
3435: where pbc.packet_id = ao.packet_id
3436: AND (
3437: ( ao.arrival_seq < p_arrival_seq
3438: --AND ao.affect_funds_flag = 'Y'

Line 3523: -- pa_bc_packet_arrival_order ao -- 7531681

3519: nvl(accounted_dr,0) - nvl(accounted_cr,0),0)),0),
3520: nvl(sum(decode(pbc.status_code||pbc.actual_flag, 'AE',nvl(accounted_dr,0)-nvl(accounted_cr,0),0)),0),
3521: nvl(sum(decode(pbc.status_code||pbc.actual_flag, 'AA',nvl(accounted_dr,0)-nvl(accounted_cr,0),0)),0)
3522: FROM pa_bc_packets pbc
3523: -- pa_bc_packet_arrival_order ao -- 7531681
3524: WHERE pbc.project_id = p_record.project_id
3525: AND pbc.top_task_id = l_top_task_id
3526: AND pbc.task_id = l_task_id
3527: AND pbc.budget_version_id = p_record.budget_version_id

Line 3540: (select 1 from pa_bc_packet_arrival_order ao

3536: -- AND pbc.packet_id = ao.packet_id -- 7531681
3537: and substr(nvl(pbc.result_code,'P'),1,1)= 'P' /* 7531681 */
3538: AND pbc.balance_posted_flag = 'N'
3539: and exists
3540: (select 1 from pa_bc_packet_arrival_order ao
3541: where ao.packet_id = pbc.packet_id
3542: AND (
3543: ( ao.arrival_seq < p_arrival_seq
3544: --AND ao.affect_funds_flag = 'Y'

Line 3636: -- pa_bc_packet_arrival_order ao -- 7531681

3632: nvl(accounted_dr,0) - nvl(accounted_cr,0),0)),0),
3633: nvl(sum(decode(pbc.status_code||pbc.actual_flag, 'AE',nvl(accounted_dr,0)-nvl(accounted_cr,0),0)),0),
3634: nvl(sum(decode(pbc.status_code||pbc.actual_flag, 'AA',nvl(accounted_dr,0)-nvl(accounted_cr,0),0)),0)
3635: FROM pa_bc_packets pbc
3636: -- pa_bc_packet_arrival_order ao -- 7531681
3637: WHERE pbc.project_id = p_record.project_id
3638: AND pbc.top_task_id = l_top_task_id
3639: AND pbc.budget_version_id = p_record.budget_version_id
3640: AND pbc.set_of_books_id = p_sob

Line 3652: ( select 1 from pa_bc_packet_arrival_order ao

3648: -- AND pbc.packet_id = ao.packet_id
3649: and pbc.balance_posted_flag = 'N' /* 7531681 */
3650: and substr(nvl(pbc.result_code,'P'),1,1)= 'P'
3651: AND exists
3652: ( select 1 from pa_bc_packet_arrival_order ao
3653: where ao.packet_id = pbc.packet_id
3654: AND (
3655: ( ao.arrival_seq < p_arrival_seq
3656: --AND ao.affect_funds_flag = 'Y'

Line 3711: -- pa_bc_packet_arrival_order ao -- 7531681

3707: nvl(accounted_dr,0) - nvl(accounted_cr,0),0)),0),
3708: nvl(sum(decode(pbc.status_code||pbc.actual_flag, 'AE',nvl(accounted_dr,0)-nvl(accounted_cr,0),0)),0),
3709: nvl(sum(decode(pbc.status_code||pbc.actual_flag, 'AA',nvl(accounted_dr,0)-nvl(accounted_cr,0),0)),0)
3710: FROM pa_bc_packets pbc
3711: -- pa_bc_packet_arrival_order ao -- 7531681
3712: WHERE pbc.project_id = p_record.project_id
3713: AND pbc.budget_version_id = p_record.budget_version_id
3714: AND pbc.set_of_books_id = p_sob
3715: AND ((p_record.time_phased_type_code = 'G' and pbc.gl_date

Line 3726: ( select 1 from pa_bc_packet_arrival_order ao

3722: -- AND pbc.packet_id = ao.packet_id -- 7531681
3723: and pbc.balance_posted_flag = 'N'
3724: and substr(nvl(pbc.result_code,'P'),1,1)= 'P'
3725: AND exists
3726: ( select 1 from pa_bc_packet_arrival_order ao
3727: where pbc.packet_id = ao.packet_id
3728: AND (
3729: ( ao.arrival_seq < p_arrival_seq
3730: --AND ao.affect_funds_flag = 'Y'

Line 3757: -- pa_bc_packet_arrival_order ao -- 7531681

3753: nvl(accounted_dr,0) - nvl(accounted_cr,0),0)),0),
3754: nvl(sum(decode(pbc.status_code||pbc.actual_flag, 'AE',nvl(accounted_dr,0)-nvl(accounted_cr,0),0)),0),
3755: nvl(sum(decode(pbc.status_code||pbc.actual_flag, 'AA',nvl(accounted_dr,0)-nvl(accounted_cr,0),0)),0)
3756: FROM pa_bc_packets pbc
3757: -- pa_bc_packet_arrival_order ao -- 7531681
3758: WHERE pbc.project_id = p_record.project_id
3759: AND pbc.budget_version_id = p_record.budget_version_id
3760: AND pbc.set_of_books_id = p_sob
3761: ANd pbc.budget_ccid = l_bdgt_ccid

Line 3773: (select 1 from pa_bc_packet_arrival_order ao

3769: -- AND pbc.packet_id = ao.packet_id -- 7531681
3770: and pbc.balance_posted_flag = 'N'
3771: and substr(nvl(pbc.result_code,'P'),1,1)= 'P'
3772: AND exists
3773: (select 1 from pa_bc_packet_arrival_order ao
3774: where pbc.packet_id = ao.packet_id
3775: AND (
3776: ( ao.arrival_seq < p_arrival_seq
3777: --AND ao.affect_funds_flag = 'Y'

Line 6478: INSERT INTO pa_bc_packet_arrival_order

6474:
6475: IF g_debug_mode = 'Y' THEN
6476: log_message(p_msg_token1 => 'Acquired the lock for funds check');
6477: End if;
6478: INSERT INTO pa_bc_packet_arrival_order
6479: ( packet_id
6480: , set_of_books_id
6481: , arrival_seq
6482: , affect_funds_flag

Line 6489: ,pa_bc_packet_arrival_order_s.nextval

6485: )
6486: VALUES (
6487: p_packet_id
6488: ,p_sobid
6489: ,pa_bc_packet_arrival_order_s.nextval
6490: ,DECODE ( p_mode, 'B', 'N', 'Y' )
6491: --For budget submit and baselining(S and B) it does not affect the funds.
6492: --For Encumbrances (E) it afffects funds.
6493: ,SYSDATE

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

6493: ,SYSDATE
6494: ,fnd_global.user_id
6495: );
6496: IF g_debug_mode = 'Y' THEN
6497: log_message(p_msg_token1 => 'No of records inserted into pa_bc_packet_arrival_order ='||sql%rowcount);
6498: End if;
6499:
6500: BEGIN
6501: SELECT arrival_seq

Line 6503: FROM pa_bc_packet_arrival_order ao

6499:
6500: BEGIN
6501: SELECT arrival_seq
6502: INTO v_arrival_seq
6503: FROM pa_bc_packet_arrival_order ao
6504: WHERE ao.packet_id = p_packet_id;
6505:
6506: EXCEPTION
6507: WHEN OTHERS THEN