[Home] [Help]
9:
10:
11: FUNCTION faxcbsx(X_book IN VARCHAR2,
12: X_init_message_flag VARCHAR2 DEFAULT 'NO',
13: X_close_period in NUMBER DEFAULT 1, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
14: return BOOLEAN is
15:
16: h_txn_status BOOLEAN := FALSE; -- TRUE if txn allowed, FALSE otherwise
17:
90:
91: FUNCTION faxcrb (X_book IN VARCHAR2,
92: X_trx_type IN VARCHAR2,
93: X_asset_id IN NUMBER,
94: X_close_period IN NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
95:
96: return BOOLEAN is
97:
98: h_mc_source_flag varchar2(3);
328: X_start IN BOOLEAN,
329: X_asset_id IN NUMBER,
330: X_trx_type IN VARCHAR2,
331: X_txn_status IN OUT NOCOPY BOOLEAN,
332: X_close_period IN NUMBER DEFAULT 1, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
333: return BOOLEAN is
334:
335:
336: h_class_str VARCHAR2(15);
508: X_start IN BOOLEAN,
509: X_asset_id IN NUMBER,
510: X_trx_type IN VARCHAR2,
511: X_txn_status IN OUT NOCOPY BOOLEAN,
512: X_close_period IN NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
513: return BOOLEAN is
514:
515: h_conc_request_id NUMBER := fnd_global.conc_request_id;
516: h_request_id NUMBER := 0; -- set to non-zero if there is non-complete running process
727: --
728: -- FUNCTION faxwcr
729: --
730:
731: FUNCTION faxwcr(X_request_id IN NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
732: return BOOLEAN is
733:
734: BEGIN
735:
761: FUNCTION faxcds(X_book IN VARCHAR2,
762: X_submit IN BOOLEAN,
763: X_asset_id IN NUMBER,
764: X_trx_type IN VARCHAR2,
765: X_txn_status IN OUT NOCOPY BOOLEAN, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
766: return BOOLEAN is
767:
768: h_deprn_stat varchar2(1);
769: h_deprn_req_id number;
926: -- FUNCTION faxcms
927: --
928:
929: FUNCTION faxcms(X_book IN VARCHAR2,
930: X_request_id OUT NOCOPY NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
931: return BOOLEAN is
932:
933: h_conc_req_id NUMBER;
934: h_parent_req_id NUMBER;
1034: END faxcms;
1035:
1036: FUNCTION faxcca(X_book IN VARCHAR2,
1037: X_request_id OUT NOCOPY NUMBER,
1038: p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
1039: return BOOLEAN is
1040:
1041: h_ca_req_id NUMBER;
1042: h_phase VARCHAR2(200) := NULL;
1116: FUNCTION faxptb(X_book IN VARCHAR2,
1117: X_start IN BOOLEAN,
1118: X_asset_id IN NUMBER,
1119: X_trx_type IN VARCHAR2,
1120: X_txn_status IN OUT NOCOPY BOOLEAN, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
1121: return BOOLEAN is
1122:
1123: h_tax_book VARCHAR2(30);
1124: h_retval BOOLEAN := TRUE;
1190: -- FUNCTION faxgcb
1191: --
1192:
1193: FUNCTION faxgcb(X_book IN VARCHAR2,
1194: X_txn_status IN OUT NOCOPY BOOLEAN, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
1195: return BOOLEAN is
1196:
1197: h_corp_book VARCHAR2(30);
1198: h_request_id NUMBER := 0;
1283:
1284: FUNCTION faxlck(X_book IN VARCHAR2,
1285: X_txn_status IN OUT NOCOPY BOOLEAN,
1286: X_asset_id IN NUMBER,
1287: X_trx_type IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
1288: return BOOLEAN is
1289:
1290: h_mass_id NUMBER;
1291: h_tmp BOOLEAN;
1437: -- Function
1438: --
1439:
1440: FUNCTION faxsav(X_action IN VARCHAR2,
1441: X_txn_status IN OUT NOCOPY BOOLEAN, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
1442: return BOOLEAN is
1443:
1444: BEGIN
1445:
1490: END faxsav;
1491:
1492:
1493: FUNCTION faxcdr(X_book IN VARCHAR2,
1494: X_asset_id IN NUMBER DEFAULT 0, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN IS
1495:
1496: deprn_run VARCHAR2(1);
1497: h_count NUMBER;
1498: h_mc_source_flag VARCHAR2(3);
1504: l_msg_count NUMBER;
1505: l_msg_data VARCHAR2(4000);
1506: l_return_status VARCHAR2(1);
1507: l_deprn_run boolean := false;
1508: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1509:
1510: CURSOR check_deprn_run IS
1511: SELECT nvl(deprn_run, 'N')
1512: FROM fa_deprn_periods dp,
1819: X_asset_id IN NUMBER DEFAULT 0,
1820: X_return_value OUT nocopy integer)
1821: AS
1822: h_ret_value boolean;
1823: p_log_level_rec FA_API_TYPES.log_level_rec_type;
1824: ERROR_FOUND exception;
1825:
1826: begin
1827: X_return_value := 0;