DBA Data[Home] [Help]

APPS.FA_MASS_RET_PKG dependencies on FA_API_TYPES

Line 4: g_log_level_rec fa_api_types.log_level_rec_type;

1: PACKAGE BODY FA_MASS_RET_PKG as
2: /* $Header: faxmreb.pls 120.29.12010000.2 2008/10/21 08:49:57 pvataj ship $ */
3:
4: g_log_level_rec fa_api_types.log_level_rec_type;
5:
6: -- Global Variables holding Mass Retirements Information
7: G_Mass_Retirement_Id fa_mass_retirements.Mass_Retirement_Id%TYPE;
8: G_Book_Type_Code fa_mass_retirements.Book_Type_Code%TYPE;

Line 143: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

139:
140: PROCEDURE Acct_Split(X_1st_Segment IN VARCHAR2,
141: X_Current_Segment IN VARCHAR2,
142: X_Acct_Split IN OUT NOCOPY VARCHAR2
143: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
144:
145: l_Acct_Split VARCHAR2(1);
146:
147: BEGIN

Line 180: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

176: PROCEDURE Check_Tax_Split(X_Asset_Id IN NUMBER,
177: X_Emp_Split OUT NOCOPY VARCHAR2,
178: X_Acct_Split OUT NOCOPY VARCHAR2,
179: X_Loc_Split OUT NOCOPY VARCHAR2
180: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
181:
182: l_1st_Employee_Id NUMBER(15);
183: l_1st_Location_Id NUMBER(15);
184:

Line 406: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

402: p_location_id IN NUMBER,
403: p_assigned_to IN NUMBER,
404: p_cost IN NUMBER,
405: p_current_units IN NUMBER
406: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
407: RETURN BOOLEAN IS
408:
409: error varchar2(100);
410: BEGIN

Line 478: p_asset_dist_tbl OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type

474:
475:
476: FUNCTION Check_Split_Distribution(
477: X_Asset_Id IN NUMBER,
478: p_asset_dist_tbl OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type
479: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
480: RETURN BOOLEAN IS
481:
482:

Line 479: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

475:
476: FUNCTION Check_Split_Distribution(
477: X_Asset_Id IN NUMBER,
478: p_asset_dist_tbl OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type
479: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
480: RETURN BOOLEAN IS
481:
482:
483: l_code_combination_id fa_distribution_history.code_combination_id%TYPE;

Line 488: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

484: l_location_id fa_distribution_history.location_id%TYPE;
485: l_assigned_to fa_distribution_history.assigned_to%TYPE;
486: l_units_assigned fa_distribution_history.units_assigned%TYPE;
487:
488: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
489: i NUMBER;
490: l_check_account_null VARCHAR2(1);
491:
492:

Line 810: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

806: PROCEDURE Write_Message(p_Asset_Number IN VARCHAR2,
807: p_message IN VARCHAR2,
808: p_token1 IN VARCHAR2,
809: p_token2 IN VARCHAR2
810: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
811: l_mesg varchar2(100);
812: l_string varchar2(512);
813: l_calling_fn varchar2(40);
814:

Line 862: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS

858: ------------------------------------------------------------------------------
859:
860: FUNCTION Check_Addition_Retirement(p_Asset_id IN NUMBER,
861: x_Reason_Code OUT NOCOPY VARCHAR2
862: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
863: -- This function will check to see if the asset about to be retired has
864: -- already been fully retired. It also checks to see if the asset has been
865: -- added in the current period and whether there is a pending retirement
866: -- or reinstatement.

Line 985: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

981:
982: PROCEDURE Message_tbl(p_Asset_Number IN VARCHAR2,
983: p_num_msg IN OUT NOCOPY NUMBER,
984: p_msg_tbl IN OUT NOCOPY FA_MASS_RET_PKG.out_tbl
985: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
986:
987: l_unit_msg_rec FA_MASS_RET_PKG.out_rec;
988: msg_tbl FA_MASS_RET_PKG.out_tbl;
989: l_check varchar2(30);

Line 1020: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

1016: -- need to check if this is done within the retirement api and thus not needed
1017: --
1018:
1019: FUNCTION Check_Extended_Life(X_Asset_id IN NUMBER
1020: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
1021: RETURN BOOLEAN IS
1022:
1023: CURSOR check_asset_life_complete IS
1024: select 'EXTENDED LIFE'

Line 1058: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS

1054: ------------------------------------------------------------------------------
1055:
1056: FUNCTION Allocate_units (p_suxess_no OUT NOCOPY NUMBER,
1057: p_fail_no OUT NOCOPY NUMBER
1058: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
1059:
1060:
1061: l_remaining_units number;
1062: l_asset_id number := 0;

Line 1091: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

1087: msg_tbl FA_MASS_RET_PKG.out_tbl;
1088:
1089: -- declare 2nd round of allocation
1090:
1091: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1092: l_2nd_asset_id number;
1093: l_2nd_asset_number fa_additions_b.asset_number%TYPE;
1094: l_2nd_cost_retired number;
1095: l_2nd_current_units number;

Line 3487: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

3483:
3484:
3485: l_candidate_units num_tbl;
3486: l_dist_count number;
3487: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
3488: l_sc_units num_tbl;
3489: l_current_units num_tbl;
3490: l_total_dist_cost number;
3491: suxess_no number;