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.XTR_NI_TRANSFERS_PKG dependencies on DUAL

Line 637: if ARec_Interface.dual_authorization_by is not null and

633: l_error := l_error +1;
634: end if;
635: end if;
636:
637: if ARec_Interface.dual_authorization_by is not null and
638: not ( val_dealer_code(ARec_Interface.dual_authorization_by)) then
639: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,
640: ARec_Interface.Deal_Type,
641: 'DualAuthorizationBy',

Line 638: not ( val_dealer_code(ARec_Interface.dual_authorization_by)) then

634: end if;
635: end if;
636:
637: if ARec_Interface.dual_authorization_by is not null and
638: not ( val_dealer_code(ARec_Interface.dual_authorization_by)) then
639: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,
640: ARec_Interface.Deal_Type,
641: 'DualAuthorizationBy',
642: 'XTR_INV_DUAL_AUTH_BY');

Line 641: 'DualAuthorizationBy',

637: if ARec_Interface.dual_authorization_by is not null and
638: not ( val_dealer_code(ARec_Interface.dual_authorization_by)) then
639: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,
640: ARec_Interface.Deal_Type,
641: 'DualAuthorizationBy',
642: 'XTR_INV_DUAL_AUTH_BY');
643: l_error := l_error +1;
644: end if;
645:

Line 642: 'XTR_INV_DUAL_AUTH_BY');

638: not ( val_dealer_code(ARec_Interface.dual_authorization_by)) then
639: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,
640: ARec_Interface.Deal_Type,
641: 'DualAuthorizationBy',
642: 'XTR_INV_DUAL_AUTH_BY');
643: l_error := l_error +1;
644: end if;
645:
646: if not ( val_deal_date(ARec_Interface.date_a)) then

Line 1810: from dual;

1806: /* Copying values into the Global Record Type */
1807: /*--------------------------------------------*/
1808: select xtr_deals_s.nextval
1809: into G_Ni_Main_Rec.DEAL_NO
1810: from dual;
1811:
1812: G_Ni_Main_Rec.EXTERNAL_DEAL_ID := ARec_Interface.EXTERNAL_DEAL_ID;
1813: G_Ni_Main_Rec.DEAL_TYPE := G_Ni_Deal_Type;
1814: G_Ni_Main_Rec.DEALER_CODE := ARec_Interface.DEALER_CODE;

Line 1883: G_Ni_Main_Rec.DUAL_AUTHORISATION_BY := ARec_Interface.DUAL_AUTHORIZATION_BY;

1879: else
1880: G_DO_TAX_DEFAULTING:=false;
1881: end if;
1882:
1883: G_Ni_Main_Rec.DUAL_AUTHORISATION_BY := ARec_Interface.DUAL_AUTHORIZATION_BY;
1884: G_Ni_Main_Rec.DUAL_AUTHORISATION_ON := ARec_Interface.DUAL_AUTHORIZATION_ON;
1885: G_Ni_Main_Rec.STATUS_CODE := 'CURRENT';
1886: G_Ni_Main_Rec.KNOCK_TYPE := 'N';
1887:

Line 1884: G_Ni_Main_Rec.DUAL_AUTHORISATION_ON := ARec_Interface.DUAL_AUTHORIZATION_ON;

1880: G_DO_TAX_DEFAULTING:=false;
1881: end if;
1882:
1883: G_Ni_Main_Rec.DUAL_AUTHORISATION_BY := ARec_Interface.DUAL_AUTHORIZATION_BY;
1884: G_Ni_Main_Rec.DUAL_AUTHORISATION_ON := ARec_Interface.DUAL_AUTHORIZATION_ON;
1885: G_Ni_Main_Rec.STATUS_CODE := 'CURRENT';
1886: G_Ni_Main_Rec.KNOCK_TYPE := 'N';
1887:
1888: /*--------------------------------------------------------------------*/

Line 2502: from dual;

2498: G_Ni_Parcel_Rec(i).STATUS_CODE := 'CURRENT';
2499:
2500: select xtr_exposure_trans_s.nextval
2501: into G_Ni_Parcel_Rec(i).PARCEL_SPLIT_NO --This overwrites old transaction tracking number
2502: from dual;
2503:
2504: END LOOP;
2505:
2506: G_Ni_Main_Rec.FREQUENCY := G_TOTAL_SIZE;

Line 2638: l_dual_user xtr_dealer_codes.dealer_code%TYPE;

2634: from xtr_dealer_codes_v
2635: where user_id = p_fnd_user;
2636:
2637: l_user xtr_dealer_codes.dealer_code%TYPE;
2638: l_dual_user xtr_dealer_codes.dealer_code%TYPE;
2639: l_dual_date DATE;
2640:
2641: l_bank_code XTR_BANK_ACCOUNTS_V.BANK_CODE%TYPE;
2642:

Line 2639: l_dual_date DATE;

2635: where user_id = p_fnd_user;
2636:
2637: l_user xtr_dealer_codes.dealer_code%TYPE;
2638: l_dual_user xtr_dealer_codes.dealer_code%TYPE;
2639: l_dual_date DATE;
2640:
2641: l_bank_code XTR_BANK_ACCOUNTS_V.BANK_CODE%TYPE;
2642:
2643: cursor get_bank_issue_code(p_serial_number in NUMBER) is

Line 2958: l_dual_user := G_Ni_Main_Rec.DUAL_AUTHORISATION_BY;

2954: open FIND_USER(G_User_Id);
2955: fetch FIND_USER into l_user;
2956: close FIND_USER;
2957:
2958: l_dual_user := G_Ni_Main_Rec.DUAL_AUTHORISATION_BY;
2959: l_dual_date := G_Ni_Main_Rec.DUAL_AUTHORISATION_ON;
2960: if ((l_dual_user is not null and l_dual_date is null) or
2961: (l_dual_user is null and l_dual_date is not null)) then
2962: if l_dual_date is null then

Line 2959: l_dual_date := G_Ni_Main_Rec.DUAL_AUTHORISATION_ON;

2955: fetch FIND_USER into l_user;
2956: close FIND_USER;
2957:
2958: l_dual_user := G_Ni_Main_Rec.DUAL_AUTHORISATION_BY;
2959: l_dual_date := G_Ni_Main_Rec.DUAL_AUTHORISATION_ON;
2960: if ((l_dual_user is not null and l_dual_date is null) or
2961: (l_dual_user is null and l_dual_date is not null)) then
2962: if l_dual_date is null then
2963: l_dual_date := trunc(sysdate);

Line 2960: if ((l_dual_user is not null and l_dual_date is null) or

2956: close FIND_USER;
2957:
2958: l_dual_user := G_Ni_Main_Rec.DUAL_AUTHORISATION_BY;
2959: l_dual_date := G_Ni_Main_Rec.DUAL_AUTHORISATION_ON;
2960: if ((l_dual_user is not null and l_dual_date is null) or
2961: (l_dual_user is null and l_dual_date is not null)) then
2962: if l_dual_date is null then
2963: l_dual_date := trunc(sysdate);
2964: elsif l_dual_user is null then

Line 2961: (l_dual_user is null and l_dual_date is not null)) then

2957:
2958: l_dual_user := G_Ni_Main_Rec.DUAL_AUTHORISATION_BY;
2959: l_dual_date := G_Ni_Main_Rec.DUAL_AUTHORISATION_ON;
2960: if ((l_dual_user is not null and l_dual_date is null) or
2961: (l_dual_user is null and l_dual_date is not null)) then
2962: if l_dual_date is null then
2963: l_dual_date := trunc(sysdate);
2964: elsif l_dual_user is null then
2965: l_dual_user := l_user;

Line 2962: if l_dual_date is null then

2958: l_dual_user := G_Ni_Main_Rec.DUAL_AUTHORISATION_BY;
2959: l_dual_date := G_Ni_Main_Rec.DUAL_AUTHORISATION_ON;
2960: if ((l_dual_user is not null and l_dual_date is null) or
2961: (l_dual_user is null and l_dual_date is not null)) then
2962: if l_dual_date is null then
2963: l_dual_date := trunc(sysdate);
2964: elsif l_dual_user is null then
2965: l_dual_user := l_user;
2966: end if;

Line 2963: l_dual_date := trunc(sysdate);

2959: l_dual_date := G_Ni_Main_Rec.DUAL_AUTHORISATION_ON;
2960: if ((l_dual_user is not null and l_dual_date is null) or
2961: (l_dual_user is null and l_dual_date is not null)) then
2962: if l_dual_date is null then
2963: l_dual_date := trunc(sysdate);
2964: elsif l_dual_user is null then
2965: l_dual_user := l_user;
2966: end if;
2967: end if;

Line 2964: elsif l_dual_user is null then

2960: if ((l_dual_user is not null and l_dual_date is null) or
2961: (l_dual_user is null and l_dual_date is not null)) then
2962: if l_dual_date is null then
2963: l_dual_date := trunc(sysdate);
2964: elsif l_dual_user is null then
2965: l_dual_user := l_user;
2966: end if;
2967: end if;
2968:

Line 2965: l_dual_user := l_user;

2961: (l_dual_user is null and l_dual_date is not null)) then
2962: if l_dual_date is null then
2963: l_dual_date := trunc(sysdate);
2964: elsif l_dual_user is null then
2965: l_dual_user := l_user;
2966: end if;
2967: end if;
2968:
2969: G_Ni_Main_Rec.CREATED_BY:=nvl(l_user,G_User_Id);

Line 3050: DUAL_AUTHORISATION_BY,

3046: INCOME_TAX_CODE,
3047: INCOME_TAX_RATE,
3048: INCOME_TAX_AMOUNT,
3049: INCOME_TAX_SETTLED_REF,
3050: DUAL_AUTHORISATION_BY,
3051: DUAL_AUTHORISATION_ON,
3052: CREATED_BY,
3053: CREATED_ON,
3054: ATTRIBUTE_CATEGORY,

Line 3051: DUAL_AUTHORISATION_ON,

3047: INCOME_TAX_RATE,
3048: INCOME_TAX_AMOUNT,
3049: INCOME_TAX_SETTLED_REF,
3050: DUAL_AUTHORISATION_BY,
3051: DUAL_AUTHORISATION_ON,
3052: CREATED_BY,
3053: CREATED_ON,
3054: ATTRIBUTE_CATEGORY,
3055: ATTRIBUTE1,

Line 3150: l_dual_user,

3146: G_Ni_Main_Rec.INCOME_TAX_CODE,
3147: G_Ni_Main_Rec.INCOME_TAX_RATE,
3148: G_Ni_Main_Rec.INCOME_TAX_AMOUNT,
3149: G_Ni_Main_Rec.INCOME_TAX_SETTLED_REF,
3150: l_dual_user,
3151: l_dual_date,
3152: G_Ni_Main_Rec.CREATED_BY,
3153: G_Ni_Main_Rec.CREATED_ON,
3154: G_Ni_Main_Rec.ATTRIBUTE_CATEGORY,

Line 3151: l_dual_date,

3147: G_Ni_Main_Rec.INCOME_TAX_RATE,
3148: G_Ni_Main_Rec.INCOME_TAX_AMOUNT,
3149: G_Ni_Main_Rec.INCOME_TAX_SETTLED_REF,
3150: l_dual_user,
3151: l_dual_date,
3152: G_Ni_Main_Rec.CREATED_BY,
3153: G_Ni_Main_Rec.CREATED_ON,
3154: G_Ni_Main_Rec.ATTRIBUTE_CATEGORY,
3155: G_Ni_Main_Rec.ATTRIBUTE1,

Line 3263: if l_dual_user is not null then

3259:
3260: CALL_ONE_STEP_SETTLEMENT(G_Ni_Main_Rec.TAX_SETTLED_REFERENCE,G_Ni_Main_Rec.INCOME_TAX_SETTLED_REF);
3261:
3262:
3263: if l_dual_user is not null then
3264: UPDATE xtr_deal_date_amounts
3265: SET dual_authorisation_by = l_dual_user,
3266: dual_authorisation_on = l_dual_date
3267: WHERE deal_number = G_Ni_Main_Rec.DEAL_NO;

Line 3265: SET dual_authorisation_by = l_dual_user,

3261:
3262:
3263: if l_dual_user is not null then
3264: UPDATE xtr_deal_date_amounts
3265: SET dual_authorisation_by = l_dual_user,
3266: dual_authorisation_on = l_dual_date
3267: WHERE deal_number = G_Ni_Main_Rec.DEAL_NO;
3268:
3269: UPDATE xtr_confirmation_details

Line 3266: dual_authorisation_on = l_dual_date

3262:
3263: if l_dual_user is not null then
3264: UPDATE xtr_deal_date_amounts
3265: SET dual_authorisation_by = l_dual_user,
3266: dual_authorisation_on = l_dual_date
3267: WHERE deal_number = G_Ni_Main_Rec.DEAL_NO;
3268:
3269: UPDATE xtr_confirmation_details
3270: SET confirmation_validated_by = l_dual_user,

Line 3270: SET confirmation_validated_by = l_dual_user,

3266: dual_authorisation_on = l_dual_date
3267: WHERE deal_number = G_Ni_Main_Rec.DEAL_NO;
3268:
3269: UPDATE xtr_confirmation_details
3270: SET confirmation_validated_by = l_dual_user,
3271: confirmation_validated_on = l_dual_date
3272: WHERE deal_no = G_Ni_Main_Rec.DEAL_NO;
3273:
3274: UPDATE xtr_deals

Line 3271: confirmation_validated_on = l_dual_date

3267: WHERE deal_number = G_Ni_Main_Rec.DEAL_NO;
3268:
3269: UPDATE xtr_confirmation_details
3270: SET confirmation_validated_by = l_dual_user,
3271: confirmation_validated_on = l_dual_date
3272: WHERE deal_no = G_Ni_Main_Rec.DEAL_NO;
3273:
3274: UPDATE xtr_deals
3275: SET dual_authorisation_on = l_dual_date

Line 3275: SET dual_authorisation_on = l_dual_date

3271: confirmation_validated_on = l_dual_date
3272: WHERE deal_no = G_Ni_Main_Rec.DEAL_NO;
3273:
3274: UPDATE xtr_deals
3275: SET dual_authorisation_on = l_dual_date
3276: WHERE deal_no = G_Ni_Main_Rec.DEAL_NO;
3277: end if;
3278:
3279: END CREATE_NI_DEAL;