DBA Data[Home] [Help]

APPS.AR_BUS_EVENT_SUB_PVT dependencies on MO_GLOBAL

Line 1103: mo_global.init('AR');

1099: --
1100: --set the application context.
1101: --
1102: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
1103: mo_global.init('AR');
1104: mo_global.set_policy_context('S',l_org_id);
1105: --
1106: -- Acquire locks on the payment schedule record so that
1107: -- the record is not changed while this subscription is

Line 1104: mo_global.set_policy_context('S',l_org_id);

1100: --set the application context.
1101: --
1102: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
1103: mo_global.init('AR');
1104: mo_global.set_policy_context('S',l_org_id);
1105: --
1106: -- Acquire locks on the payment schedule record so that
1107: -- the record is not changed while this subscription is
1108: -- executed.

Line 1408: mo_global.init('AR');

1404: --
1405: --set the application context.
1406: --
1407: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
1408: mo_global.init('AR');
1409: mo_global.set_policy_context('S',l_org_id);
1410: --
1411: -- No need to acquire locks on the payment schedule record
1412: -- because it would not exist in the database as the Incomplete

Line 1409: mo_global.set_policy_context('S',l_org_id);

1405: --set the application context.
1406: --
1407: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
1408: mo_global.init('AR');
1409: mo_global.set_policy_context('S',l_org_id);
1410: --
1411: -- No need to acquire locks on the payment schedule record
1412: -- because it would not exist in the database as the Incomplete
1413: -- event deletes the payment schedules.

Line 1660: mo_global.init('AR');

1656: --
1657: --set the application context.
1658: --
1659: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
1660: mo_global.init('AR');
1661: mo_global.set_policy_context('S',l_org_id);
1662: --Stamp the history record for the modification.
1663: /*bug#5484606-------------------------------------------------------------------+
1664: |cuddagir Added Exception Handling for update statement and moved the logic for |

Line 1661: mo_global.set_policy_context('S',l_org_id);

1657: --set the application context.
1658: --
1659: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
1660: mo_global.init('AR');
1661: mo_global.set_policy_context('S',l_org_id);
1662: --Stamp the history record for the modification.
1663: /*bug#5484606-------------------------------------------------------------------+
1664: |cuddagir Added Exception Handling for update statement and moved the logic for |
1665: |setting the flag inside the exception handling. |

Line 1901: mo_global.init('AR');

1897: --
1898: --set the application context.
1899: --
1900: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
1901: mo_global.init('AR');
1902: mo_global.set_policy_context('S',l_org_id);
1903: --
1904: -- Acquire locks on the payment schedule record so that
1905: -- the record is not changed while this subscription is

Line 1902: mo_global.set_policy_context('S',l_org_id);

1898: --set the application context.
1899: --
1900: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
1901: mo_global.init('AR');
1902: mo_global.set_policy_context('S',l_org_id);
1903: --
1904: -- Acquire locks on the payment schedule record so that
1905: -- the record is not changed while this subscription is
1906: -- executed.

Line 2256: mo_global.init('AR');

2252: --
2253: --set the application context.
2254: --
2255: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
2256: mo_global.init('AR');
2257: mo_global.set_policy_context('S',l_org_id);
2258:
2259: --
2260: -- No need to acquire locks on the payment schedule record

Line 2257: mo_global.set_policy_context('S',l_org_id);

2253: --set the application context.
2254: --
2255: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
2256: mo_global.init('AR');
2257: mo_global.set_policy_context('S',l_org_id);
2258:
2259: --
2260: -- No need to acquire locks on the payment schedule record
2261: -- because it would not exist in the database as the Incomplete

Line 2465: mo_global.init('AR');

2461: --
2462: --set the application context.
2463: --
2464: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
2465: mo_global.init('AR');
2466: mo_global.set_policy_context('S',l_org_id);
2467:
2468: --
2469: -- Acquire locks on the payment schedule record so that

Line 2466: mo_global.set_policy_context('S',l_org_id);

2462: --set the application context.
2463: --
2464: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
2465: mo_global.init('AR');
2466: mo_global.set_policy_context('S',l_org_id);
2467:
2468: --
2469: -- Acquire locks on the payment schedule record so that
2470: -- the record is not changed while this subscription is

Line 2717: mo_global.init('AR');

2713: --
2714: --set the application context.
2715: --
2716: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
2717: mo_global.init('AR');
2718: mo_global.set_policy_context('S',l_org_id);
2719: --
2720: -- No need to acquire locks on the payment schedule record
2721: -- because it would not exist in the database as the Incomplete

Line 2718: mo_global.set_policy_context('S',l_org_id);

2714: --set the application context.
2715: --
2716: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
2717: mo_global.init('AR');
2718: mo_global.set_policy_context('S',l_org_id);
2719: --
2720: -- No need to acquire locks on the payment schedule record
2721: -- because it would not exist in the database as the Incomplete
2722: -- event deletes the payment schedules.

Line 2905: mo_global.init('AR');

2901: --
2902: --set the application context.
2903: --
2904: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
2905: mo_global.init('AR');
2906: mo_global.set_policy_context('S',l_org_id);
2907:
2908: --
2909: -- Acquire locks on the payment schedule record so that

Line 2906: mo_global.set_policy_context('S',l_org_id);

2902: --set the application context.
2903: --
2904: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
2905: mo_global.init('AR');
2906: mo_global.set_policy_context('S',l_org_id);
2907:
2908: --
2909: -- Acquire locks on the payment schedule record so that
2910: -- the record is not changed while this subscription is

Line 3159: mo_global.init('AR');

3155: --
3156: --set the application context.
3157: --
3158: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
3159: mo_global.init('AR');
3160: mo_global.set_policy_context('S',l_org_id);
3161:
3162: --
3163: -- No need to acquire locks on the payment schedule record

Line 3160: mo_global.set_policy_context('S',l_org_id);

3156: --set the application context.
3157: --
3158: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
3159: mo_global.init('AR');
3160: mo_global.set_policy_context('S',l_org_id);
3161:
3162: --
3163: -- No need to acquire locks on the payment schedule record
3164: -- because it would not exist in the database as the Incomplete

Line 3350: mo_global.init('AR');

3346: --
3347: --set the application context.
3348: --
3349: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
3350: mo_global.init('AR');
3351: mo_global.set_policy_context('S',l_org_id);
3352: --
3353: -- Acquire locks on the payment schedule record so that
3354: -- the record is not changed while this subscription is

Line 3351: mo_global.set_policy_context('S',l_org_id);

3347: --set the application context.
3348: --
3349: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
3350: mo_global.init('AR');
3351: mo_global.set_policy_context('S',l_org_id);
3352: --
3353: -- Acquire locks on the payment schedule record so that
3354: -- the record is not changed while this subscription is
3355: -- executed.

Line 3682: mo_global.init('AR');

3678: --
3679: --set the application context.
3680: --
3681: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
3682: mo_global.init('AR');
3683: mo_global.set_policy_context('S',l_org_id);
3684:
3685: --we would stamp the complete_flag on the ar_trx_summary_hist
3686: --for any records for this cash receipt. They could be due to

Line 3683: mo_global.set_policy_context('S',l_org_id);

3679: --set the application context.
3680: --
3681: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
3682: mo_global.init('AR');
3683: mo_global.set_policy_context('S',l_org_id);
3684:
3685: --we would stamp the complete_flag on the ar_trx_summary_hist
3686: --for any records for this cash receipt. They could be due to
3687: -- receipt deletion or modification.

Line 3957: mo_global.init('AR');

3953: --
3954: --set the application context.
3955: --
3956: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
3957: mo_global.init('AR');
3958: mo_global.set_policy_context('S',l_org_id);
3959:
3960: UPDATE ar_trx_summary_hist
3961: set complete_flag = 'Y',

Line 3958: mo_global.set_policy_context('S',l_org_id);

3954: --set the application context.
3955: --
3956: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
3957: mo_global.init('AR');
3958: mo_global.set_policy_context('S',l_org_id);
3959:
3960: UPDATE ar_trx_summary_hist
3961: set complete_flag = 'Y',
3962: LAST_UPDATE_DATE = sysdate,

Line 4143: mo_global.init('AR');

4139: --
4140: --set the application context.
4141: --
4142: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
4143: mo_global.init('AR');
4144: mo_global.set_policy_context('S',l_org_id);
4145:
4146: OPEN get_receipt_hist(l_history_id);
4147: FETCH get_receipt_hist INTO l_hist_rec;

Line 4144: mo_global.set_policy_context('S',l_org_id);

4140: --set the application context.
4141: --
4142: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
4143: mo_global.init('AR');
4144: mo_global.set_policy_context('S',l_org_id);
4145:
4146: OPEN get_receipt_hist(l_history_id);
4147: FETCH get_receipt_hist INTO l_hist_rec;
4148:

Line 4879: mo_global.init('AR');

4875: --
4876: --set the application context.
4877: --
4878: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
4879: mo_global.init('AR');
4880: mo_global.set_policy_context('S',l_org_id);
4881:
4882: UPDATE ar_trx_summary_hist
4883: SET complete_flag = 'Y',

Line 4880: mo_global.set_policy_context('S',l_org_id);

4876: --set the application context.
4877: --
4878: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
4879: mo_global.init('AR');
4880: mo_global.set_policy_context('S',l_org_id);
4881:
4882: UPDATE ar_trx_summary_hist
4883: SET complete_flag = 'Y',
4884: LAST_UPDATE_DATE = sysdate,

Line 5055: mo_global.init('AR');

5051: --
5052: --set the application context.
5053: --
5054: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
5055: mo_global.init('AR');
5056: mo_global.set_policy_context('S',l_org_id);
5057:
5058: select to_date(l_due_date_str, 'J')
5059: into l_trx_due_date

Line 5056: mo_global.set_policy_context('S',l_org_id);

5052: --set the application context.
5053: --
5054: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
5055: mo_global.init('AR');
5056: mo_global.set_policy_context('S',l_org_id);
5057:
5058: select to_date(l_due_date_str, 'J')
5059: into l_trx_due_date
5060: from dual;

Line 5260: mo_global.init('AR');

5256: --
5257: --set the application context.
5258: --
5259: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
5260: mo_global.init('AR');
5261: mo_global.set_policy_context('S',l_org_id);
5262:
5263: select to_date(l_due_date_str, 'J')
5264: into l_trx_due_date

Line 5261: mo_global.set_policy_context('S',l_org_id);

5257: --set the application context.
5258: --
5259: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
5260: mo_global.init('AR');
5261: mo_global.set_policy_context('S',l_org_id);
5262:
5263: select to_date(l_due_date_str, 'J')
5264: into l_trx_due_date
5265: from dual;

Line 5490: mo_global.init('AR');

5486: --
5487: --set the application context.
5488: --
5489: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
5490: mo_global.init('AR');
5491: mo_global.set_policy_context('S',l_org_id);
5492:
5493: select to_date(l_due_date_str, 'J')
5494: into l_trx_due_date

Line 5491: mo_global.set_policy_context('S',l_org_id);

5487: --set the application context.
5488: --
5489: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
5490: mo_global.init('AR');
5491: mo_global.set_policy_context('S',l_org_id);
5492:
5493: select to_date(l_due_date_str, 'J')
5494: into l_trx_due_date
5495: from dual;

Line 5784: mo_global.init('AR');

5780: --
5781: --set the application context.
5782: --
5783: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
5784: mo_global.init('AR');
5785: mo_global.set_policy_context('S',l_org_id);
5786:
5787: select to_date(l_due_date_str, 'J')
5788: into l_trx_due_date

Line 5785: mo_global.set_policy_context('S',l_org_id);

5781: --set the application context.
5782: --
5783: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
5784: mo_global.init('AR');
5785: mo_global.set_policy_context('S',l_org_id);
5786:
5787: select to_date(l_due_date_str, 'J')
5788: into l_trx_due_date
5789: from dual;

Line 6179: mo_global.init('AR');

6175: --
6176: --set the application context.
6177: --
6178: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6179: mo_global.init('AR');
6180: mo_global.set_policy_context('S',l_org_id);
6181:
6182: Update_summary_for_request_id(l_request_id);
6183: IF pg_debug = 'Y'

Line 6180: mo_global.set_policy_context('S',l_org_id);

6176: --set the application context.
6177: --
6178: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6179: mo_global.init('AR');
6180: mo_global.set_policy_context('S',l_org_id);
6181:
6182: Update_summary_for_request_id(l_request_id);
6183: IF pg_debug = 'Y'
6184: THEN

Line 6243: mo_global.init('AR');

6239: --
6240: --set the application context.
6241: --
6242: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6243: mo_global.init('AR');
6244: mo_global.set_policy_context('S',l_org_id);
6245:
6246: Update_rcpt_app_info_for_req(l_request_id, l_org_id);
6247: IF pg_debug = 'Y'

Line 6244: mo_global.set_policy_context('S',l_org_id);

6240: --set the application context.
6241: --
6242: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6243: mo_global.init('AR');
6244: mo_global.set_policy_context('S',l_org_id);
6245:
6246: Update_rcpt_app_info_for_req(l_request_id, l_org_id);
6247: IF pg_debug = 'Y'
6248: THEN

Line 6334: mo_global.init('AR');

6330: --
6331: --set the application context.
6332: --
6333: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6334: mo_global.init('AR');
6335: mo_global.set_policy_context('S',l_org_id);
6336:
6337: OPEN get_adj(l_request_id);
6338:

Line 6335: mo_global.set_policy_context('S',l_org_id);

6331: --set the application context.
6332: --
6333: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6334: mo_global.init('AR');
6335: mo_global.set_policy_context('S',l_org_id);
6336:
6337: OPEN get_adj(l_request_id);
6338:
6339: LOOP

Line 6444: mo_global.init('AR');

6440: --
6441: --set the application context.
6442: --
6443: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6444: mo_global.init('AR');
6445: mo_global.set_policy_context('S',l_org_id);
6446:
6447: Update_rcpt_app_info_for_req(l_request_id, l_org_id);
6448: IF pg_debug = 'Y'

Line 6445: mo_global.set_policy_context('S',l_org_id);

6441: --set the application context.
6442: --
6443: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6444: mo_global.init('AR');
6445: mo_global.set_policy_context('S',l_org_id);
6446:
6447: Update_rcpt_app_info_for_req(l_request_id, l_org_id);
6448: IF pg_debug = 'Y'
6449: THEN

Line 6557: mo_global.init('AR');

6553: --
6554: --set the application context.
6555: --
6556: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6557: mo_global.init('AR');
6558: mo_global.set_policy_context('S',l_org_id);
6559:
6560: OPEN get_adj_details (l_adjustment_id);
6561:

Line 6558: mo_global.set_policy_context('S',l_org_id);

6554: --set the application context.
6555: --
6556: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6557: mo_global.init('AR');
6558: mo_global.set_policy_context('S',l_org_id);
6559:
6560: OPEN get_adj_details (l_adjustment_id);
6561:
6562: FETCH get_adj_details

Line 6712: mo_global.init('AR');

6708: --
6709: --set the application context.
6710: --
6711: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6712: mo_global.init('AR');
6713: mo_global.set_policy_context('S',l_org_id);
6714:
6715: OPEN get_adj_details (l_adjustment_id);
6716: FETCH get_adj_details

Line 6713: mo_global.set_policy_context('S',l_org_id);

6709: --set the application context.
6710: --
6711: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6712: mo_global.init('AR');
6713: mo_global.set_policy_context('S',l_org_id);
6714:
6715: OPEN get_adj_details (l_adjustment_id);
6716: FETCH get_adj_details
6717: INTO l_amount,

Line 6843: mo_global.init('AR');

6839: --
6840: --set the application context.
6841: --
6842: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6843: mo_global.init('AR');
6844: mo_global.set_policy_context('S',l_org_id);
6845:
6846: Update_summary_for_request_id(l_request_id);
6847:

Line 6844: mo_global.set_policy_context('S',l_org_id);

6840: --set the application context.
6841: --
6842: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6843: mo_global.init('AR');
6844: mo_global.set_policy_context('S',l_org_id);
6845:
6846: Update_summary_for_request_id(l_request_id);
6847:
6848: IF pg_debug = 'Y'