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_TUS

Line 520: UPDATE igi_exp_tus tus

516: ' ** BEGIN START_APPROVAL_WORKFLOW ** ');
517: -- =============== END DEBUG LOG ==================
518:
519: -- Update the status of the TU to 'Transmitted'
520: UPDATE igi_exp_tus tus
521: SET tus.tu_status = 'TRA'
522: WHERE tus.tu_id = p_tu_id;
523:
524: -- =============== START DEBUG LOG ================

Line 526: ' updating igi_exp_tus setting tu_status = TRA for tu_id ' || p_tu_id);

522: WHERE tus.tu_id = p_tu_id;
523:
524: -- =============== START DEBUG LOG ================
525: DEBUG_LOG_STRING (l_proc_level, 'Start_approval_workflow.Msg2',
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

Line 622: from igi_exp_tus WHERE tu_id = p_tu_id;

618: -- Introduced the following calculation for TU Full Number for bug 6640095.
619: -- If the tu_legal_number is not got generated, then it will take tu_order_number.
620:
621: select tu_legal_number into l_tu_legal_number
622: from igi_exp_tus WHERE tu_id = p_tu_id;
623:
624: IF (l_tu_legal_number is NULL) then
625:
626: -- Set TU Full Number

Line 1400: l_tu_id igi_exp_tus.tu_id%TYPE;

1396: actid IN NUMBER,
1397: funcmode IN VARCHAR2,
1398: result OUT NOCOPY VARCHAR2) IS
1399:
1400: l_tu_id igi_exp_tus.tu_id%TYPE;
1401: l_position_id per_all_positions.position_id%TYPE;
1402: l_apprv_profile_id igi_exp_tus.apprv_profile_id%TYPE;
1403: l_pos_hierarchy_id igi_exp_apprv_profiles.pos_hierarchy_id%TYPE;
1404: l_legal_num_pos_id igi_exp_apprv_profiles.legal_num_pos_id%TYPE;

Line 1402: l_apprv_profile_id igi_exp_tus.apprv_profile_id%TYPE;

1398: result OUT NOCOPY VARCHAR2) IS
1399:
1400: l_tu_id igi_exp_tus.tu_id%TYPE;
1401: l_position_id per_all_positions.position_id%TYPE;
1402: l_apprv_profile_id igi_exp_tus.apprv_profile_id%TYPE;
1403: l_pos_hierarchy_id igi_exp_apprv_profiles.pos_hierarchy_id%TYPE;
1404: l_legal_num_pos_id igi_exp_apprv_profiles.legal_num_pos_id%TYPE;
1405: l_final_apprv_pos_id igi_exp_apprv_profiles.final_apprv_pos_id%TYPE;
1406: l_business_group_id hr_all_positions_f.business_group_id%TYPE;

Line 1500: FROM igi_exp_tus

1496:
1497: -- Now get the approval profile id chosen for the TU.
1498: SELECT apprv_profile_id
1499: INTO l_apprv_profile_id
1500: FROM igi_exp_tus
1501: WHERE tu_id = l_tu_id;
1502:
1503: -- =============== START DEBUG LOG ================
1504: DEBUG_LOG_STRING (l_proc_level, 'Position_in_hierarchy.Msg5',

Line 2032: UPDATE igi_exp_tus tus

2028: ' GetItemAttrNumber TU_ID --> '|| l_tu_id);
2029: -- =============== END DEBUG LOG ==================
2030:
2031: -- Update the status of the TU to 'AVL' for 'Available'
2032: UPDATE igi_exp_tus tus
2033: SET tus.tu_status = 'AVL'
2034: WHERE tus.tu_id = l_tu_id;
2035:
2036: -- =============== START DEBUG LOG ================

Line 2038: ' UPDATE igi_exp_tus tu_status = AVL ');

2034: WHERE tus.tu_id = l_tu_id;
2035:
2036: -- =============== START DEBUG LOG ================
2037: DEBUG_LOG_STRING (l_proc_level, 'Update_tu_status_to_avl.Msg4',
2038: ' UPDATE igi_exp_tus tu_status = AVL ');
2039: -- =============== END DEBUG LOG ==================
2040:
2041: END IF;
2042:

Line 2167: l_tu_id igi_exp_tus.tu_id%TYPE;

2163: l_user_count NUMBER:= 0;
2164: l_user_list VARCHAR2(1000);
2165: l_user_name fnd_user.user_name%TYPE;
2166: l_user_id fnd_user.user_id%TYPE;
2167: l_tu_id igi_exp_tus.tu_id%TYPE;
2168: l_current_position_id per_all_positions.position_id%TYPE;
2169: l_business_group_id hr_all_positions_f.business_group_id%TYPE;
2170: l_organization_id hr_all_positions_f.organization_id%TYPE;
2171:

Line 2341: UPDATE igi_exp_tus

2337: ' GetItemAttrNumber TU_ID --> ' || l_tu_id);
2338: -- =============== END DEBUG LOG ==================
2339:
2340: -- Update the TU table with the next authorizer
2341: UPDATE igi_exp_tus
2342: SET next_approver_user_id = l_user_id
2343: WHERE tu_id = l_tu_id;
2344:
2345:

Line 2348: ' UPDATE igi_exp_tus set next_approver_user_id --> '|| l_user_id);

2344:
2345:
2346: -- =============== START DEBUG LOG ================
2347: DEBUG_LOG_STRING (l_proc_level, 'Build_user_list.Msg15',
2348: ' UPDATE igi_exp_tus set next_approver_user_id --> '|| l_user_id);
2349: -- =============== END DEBUG LOG ==================
2350:
2351: result := 'COMPLETE:ONE_USER';
2352:

Line 2577: l_tu_id igi_exp_tus.tu_id%TYPE;

2573: result OUT NOCOPY VARCHAR2) IS
2574:
2575: l_current_position_id per_all_positions.position_id%TYPE;
2576: l_current_auth_role VARCHAR2(240);
2577: l_tu_id igi_exp_tus.tu_id%TYPE;
2578:
2579: BEGIN
2580:
2581: -- =============== START DEBUG LOG ================

Line 2634: UPDATE igi_exp_tus

2630: ' GetItemAttrNumber TU_ID -->' || l_tu_id);
2631: -- =============== END DEBUG LOG ==================
2632:
2633: -- Update the next approver column to null
2634: UPDATE igi_exp_tus
2635: SET next_approver_user_id = null
2636: WHERE tu_id = l_tu_id;
2637:
2638: -- =============== START DEBUG LOG ================

Line 2640: ' Update igi_exp_tus for tu_id ' ||l_tu_id );

2636: WHERE tu_id = l_tu_id;
2637:
2638: -- =============== START DEBUG LOG ================
2639: DEBUG_LOG_STRING (l_proc_level, 'Set_pos_as_auth.Msg1',
2640: ' Update igi_exp_tus for tu_id ' ||l_tu_id );
2641: -- =============== END DEBUG LOG ==================
2642:
2643: END IF;
2644:

Line 2682: l_tu_id igi_exp_tus.tu_id%TYPE;

2678: result OUT NOCOPY VARCHAR2) IS
2679:
2680: l_current_auth_role VARCHAR2(240);
2681: l_auth_id fnd_user.user_id%TYPE;
2682: l_tu_id igi_exp_tus.tu_id%TYPE;
2683:
2684: BEGIN
2685:
2686: -- =============== START DEBUG LOG ================

Line 2728: UPDATE igi_exp_tus

2724: ' Get the user_id of the authorizer --> ' || l_auth_id);
2725: -- =============== END DEBUG LOG ==================
2726:
2727: -- Update the TU table with the next authorizer id
2728: UPDATE igi_exp_tus
2729: SET next_approver_user_id = l_auth_id
2730: WHERE tu_id = l_tu_id;
2731:
2732: -- =============== START DEBUG LOG ================

Line 2734: ' UPDATE igi_exp_tus with ' || l_auth_id || ' for ' || l_tu_id);

2730: WHERE tu_id = l_tu_id;
2731:
2732: -- =============== START DEBUG LOG ================
2733: DEBUG_LOG_STRING (l_proc_level, 'Set_chosen_user_as_auth.Msg5',
2734: ' UPDATE igi_exp_tus with ' || l_auth_id || ' for ' || l_tu_id);
2735: -- =============== END DEBUG LOG ==================
2736:
2737: -- Set the current_authorizer_role attribute
2738: wf_engine.SetItemAttrText ( itemtype => itemtype,

Line 3575: l_tu_id igi_exp_tus.tu_id%TYPE;

3571: actid IN NUMBER,
3572: funcmode IN VARCHAR2,
3573: result OUT NOCOPY VARCHAR2) IS
3574:
3575: l_tu_id igi_exp_tus.tu_id%TYPE;
3576:
3577: BEGIN
3578:
3579: -- =============== START DEBUG LOG ================

Line 3695: l_tu_id igi_exp_tus.tu_id%TYPE;

3691: actid IN NUMBER,
3692: funcmode IN VARCHAR2,
3693: result OUT NOCOPY VARCHAR2) IS
3694:
3695: l_tu_id igi_exp_tus.tu_id%TYPE;
3696: l_no_of_dus NUMBER;
3697:
3698: BEGIN
3699:

Line 3785: l_tu_id igi_exp_tus.tu_id%TYPE;

3781: actid IN NUMBER,
3782: funcmode IN VARCHAR2,
3783: result OUT NOCOPY VARCHAR2) IS
3784:
3785: l_tu_id igi_exp_tus.tu_id%TYPE;
3786:
3787: BEGIN
3788:
3789: -- =============== START DEBUG LOG ================

Line 4396: UPDATE igi_exp_tus

4392: ' l_du_amount --> ' || l_du_amount);
4393: -- =============== END DEBUG LOG ==================
4394:
4395: -- Now update the TU amount
4396: UPDATE igi_exp_tus
4397: SET tu_amount = tu_amount - l_du_amount
4398: WHERE tu_id = l_tu_id;
4399:
4400: -- =============== START DEBUG LOG ================

Line 4402: ' UPDATE igi_exp_tus tu-amount ' || SQL%ROWCOUNT);

4398: WHERE tu_id = l_tu_id;
4399:
4400: -- =============== START DEBUG LOG ================
4401: DEBUG_LOG_STRING (l_proc_level, 'Remove_dus_on_hold.Msg5',
4402: ' UPDATE igi_exp_tus tu-amount ' || SQL%ROWCOUNT);
4403: -- =============== END DEBUG LOG ==================
4404:
4405: -- Want to release all DUs in this TU with status 'On Hold' which
4406: -- have been prepared by this user.

Line 5064: UPDATE igi_exp_tus

5060: ' l_du_amount --> ' || l_du_amount);
5061: -- =============== END DEBUG LOG ==================
5062:
5063: -- Update the TU amount
5064: UPDATE igi_exp_tus
5065: SET tu_amount = tu_amount - l_du_amount
5066: WHERE tu_id = l_tu_id;
5067:
5068: -- =============== START DEBUG LOG ================

Line 5070: ' UPDATE igi_exp_tus --> ' || SQL%ROWCOUNT);

5066: WHERE tu_id = l_tu_id;
5067:
5068: -- =============== START DEBUG LOG ================
5069: DEBUG_LOG_STRING (l_proc_level, 'Rem_trx_from_rej_dus.Msg7',
5070: ' UPDATE igi_exp_tus --> ' || SQL%ROWCOUNT);
5071: -- =============== END DEBUG LOG ==================
5072:
5073: -- Now update the DU amount to 0
5074: UPDATE igi_exp_dus

Line 5217: l_tu_type_header_id igi_exp_tus.tu_type_header_id%TYPE;

5213: funcmode IN VARCHAR2,
5214: result OUT NOCOPY VARCHAR2) IS
5215:
5216: l_tu_id igi_exp_dus.tu_id%TYPE;
5217: l_tu_type_header_id igi_exp_tus.tu_type_header_id%TYPE;
5218: l_tu_fiscal_year igi_exp_tus.tu_fiscal_year%TYPE;
5219: l_tu_legal_number igi_exp_tus.tu_legal_number%TYPE;
5220: l_tu_full_number VARCHAR2(240);
5221: l_error_message VARCHAR2(250);

Line 5218: l_tu_fiscal_year igi_exp_tus.tu_fiscal_year%TYPE;

5214: result OUT NOCOPY VARCHAR2) IS
5215:
5216: l_tu_id igi_exp_dus.tu_id%TYPE;
5217: l_tu_type_header_id igi_exp_tus.tu_type_header_id%TYPE;
5218: l_tu_fiscal_year igi_exp_tus.tu_fiscal_year%TYPE;
5219: l_tu_legal_number igi_exp_tus.tu_legal_number%TYPE;
5220: l_tu_full_number VARCHAR2(240);
5221: l_error_message VARCHAR2(250);
5222:

Line 5219: l_tu_legal_number igi_exp_tus.tu_legal_number%TYPE;

5215:
5216: l_tu_id igi_exp_dus.tu_id%TYPE;
5217: l_tu_type_header_id igi_exp_tus.tu_type_header_id%TYPE;
5218: l_tu_fiscal_year igi_exp_tus.tu_fiscal_year%TYPE;
5219: l_tu_legal_number igi_exp_tus.tu_legal_number%TYPE;
5220: l_tu_full_number VARCHAR2(240);
5221: l_error_message VARCHAR2(250);
5222:
5223: BEGIN

Line 5248: FROM igi_exp_tus

5244: SELECT tu_type_header_id
5245: ,tu_fiscal_year
5246: INTO l_tu_type_header_id
5247: ,l_tu_fiscal_year
5248: FROM igi_exp_tus
5249: WHERE tu_id = l_tu_id;
5250:
5251: -- =============== START DEBUG LOG ================
5252: DEBUG_LOG_STRING (l_proc_level, 'Apply_tu_legal_num.Msg3',

Line 5302: UPDATE igi_exp_tus

5298: ELSE
5299:
5300: -- TU Legal number was generated successfully
5301: -- Apply the legal number to the TU
5302: UPDATE igi_exp_tus
5303: SET tu_legal_number = l_tu_legal_number
5304: WHERE tu_id = l_tu_id;
5305:
5306:

Line 5309: 'UPDATE igi_exp_tus - ' || SQL%ROWCOUNT);

5305:
5306:
5307: -- =============== START DEBUG LOG ================
5308: DEBUG_LOG_STRING (l_proc_level, 'Apply_tu_legal_num.Msg8',
5309: 'UPDATE igi_exp_tus - ' || SQL%ROWCOUNT);
5310: -- =============== END DEBUG LOG ==================
5311:
5312: -- OPSF(I) EXP Bug 2567802 26-Sep-2002 S Brewer Start(2)
5313: -- Set the TU Full Number attribute to include the legal number

Line 5601: l_tu_status igi_exp_tus.tu_status%TYPE;

5597: funcmode IN VARCHAR2,
5598: result OUT NOCOPY VARCHAR2) IS
5599:
5600: l_tu_id igi_exp_dus.tu_id%TYPE;
5601: l_tu_status igi_exp_tus.tu_status%TYPE;
5602: l_atr_du_count NUMBER;
5603:
5604: -- Bug 4051910
5605: -- Check if the TU has a status

Line 5609: FROM igi_exp_tus

5605: -- Check if the TU has a status
5606: CURSOR C_stat(p_tu_id number)
5607: IS
5608: SELECT tu_status
5609: FROM igi_exp_tus
5610: WHERE tu_id = p_tu_id;
5611:
5612:
5613:

Line 5646: UPDATE igi_exp_tus

5642: -- =============== END DEBUG LOG ==================
5643:
5644: IF (l_tu_status = 'TRA') THEN
5645:
5646: UPDATE igi_exp_tus
5647: SET tu_status = 'ATR'
5648: WHERE tu_id = l_tu_id;
5649: -- =============== START DEBUG LOG ================
5650: DEBUG_LOG_STRING (l_proc_level, 'Set_tu_status.Msg4',

Line 5651: ' UPDATE igi_exp_tus --> ' || SQL%ROWCOUNT);

5647: SET tu_status = 'ATR'
5648: WHERE tu_id = l_tu_id;
5649: -- =============== START DEBUG LOG ================
5650: DEBUG_LOG_STRING (l_proc_level, 'Set_tu_status.Msg4',
5651: ' UPDATE igi_exp_tus --> ' || SQL%ROWCOUNT);
5652: -- =============== END DEBUG LOG ==================
5653:
5654: END IF;
5655:

Line 6738: UPDATE igi_exp_tus

6734: ' l_du_amount --> ' || l_du_amount);
6735: -- =============== END DEBUG LOG ==================
6736:
6737: -- Now update the TU amount
6738: UPDATE igi_exp_tus
6739: SET tu_amount = tu_amount - l_du_amount
6740: WHERE tu_id = l_tu_id;
6741:
6742: -- =============== START DEBUG LOG ================

Line 6744: ' UPDATE igi_exp_tus -> ' || SQL%ROWCOUNT);

6740: WHERE tu_id = l_tu_id;
6741:
6742: -- =============== START DEBUG LOG ================
6743: DEBUG_LOG_STRING (l_proc_level, 'Remove_all_on_hold_dus.Msg4',
6744: ' UPDATE igi_exp_tus -> ' || SQL%ROWCOUNT);
6745: -- =============== END DEBUG LOG ==================
6746:
6747:
6748: -- OPSF(I) EXP Bug 2415293 S Brewer 18-JUL-2002 End(3)

Line 7354: UPDATE igi_exp_tus

7350: DEBUG_LOG_STRING (l_proc_level, 'Set_tu_to_complete.Msg2',
7351: ' GetItemAttrNumber TU_ID --> ' || l_tu_id);
7352: -- =============== END DEBUG LOG ==================
7353:
7354: UPDATE igi_exp_tus
7355: SET tu_status = 'COM'
7356: WHERE tu_id = l_tu_id;
7357:
7358: -- =============== START DEBUG LOG ================

Line 7360: ' UPDATE igi_exp_tus --> ' || SQL%ROWCOUNT);

7356: WHERE tu_id = l_tu_id;
7357:
7358: -- =============== START DEBUG LOG ================
7359: DEBUG_LOG_STRING (l_proc_level, 'Set_tu_to_complete.Msg3',
7360: ' UPDATE igi_exp_tus --> ' || SQL%ROWCOUNT);
7361: -- =============== END DEBUG LOG ==================
7362:
7363: END IF;
7364:

Line 7407: l_tu_legal_number igi_exp_tus.tu_legal_number%TYPE;

7403: funcmode IN VARCHAR2,
7404: result OUT NOCOPY VARCHAR2) IS
7405:
7406: l_tu_id igi_exp_dus.tu_id%TYPE;
7407: l_tu_legal_number igi_exp_tus.tu_legal_number%TYPE;
7408: -- Check if the TU has a legal number
7409: -- Bug 4051910
7410: CURSOR c_leg_num(c_tu_id number) is
7411: SELECT tu_legal_number

Line 7412: FROM igi_exp_tus

7408: -- Check if the TU has a legal number
7409: -- Bug 4051910
7410: CURSOR c_leg_num(c_tu_id number) is
7411: SELECT tu_legal_number
7412: FROM igi_exp_tus
7413: WHERE tu_id = c_tu_id;
7414:
7415:
7416: