DBA Data[Home] [Help]

APPS.AR_BUS_EVENT_SUB_PVT dependencies on MO_GLOBAL

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3964: --
3965: --set the application context.
3966: --
3967: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
3968: mo_global.init('AR');
3969: mo_global.set_policy_context('S',l_org_id);
3970:
3971: UPDATE ar_trx_summary_hist
3972: set complete_flag = 'Y',

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

3965: --set the application context.
3966: --
3967: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
3968: mo_global.init('AR');
3969: mo_global.set_policy_context('S',l_org_id);
3970:
3971: UPDATE ar_trx_summary_hist
3972: set complete_flag = 'Y',
3973: LAST_UPDATE_DATE = sysdate,

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

4149: --
4150: --set the application context.
4151: --
4152: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
4153: mo_global.init('AR');
4154: mo_global.set_policy_context('S',l_org_id);
4155:
4156: OPEN get_receipt_hist(l_history_id);
4157: FETCH get_receipt_hist INTO l_hist_rec;

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

4150: --set the application context.
4151: --
4152: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
4153: mo_global.init('AR');
4154: mo_global.set_policy_context('S',l_org_id);
4155:
4156: OPEN get_receipt_hist(l_history_id);
4157: FETCH get_receipt_hist INTO l_hist_rec;
4158:

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

4886: --
4887: --set the application context.
4888: --
4889: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
4890: mo_global.init('AR');
4891: mo_global.set_policy_context('S',l_org_id);
4892:
4893: UPDATE ar_trx_summary_hist
4894: SET complete_flag = 'Y',

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

4887: --set the application context.
4888: --
4889: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
4890: mo_global.init('AR');
4891: mo_global.set_policy_context('S',l_org_id);
4892:
4893: UPDATE ar_trx_summary_hist
4894: SET complete_flag = 'Y',
4895: LAST_UPDATE_DATE = sysdate,

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

5062: --
5063: --set the application context.
5064: --
5065: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
5066: mo_global.init('AR');
5067: mo_global.set_policy_context('S',l_org_id);
5068:
5069: select to_date(l_due_date_str, 'J')
5070: into l_trx_due_date

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

5063: --set the application context.
5064: --
5065: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
5066: mo_global.init('AR');
5067: mo_global.set_policy_context('S',l_org_id);
5068:
5069: select to_date(l_due_date_str, 'J')
5070: into l_trx_due_date
5071: from dual;

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

5271: --
5272: --set the application context.
5273: --
5274: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
5275: mo_global.init('AR');
5276: mo_global.set_policy_context('S',l_org_id);
5277:
5278: select to_date(l_due_date_str, 'J')
5279: into l_trx_due_date

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

5272: --set the application context.
5273: --
5274: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
5275: mo_global.init('AR');
5276: mo_global.set_policy_context('S',l_org_id);
5277:
5278: select to_date(l_due_date_str, 'J')
5279: into l_trx_due_date
5280: from dual;

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

5504: --
5505: --set the application context.
5506: --
5507: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
5508: mo_global.init('AR');
5509: mo_global.set_policy_context('S',l_org_id);
5510:
5511: select to_date(l_due_date_str, 'J')
5512: into l_trx_due_date

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

5505: --set the application context.
5506: --
5507: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
5508: mo_global.init('AR');
5509: mo_global.set_policy_context('S',l_org_id);
5510:
5511: select to_date(l_due_date_str, 'J')
5512: into l_trx_due_date
5513: from dual;

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

5803: --
5804: --set the application context.
5805: --
5806: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
5807: mo_global.init('AR');
5808: mo_global.set_policy_context('S',l_org_id);
5809:
5810: select to_date(l_due_date_str, 'J')
5811: into l_trx_due_date

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

5804: --set the application context.
5805: --
5806: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
5807: mo_global.init('AR');
5808: mo_global.set_policy_context('S',l_org_id);
5809:
5810: select to_date(l_due_date_str, 'J')
5811: into l_trx_due_date
5812: from dual;

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

6203: --
6204: --set the application context.
6205: --
6206: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6207: mo_global.init('AR');
6208: mo_global.set_policy_context('S',l_org_id);
6209:
6210: Update_summary_for_request_id(l_request_id);
6211: IF pg_debug = 'Y'

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

6204: --set the application context.
6205: --
6206: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6207: mo_global.init('AR');
6208: mo_global.set_policy_context('S',l_org_id);
6209:
6210: Update_summary_for_request_id(l_request_id);
6211: IF pg_debug = 'Y'
6212: THEN

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

6267: --
6268: --set the application context.
6269: --
6270: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6271: mo_global.init('AR');
6272: mo_global.set_policy_context('S',l_org_id);
6273:
6274: Update_rcpt_app_info_for_req(l_request_id, l_org_id);
6275: IF pg_debug = 'Y'

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

6268: --set the application context.
6269: --
6270: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6271: mo_global.init('AR');
6272: mo_global.set_policy_context('S',l_org_id);
6273:
6274: Update_rcpt_app_info_for_req(l_request_id, l_org_id);
6275: IF pg_debug = 'Y'
6276: THEN

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

6358: --
6359: --set the application context.
6360: --
6361: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6362: mo_global.init('AR');
6363: mo_global.set_policy_context('S',l_org_id);
6364:
6365: OPEN get_adj(l_request_id);
6366:

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

6359: --set the application context.
6360: --
6361: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6362: mo_global.init('AR');
6363: mo_global.set_policy_context('S',l_org_id);
6364:
6365: OPEN get_adj(l_request_id);
6366:
6367: LOOP

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

6468: --
6469: --set the application context.
6470: --
6471: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6472: mo_global.init('AR');
6473: mo_global.set_policy_context('S',l_org_id);
6474:
6475: Update_rcpt_app_info_for_req(l_request_id, l_org_id);
6476: IF pg_debug = 'Y'

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

6469: --set the application context.
6470: --
6471: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6472: mo_global.init('AR');
6473: mo_global.set_policy_context('S',l_org_id);
6474:
6475: Update_rcpt_app_info_for_req(l_request_id, l_org_id);
6476: IF pg_debug = 'Y'
6477: THEN

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

6581: --
6582: --set the application context.
6583: --
6584: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6585: mo_global.init('AR');
6586: mo_global.set_policy_context('S',l_org_id);
6587:
6588: OPEN get_adj_details (l_adjustment_id);
6589:

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

6582: --set the application context.
6583: --
6584: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6585: mo_global.init('AR');
6586: mo_global.set_policy_context('S',l_org_id);
6587:
6588: OPEN get_adj_details (l_adjustment_id);
6589:
6590: FETCH get_adj_details

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

6748: --
6749: --set the application context.
6750: --
6751: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6752: mo_global.init('AR');
6753: mo_global.set_policy_context('S',l_org_id);
6754:
6755: OPEN get_adj_details (l_adjustment_id);
6756: FETCH get_adj_details

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

6749: --set the application context.
6750: --
6751: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6752: mo_global.init('AR');
6753: mo_global.set_policy_context('S',l_org_id);
6754:
6755: OPEN get_adj_details (l_adjustment_id);
6756: FETCH get_adj_details
6757: INTO l_amount,

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

6884: --
6885: --set the application context.
6886: --
6887: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6888: mo_global.init('AR');
6889: mo_global.set_policy_context('S',l_org_id);
6890:
6891: Update_summary_for_request_id(l_request_id);
6892:

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

6885: --set the application context.
6886: --
6887: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6888: mo_global.init('AR');
6889: mo_global.set_policy_context('S',l_org_id);
6890:
6891: Update_summary_for_request_id(l_request_id);
6892:
6893: IF pg_debug = 'Y'