DBA Data[Home] [Help]

APPS.OKL_QUICK_QUOTES_PVT dependencies on DBMS_TRANSACTION

Line 1311: DBMS_TRANSACTION.SAVEPOINT('quick_quote_savepoint');

1307: ,p_api_type => g_api_type
1308: ,x_return_status => x_return_status); -- check if activity started successfully
1309:
1310: -- establish a savepoint to rollback when p_commit is N
1311: DBMS_TRANSACTION.SAVEPOINT('quick_quote_savepoint');
1312:
1313: -- calculate the total asset cost except for solve for financed amount
1314: FOR i in l_qqlv_tbl_type.FIRST..l_qqlv_tbl_type.LAST LOOP
1315: IF (l_qqhv_rec_type.pricing_method<>'SF' and l_qqlv_tbl_type(i).TYPE='ITEM_CATEGORY' ) THEN

Line 2071: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('quick_quote_savepoint');

2067: x_qqhv_rec_type := lx_qqhv_rec_type;
2068: x_qqlv_tbl_type := lx_qqlv_tbl_type;
2069: IF (p_commit = 'N') THEN
2070: -- rollback the transaction
2071: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('quick_quote_savepoint');
2072: ELSIF (p_commit='Y') THEN
2073: -- update the data in the lease quote tables
2074: update_quick_qte(l_api_version,
2075: p_init_msg_list,