[Home] [Help]
1: PACKAGE BODY FA_MODIFY_DISTRIBUTIONS_PKG as
2: /* $Header: FAMDSTB.pls 120.6 2009/04/16 15:02:03 bridgway ship $ */
3:
4: g_log_level_rec fa_api_types.log_level_rec_type;
5:
6: PROCEDURE modify_distributions(
7: P_api_version IN NUMBER,
8: P_init_msg_list IN VARCHAR2,
291: post_batch_id IN NUMBER,
292: last_updated_by IN NUMBER,
293: last_update_date IN DATE,
294: last_update_login IN NUMBER
295: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
296:
297: X_row_id ROWID := NULL;
298: X_asset_id NUMBER;
299: X_dist_id NUMBER;
618: IN varchar2,
619: p_last_updated_by IN NUMBER,
620: p_last_update_date IN DATE,
621: p_last_update_login IN NUMBER
622: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
623: BEGIN
624: if (g_asgn_count=0) then /* initialize the table */
625: asgn_table.delete;
626: end if;
672: x_msg_count OUT NOCOPY NUMBER,
673: x_msg_data OUT NOCOPY VARCHAR2,
674: book_type_code IN VARCHAR2,
675: asset_id IN NUMBER
676: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN VARCHAR2
677: IS
678:
679: h_return_status VARCHAR2(10) := FND_API.G_RET_STS_ERROR;
680: h_msg_count NUMBER := 0;
905: x_msg_count OUT NOCOPY NUMBER,
906: x_msg_data OUT NOCOPY VARCHAR2,
907: book_type_code IN VARCHAR2,
908: asset_id IN NUMBER
909: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN VARCHAR2
910: IS
911:
912: h_return_status VARCHAR2(10) := FND_API.G_RET_STS_ERROR;
913: h_msg_count NUMBER := 0;
1143: X_Calendar_Period_Close_Date OUT NOCOPY DATE,
1144: X_FY_Start_Date OUT NOCOPY DATE,
1145: X_FY_End_Date OUT NOCOPY DATE,
1146: X_return_status OUT NOCOPY VARCHAR2
1147: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
1148:
1149: Lv_Fiscal_Year Number(4);
1150: Lv_Fiscal_Year_Name Varchar2(30);
1151:
1196: END get_header_info;
1197:
1198: FUNCTION check_if_corp_book(
1199: book_type_code IN VARCHAR2
1200: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN VARCHAR2
1201: IS
1202:
1203: X_corp_book_type_code VARCHAR2(30) := NULL;
1204:
1267:
1268: FUNCTION check_location_ccid(
1269: p_location_id IN NUMBER,
1270: p_ccid_id IN NUMBER
1271: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN VARCHAR2
1272: IS
1273:
1274: X_location_id NUMBER := NULL;
1275: X_ccid_id NUMBER := NULL;