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.IGI_EXP_APPROVAL_PKG dependencies on IGI_EXP_DUS

Line 181: l_tu_id igi_exp_dus.tu_id%TYPE;

177: IS
178:
179: itemtype VARCHAR2(30);
180: itemkey VARCHAR2(60);
181: l_tu_id igi_exp_dus.tu_id%TYPE;
182: l_du_prep_id igi_exp_dus.du_by_user_id%TYPE;
183:
184: l_du_list VARCHAR2(28000);
185: l_du VARCHAR2(4000);

Line 182: l_du_prep_id igi_exp_dus.du_by_user_id%TYPE;

178:
179: itemtype VARCHAR2(30);
180: itemkey VARCHAR2(60);
181: l_tu_id igi_exp_dus.tu_id%TYPE;
182: l_du_prep_id igi_exp_dus.du_by_user_id%TYPE;
183:
184: l_du_list VARCHAR2(28000);
185: l_du VARCHAR2(4000);
186:

Line 530: UPDATE igi_exp_dus dus

526: ' updating igi_exp_tus setting tu_status = TRA for tu_id ' || p_tu_id);
527: -- =============== END DEBUG LOG ==================
528:
529: -- Update the status of all DUs in the TU to 'Transmitted'
530: UPDATE igi_exp_dus dus
531: SET dus.du_status = 'TRA'
532: WHERE dus.tu_id = p_tu_id;
533:
534: -- =============== START DEBUG LOG ================

Line 536: ' updating igi_exp_dus setting du_status = TRA for tu_id ' || p_tu_id);

532: WHERE dus.tu_id = p_tu_id;
533:
534: -- =============== START DEBUG LOG ================
535: DEBUG_LOG_STRING (l_proc_level, 'Start_approval_workflow.Msg3',
536: ' updating igi_exp_dus setting du_status = TRA for tu_id ' || p_tu_id);
537: -- =============== END DEBUG LOG ==================
538:
539: -- Get approval run id
540: SELECT igi_exp_tu_run_s1.nextval

Line 2079: l_tu_id igi_exp_dus.tu_id%TYPE;

2075: actid IN NUMBER,
2076: funcmode IN VARCHAR2,
2077: result OUT NOCOPY VARCHAR2) IS
2078:
2079: l_tu_id igi_exp_dus.tu_id%TYPE;
2080:
2081: BEGIN
2082:
2083: -- =============== START DEBUG LOG ================

Line 2117: UPDATE igi_exp_dus dus

2113:
2114: -- Update the status of the DUs in the TU
2115: -- to 'ITU' for 'In a Transmission Unit'
2116:
2117: UPDATE igi_exp_dus dus
2118: SET dus.du_status = 'ITU'
2119: WHERE dus.tu_id = l_tu_id;
2120:
2121: -- =============== START DEBUG LOG ================

Line 2123: ' UPDATE igi_exp_dus du_status = ITU ');

2119: WHERE dus.tu_id = l_tu_id;
2120:
2121: -- =============== START DEBUG LOG ================
2122: DEBUG_LOG_STRING (l_proc_level, 'Update_dus_to_in_a_tu.Msg4',
2123: ' UPDATE igi_exp_dus du_status = ITU ');
2124: -- =============== END DEBUG LOG ==================
2125:
2126: END IF;
2127:

Line 3615: UPDATE igi_exp_dus dus

3611: ' GetItemAttrNumber TU_ID --> ' || l_tu_id);
3612: -- =============== END DEBUG LOG ==================
3613:
3614: -- Change the status of the dialog units on hold
3615: UPDATE igi_exp_dus dus
3616: SET dus.du_status = 'APP'
3617: WHERE dus.du_status = 'HLD'
3618: AND dus.tu_id = l_tu_id;
3619:

Line 3622: ' UPDATE igi_exp_dus dus HLD to APP ' || SQL%ROWCOUNT);

3618: AND dus.tu_id = l_tu_id;
3619:
3620: -- =============== START DEBUG LOG ================
3621: DEBUG_LOG_STRING (l_proc_level, 'Reset_du_statuses.Msg3',
3622: ' UPDATE igi_exp_dus dus HLD to APP ' || SQL%ROWCOUNT);
3623: -- =============== END DEBUG LOG ==================
3624:
3625: -- Change the status of dialog units which have been rejected
3626: -- but still contain transactions.

Line 3627: UPDATE igi_exp_dus dus

3623: -- =============== END DEBUG LOG ==================
3624:
3625: -- Change the status of dialog units which have been rejected
3626: -- but still contain transactions.
3627: UPDATE igi_exp_dus dus
3628: SET dus.du_status = 'APP'
3629: WHERE dus.du_status = 'REJ'
3630: AND dus.tu_id = l_tu_id
3631: AND EXISTS (SELECT 'AR'

Line 3641: ' UPDATE igi_exp_dus status - REJ to APP' || SQL%ROWCOUNT);

3637: WHERE ap.du_id = dus.du_id);
3638:
3639: -- =============== START DEBUG LOG ================
3640: DEBUG_LOG_STRING (l_proc_level, 'Reset_du_statuses.Msg4',
3641: ' UPDATE igi_exp_dus status - REJ to APP' || SQL%ROWCOUNT);
3642: -- =============== END DEBUG LOG ==================
3643:
3644: -- Change the status of the dialog units which are in status
3645: -- approved and transmitted

Line 3646: UPDATE igi_exp_dus dus

3642: -- =============== END DEBUG LOG ==================
3643:
3644: -- Change the status of the dialog units which are in status
3645: -- approved and transmitted
3646: UPDATE igi_exp_dus dus
3647: SET dus.du_status = 'APP'
3648: WHERE dus.du_status = 'ATR'
3649: AND dus.tu_id = l_tu_id;
3650:

Line 3653: ' UPDATE igi_exp_dus status -- ATR to APP ' || SQL%ROWCOUNT);

3649: AND dus.tu_id = l_tu_id;
3650:
3651: -- =============== START DEBUG LOG ================
3652: DEBUG_LOG_STRING (l_proc_level, 'Reset_du_statuses.Msg5',
3653: ' UPDATE igi_exp_dus status -- ATR to APP ' || SQL%ROWCOUNT);
3654: -- =============== END DEBUG LOG ==================
3655:
3656: END IF;
3657:

Line 3723: FROM igi_exp_dus

3719: -- i.e. that they have been set to a status of Approved(APP)
3720: -- Rejected (REJ) or On Hold (HLD)
3721: SELECT count(*)
3722: INTO l_no_of_dus
3723: FROM igi_exp_dus
3724: WHERE tu_id = l_tu_id
3725: AND du_status NOT IN ('APP','REJ','HLD');
3726:
3727: -- =============== START DEBUG LOG ================

Line 3808: UPDATE igi_exp_dus

3804: DEBUG_LOG_STRING (l_proc_level, 'Set_dus_to_atr.Msg2',
3805: ' GetItemAttrNumber TU_ID --> ' || l_tu_id);
3806: -- =============== END DEBUG LOG ==================
3807:
3808: UPDATE igi_exp_dus
3809: SET du_status = 'ATR'
3810: WHERE du_status = 'APP'
3811: AND tu_id = l_tu_id;
3812:

Line 3815: ' UPDATE igi_exp_dus APP - ATR');

3811: AND tu_id = l_tu_id;
3812:
3813: -- =============== START DEBUG LOG ================
3814: DEBUG_LOG_STRING (l_proc_level, 'Set_dus_to_atr.Msg3',
3815: ' UPDATE igi_exp_dus APP - ATR');
3816: -- =============== END DEBUG LOG ==================
3817:
3818: END IF;
3819:

Line 3856: CURSOR c_du_hold_info(p_tu_id igi_exp_dus.tu_id%TYPE)

3852: result OUT NOCOPY VARCHAR2)
3853: IS
3854:
3855:
3856: CURSOR c_du_hold_info(p_tu_id igi_exp_dus.tu_id%TYPE)
3857: IS
3858: SELECT du_order_number
3859: ,du_legal_number
3860: FROM igi_exp_dus

Line 3860: FROM igi_exp_dus

3856: CURSOR c_du_hold_info(p_tu_id igi_exp_dus.tu_id%TYPE)
3857: IS
3858: SELECT du_order_number
3859: ,du_legal_number
3860: FROM igi_exp_dus
3861: WHERE tu_id = p_tu_id
3862: AND du_status = 'HLD';
3863:
3864: l_tu_id igi_exp_dus.tu_id%TYPE;

Line 3864: l_tu_id igi_exp_dus.tu_id%TYPE;

3860: FROM igi_exp_dus
3861: WHERE tu_id = p_tu_id
3862: AND du_status = 'HLD';
3863:
3864: l_tu_id igi_exp_dus.tu_id%TYPE;
3865: l_hold_count NUMBER;
3866: l_du_hold_list VARCHAR2(28000);
3867:
3868: BEGIN

Line 3890: FROM igi_exp_dus

3886: -- =============== END DEBUG LOG ==================
3887:
3888: SELECT count(*)
3889: INTO l_hold_count
3890: FROM igi_exp_dus
3891: WHERE du_status = 'HLD'
3892: AND tu_id = l_tu_id;
3893:
3894: -- =============== START DEBUG LOG ================

Line 4078: CURSOR c_next_du_hld(p_tu_id igi_exp_dus.tu_id%TYPE)

4074: actid IN NUMBER,
4075: funcmode IN VARCHAR2,
4076: result OUT NOCOPY VARCHAR2) IS
4077:
4078: CURSOR c_next_du_hld(p_tu_id igi_exp_dus.tu_id%TYPE)
4079: IS
4080: SELECT du_id
4081: ,du_by_user_id
4082: FROM igi_exp_dus

Line 4082: FROM igi_exp_dus

4078: CURSOR c_next_du_hld(p_tu_id igi_exp_dus.tu_id%TYPE)
4079: IS
4080: SELECT du_id
4081: ,du_by_user_id
4082: FROM igi_exp_dus
4083: WHERE tu_id = p_tu_id
4084: AND du_status = 'HLD'
4085: AND rownum = 1;
4086:

Line 4087: CURSOR c_du_info(p_tu_id igi_exp_dus.tu_id%TYPE

4083: WHERE tu_id = p_tu_id
4084: AND du_status = 'HLD'
4085: AND rownum = 1;
4086:
4087: CURSOR c_du_info(p_tu_id igi_exp_dus.tu_id%TYPE
4088: ,p_du_preparer_id igi_exp_dus.du_by_user_id%TYPE)
4089: IS
4090: SELECT du_order_number
4091: ,du_legal_number

Line 4088: ,p_du_preparer_id igi_exp_dus.du_by_user_id%TYPE)

4084: AND du_status = 'HLD'
4085: AND rownum = 1;
4086:
4087: CURSOR c_du_info(p_tu_id igi_exp_dus.tu_id%TYPE
4088: ,p_du_preparer_id igi_exp_dus.du_by_user_id%TYPE)
4089: IS
4090: SELECT du_order_number
4091: ,du_legal_number
4092: FROM igi_exp_dus

Line 4092: FROM igi_exp_dus

4088: ,p_du_preparer_id igi_exp_dus.du_by_user_id%TYPE)
4089: IS
4090: SELECT du_order_number
4091: ,du_legal_number
4092: FROM igi_exp_dus
4093: WHERE tu_id = p_tu_id
4094: AND du_status = 'HLD'
4095: AND du_by_user_id = p_du_preparer_id;
4096:

Line 4097: l_tu_id igi_exp_dus.tu_id%TYPE;

4093: WHERE tu_id = p_tu_id
4094: AND du_status = 'HLD'
4095: AND du_by_user_id = p_du_preparer_id;
4096:
4097: l_tu_id igi_exp_dus.tu_id%TYPE;
4098: l_du_id igi_exp_dus.du_id%TYPE;
4099: l_du_prep_id igi_exp_dus.du_by_user_id%TYPE;
4100: l_du_prep_name fnd_user.user_name%TYPE;
4101: l_du_by_prep_list VARCHAR2(28000);

Line 4098: l_du_id igi_exp_dus.du_id%TYPE;

4094: AND du_status = 'HLD'
4095: AND du_by_user_id = p_du_preparer_id;
4096:
4097: l_tu_id igi_exp_dus.tu_id%TYPE;
4098: l_du_id igi_exp_dus.du_id%TYPE;
4099: l_du_prep_id igi_exp_dus.du_by_user_id%TYPE;
4100: l_du_prep_name fnd_user.user_name%TYPE;
4101: l_du_by_prep_list VARCHAR2(28000);
4102:

Line 4099: l_du_prep_id igi_exp_dus.du_by_user_id%TYPE;

4095: AND du_by_user_id = p_du_preparer_id;
4096:
4097: l_tu_id igi_exp_dus.tu_id%TYPE;
4098: l_du_id igi_exp_dus.du_id%TYPE;
4099: l_du_prep_id igi_exp_dus.du_by_user_id%TYPE;
4100: l_du_prep_name fnd_user.user_name%TYPE;
4101: l_du_by_prep_list VARCHAR2(28000);
4102:
4103: BEGIN

Line 4345: l_tu_id igi_exp_dus.tu_id%TYPE;

4341: actid IN NUMBER,
4342: funcmode IN VARCHAR2,
4343: result OUT NOCOPY VARCHAR2) IS
4344:
4345: l_tu_id igi_exp_dus.tu_id%TYPE;
4346: l_du_prep_id igi_exp_dus.du_by_user_id%TYPE;
4347: l_du_amount igi_exp_dus.du_amount%TYPE;
4348:
4349: BEGIN

Line 4346: l_du_prep_id igi_exp_dus.du_by_user_id%TYPE;

4342: funcmode IN VARCHAR2,
4343: result OUT NOCOPY VARCHAR2) IS
4344:
4345: l_tu_id igi_exp_dus.tu_id%TYPE;
4346: l_du_prep_id igi_exp_dus.du_by_user_id%TYPE;
4347: l_du_amount igi_exp_dus.du_amount%TYPE;
4348:
4349: BEGIN
4350:

Line 4347: l_du_amount igi_exp_dus.du_amount%TYPE;

4343: result OUT NOCOPY VARCHAR2) IS
4344:
4345: l_tu_id igi_exp_dus.tu_id%TYPE;
4346: l_du_prep_id igi_exp_dus.du_by_user_id%TYPE;
4347: l_du_amount igi_exp_dus.du_amount%TYPE;
4348:
4349: BEGIN
4350:
4351: -- =============== START DEBUG LOG ================

Line 4385: FROM igi_exp_dus

4381: -- i.e. New TU amount = TU amount - released DU amount
4382: -- Find the total amount of all DUs about to be released
4383: SELECT sum(du_amount)
4384: INTO l_du_amount
4385: FROM igi_exp_dus
4386: WHERE tu_id = l_tu_id
4387: AND du_by_user_id = l_du_prep_id
4388: AND du_status = 'HLD';
4389:

Line 4408: UPDATE igi_exp_dus

4404:
4405: -- Want to release all DUs in this TU with status 'On Hold' which
4406: -- have been prepared by this user.
4407:
4408: UPDATE igi_exp_dus
4409: SET tu_id = null
4410: WHERE tu_id = l_tu_id
4411: AND du_by_user_id = l_du_prep_id
4412: AND du_status = 'HLD';

Line 4416: ' UPDATE igi_exp_dus tu_id to NULL --> ' || SQL%ROWCOUNT);

4412: AND du_status = 'HLD';
4413:
4414: -- =============== START DEBUG LOG ================
4415: DEBUG_LOG_STRING (l_proc_level, 'Remove_dus_on_hold.Msg6',
4416: ' UPDATE igi_exp_dus tu_id to NULL --> ' || SQL%ROWCOUNT);
4417: -- =============== END DEBUG LOG ==================
4418:
4419: END IF;
4420:

Line 4464: CURSOR c_du_rej_info(p_tu_id igi_exp_dus.tu_id%TYPE)

4460: actid IN NUMBER,
4461: funcmode IN VARCHAR2,
4462: result OUT NOCOPY VARCHAR2) IS
4463:
4464: CURSOR c_du_rej_info(p_tu_id igi_exp_dus.tu_id%TYPE)
4465: IS
4466: SELECT du_order_number
4467: ,du_legal_number
4468: FROM igi_exp_dus du

Line 4468: FROM igi_exp_dus du

4464: CURSOR c_du_rej_info(p_tu_id igi_exp_dus.tu_id%TYPE)
4465: IS
4466: SELECT du_order_number
4467: ,du_legal_number
4468: FROM igi_exp_dus du
4469: WHERE tu_id = p_tu_id
4470: AND du_status = 'REJ';
4471:
4472: l_tu_id igi_exp_dus.tu_id%TYPE;

Line 4472: l_tu_id igi_exp_dus.tu_id%TYPE;

4468: FROM igi_exp_dus du
4469: WHERE tu_id = p_tu_id
4470: AND du_status = 'REJ';
4471:
4472: l_tu_id igi_exp_dus.tu_id%TYPE;
4473: l_rej_count NUMBER;
4474: l_du_rej_list VARCHAR2(28000);
4475:
4476:

Line 4501: FROM igi_exp_dus du

4497: -- Find out NOCOPY if there are any DUs which have been rejected
4498: -- (i.e. if the status of the DU is 'Rejected' )
4499: SELECT count(*)
4500: INTO l_rej_count
4501: FROM igi_exp_dus du
4502: WHERE tu_id = l_tu_id
4503: AND du_status = 'REJ';
4504:
4505: -- =============== START DEBUG LOG ================

Line 4692: CURSOR c_next_du_rej(p_tu_id igi_exp_dus.tu_id%TYPE)

4688: actid IN NUMBER,
4689: funcmode IN VARCHAR2,
4690: result OUT NOCOPY VARCHAR2) IS
4691:
4692: CURSOR c_next_du_rej(p_tu_id igi_exp_dus.tu_id%TYPE)
4693: IS
4694: SELECT du_id
4695: ,du_by_user_id
4696: FROM igi_exp_dus du

Line 4696: FROM igi_exp_dus du

4692: CURSOR c_next_du_rej(p_tu_id igi_exp_dus.tu_id%TYPE)
4693: IS
4694: SELECT du_id
4695: ,du_by_user_id
4696: FROM igi_exp_dus du
4697: WHERE tu_id = p_tu_id
4698: AND du_status = 'REJ'
4699: AND rownum = 1;
4700:

Line 4701: CURSOR c_rej_du_info(p_tu_id igi_exp_dus.tu_id%TYPE

4697: WHERE tu_id = p_tu_id
4698: AND du_status = 'REJ'
4699: AND rownum = 1;
4700:
4701: CURSOR c_rej_du_info(p_tu_id igi_exp_dus.tu_id%TYPE
4702: ,p_du_preparer_id igi_exp_dus.du_by_user_id%TYPE)
4703: IS
4704: SELECT du_order_number
4705: ,du_legal_number

Line 4702: ,p_du_preparer_id igi_exp_dus.du_by_user_id%TYPE)

4698: AND du_status = 'REJ'
4699: AND rownum = 1;
4700:
4701: CURSOR c_rej_du_info(p_tu_id igi_exp_dus.tu_id%TYPE
4702: ,p_du_preparer_id igi_exp_dus.du_by_user_id%TYPE)
4703: IS
4704: SELECT du_order_number
4705: ,du_legal_number
4706: FROM igi_exp_dus du

Line 4706: FROM igi_exp_dus du

4702: ,p_du_preparer_id igi_exp_dus.du_by_user_id%TYPE)
4703: IS
4704: SELECT du_order_number
4705: ,du_legal_number
4706: FROM igi_exp_dus du
4707: WHERE tu_id = p_tu_id
4708: AND du_status = 'REJ'
4709: AND du_by_user_id = p_du_preparer_id;
4710:

Line 4711: l_tu_id igi_exp_dus.tu_id%TYPE;

4707: WHERE tu_id = p_tu_id
4708: AND du_status = 'REJ'
4709: AND du_by_user_id = p_du_preparer_id;
4710:
4711: l_tu_id igi_exp_dus.tu_id%TYPE;
4712: l_du_id igi_exp_dus.du_id%TYPE;
4713: l_du_prep_id igi_exp_dus.du_by_user_id%TYPE;
4714: l_du_prep_name fnd_user.user_name%TYPE;
4715: l_no NUMBER := 0 ;

Line 4712: l_du_id igi_exp_dus.du_id%TYPE;

4708: AND du_status = 'REJ'
4709: AND du_by_user_id = p_du_preparer_id;
4710:
4711: l_tu_id igi_exp_dus.tu_id%TYPE;
4712: l_du_id igi_exp_dus.du_id%TYPE;
4713: l_du_prep_id igi_exp_dus.du_by_user_id%TYPE;
4714: l_du_prep_name fnd_user.user_name%TYPE;
4715: l_no NUMBER := 0 ;
4716: l_du_rej_list VARCHAR2(28000);

Line 4713: l_du_prep_id igi_exp_dus.du_by_user_id%TYPE;

4709: AND du_by_user_id = p_du_preparer_id;
4710:
4711: l_tu_id igi_exp_dus.tu_id%TYPE;
4712: l_du_id igi_exp_dus.du_id%TYPE;
4713: l_du_prep_id igi_exp_dus.du_by_user_id%TYPE;
4714: l_du_prep_name fnd_user.user_name%TYPE;
4715: l_no NUMBER := 0 ;
4716: l_du_rej_list VARCHAR2(28000);
4717:

Line 4961: CURSOR c_rej_dus(p_tu_id igi_exp_dus.tu_id%TYPE

4957: actid IN NUMBER,
4958: funcmode IN VARCHAR2,
4959: result OUT NOCOPY VARCHAR2) IS
4960:
4961: CURSOR c_rej_dus(p_tu_id igi_exp_dus.tu_id%TYPE
4962: ,p_du_preparer_id igi_exp_dus.du_by_user_id%TYPE)
4963: IS
4964: SELECT du_id
4965: FROM igi_exp_dus du

Line 4962: ,p_du_preparer_id igi_exp_dus.du_by_user_id%TYPE)

4958: funcmode IN VARCHAR2,
4959: result OUT NOCOPY VARCHAR2) IS
4960:
4961: CURSOR c_rej_dus(p_tu_id igi_exp_dus.tu_id%TYPE
4962: ,p_du_preparer_id igi_exp_dus.du_by_user_id%TYPE)
4963: IS
4964: SELECT du_id
4965: FROM igi_exp_dus du
4966: WHERE tu_id = p_tu_id

Line 4965: FROM igi_exp_dus du

4961: CURSOR c_rej_dus(p_tu_id igi_exp_dus.tu_id%TYPE
4962: ,p_du_preparer_id igi_exp_dus.du_by_user_id%TYPE)
4963: IS
4964: SELECT du_id
4965: FROM igi_exp_dus du
4966: WHERE tu_id = p_tu_id
4967: AND du_status = 'REJ'
4968: AND du_by_user_id = p_du_preparer_id
4969: AND EXISTS (SELECT 'AR'

Line 4977: l_tu_id igi_exp_dus.tu_id%TYPE;

4973: SELECT 'AP'
4974: FROM igi_exp_ap_trans ap
4975: WHERE ap.du_id = du.du_id);
4976:
4977: l_tu_id igi_exp_dus.tu_id%TYPE;
4978: l_du_prep_id igi_exp_dus.du_by_user_id%TYPE;
4979: l_du_id igi_exp_dus.du_id%TYPE;
4980: l_du_amount igi_exp_dus.du_amount%TYPE;
4981:

Line 4978: l_du_prep_id igi_exp_dus.du_by_user_id%TYPE;

4974: FROM igi_exp_ap_trans ap
4975: WHERE ap.du_id = du.du_id);
4976:
4977: l_tu_id igi_exp_dus.tu_id%TYPE;
4978: l_du_prep_id igi_exp_dus.du_by_user_id%TYPE;
4979: l_du_id igi_exp_dus.du_id%TYPE;
4980: l_du_amount igi_exp_dus.du_amount%TYPE;
4981:
4982: BEGIN

Line 4979: l_du_id igi_exp_dus.du_id%TYPE;

4975: WHERE ap.du_id = du.du_id);
4976:
4977: l_tu_id igi_exp_dus.tu_id%TYPE;
4978: l_du_prep_id igi_exp_dus.du_by_user_id%TYPE;
4979: l_du_id igi_exp_dus.du_id%TYPE;
4980: l_du_amount igi_exp_dus.du_amount%TYPE;
4981:
4982: BEGIN
4983:

Line 4980: l_du_amount igi_exp_dus.du_amount%TYPE;

4976:
4977: l_tu_id igi_exp_dus.tu_id%TYPE;
4978: l_du_prep_id igi_exp_dus.du_by_user_id%TYPE;
4979: l_du_id igi_exp_dus.du_id%TYPE;
4980: l_du_amount igi_exp_dus.du_amount%TYPE;
4981:
4982: BEGIN
4983:
4984: -- =============== START DEBUG LOG ================

Line 5046: FROM igi_exp_dus

5042:
5043: -- First find the total DU amount
5044: SELECT sum(du_amount)
5045: INTO l_du_amount
5046: FROM igi_exp_dus
5047: WHERE tu_id = l_tu_id
5048: AND du_by_user_id = l_du_prep_id
5049: AND du_status = 'REJ';
5050:

Line 5067: UPDATE igi_exp_dus

5063: ' UPDATE igi_exp_tus --> ' || SQL%ROWCOUNT);
5064: -- =============== END DEBUG LOG ==================
5065:
5066: -- Now update the DU amount to 0
5067: UPDATE igi_exp_dus
5068: SET du_amount = 0
5069: WHERE tu_id = l_tu_id
5070: AND du_by_user_id = l_du_prep_id
5071: AND du_status = 'REJ';

Line 5077: ' UPDATE igi_exp_dus du_amount = 0 --> ' || SQL%ROWCOUNT);

5073: -- OPSF(I) EXP Bug 2415293 S Brewer 18-JUL-2002 End(2)
5074:
5075: -- =============== START DEBUG LOG ================
5076: DEBUG_LOG_STRING (l_proc_level, 'Rem_trx_from_rej_dus.Msg8',
5077: ' UPDATE igi_exp_dus du_amount = 0 --> ' || SQL%ROWCOUNT);
5078: -- =============== END DEBUG LOG ==================
5079:
5080: END IF;
5081:

Line 5209: l_tu_id igi_exp_dus.tu_id%TYPE;

5205: actid IN NUMBER,
5206: funcmode IN VARCHAR2,
5207: result OUT NOCOPY VARCHAR2) IS
5208:
5209: l_tu_id igi_exp_dus.tu_id%TYPE;
5210: l_tu_type_header_id igi_exp_tus.tu_type_header_id%TYPE;
5211: l_tu_fiscal_year igi_exp_tus.tu_fiscal_year%TYPE;
5212: l_tu_legal_number igi_exp_tus.tu_legal_number%TYPE;
5213: l_tu_full_number VARCHAR2(240);

Line 5385: CURSOR c_get_du(p_tu_id igi_exp_dus.tu_id%TYPE)

5381: actid IN NUMBER,
5382: funcmode IN VARCHAR2,
5383: result OUT NOCOPY VARCHAR2) IS
5384:
5385: CURSOR c_get_du(p_tu_id igi_exp_dus.tu_id%TYPE)
5386: IS
5387: SELECT du_id
5388: ,du_type_header_id
5389: ,du_fiscal_year

Line 5391: FROM igi_exp_dus

5387: SELECT du_id
5388: ,du_type_header_id
5389: ,du_fiscal_year
5390: ,du_order_number
5391: FROM igi_exp_dus
5392: WHERE tu_id = p_tu_id
5393: AND du_status = 'ATR';
5394:
5395: l_tu_id igi_exp_dus.tu_id%TYPE;

Line 5395: l_tu_id igi_exp_dus.tu_id%TYPE;

5391: FROM igi_exp_dus
5392: WHERE tu_id = p_tu_id
5393: AND du_status = 'ATR';
5394:
5395: l_tu_id igi_exp_dus.tu_id%TYPE;
5396: l_du_id igi_exp_dus.du_id%TYPE;
5397: l_du_type_header_id igi_exp_dus.du_type_header_id%TYPE;
5398: l_du_fiscal_year igi_exp_dus.du_fiscal_year%TYPE;
5399: l_du_order_number igi_exp_dus.du_order_number%TYPE;

Line 5396: l_du_id igi_exp_dus.du_id%TYPE;

5392: WHERE tu_id = p_tu_id
5393: AND du_status = 'ATR';
5394:
5395: l_tu_id igi_exp_dus.tu_id%TYPE;
5396: l_du_id igi_exp_dus.du_id%TYPE;
5397: l_du_type_header_id igi_exp_dus.du_type_header_id%TYPE;
5398: l_du_fiscal_year igi_exp_dus.du_fiscal_year%TYPE;
5399: l_du_order_number igi_exp_dus.du_order_number%TYPE;
5400: l_du_legal_number igi_exp_dus.du_legal_number%TYPE;

Line 5397: l_du_type_header_id igi_exp_dus.du_type_header_id%TYPE;

5393: AND du_status = 'ATR';
5394:
5395: l_tu_id igi_exp_dus.tu_id%TYPE;
5396: l_du_id igi_exp_dus.du_id%TYPE;
5397: l_du_type_header_id igi_exp_dus.du_type_header_id%TYPE;
5398: l_du_fiscal_year igi_exp_dus.du_fiscal_year%TYPE;
5399: l_du_order_number igi_exp_dus.du_order_number%TYPE;
5400: l_du_legal_number igi_exp_dus.du_legal_number%TYPE;
5401: l_error_message VARCHAR2(250);

Line 5398: l_du_fiscal_year igi_exp_dus.du_fiscal_year%TYPE;

5394:
5395: l_tu_id igi_exp_dus.tu_id%TYPE;
5396: l_du_id igi_exp_dus.du_id%TYPE;
5397: l_du_type_header_id igi_exp_dus.du_type_header_id%TYPE;
5398: l_du_fiscal_year igi_exp_dus.du_fiscal_year%TYPE;
5399: l_du_order_number igi_exp_dus.du_order_number%TYPE;
5400: l_du_legal_number igi_exp_dus.du_legal_number%TYPE;
5401: l_error_message VARCHAR2(250);
5402: l_du_failed VARCHAR2(1):='N';

Line 5399: l_du_order_number igi_exp_dus.du_order_number%TYPE;

5395: l_tu_id igi_exp_dus.tu_id%TYPE;
5396: l_du_id igi_exp_dus.du_id%TYPE;
5397: l_du_type_header_id igi_exp_dus.du_type_header_id%TYPE;
5398: l_du_fiscal_year igi_exp_dus.du_fiscal_year%TYPE;
5399: l_du_order_number igi_exp_dus.du_order_number%TYPE;
5400: l_du_legal_number igi_exp_dus.du_legal_number%TYPE;
5401: l_error_message VARCHAR2(250);
5402: l_du_failed VARCHAR2(1):='N';
5403:

Line 5400: l_du_legal_number igi_exp_dus.du_legal_number%TYPE;

5396: l_du_id igi_exp_dus.du_id%TYPE;
5397: l_du_type_header_id igi_exp_dus.du_type_header_id%TYPE;
5398: l_du_fiscal_year igi_exp_dus.du_fiscal_year%TYPE;
5399: l_du_order_number igi_exp_dus.du_order_number%TYPE;
5400: l_du_legal_number igi_exp_dus.du_legal_number%TYPE;
5401: l_error_message VARCHAR2(250);
5402: l_du_failed VARCHAR2(1):='N';
5403:
5404: BEGIN

Line 5525: UPDATE igi_exp_dus

5521: ELSE
5522:
5523: -- DU Legal number was generated successfully
5524: -- Apply the legal number to the DU
5525: UPDATE igi_exp_dus
5526: SET du_legal_number = l_du_legal_number
5527: WHERE du_id = l_du_id;
5528:
5529: -- =============== START DEBUG LOG ================

Line 5531: ' UPDATE igi_exp_dus --> ' || SQL%ROWCOUNT);

5527: WHERE du_id = l_du_id;
5528:
5529: -- =============== START DEBUG LOG ================
5530: DEBUG_LOG_STRING (l_proc_level, 'Apply_du_legal_num.Msg12',
5531: ' UPDATE igi_exp_dus --> ' || SQL%ROWCOUNT);
5532: -- =============== END DEBUG LOG ==================
5533:
5534: END IF;
5535: END LOOP;

Line 5593: l_tu_id igi_exp_dus.tu_id%TYPE;

5589: actid IN NUMBER,
5590: funcmode IN VARCHAR2,
5591: result OUT NOCOPY VARCHAR2) IS
5592:
5593: l_tu_id igi_exp_dus.tu_id%TYPE;
5594: l_tu_status igi_exp_tus.tu_status%TYPE;
5595: l_atr_du_count NUMBER;
5596:
5597: -- Bug 4051910

Line 5652: FROM igi_exp_dus

5648:
5649: -- Find how many DUs in the TU are approved
5650: SELECT count(*)
5651: INTO l_atr_du_count
5652: FROM igi_exp_dus
5653: WHERE tu_id = l_tu_id
5654: AND du_status = 'ATR';
5655:
5656: -- =============== START DEBUG LOG ================

Line 5906: l_tu_id igi_exp_dus.tu_id%TYPE;

5902: actid IN NUMBER,
5903: funcmode IN VARCHAR2,
5904: result OUT NOCOPY VARCHAR2) IS
5905:
5906: l_tu_id igi_exp_dus.tu_id%TYPE;
5907: l_du_prep_name fnd_user.user_name%TYPE;
5908: l_du_id igi_exp_dus.du_id%TYPE;
5909:
5910: BEGIN

Line 5908: l_du_id igi_exp_dus.du_id%TYPE;

5904: result OUT NOCOPY VARCHAR2) IS
5905:
5906: l_tu_id igi_exp_dus.tu_id%TYPE;
5907: l_du_prep_name fnd_user.user_name%TYPE;
5908: l_du_id igi_exp_dus.du_id%TYPE;
5909:
5910: BEGIN
5911:
5912: -- =============== START DEBUG LOG ================

Line 5935: FROM igi_exp_dus du

5931: SELECT du.du_id
5932: ,fnd.user_name
5933: INTO l_du_id
5934: ,l_du_prep_name
5935: FROM igi_exp_dus du
5936: ,fnd_user fnd
5937: WHERE du.tu_id = l_tu_id
5938: AND du.du_status = 'ATR'
5939: AND du.du_by_user_id = fnd.user_id

Line 6005: l_du_id igi_exp_dus.du_id%TYPE;

6001: actid IN NUMBER,
6002: funcmode IN VARCHAR2,
6003: result OUT NOCOPY VARCHAR2) IS
6004:
6005: l_du_id igi_exp_dus.du_id%TYPE;
6006: l_app_id igi_exp_du_type_headers.application_id%TYPE;
6007: l_order_number igi_exp_dus.du_order_number%TYPE;
6008: l_legal_number igi_exp_dus.du_legal_number%TYPE;
6009: l_failed_du VARCHAR2(510);

Line 6007: l_order_number igi_exp_dus.du_order_number%TYPE;

6003: result OUT NOCOPY VARCHAR2) IS
6004:
6005: l_du_id igi_exp_dus.du_id%TYPE;
6006: l_app_id igi_exp_du_type_headers.application_id%TYPE;
6007: l_order_number igi_exp_dus.du_order_number%TYPE;
6008: l_legal_number igi_exp_dus.du_legal_number%TYPE;
6009: l_failed_du VARCHAR2(510);
6010: l_failed_trx VARCHAR2(50);
6011: l_gl_date DATE := sysdate;

Line 6008: l_legal_number igi_exp_dus.du_legal_number%TYPE;

6004:
6005: l_du_id igi_exp_dus.du_id%TYPE;
6006: l_app_id igi_exp_du_type_headers.application_id%TYPE;
6007: l_order_number igi_exp_dus.du_order_number%TYPE;
6008: l_legal_number igi_exp_dus.du_legal_number%TYPE;
6009: l_failed_du VARCHAR2(510);
6010: l_failed_trx VARCHAR2(50);
6011: l_gl_date DATE := sysdate;
6012: l_error_message VARCHAR2(4000);

Line 6040: ,igi_exp_dus du

6036: -- Get the application id for the du
6037: SELECT du_type.application_id
6038: INTO l_app_id
6039: FROM igi_exp_du_type_headers_all du_type
6040: ,igi_exp_dus du
6041: WHERE du.du_id = l_du_id
6042: AND du.du_type_header_id = du_type.du_type_header_id;
6043:
6044: -- =============== START DEBUG LOG ================

Line 6067: FROM igi_exp_dus

6063: IF (l_error_message <> 'Success') THEN
6064:
6065: SELECT du_order_number, du_legal_number
6066: INTO l_order_number, l_legal_number
6067: FROM igi_exp_dus
6068: WHERE du_id = l_du_id;
6069:
6070: -- =============== START DEBUG LOG ================
6071: DEBUG_LOG_STRING (l_proc_level, 'Process_transactions.Msg6',

Line 6242: l_du_id igi_exp_dus.du_id%TYPE;

6238: actid IN NUMBER,
6239: funcmode IN VARCHAR2,
6240: result OUT NOCOPY VARCHAR2) IS
6241:
6242: l_du_id igi_exp_dus.du_id%TYPE;
6243:
6244: BEGIN
6245:
6246: -- =============== START DEBUG LOG ================

Line 6264: UPDATE igi_exp_dus

6260: DEBUG_LOG_STRING (l_proc_level, 'Set_du_to_complete.Msg1',
6261: ' GetItemAttrNumber DU_ID_FOR_COMPLETION --> '|| l_du_id);
6262: -- =============== END DEBUG LOG ==================
6263:
6264: UPDATE igi_exp_dus
6265: SET du_status = 'COM'
6266: WHERE du_id = l_du_id;
6267:
6268: -- =============== START DEBUG LOG ================

Line 6270: ' UPDATE igi_exp_dus status - COM --> ' || SQL%ROWCOUNT);

6266: WHERE du_id = l_du_id;
6267:
6268: -- =============== START DEBUG LOG ================
6269: DEBUG_LOG_STRING (l_proc_level, 'Set_du_to_complete.Msg1',
6270: ' UPDATE igi_exp_dus status - COM --> ' || SQL%ROWCOUNT);
6271: -- =============== END DEBUG LOG ==================
6272:
6273: END IF;
6274:

Line 6312: l_du_id igi_exp_dus.du_id%TYPE;

6308: actid IN NUMBER,
6309: funcmode IN VARCHAR2,
6310: result OUT NOCOPY VARCHAR2) IS
6311:
6312: l_du_id igi_exp_dus.du_id%TYPE;
6313:
6314: BEGIN
6315:
6316: -- =============== START DEBUG LOG ================

Line 6334: UPDATE igi_exp_dus

6330: DEBUG_LOG_STRING (l_proc_level, 'Put_failed_du_on_hold.Msg2',
6331: ' GetItemAttrNumber DU_ID_FOR_COMPLETION --> ' || l_du_id);
6332: -- =============== END DEBUG LOG ==================
6333:
6334: UPDATE igi_exp_dus
6335: SET du_status = 'HLD'
6336: WHERE du_id = l_du_id;
6337:
6338: -- =============== START DEBUG LOG ================

Line 6340: ' UPDATE igi_exp_dus du_status = HLD --> ' || SQL%ROWCOUNT);

6336: WHERE du_id = l_du_id;
6337:
6338: -- =============== START DEBUG LOG ================
6339: DEBUG_LOG_STRING (l_proc_level, 'Put_failed_du_on_hold.Msg3',
6340: ' UPDATE igi_exp_dus du_status = HLD --> ' || SQL%ROWCOUNT);
6341: -- =============== END DEBUG LOG ==================
6342:
6343: END IF;
6344:

Line 6381: l_tu_id igi_exp_dus.tu_id%TYPE;

6377: actid IN NUMBER,
6378: funcmode IN VARCHAR2,
6379: result OUT NOCOPY VARCHAR2) IS
6380:
6381: l_tu_id igi_exp_dus.tu_id%TYPE;
6382: l_incom_count NUMBER;
6383:
6384: BEGIN
6385:

Line 6406: FROM igi_exp_dus

6402: -- =============== END DEBUG LOG ==================
6403:
6404: SELECT count(*)
6405: INTO l_incom_count
6406: FROM igi_exp_dus
6407: WHERE tu_id = l_tu_id
6408: AND du_status = 'ATR';
6409:
6410: -- =============== START DEBUG LOG ================

Line 6470: l_tu_id igi_exp_dus.tu_id%TYPE;

6466: funcmode IN VARCHAR2,
6467: result OUT NOCOPY VARCHAR2) IS
6468:
6469:
6470: l_tu_id igi_exp_dus.tu_id%TYPE;
6471: l_failed_du_count NUMBER;
6472: l_du_hold_list VARCHAR2(28000);
6473:
6474: CURSOR c_du_hold_info(p_tu_id igi_exp_dus.tu_id%TYPE)

Line 6474: CURSOR c_du_hold_info(p_tu_id igi_exp_dus.tu_id%TYPE)

6470: l_tu_id igi_exp_dus.tu_id%TYPE;
6471: l_failed_du_count NUMBER;
6472: l_du_hold_list VARCHAR2(28000);
6473:
6474: CURSOR c_du_hold_info(p_tu_id igi_exp_dus.tu_id%TYPE)
6475: IS
6476: SELECT du_order_number
6477: ,du_legal_number
6478: FROM igi_exp_dus

Line 6478: FROM igi_exp_dus

6474: CURSOR c_du_hold_info(p_tu_id igi_exp_dus.tu_id%TYPE)
6475: IS
6476: SELECT du_order_number
6477: ,du_legal_number
6478: FROM igi_exp_dus
6479: WHERE tu_id = p_tu_id
6480: AND du_status = 'HLD';
6481:
6482: BEGIN

Line 6504: FROM igi_exp_dus

6500: -- =============== END DEBUG LOG ==================
6501:
6502: SELECT count(*)
6503: INTO l_failed_du_count
6504: FROM igi_exp_dus
6505: WHERE tu_id = l_tu_id
6506: AND du_status = 'HLD';
6507:
6508: -- =============== START DEBUG LOG ================

Line 6688: l_tu_id igi_exp_dus.tu_id%TYPE;

6684: actid IN NUMBER,
6685: funcmode IN VARCHAR2,
6686: result OUT NOCOPY VARCHAR2) IS
6687:
6688: l_tu_id igi_exp_dus.tu_id%TYPE;
6689: l_du_amount igi_exp_dus.du_amount%TYPE;
6690:
6691: BEGIN
6692:

Line 6689: l_du_amount igi_exp_dus.du_amount%TYPE;

6685: funcmode IN VARCHAR2,
6686: result OUT NOCOPY VARCHAR2) IS
6687:
6688: l_tu_id igi_exp_dus.tu_id%TYPE;
6689: l_du_amount igi_exp_dus.du_amount%TYPE;
6690:
6691: BEGIN
6692:
6693: -- =============== START DEBUG LOG ================

Line 6721: FROM igi_exp_dus

6717:
6718: -- Find the total DU amount
6719: SELECT sum(du_amount)
6720: INTO l_du_amount
6721: FROM igi_exp_dus
6722: WHERE tu_id = l_tu_id
6723: AND du_status = 'HLD';
6724:
6725: -- =============== START DEBUG LOG ================

Line 6745: UPDATE igi_exp_dus

6741: -- OPSF(I) EXP Bug 2415293 S Brewer 18-JUL-2002 End(3)
6742:
6743: -- Remove the DUs which were put on hold (due to transaction
6744: -- completion failure) from the TU
6745: UPDATE igi_exp_dus
6746: SET tu_id = null
6747: WHERE tu_id = l_tu_id
6748: AND du_status = 'HLD';
6749:

Line 6752: ' UPDATE igi_exp_dus status = HLD --> ' || SQL%ROWCOUNT);

6748: AND du_status = 'HLD';
6749:
6750: -- =============== START DEBUG LOG ================
6751: DEBUG_LOG_STRING (l_proc_level, 'Remove_all_on_hold_dus.Msg5',
6752: ' UPDATE igi_exp_dus status = HLD --> ' || SQL%ROWCOUNT);
6753: -- =============== END DEBUG LOG ==================
6754:
6755: END IF;
6756:

Line 6794: l_tu_id igi_exp_dus.tu_id%TYPE;

6790: actid IN NUMBER,
6791: funcmode IN VARCHAR2,
6792: result OUT NOCOPY VARCHAR2) IS
6793:
6794: l_tu_id igi_exp_dus.tu_id%TYPE;
6795: l_com_du_count NUMBER;
6796:
6797: BEGIN
6798:

Line 6819: FROM igi_exp_dus

6815: -- =============== END DEBUG LOG ==================
6816:
6817: SELECT count(*)
6818: INTO l_com_du_count
6819: FROM igi_exp_dus
6820: WHERE tu_id = l_tu_id
6821: AND du_status = 'COM';
6822:
6823: -- =============== START DEBUG LOG ================

Line 6880: CURSOR c_prep_list(p_tu_id igi_exp_dus.tu_id%TYPE)

6876: actid IN NUMBER,
6877: funcmode IN VARCHAR2,
6878: result OUT NOCOPY VARCHAR2) IS
6879:
6880: CURSOR c_prep_list(p_tu_id igi_exp_dus.tu_id%TYPE)
6881: IS
6882: SELECT distinct du_by_user_id
6883: FROM igi_exp_dus
6884: WHERE tu_id = p_tu_id

Line 6883: FROM igi_exp_dus

6879:
6880: CURSOR c_prep_list(p_tu_id igi_exp_dus.tu_id%TYPE)
6881: IS
6882: SELECT distinct du_by_user_id
6883: FROM igi_exp_dus
6884: WHERE tu_id = p_tu_id
6885: AND du_status = 'COM';
6886:
6887: l_tu_id igi_exp_dus.tu_id%TYPE;

Line 6887: l_tu_id igi_exp_dus.tu_id%TYPE;

6883: FROM igi_exp_dus
6884: WHERE tu_id = p_tu_id
6885: AND du_status = 'COM';
6886:
6887: l_tu_id igi_exp_dus.tu_id%TYPE;
6888: l_user_id igi_exp_dus.du_by_user_id%TYPE;
6889: l_user_list VARCHAR2(1000);
6890:
6891:

Line 6888: l_user_id igi_exp_dus.du_by_user_id%TYPE;

6884: WHERE tu_id = p_tu_id
6885: AND du_status = 'COM';
6886:
6887: l_tu_id igi_exp_dus.tu_id%TYPE;
6888: l_user_id igi_exp_dus.du_by_user_id%TYPE;
6889: l_user_list VARCHAR2(1000);
6890:
6891:
6892: BEGIN

Line 6976: l_tu_id igi_exp_dus.tu_id%TYPE;

6972: l_num NUMBER;
6973: l_prep_list VARCHAR2(1000);
6974: l_next_prep NUMBER;
6975: l_next_prep_name fnd_user.user_name%TYPE;
6976: l_tu_id igi_exp_dus.tu_id%TYPE;
6977:
6978: l_com_du_list VARCHAR2(28000);
6979:
6980: CURSOR c_com_dus(p_tu_id igi_exp_dus.tu_id%TYPE

Line 6980: CURSOR c_com_dus(p_tu_id igi_exp_dus.tu_id%TYPE

6976: l_tu_id igi_exp_dus.tu_id%TYPE;
6977:
6978: l_com_du_list VARCHAR2(28000);
6979:
6980: CURSOR c_com_dus(p_tu_id igi_exp_dus.tu_id%TYPE
6981: ,p_du_by_user_id igi_exp_dus.du_by_user_id%TYPE)
6982: IS
6983: SELECT du_order_number
6984: ,du_legal_number

Line 6981: ,p_du_by_user_id igi_exp_dus.du_by_user_id%TYPE)

6977:
6978: l_com_du_list VARCHAR2(28000);
6979:
6980: CURSOR c_com_dus(p_tu_id igi_exp_dus.tu_id%TYPE
6981: ,p_du_by_user_id igi_exp_dus.du_by_user_id%TYPE)
6982: IS
6983: SELECT du_order_number
6984: ,du_legal_number
6985: FROM igi_exp_dus

Line 6985: FROM igi_exp_dus

6981: ,p_du_by_user_id igi_exp_dus.du_by_user_id%TYPE)
6982: IS
6983: SELECT du_order_number
6984: ,du_legal_number
6985: FROM igi_exp_dus
6986: WHERE tu_id = p_tu_id
6987: AND du_status = 'COM'
6988: AND du_by_user_id = p_du_by_user_id;
6989:

Line 7325: l_tu_id igi_exp_dus.tu_id%TYPE;

7321: actid IN NUMBER,
7322: funcmode IN VARCHAR2,
7323: result OUT NOCOPY VARCHAR2) IS
7324:
7325: l_tu_id igi_exp_dus.tu_id%TYPE;
7326:
7327: BEGIN
7328:
7329: -- =============== START DEBUG LOG ================

Line 7399: l_tu_id igi_exp_dus.tu_id%TYPE;

7395: actid IN NUMBER,
7396: funcmode IN VARCHAR2,
7397: result OUT NOCOPY VARCHAR2) IS
7398:
7399: l_tu_id igi_exp_dus.tu_id%TYPE;
7400: l_tu_legal_number igi_exp_tus.tu_legal_number%TYPE;
7401: -- Check if the TU has a legal number
7402: -- Bug 4051910
7403: CURSOR c_leg_num(c_tu_id number) is

Line 7495: l_tu_id igi_exp_dus.tu_id%TYPE;

7491: actid IN NUMBER,
7492: funcmode IN VARCHAR2,
7493: result OUT NOCOPY VARCHAR2) IS
7494:
7495: l_tu_id igi_exp_dus.tu_id%TYPE;
7496: l_du_prep_id igi_exp_dus.du_by_user_id%TYPE;
7497:
7498: BEGIN
7499:

Line 7496: l_du_prep_id igi_exp_dus.du_by_user_id%TYPE;

7492: funcmode IN VARCHAR2,
7493: result OUT NOCOPY VARCHAR2) IS
7494:
7495: l_tu_id igi_exp_dus.tu_id%TYPE;
7496: l_du_prep_id igi_exp_dus.du_by_user_id%TYPE;
7497:
7498: BEGIN
7499:
7500: -- =============== START DEBUG LOG ================

Line 7532: UPDATE igi_exp_dus

7528: -- =============== END DEBUG LOG ==================
7529:
7530: -- Remove the rejected DUs (prepared by user l_du_prep_id) from the
7531: -- TU
7532: UPDATE igi_exp_dus
7533: SET tu_id = null
7534: WHERE tu_id = l_tu_id
7535: AND du_by_user_id = l_du_prep_id
7536: AND du_status = 'REJ';

Line 7540: ' UPDATE igi_exp_dus du_status = REJ --> ' || SQL%ROWCOUNT);

7536: AND du_status = 'REJ';
7537:
7538: -- =============== START DEBUG LOG ================
7539: DEBUG_LOG_STRING (l_proc_level, 'Remove_rej_dus_from_tu.Msg4',
7540: ' UPDATE igi_exp_dus du_status = REJ --> ' || SQL%ROWCOUNT);
7541: -- =============== END DEBUG LOG ==================
7542:
7543: END IF;
7544:

Line 7580: CURSOR c_next_du_rej(p_tu_id igi_exp_dus.tu_id%TYPE)

7576: actid IN NUMBER,
7577: funcmode IN VARCHAR2,
7578: result OUT NOCOPY VARCHAR2) IS
7579:
7580: CURSOR c_next_du_rej(p_tu_id igi_exp_dus.tu_id%TYPE)
7581: IS
7582: SELECT du_id
7583: ,du_by_user_id
7584: FROM igi_exp_dus du

Line 7584: FROM igi_exp_dus du

7580: CURSOR c_next_du_rej(p_tu_id igi_exp_dus.tu_id%TYPE)
7581: IS
7582: SELECT du_id
7583: ,du_by_user_id
7584: FROM igi_exp_dus du
7585: WHERE tu_id = p_tu_id
7586: AND du_status = 'REJ'
7587: AND EXISTS (SELECT 'AR'
7588: FROM igi_exp_ar_trans ar

Line 7597: CURSOR c_rej_du_info(p_tu_id igi_exp_dus.tu_id%TYPE

7593: WHERE ap.du_id = du.du_id)
7594: AND rownum = 1;
7595:
7596:
7597: CURSOR c_rej_du_info(p_tu_id igi_exp_dus.tu_id%TYPE
7598: ,p_du_preparer_id igi_exp_dus.du_by_user_id%TYPE)
7599: IS
7600: SELECT du_order_number
7601: ,du_legal_number

Line 7598: ,p_du_preparer_id igi_exp_dus.du_by_user_id%TYPE)

7594: AND rownum = 1;
7595:
7596:
7597: CURSOR c_rej_du_info(p_tu_id igi_exp_dus.tu_id%TYPE
7598: ,p_du_preparer_id igi_exp_dus.du_by_user_id%TYPE)
7599: IS
7600: SELECT du_order_number
7601: ,du_legal_number
7602: FROM igi_exp_dus du

Line 7602: FROM igi_exp_dus du

7598: ,p_du_preparer_id igi_exp_dus.du_by_user_id%TYPE)
7599: IS
7600: SELECT du_order_number
7601: ,du_legal_number
7602: FROM igi_exp_dus du
7603: WHERE tu_id = p_tu_id
7604: AND du_status = 'REJ'
7605: AND du_by_user_id = p_du_preparer_id
7606: AND EXISTS (SELECT 'AR'

Line 7614: l_tu_id igi_exp_dus.tu_id%TYPE;

7610: SELECT 'AP'
7611: FROM igi_exp_ap_trans ap
7612: WHERE ap.du_id = du.du_id);
7613:
7614: l_tu_id igi_exp_dus.tu_id%TYPE;
7615: l_du_id igi_exp_dus.du_id%TYPE;
7616: l_du_prep_id igi_exp_dus.du_by_user_id%TYPE;
7617: l_du_prep_name fnd_user.user_name%TYPE;
7618:

Line 7615: l_du_id igi_exp_dus.du_id%TYPE;

7611: FROM igi_exp_ap_trans ap
7612: WHERE ap.du_id = du.du_id);
7613:
7614: l_tu_id igi_exp_dus.tu_id%TYPE;
7615: l_du_id igi_exp_dus.du_id%TYPE;
7616: l_du_prep_id igi_exp_dus.du_by_user_id%TYPE;
7617: l_du_prep_name fnd_user.user_name%TYPE;
7618:
7619: l_du_rej_list VARCHAR2(28000);

Line 7616: l_du_prep_id igi_exp_dus.du_by_user_id%TYPE;

7612: WHERE ap.du_id = du.du_id);
7613:
7614: l_tu_id igi_exp_dus.tu_id%TYPE;
7615: l_du_id igi_exp_dus.du_id%TYPE;
7616: l_du_prep_id igi_exp_dus.du_by_user_id%TYPE;
7617: l_du_prep_name fnd_user.user_name%TYPE;
7618:
7619: l_du_rej_list VARCHAR2(28000);
7620: