DBA Data[Home] [Help]

APPS.JAI_AP_UTILS_PKG dependencies on FND_GLOBAL

Line 758: fnd_global.user_id,

754: lv_description,
755: lv_tax_account_code,
756: v_org_id,
757: 'N',
758: fnd_global.user_id,
759: SYSDATE,
760: fnd_global.user_id,
761: SYSDATE,
762: fnd_global.login_id);

Line 760: fnd_global.user_id,

756: v_org_id,
757: 'N',
758: fnd_global.user_id,
759: SYSDATE,
760: fnd_global.user_id,
761: SYSDATE,
762: fnd_global.login_id);
763:
764: END LOOP;

Line 762: fnd_global.login_id);

758: fnd_global.user_id,
759: SYSDATE,
760: fnd_global.user_id,
761: SYSDATE,
762: fnd_global.login_id);
763:
764: END LOOP;
765: IF ln_depb_amount > 0 THEN
766: ln_depb_amount := - ln_depb_amount;

Line 807: fnd_global.login_id,

803: lv_description, -- item_description,
804: ln_depb_account_id,
805: v_org_id, -- org_id,
806: 'N', -- amount_includes_tax_flag,
807: fnd_global.login_id,
808: SYSDATE,
809: fnd_global.login_id,
810: SYSDATE,
811: fnd_global.login_id

Line 809: fnd_global.login_id,

805: v_org_id, -- org_id,
806: 'N', -- amount_includes_tax_flag,
807: fnd_global.login_id,
808: SYSDATE,
809: fnd_global.login_id,
810: SYSDATE,
811: fnd_global.login_id
812: );
813: END IF;

Line 811: fnd_global.login_id

807: fnd_global.login_id,
808: SYSDATE,
809: fnd_global.login_id,
810: SYSDATE,
811: fnd_global.login_id
812: );
813: END IF;
814:
815:

Line 2097: ln_request_id := FND_GLOBAL.conc_request_id;

2093: lv_thhold_xcep_id_updated := '';
2094:
2095: fnd_file.put_line(FND_FILE.LOG, 'START OF Procedure ');
2096:
2097: ln_request_id := FND_GLOBAL.conc_request_id;
2098:
2099: lv_debug_msg := ' A. Report Parameters';
2100:
2101: If lv_debug_flag = 'Y' then

Line 2302: fnd_global.user_id,

2298: lv_vendor_site_id_updated,
2299: lv_thhold_grp_id_updated,
2300: lv_thhold_xcep_id_updated,
2301: sysdate,
2302: fnd_global.user_id,
2303: sysdate,
2304: fnd_global.user_id,
2305: fnd_global.login_id
2306: );

Line 2304: fnd_global.user_id,

2300: lv_thhold_xcep_id_updated,
2301: sysdate,
2302: fnd_global.user_id,
2303: sysdate,
2304: fnd_global.user_id,
2305: fnd_global.login_id
2306: );
2307:
2308:

Line 2305: fnd_global.login_id

2301: sysdate,
2302: fnd_global.user_id,
2303: sysdate,
2304: fnd_global.user_id,
2305: fnd_global.login_id
2306: );
2307:
2308:
2309: commit;

Line 3760: ,fnd_global.user_id

3756: ,p_item_class_cd
3757: ,p_org_id
3758: ,p_object_version_number
3759: ,sysdate
3760: ,fnd_global.user_id
3761: ,sysdate
3762: ,fnd_global.user_id
3763: ,fnd_global.login_id
3764: );

Line 3762: ,fnd_global.user_id

3758: ,p_object_version_number
3759: ,sysdate
3760: ,fnd_global.user_id
3761: ,sysdate
3762: ,fnd_global.user_id
3763: ,fnd_global.login_id
3764: );
3765:
3766:

Line 3763: ,fnd_global.login_id

3759: ,sysdate
3760: ,fnd_global.user_id
3761: ,sysdate
3762: ,fnd_global.user_id
3763: ,fnd_global.login_id
3764: );
3765:
3766:
3767: --get legacy TDS tax rate from tax code

Line 3810: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;

3806: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;
3807: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;
3808: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;
3809: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3810: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;
3811: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;
3812: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;
3813: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;
3814: --insert tax code

Line 3812: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;

3808: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;
3809: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3810: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;
3811: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;
3812: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;
3813: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;
3814: --insert tax code
3815: insert_jai_cmn_taxes_all(jai_cmn_taxes_all_rec);
3816:

Line 3813: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;

3809: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3810: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;
3811: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;
3812: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;
3813: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;
3814: --insert tax code
3815: insert_jai_cmn_taxes_all(jai_cmn_taxes_all_rec);
3816:
3817: --@Create new tax category line for base TDS tax

Line 3825: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;

3821: jai_cmn_tax_ctg_lines_rec.line_no := 1;
3822: jai_cmn_tax_ctg_lines_rec.precedence_1 := 0;
3823: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;
3824: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3825: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3826: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;
3827: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;
3828: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;
3829: insert_jai_cmn_tax_ctg_lines(jai_cmn_tax_ctg_lines_rec);

Line 3827: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;

3823: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;
3824: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3825: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3826: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;
3827: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;
3828: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;
3829: insert_jai_cmn_tax_ctg_lines(jai_cmn_tax_ctg_lines_rec);
3830:
3831: --get tax code ID for base tax

Line 3828: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;

3824: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3825: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3826: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;
3827: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;
3828: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;
3829: insert_jai_cmn_tax_ctg_lines(jai_cmn_tax_ctg_lines_rec);
3830:
3831: --get tax code ID for base tax
3832: SELECT JAI_CMN_TAXES_ALL_S.nextval

Line 3862: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;

3858: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;
3859: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;
3860: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;
3861: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3862: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;
3863: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;
3864: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;
3865: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;
3866: --insert tax code

Line 3864: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;

3860: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;
3861: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3862: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;
3863: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;
3864: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;
3865: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;
3866: --insert tax code
3867: insert_jai_cmn_taxes_all(jai_cmn_taxes_all_rec);
3868:

Line 3865: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;

3861: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3862: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;
3863: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;
3864: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;
3865: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;
3866: --insert tax code
3867: insert_jai_cmn_taxes_all(jai_cmn_taxes_all_rec);
3868:
3869: --@Create new tax category TDS CESS tax

Line 3877: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;

3873: jai_cmn_tax_ctg_lines_rec.line_no := 2;
3874: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;
3875: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;
3876: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3877: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3878: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;
3879: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;
3880: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;
3881: insert_jai_cmn_tax_ctg_lines(jai_cmn_tax_ctg_lines_rec);

Line 3879: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;

3875: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;
3876: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3877: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3878: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;
3879: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;
3880: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;
3881: insert_jai_cmn_tax_ctg_lines(jai_cmn_tax_ctg_lines_rec);
3882: END IF;
3883:

Line 3880: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;

3876: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3877: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3878: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;
3879: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;
3880: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;
3881: insert_jai_cmn_tax_ctg_lines(jai_cmn_tax_ctg_lines_rec);
3882: END IF;
3883:
3884: IF NVL(ln_sh_cess_rate,0) <> 0 THEN

Line 3910: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;

3906: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;
3907: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;
3908: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;
3909: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3910: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;
3911: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;
3912: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;
3913: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;
3914: --insert tax code

Line 3912: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;

3908: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;
3909: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3910: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;
3911: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;
3912: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;
3913: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;
3914: --insert tax code
3915: insert_jai_cmn_taxes_all(jai_cmn_taxes_all_rec);
3916:

Line 3913: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;

3909: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3910: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;
3911: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;
3912: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;
3913: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;
3914: --insert tax code
3915: insert_jai_cmn_taxes_all(jai_cmn_taxes_all_rec);
3916:
3917: --@Create new tax category TDS SH CESS tax

Line 3929: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;

3925: END IF;
3926: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;
3927: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;
3928: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3929: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3930: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;
3931: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;
3932: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;
3933: insert_jai_cmn_tax_ctg_lines(jai_cmn_tax_ctg_lines_rec);

Line 3931: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;

3927: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;
3928: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3929: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3930: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;
3931: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;
3932: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;
3933: insert_jai_cmn_tax_ctg_lines(jai_cmn_tax_ctg_lines_rec);
3934: END IF;
3935:

Line 3932: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;

3928: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3929: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3930: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;
3931: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;
3932: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;
3933: insert_jai_cmn_tax_ctg_lines(jai_cmn_tax_ctg_lines_rec);
3934: END IF;
3935:
3936: IF NVL(ln_surcharge_rate,0) <> 0 THEN

Line 3962: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;

3958: jai_cmn_taxes_all_rec.section_type := tax_code_info_rec.section_type;
3959: jai_cmn_taxes_all_rec.start_date := tax_code_info_rec.start_date;
3960: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;
3961: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3962: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;
3963: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;
3964: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;
3965: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;
3966: --insert tax code

Line 3964: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;

3960: jai_cmn_taxes_all_rec.end_date := tax_code_info_rec.end_date;
3961: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3962: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;
3963: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;
3964: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;
3965: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;
3966: --insert tax code
3967: insert_jai_cmn_taxes_all(jai_cmn_taxes_all_rec);
3968:

Line 3965: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;

3961: jai_cmn_taxes_all_rec.CREATION_DATE := sysdate;
3962: jai_cmn_taxes_all_rec.CREATED_BY := fnd_global.user_id;
3963: jai_cmn_taxes_all_rec.LAST_UPDATE_DATE := sysdate;
3964: jai_cmn_taxes_all_rec.LAST_UPDATED_BY := fnd_global.user_id;
3965: jai_cmn_taxes_all_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;
3966: --insert tax code
3967: insert_jai_cmn_taxes_all(jai_cmn_taxes_all_rec);
3968:
3969: --@Create new tax category TDS Surcharge tax

Line 3988: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;

3984: jai_cmn_tax_ctg_lines_rec.precedence_1 := 1;
3985: END IF;
3986: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;
3987: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3988: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3989: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;
3990: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;
3991: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;
3992: insert_jai_cmn_tax_ctg_lines(jai_cmn_tax_ctg_lines_rec);

Line 3990: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;

3986: jai_cmn_tax_ctg_lines_rec.object_version_number := p_object_version_number;
3987: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3988: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3989: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;
3990: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;
3991: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;
3992: insert_jai_cmn_tax_ctg_lines(jai_cmn_tax_ctg_lines_rec);
3993: END IF;
3994:

Line 3991: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;

3987: jai_cmn_tax_ctg_lines_rec.creation_date := sysdate;
3988: jai_cmn_tax_ctg_lines_rec.created_by := fnd_global.user_id;
3989: jai_cmn_tax_ctg_lines_rec.last_update_date := sysdate;
3990: jai_cmn_tax_ctg_lines_rec.last_updated_by := fnd_global.user_id;
3991: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;
3992: insert_jai_cmn_tax_ctg_lines(jai_cmn_tax_ctg_lines_rec);
3993: END IF;
3994:
3995: END AUTO_CREATE_DTC_CATEGORY;